· 8 years ago · Feb 15, 2018, 10:04 AM
1CREATE TABLE
2IF NOT EXISTS node (
3 node_id INTEGER PRIMARY KEY AUTOINCREMENT,
4 provider_id INTEGER UNIQUE
5)
6
7import pandas
8
9nodes_file = 'nodes.csv'
10df = pandas.read_csv(node_file, sep=sep)
11df.[to_sql][1]("nodes", conn, if_exists='append', index=False)
12
13IntegrityError: UNIQUE constraint failed: node.node_provider_id
14IntegrityErrorTraceback (most recent call last)
15in engine
16----> 1 df.to_sql("node", conn, if_exists='append', index=False)
17
18query = "SELECT count(*) from node;"
19cursor.execute(query)
20<sqlite3.Cursor at 0x7f7703caa650>
21
22print(cursor.fetchall())
23[(0,)]