(self, connection, metadata)
| 50 | __sparse_driver_backend__ = True |
| 51 | |
| 52 | def test_basic_reflection(self, connection, metadata): |
| 53 | meta = metadata |
| 54 | |
| 55 | users = Table( |
| 56 | "engine_users", |
| 57 | meta, |
| 58 | Column("user_id", sa.INT, primary_key=True), |
| 59 | Column("user_name", sa.VARCHAR(20), nullable=False), |
| 60 | Column("test1", sa.CHAR(5), nullable=False), |
| 61 | Column("test2", sa.Float(), nullable=False), |
| 62 | Column("test3", sa.Text), |
| 63 | Column("test4", sa.Numeric(10, 2), nullable=False), |
| 64 | Column("test5", sa.Date), |
| 65 | Column( |
| 66 | "parent_user_id", |
| 67 | sa.Integer, |
| 68 | sa.ForeignKey("engine_users.user_id"), |
| 69 | ), |
| 70 | Column("test6", sa.Date, nullable=False), |
| 71 | Column("test7", sa.Text), |
| 72 | Column("test8", sa.LargeBinary), |
| 73 | Column("test_passivedefault2", sa.Integer, server_default="5"), |
| 74 | Column("test9", sa.LargeBinary(100)), |
| 75 | Column("test10", sa.Numeric(10, 2)), |
| 76 | test_needs_fk=True, |
| 77 | ) |
| 78 | |
| 79 | addresses = Table( |
| 80 | "engine_email_addresses", |
| 81 | meta, |
| 82 | Column("address_id", sa.Integer, primary_key=True), |
| 83 | Column( |
| 84 | "remote_user_id", sa.Integer, sa.ForeignKey(users.c.user_id) |
| 85 | ), |
| 86 | Column("email_address", sa.String(20)), |
| 87 | test_needs_fk=True, |
| 88 | ) |
| 89 | meta.create_all(connection) |
| 90 | |
| 91 | meta2 = MetaData() |
| 92 | reflected_users = Table( |
| 93 | "engine_users", meta2, autoload_with=connection |
| 94 | ) |
| 95 | reflected_addresses = Table( |
| 96 | "engine_email_addresses", |
| 97 | meta2, |
| 98 | autoload_with=connection, |
| 99 | ) |
| 100 | self.assert_tables_equal(users, reflected_users) |
| 101 | self.assert_tables_equal(addresses, reflected_addresses) |
| 102 | |
| 103 | def test_autoload_with_imply_autoload(self, metadata, connection): |
| 104 | meta = metadata |
nothing calls this directly
no test coverage detected