validate_table_name

pydriosm.ios.validate_table_name(table_name, sub_space='')

Validate a table name for importing OSM data into a PostgreSQL database.

Parameters
  • table_name (str) – name as input of a table in a PostgreSQL database

  • sub_space (str) – substitute for space

Returns

valid name of the table in the database

Return type

str

Examples:

>>> from pydriosm.ios import validate_table_name

>>> region_name = 'greater london'

>>> valid_table_name = validate_table_name(region_name)
>>> print(valid_table_name)
greater london

>>> region_name = 'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch, Wales'

>>> valid_table_name = validate_table_name(region_name, sub_space='_')
>>> print(valid_table_name)
Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch_W..