bw2data.updates

Module Contents

Classes

Updates

Attributes

UPDATE_ACTIVITYDATASET
UPDATE_EXCHANGEDATASET
UPDATE_WARNING
hash_re
is_hash

class bw2data.updates.Updates

UPDATES

classmethod _reprocess_all()

classmethod check_automatic_updates()

Get list of automatic updates to be applied

classmethod check_status(verbose=True)

Check if updates need to be applied.

Returns:

List of needed updates (strings), if any.

classmethod database_search_directories_20()

classmethod do_update(key)

classmethod expire_all_processed_data_40()

classmethod explain(key)

classmethod fix_migrations_filename()

“Fix migration data filenames to use shorter hash.

See brightway-lca/brightway2-io#115

classmethod processed_data_format_change_23()

classmethod reprocess_all_1_0()

1.0: Reprocess all to make sure default ‘loc’ value inserted when not specified.

classmethod schema_change_20_compound_keys()

classmethod set_initial_updates()

bw2data.updates.UPDATE_ACTIVITYDATASET = Multiline-String

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

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;
"""

bw2data.updates.UPDATE_WARNING = Multiline-String

Show Value

"""

Your data needs to be updated.

"""

bw2data.updates.hash_re

bw2data.updates.is_hash