summaryrefslogtreecommitdiff
path: root/sandbox/test_copy2.py
diff options
context:
space:
mode:
authorDaniele Varrazzo <daniele.varrazzo@gmail.com>2018-10-15 00:58:32 +0100
committerDaniele Varrazzo <daniele.varrazzo@gmail.com>2018-10-15 00:58:32 +0100
commitb205764fdde4549c48c27841aa17e6c7f499e808 (patch)
tree1475eb57dc854ea4a1dc93c1c6a567e6fc584e5c /sandbox/test_copy2.py
parente7227ce87b8da75fef1a3376ebb47e2bf20f6063 (diff)
parent7a5edff6c66a0410d6fecd4445980aabafc3ab4a (diff)
downloadpsycopg2-errors-module.tar.gz
Merge branch 'master' into errors-moduleerrors-module
Diffstat (limited to 'sandbox/test_copy2.py')
-rw-r--r--sandbox/test_copy2.py42
1 files changed, 0 insertions, 42 deletions
diff --git a/sandbox/test_copy2.py b/sandbox/test_copy2.py
deleted file mode 100644
index 088c17b..0000000
--- a/sandbox/test_copy2.py
+++ /dev/null
@@ -1,42 +0,0 @@
-import psycopg2
-
-dbconn = psycopg2.connect(database="test",host="localhost",port="5432")
-query = """
- CREATE TEMP TABLE data (
- field01 char,
- field02 varchar,
- field03 varchar,
- field04 varchar,
- field05 varchar,
- field06 varchar,
- field07 varchar,
- field08 varchar,
- field09 numeric,
- field10 integer,
- field11 numeric,
- field12 numeric,
- field13 numeric,
- field14 numeric,
- field15 numeric,
- field16 numeric,
- field17 char,
- field18 char,
- field19 char,
- field20 varchar,
- field21 varchar,
- field22 integer,
- field23 char,
- field24 char
- );
- """
-cursor = dbconn.cursor()
-cursor.execute(query)
-
-f = open('test_copy2.csv')
-cursor.copy_from(f, 'data', sep='|')
-f.close()
-
-dbconn.commit()
-
-cursor.close()
-dbconn.close()