()
| 94 | |
| 95 | |
| 96 | def iris_table_metadata(): |
| 97 | import sqlalchemy |
| 98 | from sqlalchemy import ( |
| 99 | Column, |
| 100 | Double, |
| 101 | Float, |
| 102 | MetaData, |
| 103 | String, |
| 104 | Table, |
| 105 | ) |
| 106 | |
| 107 | dtype = Double if Version(sqlalchemy.__version__) >= Version("2.0.0") else Float |
| 108 | metadata = MetaData() |
| 109 | iris = Table( |
| 110 | "iris", |
| 111 | metadata, |
| 112 | Column("SepalLength", dtype), |
| 113 | Column("SepalWidth", dtype), |
| 114 | Column("PetalLength", dtype), |
| 115 | Column("PetalWidth", dtype), |
| 116 | Column("Name", String(200)), |
| 117 | ) |
| 118 | return iris |
| 119 | |
| 120 | |
| 121 | def create_and_load_iris_sqlite3(conn, iris_file: Path): |
no test coverage detected