Application de bases de données, principes et exemples avec Python

#!/usr/bin/python3

# http://initd.org/psycopg/docs/usage.html

import psycopg2

HOST = "localhost"

USER = "me"

PASSWORD = "secret"

DATABASE = "mydb"

# Open connection

conn = psycopg2.connect("host=%s dbname=%s user=%s password=%s" % (HOST, DATABASE, USER, PASSWORD))

# Open a cursor to send SQL commands

cur = conn.cursor()

# Execute a SQL SELECT command

sql = "SELECT * FROM t"

cur.execute(sql)

# Fetch data line by line

raw = cur.fetchone()

while raw:

    print (raw[0])

    print (raw[1])

    raw = cur.fetchone()

# Close connection

conn.close()

#!/usr/bin/python3

# http://initd.org/psycopg/docs/usage.html

import psycopg2

HOST = "localhost"
USER = "me"
PASSWORD = "secret"
DATABASE = "mydb"

# Open connection
conn = psycopg2.connect("host=%s dbname=%s user=%s password=%s" % (HOST, DATABASE, USER, PASSWORD))

# Open a cursor to send SQL commands
cur = conn.cursor()

# Execute a SQL SELECT command
sql = "SELECT * FROM t"
cur.execute(sql)

# Fetch data line by line
raw = cur.fetchone()
while raw:
    print (raw[0])
    print (raw[1])
    raw = cur.fetchone()

# Close connection
conn.close()

$ ./select.py 

Hello

1

$ ./select.py 
Hello
1