def test_adapt_schema(): schema = Schema.from_column_dicts(V2_SCHEMA_DATA) dataset = FakeDataset() dataset.schema = schema dataset.tree = dataset dataset.name = "test_dataset" sqlite_table_info = generate_sqlite_table_info(dataset) assert sqlite_table_info == [ { 'cid': 0, 'name': 'OBJECTID', 'pk': 1, 'type': 'INTEGER', 'notnull': 1, 'dflt_value': None, }, { 'cid': 1, 'name': 'GEOMETRY', 'pk': 0, 'type': 'GEOMETRY', 'notnull': 0, 'dflt_value': None, }, { 'cid': 2, 'name': 'Ward', 'pk': 0, 'type': 'TEXT', 'notnull': 0, 'dflt_value': None, }, { 'cid': 3, 'name': 'Shape_Leng', 'pk': 0, 'type': 'REAL', 'notnull': 0, 'dflt_value': None, }, { 'cid': 4, 'name': 'Shape_Area', 'pk': 0, 'type': 'REAL', 'notnull': 0, 'dflt_value': None, }, ]
def test_adapt_schema(): schema = Schema.from_column_dicts(V2_SCHEMA_DATA) dataset = FakeDataset() dataset.schema = schema dataset.tree = dataset dataset.name = "test_dataset" sqlite_table_info = generate_sqlite_table_info(dataset) assert sqlite_table_info == [ { "cid": 0, "name": "OBJECTID", "pk": 1, "type": "INTEGER", "notnull": 1, "dflt_value": None, }, { "cid": 1, "name": "GEOMETRY", "pk": 0, "type": "GEOMETRY", "notnull": 0, "dflt_value": None, }, { "cid": 2, "name": "Ward", "pk": 0, "type": "TEXT", "notnull": 0, "dflt_value": None, }, { "cid": 3, "name": "Shape_Leng", "pk": 0, "type": "REAL", "notnull": 0, "dflt_value": None, }, { "cid": 4, "name": "Shape_Area", "pk": 0, "type": "REAL", "notnull": 0, "dflt_value": None, }, ]