python-driver/samples/LoadCSVFile.py at master · Teradata/python-driver · GitHub

25 lines (19 loc) · 1.32 KB

# This sample program demonstrates two different approaches to load data values

# from a CSV file and insert those data values into a database table.

# This sample program requires the airports.csv file to be located in the current directory.

import csv

import teradatasql

with teradatasql.connect (host="whomooz", user="guest", password="please") as con:

with con.cursor () as cur:

cur.execute ("create volatile table Airports (City varchar(100), Airport varchar(100), AirportCode varchar(10)) on commit preserve rows")

print ("Slower approach - use the Python csv module to parse data values from a CSV file")

with open ("airports.csv", newline="") as f:

cur.execute ("insert into Airports (?, ?, ?)", [ row for row in csv.reader (f) ])

cur.execute ("select AirportCode, Airport, City from Airports order by AirportCode")

[ print (row) for row in cur.fetchall () ]

cur.execute ("delete from Airports")

print ("Faster approach - the driver loads data values from a CSV file")

cur.execute ("{fn teradata_read_csv(airports.csv)}insert into Airports (?, ?, ?)")

cur.execute ("select AirportCode, Airport, City from Airports order by AirportCode")

[ print (row) for row in cur.fetchall () ]

Expand file tree