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 INSERT command

sql = "INSERT INTO t VALUES ('Hello',1)"

cur.execute(sql)

# Commit (transactionnal mode is by default)

conn.commit()

# Close connection

conn.close()

#!/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 INSERT command
sql = "INSERT INTO t VALUES ('Hello',1)"
cur.execute(sql)

# Commit (transactionnal mode is by default)
conn.commit()

# Close connection
conn.close()

$ ./insert.py 

[('Hello', 1)]

$ ./insert.py 
[('Hello', 1)]