(table_name: str, fields: FieldMap)
| 80 | |
| 81 | |
| 82 | def make_schema_sql(table_name: str, fields: FieldMap) -> str: |
| 83 | check_identifier(table_name) |
| 84 | pk = 'pk INTEGER PRIMARY KEY,' |
| 85 | spcs = ' ' * 4 |
| 86 | columns = ',\n '.join( |
| 87 | f'{field_name} {sql_type}' |
| 88 | for field_name, sql_type in gen_columns_sql(fields) |
| 89 | ) |
| 90 | return f'CREATE TABLE {table_name} (\n{spcs}{pk}\n{spcs}{columns}\n)' |
| 91 | |
| 92 | |
| 93 | def create_table(table_name: str, fields: FieldMap) -> None: |