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

#!/usr/bin/python3

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 name, century FROM v_philosopher"

cur.execute(sql)

# Fetch data line by line

raw = cur.fetchone()

while raw:

  print (raw[0], raw[1])

  raw = cur.fetchone()

#!/usr/bin/python3

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 name, century FROM v_philosopher"
cur.execute(sql)

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