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, defaults to ''

Returns:

valid name of the table in the database

Return type:

str

Examples:

>>> from pydriosm.ios import validate_table_name

>>> subrgn_name = 'greater london'
>>> valid_table_name = validate_table_name(subrgn_name)
>>> valid_table_name
'greater london'

>>> subrgn_name = 'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch, Wales'
>>> valid_table_name = validate_table_name(subrgn_name, sub_space='_')
>>> valid_table_name
'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch_W..'