Add a timestamp column.

James William Pye · James William Pye · commit 441ea9d2bf58 · 2009-03-23T19:23:44.000-07:00
diff --git a/postgresql/test/perf_query_io.py b/postgresql/test/perf_query_io.py
@@ -9,10 +9,17 @@
 import time
 import sys
 import decimal
+import datetime
 
 def insertSamples(count, insert_records):
 	recs = [
-		(-3, 123, 0xfffffea023, decimal.Decimal("90900023123.40031"), decimal.Decimal("432.40031"), 'some_&oacute;&auml;&aelig;_thing', 'varying', '&aelig;')
+		(
+			-3, 123, 0xfffffea023,
+			decimal.Decimal("90900023123.40031"),
+			decimal.Decimal("432.40031"),
+			'some_&oacute;&auml;&aelig;_thing', 'varying', '&aelig;',
+			datetime.datetime(1982, 5, 18, 12, 0, 0, 100232)
+		)
 		for x in range(count)
 	]
 	gen = time.time()
@@ -54,9 +61,9 @@ def timeTupleRead(portal):
 
 def main(count):
 	execute('CREATE TEMP TABLE samples '
-		'(i2 int2, i4 int4, i8 int8, n numeric, n2 numeric, t text, v varchar, c char)')
+		'(i2 int2, i4 int4, i8 int8, n numeric, n2 numeric, t text, v varchar, c char, ts timestamp)')
 	insert_records = prepare(
-		"INSERT INTO samples VALUES ($1, $2, $3, $4, $5, $6, $7, $8)"
+		"INSERT INTO samples VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)"
 	)
 	select_records = prepare("SELECT * FROM samples")
 	try:
