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,
},
]