DbMigration

static class · namespace z3n7 · source Db/DbExtencions.cs

public static class DbMigration

Copying tables inside the project database and between PostgreSQL and SQLite.

Methods#

MigrateAllTables#

public static void MigrateAllTables(this IZennoPosterProjectModel project)

Extension method for IZennoPosterProjectModel. source

Copies every user table from the current database to the other kind: PostgreSQL → SQLite or SQLite → PostgreSQL (see Sql.MigrateAllTablesAsync). Errors are written to the log as a warning.

Remarks: PostgreSQL is reached at localhost:5432, database and user postgres, password from the DBpstgrPass variable; SQLite at the DBsqltPath variable.

MigrateTable#

public static void MigrateTable(this IZennoPosterProjectModel project, string source, string dest)

Extension method for IZennoPosterProjectModel. source

Copies source to a new table dest in the same database, then renames a column acc0 or key to id if there is one.

Remarks: The database kind follows dbSource. PostgreSQL is reached at localhost:5432, database and user postgres, password from the DBpstgrPass variable; SQLite at the DBsqltPath variable.