def apply_patch(store):
store.execute("""ALTER TABLE account ADD COLUMN account_type int;""")
# We need to add back the account_type column removed in 2-27
try:
Account.sqlmeta.addColumn(IntCol('account_type', default=None))
except KeyError:
pass
# Register the accounts again to set the account_type
register_accounts(store)
def apply_patch(store):
profiles = store.find(ProfileSettings, app_dir_name=u'admin')
for profile in profiles:
store.find(ProfileSettings,
app_dir_name=u'financial',
has_permission=profile.has_permission,
user_profile=profile.user_profile)
store.execute("""
CREATE TABLE account (
id serial NOT NULL PRIMARY KEY,
te_created_id bigint UNIQUE REFERENCES transaction_entry(id),
te_modified_id bigint UNIQUE REFERENCES transaction_entry(id),
description text NOT NULL,
code text,
parent_id bigint REFERENCES account(id),
station_id bigint REFERENCES branch_station(id)
);""")
store.execute("""
CREATE TABLE account_transaction (
id serial NOT NULL PRIMARY KEY,
te_created_id bigint UNIQUE REFERENCES transaction_entry(id),
te_modified_id bigint UNIQUE REFERENCES transaction_entry(id),
description text,
code text,
value numeric(10, 3) CONSTRAINT nonzero_value CHECK (value != 0),
source_account_id bigint REFERENCES account(id) NOT NULL,
account_id bigint REFERENCES account(id) NOT NULL,
date timestamp NOT NULL,
payment_id bigint REFERENCES payment(id)
);""")
# Patch 2-30 introduces this
try:
from stoqlib.domain.account import Account
Account.sqlmeta.delColumn('account_type')
except KeyError:
pass
register_accounts(store)
