<commit_before>BEGIN;
/* accounts */
INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('dexb00', current_date, current_date);

INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('dexb01', current_date, current_date);

INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('dexb02', current_date, current_date);

INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('binb00', current_date, current_date);

INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('unib00', current_date, current_date);

/* markets */
INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('ams', 'Amsterdam', 'NL', current_date, current_date);

INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('ebr', 'Brussels', 'BE', current_date, current_date);

INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('etr', 'Xetra', 'DE', current_date, current_date);

INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('epa', 'Paris', 'FR', current_date, current_date);

INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('other', 'Other', '', current_date, current_date);

/* stock names */
INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('rhji', '2', 'RHJI International', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('nests', '2', 'Nestle', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('devg', '2', 'Devgen', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('enin', '2', '4 Energy Invest', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('adhof', '1', 'Koninklijke AHOLD N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('dexb', '2', 'Dexia', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('crxl', '1', 'Crucell N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('drak', '1', 'Draka Holding N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('theb', '2', 'Thenergo N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('eurn', '2', 'Euronav', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('tnet', '2', 'Telenet', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('exm', '2', 'Exmar', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('cofb', '2', 'Cofinimmo N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('fme', '3', 'Fresenius Medical Care', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('gsz', '4', 'GDF Suez SA', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('zsl23.90', '2', 'Zilver Sprinter Long 23.90', current_date, current_date);

/* products */
INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('account.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('account.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('bet.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('bet.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('bill.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('bill.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('car.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('car.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('clothes.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('clothes.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('extra.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('extra.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('food.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('food.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('gift.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('gift.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('hobby.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('hobby.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('house.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('house.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('invest.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('invest.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('trade.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('trade.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('salary.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('salary.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('tax.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('tax.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('travel.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('travel.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('utilities.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('utilities.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('other.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('other.tx', 0, current_date, current_date);

/* t_object */
INSERT INTO T_OBJECT(name, date_created, date_modified)
values('none', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('buystocks', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('sellstocks', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('invest', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('refund', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('dividend', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('close', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('electricity', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('gas', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('water', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('mutuality', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('internet', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('dexia', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('other', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('insurance', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('police', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('vik', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('phone', current_date, current_date);

/* margin types */
INSERT INTO T_MARGIN_TYPE(margin_type)
values('safety');

/* margins */
INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Financial reserve', 5000, current_date, current_date);

INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Financial reserve after crossover', 1600000, current_date, current_date);

INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Safety margin passive income', 5000, current_date, current_date);

INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Safe withdrawal rate', 0.03, current_date, current_date);

INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Bargain reserve', 100000, current_date, current_date);
COMMIT;<commit_msg>Not used, comment for now. Will be moved or removed later.<commit_after>BEGIN;
/* accounts */
INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('dexb00', current_date, current_date);

INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('dexb01', current_date, current_date);

INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('dexb02', current_date, current_date);

INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('binb00', current_date, current_date);

INSERT INTO T_ACCOUNT(name, date_created, date_modified)
values('unib00', current_date, current_date);

/* markets */
INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('ams', 'Amsterdam', 'NL', current_date, current_date);

INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('ebr', 'Brussels', 'BE', current_date, current_date);

INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('etr', 'Xetra', 'DE', current_date, current_date);

INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('epa', 'Paris', 'FR', current_date, current_date);

INSERT INTO T_MARKET(code, name, country, date_created, date_modified)
values('other', 'Other', '', current_date, current_date);

/* stock names */
INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('rhji', '2', 'RHJI International', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('nests', '2', 'Nestle', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('devg', '2', 'Devgen', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('enin', '2', '4 Energy Invest', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('adhof', '1', 'Koninklijke AHOLD N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('dexb', '2', 'Dexia', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('crxl', '1', 'Crucell N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('drak', '1', 'Draka Holding N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('theb', '2', 'Thenergo N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('eurn', '2', 'Euronav', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('tnet', '2', 'Telenet', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('exm', '2', 'Exmar', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('cofb', '2', 'Cofinimmo N.V.', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('fme', '3', 'Fresenius Medical Care', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('gsz', '4', 'GDF Suez SA', current_date, current_date);

INSERT INTO T_STOCK_NAME(name, mid, description, date_created, date_modified)
values('zsl23.90', '2', 'Zilver Sprinter Long 23.90', current_date, current_date);

/* products */
INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('account.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('account.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('bet.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('bet.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('bill.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('bill.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('car.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('car.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('clothes.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('clothes.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('extra.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('extra.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('food.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('food.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('gift.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('gift.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('hobby.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('hobby.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('house.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('house.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('invest.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('invest.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('trade.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('trade.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('salary.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('salary.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('tax.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('tax.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('travel.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('travel.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('utilities.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('utilities.tx', 0, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('other.rx', 1, current_date, current_date);

INSERT INTO T_PRODUCT(name, flg_income, date_created, date_modified)
values('other.tx', 0, current_date, current_date);

/* t_object */
INSERT INTO T_OBJECT(name, date_created, date_modified)
values('none', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('buystocks', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('sellstocks', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('invest', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('refund', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('dividend', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('close', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('electricity', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('gas', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('water', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('mutuality', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('internet', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('dexia', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('other', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('insurance', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('police', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('vik', current_date, current_date);

INSERT INTO T_OBJECT(name, date_created, date_modified)
values('phone', current_date, current_date);

/* margin types */
INSERT INTO T_MARGIN_TYPE(margin_type)
values('safety');

/* margins */
/* -- Note: this might belong to the bi sql folder
INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Financial reserve', 5000, current_date, current_date);

INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Financial reserve after crossover', 1600000, current_date, current_date);

INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Safety margin passive income', 5000, current_date, current_date);

INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Safe withdrawal rate', 0.03, current_date, current_date);

INSERT INTO T_MARGIN(margin_type_id, description, value, date_created, date_modified)
values(1, 'Bargain reserve', 100000, current_date, current_date);*/
COMMIT;
{'fraction_non_alphanumeric': 0.11969625059326056, 'fraction_numerical': 0.009302325581395349, 'mean_word_length': 9.043374642516683, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7444682', 'n_tokens_mistral': 7367, 'n_tokens_neox': 6929, 'n_words': 1772}