| 47 | class _InsertTestBase: |
| 48 | @classmethod |
| 49 | def define_tables(cls, metadata): |
| 50 | Table( |
| 51 | "mytable", |
| 52 | metadata, |
| 53 | Column("myid", Integer), |
| 54 | Column("name", String(30)), |
| 55 | Column("description", String(30)), |
| 56 | ) |
| 57 | Table( |
| 58 | "myothertable", |
| 59 | metadata, |
| 60 | Column("otherid", Integer, primary_key=True), |
| 61 | Column("othername", String(30)), |
| 62 | ) |
| 63 | Table( |
| 64 | "table_w_defaults", |
| 65 | metadata, |
| 66 | Column("id", Integer, primary_key=True), |
| 67 | Column("x", Integer, default=10), |
| 68 | Column("y", Integer, server_default=text("5")), |
| 69 | Column("z", Integer, default=lambda: 10), |
| 70 | ) |
| 71 | |
| 72 | Table( |
| 73 | "mytable_w_sql_default", |
| 74 | metadata, |
| 75 | Column("id", Integer, primary_key=True), |
| 76 | Column("name", String(30)), |
| 77 | Column("description", String(30)), |
| 78 | Column("created_at", DateTime, default=func.now()), |
| 79 | ) |
| 80 | |
| 81 | |
| 82 | class InsertTest(_InsertTestBase, fixtures.TablesTest, AssertsCompiledSQL): |