Looks like I get the exact same problem using sqlite, so my code is the
culprit, not Postgres (surprise, surprise):
2009-05-18 12:04:53,885 INFO sqlalchemy.engine.base.Engine.0x..ac SELECT
name FROM (SELECT * FROM sqlite_master UNION ALL SELECT * FROM
sqlite_temp_master) WHERE type='table' ORDER BY name
2009-05-18 12:04:53,886 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:53,889 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info("export")
2009-05-18 12:04:53,890 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:53,891 INFO sqlalchemy.engine.base.Engine.0x..ac
CREATE TABLE export (
id INTEGER NOT NULL,
export_id VARCHAR(50),
export_id_date_collected TIMESTAMP,
export_date TIMESTAMP,
export_date_date_collected TIMESTAMP,
export_period_start_date TIMESTAMP,
export_period_start_date_date_collected TIMESTAMP,
export_period_end_date TIMESTAMP,
export_period_end_date_date_collected TIMESTAMP,
export_software_vendor VARCHAR(50),
export_software_vendor_date_collected TIMESTAMP,
export_software_version VARCHAR(10),
export_software_version_date_collected TIMESTAMP,
PRIMARY KEY (id)
)
2009-05-18 12:04:53,892 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,193 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
2009-05-18 12:04:54,199 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info("database")
2009-05-18 12:04:54,199 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,201 INFO sqlalchemy.engine.base.Engine.0x..ac
CREATE TABLE "database" (
id INTEGER NOT NULL,
database_id VARCHAR(50),
database_id_date_collected TIMESTAMP,
database_email VARCHAR(50),
database_email_date_collected TIMESTAMP,
database_contact_extension VARCHAR(10),
database_contact_extension_date_collected TIMESTAMP,
database_contact_last VARCHAR(20),
database_contact_last_date_collected TIMESTAMP,
database_contact_phone VARCHAR(20),
database_contact_phone_date_collected TIMESTAMP,
database_name VARCHAR(50),
database_name_date_collected TIMESTAMP,
PRIMARY KEY (id)
)
2009-05-18 12:04:54,201 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,203 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
2009-05-18 12:04:54,206 INFO sqlalchemy.engine.base.Engine.0x..ac SELECT
name FROM (SELECT * FROM sqlite_master UNION ALL SELECT * FROM
sqlite_temp_master) WHERE type='table' ORDER BY name
2009-05-18 12:04:54,206 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,207 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info("database")
2009-05-18 12:04:54,207 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,211 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
foreign_key_list("database")
2009-05-18 12:04:54,212 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,212 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
index_list("database")
2009-05-18 12:04:54,212 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,213 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info(export)
2009-05-18 12:04:54,213 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,233 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
foreign_key_list(export)
2009-05-18 12:04:54,233 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,234 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
index_list(export)
2009-05-18 12:04:54,234 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,237 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info("person")
2009-05-18 12:04:54,256 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,258 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info("export")
2009-05-18 12:04:54,259 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,266 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info("database")
2009-05-18 12:04:54,276 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,279 INFO sqlalchemy.engine.base.Engine.0x..ac
CREATE TABLE person (
id INTEGER NOT NULL,
person_id VARCHAR(50),
person_id_date_collected TIMESTAMP,
date_of_birth DATE,
date_of_birth_date_collected TIMESTAMP,
ethnicity INTEGER,
ethnicity_date_collected TIMESTAMP,
gender INTEGER,
gender_date_collected TIMESTAMP,
legal_first_name VARCHAR(50),
legal_first_name_date_collected TIMESTAMP,
legal_last_name VARCHAR(50),
legal_last_name_date_collected TIMESTAMP,
legal_middle_name VARCHAR(50),
legal_middle_name_date_collected TIMESTAMP,
legal_suffix VARCHAR(50),
legal_suffix_date_collected TIMESTAMP,
social_security_number VARCHAR(9),
social_security_number_date_collected TIMESTAMP,
social_security_number_quality_code VARCHAR(2),
social_security_number_quality_code_date_collected TIMESTAMP,
PRIMARY KEY (id)
)
2009-05-18 12:04:54,288 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,292 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
2009-05-18 12:04:54,301 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info("other_names")
2009-05-18 12:04:54,364 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,366 INFO sqlalchemy.engine.base.Engine.0x..ac
CREATE TABLE other_names (
id INTEGER NOT NULL,
other_first_name VARCHAR(50),
other_first_name_date_collected TIMESTAMP,
other_middle_name VARCHAR(50),
other_middle_name_date_collected TIMESTAMP,
other_last_name VARCHAR(50),
other_last_name_date_collected TIMESTAMP,
other_suffix VARCHAR(50),
other_suffix_date_collected TIMESTAMP,
PRIMARY KEY (id)
)
2009-05-18 12:04:54,373 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,380 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
2009-05-18 12:04:54,384 INFO sqlalchemy.engine.base.Engine.0x..ac PRAGMA
table_info("races")
2009-05-18 12:04:54,384 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,389 INFO sqlalchemy.engine.base.Engine.0x..ac
CREATE TABLE races (
id INTEGER NOT NULL,
race INTEGER,
race_date_collected TIMESTAMP,
PRIMARY KEY (id)
)
2009-05-18 12:04:54,389 INFO sqlalchemy.engine.base.Engine.0x..ac {}
2009-05-18 12:04:54,396 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
{'export_software_version_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'export_software_vendor_date_collected': datetime.datetime(2004,
8, 1, 0, 0), 'export_software_version': '1.1',
'export_date_date_collected': datetime.datetime(2004, 8, 1, 0, 0),
'export_period_end_date': '2004-12-14T00:00:00', 'export_date':
'2004-12-15T00:00:00', 'export_period_end_date_date_collected':
datetime.datetime(2004, 8, 1, 0, 0), 'export_software_vendor':
"HMIS_'R_Us", 'export_id_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'export_period_start_date_date_collected':
datetime.datetime(2004, 8, 1, 0, 0), 'export_id': '6',
'export_period_start_date': '2004-01-01T00:00:00'}
2009-05-18 12:04:54,489 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ec register object for
flush: exp...@0x85fe3ac isdelete=False listonly=False postupdate=False
2009-05-18 12:04:54,504 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ec Dependent tuples:
2009-05-18 12:04:54,505 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ec Dependency sort:
[UOWTask(0x86064ec) Mapper: 'Export/export']
2009-05-18 12:04:54,506 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ec Task dump:
UOWTask(0x86064ec, Export/export/None) (save/update phase)
+-Save exp...@0x85fe3ac
UOWTask(0x86064ec, Export/export/None) (delete phase)
2009-05-18 12:04:54,508 INFO sqlalchemy.engine.base.Engine.0x..ac BEGIN
2009-05-18 12:04:54,512 INFO sqlalchemy.engine.base.Engine.0x..ac INSERT
INTO export (export_id, export_id_date_collected, export_date,
export_date_date_collected, export_period_start_date,
export_period_start_date_date_collected, export_period_end_date,
export_period_end_date_date_collected, export_software_vendor,
export_software_vendor_date_collected, export_software_version,
export_software_version_date_collected) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-18 12:04:54,519 INFO sqlalchemy.engine.base.Engine.0x..ac ['6',
'2004-08-01 00:00:00.0', '2004-12-15T00:00:00', '2004-08-01 00:00:00.0',
'2004-01-01T00:00:00', '2004-08-01 00:00:00.0', '2004-12-14T00:00:00',
'2004-08-01 00:00:00.0', "HMIS_'R_Us", '2004-08-01 00:00:00.0', '1.1',
'2004-08-01 00:00:00.0']
2009-05-18 12:04:54,521 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ec Execute Complete
2009-05-18 12:04:54,532 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
{'database_id_date_collected': datetime.datetime(2002, 10, 10, 12, 0,
tzinfo=tzoffset(None, 18000)), 'database_contact_phone': '6179234567',
'database_contact_phone_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'database_name': 'Hal_the_Database',
'database_contact_last_date_collected': datetime.datetime(2004, 8, 1, 0,
0), 'database_contact_extension_date_collected': datetime.datetime(2004,
8, 1, 0, 0), 'database_email_date_collected': datetime.datetime(2004, 8,
1, 0, 0), 'database_id': '31', 'database_name_date_collected':
datetime.datetime(2004, 8, 1, 0, 0), 'database_email': 't...@test.com',
'database_contact_last': 'Fell', 'database_contact_extension': '75511'}
2009-05-18 12:04:54,556 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c register object for
flush: datab...@0x8606b8c isdelete=False listonly=False postupdate=False
2009-05-18 12:04:54,569 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c Dependent tuples:
2009-05-18 12:04:54,578 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c Dependency sort:
[UOWTask(0x86a368c) Mapper: 'Database/database']
2009-05-18 12:04:54,579 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c Task dump:
UOWTask(0x86a368c, Database/database/None) (save/update phase)
+-Save datab...@0x8606b8c
UOWTask(0x86a368c, Database/database/None) (delete phase)
2009-05-18 12:04:54,580 INFO sqlalchemy.engine.base.Engine.0x..ac BEGIN
2009-05-18 12:04:54,582 INFO sqlalchemy.engine.base.Engine.0x..ac INSERT
INTO "database" (database_id, database_id_date_collected,
database_email, database_email_date_collected,
database_contact_extension, database_contact_extension_date_collected,
database_contact_last, database_contact_last_date_collected,
database_contact_phone, database_contact_phone_date_collected,
database_name, database_name_date_collected) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-18 12:04:54,596 INFO sqlalchemy.engine.base.Engine.0x..ac ['31',
'2002-10-10 12:00:00.0', 't...@test.com', '2004-08-01 00:00:00.0',
'75511', '2004-08-01 00:00:00.0', 'Fell', '2004-08-01 00:00:00.0',
'6179234567', '2004-08-01 00:00:00.0', 'Hal_the_Database', '2004-08-01
00:00:00.0']
2009-05-18 12:04:54,597 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c Execute Complete
2009-05-18 12:04:54,598 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
{'person_date_of_birth': '1999-01-22', 'person_legal_last_name':
'Washington', 'person_id_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'person_legal_middle_name_date_collected':
datetime.datetime(2004, 8, 1, 0, 0),
'person_legal_suffix_date_collected': datetime.datetime(2004, 8, 1, 0,
0), 'person_legal_suffix': 'Jr.', 'person_legal_middle_name': 'Michael',
'person_gender_date_collected': datetime.datetime(2004, 8, 1, 0, 0),
'person_date_of_birth_date_collected': datetime.datetime(2004, 8, 1, 0,
0), 'person_legal_first_name': 'George', 'person_id': 'DCF017Y0',
'person_legal_first_name_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'person_legal_last_name_date_collected': datetime.datetime(2004,
8, 1, 0, 0), 'person_ethnicity_date_collected': datetime.datetime(2004,
8, 1, 0, 0), 'person_ethnicity': '0', 'person_gender': '1'}
2009-05-18 12:04:54,649 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..6c register object for
flush: per...@0x86a344c isdelete=False listonly=False postupdate=False
2009-05-18 12:04:54,669 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..6c Dependent tuples:
2009-05-18 12:04:54,670 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..6c Dependency sort:
[UOWTask(0x86a370c) Mapper: 'Person/person']
2009-05-18 12:04:54,670 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..6c Task dump:
UOWTask(0x86a370c, Person/person/None) (save/update phase)
+-Save per...@0x86a344c
UOWTask(0x86a370c, Person/person/None) (delete phase)
2009-05-18 12:04:54,670 INFO sqlalchemy.engine.base.Engine.0x..ac BEGIN
2009-05-18 12:04:54,686 INFO sqlalchemy.engine.base.Engine.0x..ac INSERT
INTO person (person_id, person_id_date_collected, date_of_birth,
date_of_birth_date_collected, ethnicity, ethnicity_date_collected,
gender, gender_date_collected, legal_first_name,
legal_first_name_date_collected, legal_last_name,
legal_last_name_date_collected, legal_middle_name,
legal_middle_name_date_collected, legal_suffix,
legal_suffix_date_collected, social_security_number,
social_security_number_date_collected,
social_security_number_quality_code,
social_security_number_quality_code_date_collected) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-18 12:04:54,688 INFO sqlalchemy.engine.base.Engine.0x..ac
['DCF017Y0', '2004-08-01 00:00:00.0', None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None,
None]
2009-05-18 12:04:54,690 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..6c Execute Complete
2009-05-18 12:04:54,700 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
{'person_date_of_birth': '1999-01-22', 'person_legal_last_name':
'Kennedy', 'person_id_date_collected': datetime.datetime(2004, 8, 1, 0,
0), 'person_date_of_birth_date_collected': datetime.datetime(2008, 8, 1,
0, 0), 'person_legal_first_name': 'Robert', 'person_id': '7451',
'person_legal_first_name_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'person_legal_last_name_date_collected': datetime.datetime(2004,
8, 1, 0, 0)}
2009-05-18 12:04:54,735 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c register object for
flush: per...@0x86a388c isdelete=False listonly=False postupdate=False
2009-05-18 12:04:54,736 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c Dependent tuples:
2009-05-18 12:04:54,736 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c Dependency sort:
[UOWTask(0x86a3a8c) Mapper: 'Person/person']
2009-05-18 12:04:54,737 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c Task dump:
UOWTask(0x86a3a8c, Person/person/None) (save/update phase)
+-Save per...@0x86a388c
UOWTask(0x86a3a8c, Person/person/None) (delete phase)
2009-05-18 12:04:54,745 INFO sqlalchemy.engine.base.Engine.0x..ac BEGIN
2009-05-18 12:04:54,749 INFO sqlalchemy.engine.base.Engine.0x..ac INSERT
INTO person (person_id, person_id_date_collected, date_of_birth,
date_of_birth_date_collected, ethnicity, ethnicity_date_collected,
gender, gender_date_collected, legal_first_name,
legal_first_name_date_collected, legal_last_name,
legal_last_name_date_collected, legal_middle_name,
legal_middle_name_date_collected, legal_suffix,
legal_suffix_date_collected, social_security_number,
social_security_number_date_collected,
social_security_number_quality_code,
social_security_number_quality_code_date_collected) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-18 12:04:54,749 INFO sqlalchemy.engine.base.Engine.0x..ac
['7451', '2004-08-01 00:00:00.0', None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None]
2009-05-18 12:04:54,751 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c Execute Complete
2009-05-18 12:04:54,774 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
{'person_id': '1234763', 'person_id_date_collected':
datetime.datetime(2004, 8, 1, 0, 0), 'person_date_of_birth':
'1999-01-22', 'person_date_of_birth_date_collected':
datetime.datetime(1972, 8, 1, 0, 0)}
2009-05-18 12:04:54,801 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..0c register object for
flush: per...@0x86a3b2c isdelete=False listonly=False postupdate=False
2009-05-18 12:04:54,808 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..0c Dependent tuples:
2009-05-18 12:04:54,808 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..0c Dependency sort:
[UOWTask(0x86a3ecc) Mapper: 'Person/person']
2009-05-18 12:04:54,812 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..0c Task dump:
UOWTask(0x86a3ecc, Person/person/None) (save/update phase)
+-Save per...@0x86a3b2c
UOWTask(0x86a3ecc, Person/person/None) (delete phase)
2009-05-18 12:04:54,813 INFO sqlalchemy.engine.base.Engine.0x..ac BEGIN
2009-05-18 12:04:54,816 INFO sqlalchemy.engine.base.Engine.0x..ac INSERT
INTO person (person_id, person_id_date_collected, date_of_birth,
date_of_birth_date_collected, ethnicity, ethnicity_date_collected,
gender, gender_date_collected, legal_first_name,
legal_first_name_date_collected, legal_last_name,
legal_last_name_date_collected, legal_middle_name,
legal_middle_name_date_collected, legal_suffix,
legal_suffix_date_collected, social_security_number,
social_security_number_date_collected,
social_security_number_quality_code,
social_security_number_quality_code_date_collected) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-18 12:04:54,824 INFO sqlalchemy.engine.base.Engine.0x..ac
['1234763', '2004-08-01 00:00:00.0', None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None]
2009-05-18 12:04:54,826 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..0c Execute Complete
2009-05-18 12:04:54,826 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
{'person_date_of_birth': '1999-01-22', 'person_legal_last_name':
'Washington', 'person_date_of_birth_date_collected':
datetime.datetime(2004, 8, 1, 0, 0),
'person_legal_middle_name_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'person_legal_suffix_date_collected': datetime.datetime(2004, 8,
1, 0, 0), 'person_legal_middle_name': 'Michael',
'person_gender_date_collected': datetime.datetime(2004, 8, 1, 0, 0),
'person_legal_suffix': 'Jr.', 'person_legal_first_name': 'George',
'person_gender': '1', 'person_legal_first_name_date_collected':
datetime.datetime(2004, 8, 1, 0, 0),
'person_legal_last_name_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'person_ethnicity_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'person_ethnicity': '0'}
2009-05-18 12:04:54,882 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c register object for
flush: per...@0x86a39ec isdelete=False listonly=False postupdate=False
2009-05-18 12:04:54,883 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c Dependent tuples:
2009-05-18 12:04:54,893 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c Dependency sort:
[UOWTask(0x86a64ac) Mapper: 'Person/person']
2009-05-18 12:04:54,894 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c Task dump:
UOWTask(0x86a64ac, Person/person/None) (save/update phase)
+-Save per...@0x86a39ec
UOWTask(0x86a64ac, Person/person/None) (delete phase)
2009-05-18 12:04:54,894 INFO sqlalchemy.engine.base.Engine.0x..ac BEGIN
2009-05-18 12:04:54,905 INFO sqlalchemy.engine.base.Engine.0x..ac INSERT
INTO person (person_id, person_id_date_collected, date_of_birth,
date_of_birth_date_collected, ethnicity, ethnicity_date_collected,
gender, gender_date_collected, legal_first_name,
legal_first_name_date_collected, legal_last_name,
legal_last_name_date_collected, legal_middle_name,
legal_middle_name_date_collected, legal_suffix,
legal_suffix_date_collected, social_security_number,
social_security_number_date_collected,
social_security_number_quality_code,
social_security_number_quality_code_date_collected) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-18 12:04:54,907 INFO sqlalchemy.engine.base.Engine.0x..ac [None,
None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None]
2009-05-18 12:04:54,916 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..4c Execute Complete
2009-05-18 12:04:54,917 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
{'person_legal_last_name_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'person_id_date_collected': datetime.datetime(2004, 8, 1, 0, 0),
'person_legal_first_name': 'Robert',
'person_legal_first_name_date_collected': datetime.datetime(2004, 8, 1,
0, 0), 'person_id': '7451', 'person_legal_last_name': 'Kennedy'}
2009-05-18 12:04:54,968 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c register object for
flush: per...@0x86a646c isdelete=False listonly=False postupdate=False
2009-05-18 12:04:54,984 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c Dependent tuples:
2009-05-18 12:04:54,985 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c Dependency sort:
[UOWTask(0x86a60ac) Mapper: 'Person/person']
2009-05-18 12:04:54,985 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c Task dump:
UOWTask(0x86a60ac, Person/person/None) (save/update phase)
+-Save per...@0x86a646c
UOWTask(0x86a60ac, Person/person/None) (delete phase)
2009-05-18 12:04:54,986 INFO sqlalchemy.engine.base.Engine.0x..ac BEGIN
2009-05-18 12:04:54,997 INFO sqlalchemy.engine.base.Engine.0x..ac INSERT
INTO person (person_id, person_id_date_collected, date_of_birth,
date_of_birth_date_collected, ethnicity, ethnicity_date_collected,
gender, gender_date_collected, legal_first_name,
legal_first_name_date_collected, legal_last_name,
legal_last_name_date_collected, legal_middle_name,
legal_middle_name_date_collected, legal_suffix,
legal_suffix_date_collected, social_security_number,
social_security_number_date_collected,
social_security_number_quality_code,
social_security_number_quality_code_date_collected) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-18 12:04:54,998 INFO sqlalchemy.engine.base.Engine.0x..ac
['7451', '2004-08-01 00:00:00.0', None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None]
2009-05-18 12:04:54,999 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..8c Execute Complete
2009-05-18 12:04:54,999 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
{'person_id': '1234763', 'person_id_date_collected':
datetime.datetime(2004, 8, 1, 0, 0), 'person_date_of_birth':
'1999-01-22', 'person_date_of_birth_date_collected':
datetime.datetime(1998, 8, 1, 0, 0)}
2009-05-18 12:04:55,017 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ac register object for
flush: per...@0x86a3fcc isdelete=False listonly=False postupdate=False
2009-05-18 12:04:55,018 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ac Dependent tuples:
2009-05-18 12:04:55,018 DEBUG
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ac Dependency sort:
[UOWTask(0x86a374c) Mapper: 'Person/person']
2009-05-18 12:04:55,019 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ac Task dump:
UOWTask(0x86a374c, Person/person/None) (save/update phase)
+-Save per...@0x86a3fcc
UOWTask(0x86a374c, Person/person/None) (delete phase)
2009-05-18 12:04:55,019 INFO sqlalchemy.engine.base.Engine.0x..ac BEGIN
2009-05-18 12:04:55,050 INFO sqlalchemy.engine.base.Engine.0x..ac INSERT
INTO person (person_id, person_id_date_collected, date_of_birth,
date_of_birth_date_collected, ethnicity, ethnicity_date_collected,
gender, gender_date_collected, legal_first_name,
legal_first_name_date_collected, legal_last_name,
legal_last_name_date_collected, legal_middle_name,
legal_middle_name_date_collected, legal_suffix,
legal_suffix_date_collected, social_security_number,
social_security_number_date_collected,
social_security_number_quality_code,
social_security_number_quality_code_date_collected) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-05-18 12:04:55,060 INFO sqlalchemy.engine.base.Engine.0x..ac
['1234763', '2004-08-01 00:00:00.0', None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None]
2009-05-18 12:04:55,068 INFO
sqlalchemy.orm.unitofwork.UOWTransaction.0x..ac Execute Complete
2009-05-18 12:04:55,081 INFO sqlalchemy.engine.base.Engine.0x..ac COMMIT
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
