Python and SQLQueries

Question

This might be a basic question but I can't seem to get the output of the python/sql statements I write. For example, when type the following,

from sql import *
from sql.aggregate import *
from sql.conditionals import *
user = Table('user')
select = user.select()
tuple(select)

I don't see the output (i.e the records) of these statements in the console. Why is this? When I type tuple(select) in the shell, I get the following as output:

('SELECT * FROM "combine2" AS "a"', ())

Note that I am using the sql module.

What module(s) are you using for SQL?

Scott Hunter
– Scott Hunter

2017-08-21 16:05:18 +00:00
Commented Aug 21, 2017 at 16:05 — Scott Hunter
– Scott Hunter, Commented Aug 21, 2017 at 16:05
@ScottHunter that's python-sql library.

alecxe
– alecxe

2017-08-22 03:34:18 +00:00
Commented Aug 22, 2017 at 3:34 — alecxe
– alecxe, Commented Aug 22, 2017 at 3:34

alecxe · Accepted Answer · 2017-08-21 16:06:30Z

2

From what I understand, python-sql library, which you are using, is for creating/generating SQL queries only. In order to execute them, you need to use a database driver. E.g. in case of SQLite:

import sqlite3

# ...
statement = user.select()

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

cursor.execute(statement)
for row in cursor.fetchall():
    print(row)

answered Aug 21, 2017 at 16:06

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Damien Over a year ago

When I type cursor.execute(tuple(statement)) or cursor.execute(statement)...it doesn't work.

alecxe Over a year ago

@Damien wait, what do you mean by "does not work"? Do you fetch the results afterwards like in my sample? Thanks.

Scott Hunter Over a year ago

Make sure that the argument to sqlite2.connect is the correct path to your database file (by checking the value returned, of course).

Collectives™ on Stack Overflow

Python and SQLQueries

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related