SHOW:
|
|
- or go back to the newest paste.
| 1 | #!/usr/bin/python | |
| 2 | ||
| 3 | import psycopg2 | |
| 4 | ||
| 5 | conn = psycopg2.connect(database="test", user="postgres", password="usuario", host="127.0.0.1", port="5432") | |
| 6 | print "Opened database successfully" | |
| 7 | ||
| 8 | cur = conn.cursor() | |
| 9 | ||
| 10 | cur.execute("UPDATE PERSONA set nombre = 'ANA' where ID=3")
| |
| 11 | - | conn.commit |
| 11 | + | conn.commit() |
| 12 | # ^ AQUI ^ ^ el paréntesis es importante! | |
| 13 | print "Total number of rows updated :", cur.rowcount | |
| 14 | ||
| 15 | cur.execute("SELECT id, nombre from PERSONA")
| |
| 16 | rows = cur.fetchall() | |
| 17 | for row in rows: | |
| 18 | print "ID = ", row[0] | |
| 19 | print "NOMBRE = ", row[1] | |
| 20 | ||
| 21 | print "OPERACION REALIZADA"; | |
| 22 | conn.close() |
