Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- import psycopg2
- from datetime import datetime
- def read_db(db_name, table_name='Samples'):
- conn = sqlite3.connect(db_name)
- cur = conn.cursor()
- cur.execute("select * from {}".format(table_name))
- my_table = cur.fetchall()
- conn.close()
- return my_table
- def write_central_db(content):
- conn = psycopg2.connect(database='frutopy', user='berry', password='password123', host='localhost', port='8000') #FIXME please
- cur = conn.cursor()
- table_name = 'Sample'
- for row in content:
- cur.execute("""INSERT INTO \"%s\" VALUES """, % (table_name, ))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement