public string SetupDb(string urlBase) { Db = new DbConfiguration(new SqliteFactory()); var created = Db.CheckDb(); TableCreation.CreateTables(Db.DbConnection()); if (created) { CreateDefaultSettingsPage(urlBase); } else { // Shrink DB TableCreation.Vacuum(Db.DbConnection()); } var version = CheckSchema(); if (version > 0) { if (version > 1899 && version <= 1900) { MigrateToVersion1900(); } if (version > 1899 && version <= 1910) { MigrateToVersion1910(); } } return(Db.DbConnection().ConnectionString); }
public string SetupDb(string urlBase) { Db = new DbConfiguration(new SqliteFactory()); var created = Db.CheckDb(); TableCreation.CreateTables(Db.DbConnection()); if (created) { CreateDefaultSettingsPage(urlBase); } var version = CheckSchema(); if (version > 0) { if (version > 1300 && version <= 1699) { MigrateDbFrom1300(); UpdateRequestBlobsTable(); } } return(Db.DbConnection().ConnectionString); }
public string SetupDb(string urlBase) { Db = new DbConfiguration(new SqliteFactory()); var created = Db.CheckDb(); TableCreation.CreateTables(Db.DbConnection()); if (created) { CreateDefaultSettingsPage(urlBase); } else { // Shrink DB TableCreation.Vacuum(Db.DbConnection()); } // Add the new 'running' item into the scheduled jobs so we can check if the cachers are running Db.DbConnection().AlterTable("ScheduledJobs", "ADD", "Running", true, "INTEGER"); return(Db.DbConnection().ConnectionString); }
public string SetupDb(string urlBase) { Db = new DbConfiguration(new SqliteFactory()); var created = Db.CheckDb(); TableCreation.CreateTables(Db.DbConnection()); if (created) { CreateDefaultSettingsPage(urlBase); } else { // Shrink DB TableCreation.Vacuum(Db.DbConnection()); } // The below code is obsolete, we should use PlexRequests.Core.Migrations.MigrationRunner var version = CheckSchema(); if (version > 0) { if (version > 1899 && version <= 1900) { MigrateToVersion1900(); } if (version > 1899 && version <= 1910) { MigrateToVersion1910(); } } return(Db.DbConnection().ConnectionString); }