bw2data.updates#
Attributes#
Classes#
Module Contents#
- class bw2data.updates.Updates[source]#
-
- classmethod check_status(verbose=True)[source]#
Check if updates need to be applied.
- Returns:
List of needed updates (strings), if any.
- bw2data.updates.UPDATE_ACTIVITYDATASET = Multiline-String[source]#
Show Value
""" BEGIN; DROP INDEX IF EXISTS "activitydataset_key"; ALTER TABLE ActivityDataset rename to AD_old; CREATE TABLE "activitydataset" ( "id" INTEGER NOT NULL PRIMARY KEY, "database" TEXT NOT NULL, "code" TEXT NOT NULL, "data" BLOB NOT NULL, "location" TEXT, "name" TEXT, "product" TEXT, "type" TEXT ); INSERT INTO ActivityDataset ("database", "code", "data", "location", "name", "product", "type") SELECT substr(key, 0, instr(key, 'β‘')), substr("key", instr("key", 'β‘') + 1), "data", "location", "name", "product", "type" FROM AD_old; CREATE UNIQUE INDEX "activitydataset_key" ON "activitydataset" ("database", "code"); DROP TABLE AD_old; COMMIT; """
- bw2data.updates.UPDATE_EXCHANGEDATASET = Multiline-String[source]#
Show Value
""" BEGIN; DROP INDEX IF EXISTS "exchangedataset_database"; DROP INDEX IF EXISTS "exchangedataset_input"; DROP INDEX IF EXISTS "exchangedataset_output"; ALTER TABLE ExchangeDataset rename to ED_old; CREATE TABLE "exchangedataset" ( "id" INTEGER NOT NULL PRIMARY KEY, "data" BLOB NOT NULL, "input_database" TEXT NOT NULL, "input_code" TEXT NOT NULL, "output_database" TEXT NOT NULL, "output_code" TEXT NOT NULL, "type" TEXT NOT NULL ); INSERT INTO ExchangeDataset ("data", "input_database", "input_code", "output_database", "output_code", "type") SELECT "data", substr("input", 0, instr("input", 'β‘')), substr("input", instr("input", 'β‘') + 1), substr("output", 0, instr("output", 'β‘')), substr("output", instr("output", 'β‘') + 1), "type" FROM ED_old; CREATE INDEX "exchangedataset_input" ON "exchangedataset" ("input_database", "input_code"); CREATE INDEX "exchangedataset_output" ON "exchangedataset" ("output_database", "output_code"); DROP TABLE ED_old; COMMIT; """