mss_dataserver.core.database_util.update_db_table

mss_dataserver.core.database_util.update_db_table(engine, table, metadata, prefix)[source]

Update the table structure to the new schema.

Parameters
  • engine (sqlalchemy.engine.Engine) – The sqlalchemy database Engine.

  • table (sqlalchemy.schema.Table) – The table to migrate.

  • metadata (sqlalchemy.schema.MetaData) – The tables of the current database schema.

  • prefix (String) – The database table name prefix. The names of the tables contain only the basename (e.g. geom_recorder). The full table name usually contains the name of the project as a prefix.