Skip to content

If spatialite detected, mark idx_XXX_Geometry tables as hidden #228

New issue
New issue
Closed
Closed
If spatialite detected, mark idx_XXX_Geometry tables as hidden#228
Labels
small
@simonw

Description

@simonw
simonw
opened on Apr 19, 2018

https://timezones-api.now.sh/timezones-faf26d0

2018-04-19 at 1 36 pm

Need to update this logic:

datasette/datasette/app.py

Lines 1276 to 1288 in e2750c7

if detect_spatialite(conn):
# Also hide Spatialite internal tables
hidden_tables += [
'ElementaryGeometries', 'SpatialIndex', 'geometry_columns',
'spatial_ref_sys', 'spatialite_history', 'sql_statements_log',
'sqlite_sequence', 'views_geometry_columns', 'virts_geometry_columns'
]
for t in tables.keys():
for hidden_table in hidden_tables:
if t == hidden_table or t.startswith(hidden_table):
tables[t]['hidden'] = True
continue

Metadata

Metadata

Assignees

No one assigned

    Labels

    small

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions