Insert a default row using raw SQL based on database type.
(db)
| 26 | |
| 27 | @pytest_asyncio.fixture |
| 28 | async def default_row(db): |
| 29 | """Insert a default row using raw SQL based on database type.""" |
| 30 | db_conn = connections.get("models") |
| 31 | if isinstance(db_conn, MySQLClient): |
| 32 | await db_conn.execute_query( |
| 33 | "insert into defaultmodel (`int_default`,`float_default`,`decimal_default`,`bool_default`,`char_default`,`date_default`,`datetime_default`) values (DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT)", |
| 34 | ) |
| 35 | elif isinstance(db_conn, SqliteClient): |
| 36 | await db_conn.execute_query( |
| 37 | "insert into defaultmodel default values", |
| 38 | ) |
| 39 | elif isinstance(db_conn, (AsyncpgDBClient, PsycopgClient)) or ( |
| 40 | MSSQLClient is not None and isinstance(db_conn, MSSQLClient) |
| 41 | ): |
| 42 | await db_conn.execute_query( |
| 43 | 'insert into defaultmodel ("int_default","float_default","decimal_default","bool_default","char_default","date_default","datetime_default") values (DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT)', |
| 44 | ) |
| 45 | elif OracleClient is not None and isinstance(db_conn, OracleClient): |
| 46 | await db_conn.execute_query( |
| 47 | 'insert into "defaultmodel" ("int_default","float_default","decimal_default","bool_default","char_default","date_default","datetime_default") values (DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT)', |
| 48 | ) |
| 49 | yield |
| 50 | |
| 51 | |
| 52 | @pytest.mark.asyncio |
nothing calls this directly
no test coverage detected
searching dependent graphs…