Advertisement
Guest User

te quiero

a guest
Jul 4th, 2016
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. import sqlite3
  2. import psycopg2
  3. from datetime import datetime
  4.  
  5. def read_db(db_name, table_name='Samples'):
  6. conn = sqlite3.connect(db_name)
  7. cur = conn.cursor()
  8. cur.execute("select * from {}".format(table_name))
  9. my_table = cur.fetchall()
  10. conn.close()
  11. return my_table
  12.  
  13.  
  14. def write_central_db(content):
  15. conn = psycopg2.connect(database='frutopy', user='berry', password='password123', host='localhost', port='8000') #FIXME please
  16. cur = conn.cursor()
  17. table_name = 'Sample'
  18. for row in content:
  19. cur.execute("""INSERT INTO \"%s\" VALUES """, % (table_name, ))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement