<commit_before>ALTER TABLE PROPOSAL DISABLE CONSTRAINT FK_PROPOSAL_ACTIVITY_TYPE_CODE;
ALTER TABLE EPS_PROP_RATES DISABLE CONSTRAINT FK_EPS_PROP_RATES_ACTIVITY_KRA;
ALTER TABLE INSTITUTE_RATES DISABLE CONSTRAINT FK_INST_RATES_ACTIVITY_KRA;

insert into activity_type (activity_type_code, description, obj_id, update_timestamp, update_user, ver_nbr)
values('tst', 'test activity type', sys_guid(), sysdate, 'jhulslander', 1);

ALTER TABLE PROPOSAL ENABLE CONSTRAINT FK_PROPOSAL_ACTIVITY_TYPE_CODE;
ALTER TABLE EPS_PROP_RATES ENABLE CONSTRAINT FK_EPS_PROP_RATES_ACTIVITY_KRA;
ALTER TABLE INSTITUTE_RATES ENABLE CONSTRAINT FK_INST_RATES_ACTIVITY_KRA;

insert into notice_of_opportunity (description, notice_of_opportunity_code, obj_id, update_timestamp, update_user, ver_nbr)
values('opt descr', 'tod', sys_guid(), sysdate, 'jhulslander', 1);

ALTER TABLE ROLODEX DISABLE CONSTRAINT FK_ROLODEX_COUNTRY_KRA;
alter table state_code disable constraint FK_STATE_CODE_COUNTRY;
delete from country_code where country_code = 'USA';
insert into country_code(country_code, country_name, obj_id, update_timestamp, update_user, ver_nbr)
values ('USA', 'United States', sys_guid(), sysdate, 'jhulslander', 1);
alter table state_code enable constraint FK_STATE_CODE_COUNTRY;
ALTER TABLE ROLODEX ENABLE CONSTRAINT FK_ROLODEX_COUNTRY_KRA;

insert into ROLODEX (COMMENTS, PHONE_NUMBER, COUNTRY_CODE, SPONSOR_CODE, OWNED_BY_UNIT, SPONSOR_ADDRESS_FLAG, DELETE_FLAG, CREATE_USER, UPDATE_TIMESTAMP, UPDATE_USER,
  VER_NBR, OBJ_ID, ROLODEX_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, SUFFIX, PREFIX, TITLE, ORGANIZATION, ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3, FAX_NUMBER,
  EMAIL_ADDRESS, CITY, COUNTRY_CODE, STATE, POSTAL_CODE)
values('comment', '6072552047', 'USA', null, '01', 'N', null, 'jhulslander', sysdate, 'jhulslander',
  1, sys_guid(), 100, 'Hulslander', 'Jay', 'D', 'Mr.', null, null, '01', '120 maple ave', 'Ithaca NY 14850', null, null,
  '<EMAIL>', 'Ithaca', 'USA', 'NY', '14850');
  
insert into ROLODEX (COMMENTS, PHONE_NUMBER, COUNTRY_CODE, SPONSOR_CODE, OWNED_BY_UNIT, SPONSOR_ADDRESS_FLAG, DELETE_FLAG, CREATE_USER, UPDATE_TIMESTAMP, UPDATE_USER,
  VER_NBR, OBJ_ID, ROLODEX_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, SUFFIX, PREFIX, TITLE, ORGANIZATION, ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3, FAX_NUMBER,
  EMAIL_ADDRESS, CITY, COUNTRY_CODE, STATE, POSTAL_CODE)
values('comment', '6072552047', 'USA', null, '01', 'N', null, 'jhulslander', sysdate, 'jhulslander',
  1, sys_guid(), 101, 'Hulslander2', 'Jay2', 'D', 'Mr.', null, null, '01', '120 maple ave', 'Ithaca NY 14850', null, null,
  '<EMAIL>', 'Ithaca', 'USA', 'NY', '14850');

insert into sponsor_type(description, obj_id, sponsor_type_code, update_timestamp, update_user, ver_nbr)
values('test code', sys_guid(), 'tst', sysdate, 'jhulslander', 1);
  
insert into sponsor (SPONSOR_CODE, SPONSOR_NAME, ACRONYM, SPONSOR_TYPE_CODE, DUN_AND_BRADSTREET_NUMBER, DUNS_PLUS_FOUR_NUMBER, DODAC_NUMBER, CAGE_NUMBER, POSTAL_CODE,
  STATE, COUNTRY_CODE, ROLODEX_ID, AUDIT_REPORT_SENT_FOR_FY, OWNED_BY_UNIT, CREATE_USER, UPDATE_TIMESTAMP, UPDATE_USER, VER_NBR, OBJ_ID)
values('tst', 'tester', null, 'tst', null, null, null, null, '13068',
  'NY', 'USA', 100, null, '01', 'jhulslander', sysdate, 'jhulslander', 1, sys_guid());
  
insert into proposal_type (description, obj_id, proposal_type_code, update_timestamp, update_user, ver_nbr)
values('test type', sys_guid(), 'tst', sysdate, 'jhulslander', 1);

insert into proposal (MAIL_DESCRIPTION, PROPOSAL_SEQUENCE_STATUS, FISCAL_MONTH, FISCAL_YEAR, ACTIVITY_TYPE_CODE, REQUESTED_START_DATE_INITIAL, REQUESTED_START_DATE_TOTAL,
  REQUESTED_END_DATE_INITIAL, REQUESTED_END_DATE_TOTAL, TOTAL_DIRECT_COST_INITIAL, TOTAL_DIRECT_COST_TOTAL, TOTAL_INDIRECT_COST_INITIAL, TOTAL_INDIRECT_COST_TOTAL,
  NUMBER_OF_COPIES, DEADLINE_DATE, DEADLINE_TYPE, MAIL_BY, MAIL_TYPE, MAIL_ACCOUNT_NUMBER, SUBCONTRACT_FLAG, COST_SHARING_INDICATOR, IDC_RATE_INDICATOR, SPECIAL_REVIEW_INDICATOR,
  STATUS_CODE, SCIENCE_CODE_INDICATOR, NSF_CODE, PRIME_SPONSOR_CODE, INITIAL_CONTRACT_ADMIN, IP_REVIEW_ACTIVITY_INDICATOR, CURRENT_AWARD_NUMBER, CFDA_NUMBER, OPPORTUNITY,<commit_msg>fixing unit tests - still causes constraint violations but is at least valid sql now...<commit_after>ALTER TABLE PROPOSAL DISABLE CONSTRAINT FK_PROPOSAL_ACTIVITY_TYPE_CODE;
ALTER TABLE EPS_PROP_RATES DISABLE CONSTRAINT FK_EPS_PROP_RATES_ACTIVITY_KRA;
ALTER TABLE INSTITUTE_RATES DISABLE CONSTRAINT FK_INST_RATES_ACTIVITY_KRA;

insert into activity_type (activity_type_code, description, obj_id, update_timestamp, update_user, ver_nbr)
values('tst', 'test activity type', sys_guid(), sysdate, 'jhulslander', 1);

ALTER TABLE PROPOSAL ENABLE CONSTRAINT FK_PROPOSAL_ACTIVITY_TYPE_CODE;
ALTER TABLE EPS_PROP_RATES ENABLE CONSTRAINT FK_EPS_PROP_RATES_ACTIVITY_KRA;
ALTER TABLE INSTITUTE_RATES ENABLE CONSTRAINT FK_INST_RATES_ACTIVITY_KRA;

insert into notice_of_opportunity (description, notice_of_opportunity_code, obj_id, update_timestamp, update_user, ver_nbr)
values('opt descr', 'tod', sys_guid(), sysdate, 'jhulslander', 1);

ALTER TABLE ROLODEX DISABLE CONSTRAINT FK_ROLODEX_COUNTRY_KRA;
alter table state_code disable constraint FK_STATE_CODE_COUNTRY;
delete from country_code where country_code = 'USA';
insert into country_code(country_code, country_name, obj_id, update_timestamp, update_user, ver_nbr)
values ('USA', 'United States', sys_guid(), sysdate, 'jhulslander', 1);
alter table state_code enable constraint FK_STATE_CODE_COUNTRY;
ALTER TABLE ROLODEX ENABLE CONSTRAINT FK_ROLODEX_COUNTRY_KRA;

insert into ROLODEX (COMMENTS, PHONE_NUMBER, COUNTRY_CODE, SPONSOR_CODE, OWNED_BY_UNIT, SPONSOR_ADDRESS_FLAG, DELETE_FLAG, CREATE_USER, UPDATE_TIMESTAMP, UPDATE_USER,
  VER_NBR, OBJ_ID, ROLODEX_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, SUFFIX, PREFIX, TITLE, ORGANIZATION, ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3, FAX_NUMBER,
  EMAIL_ADDRESS, CITY, STATE, POSTAL_CODE)
values('comment', '6072552047', 'USA', null, '01', 'N', null, 'jhulslander', sysdate, 'jhulslander',
  1, sys_guid(), 100, 'Hulslander', 'Jay', 'D', 'Mr.', null, null, '01', '120 maple ave', 'Ithaca NY 14850', null, null,
  '<EMAIL>', 'Ithaca', 'NY', '14850');
  
insert into ROLODEX (COMMENTS, PHONE_NUMBER, COUNTRY_CODE, SPONSOR_CODE, OWNED_BY_UNIT, SPONSOR_ADDRESS_FLAG, DELETE_FLAG, CREATE_USER, UPDATE_TIMESTAMP, UPDATE_USER,
  VER_NBR, OBJ_ID, ROLODEX_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, SUFFIX, PREFIX, TITLE, ORGANIZATION, ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3, FAX_NUMBER,
  EMAIL_ADDRESS, CITY, STATE, POSTAL_CODE)
values('comment', '6072552047', 'USA', null, '01', 'N', null, 'jhulslander', sysdate, 'jhulslander',
  1, sys_guid(), 101, 'Hulslander2', 'Jay2', 'D', 'Mr.', null, null, '01', '120 maple ave', 'Ithaca NY 14850', null, null,
  '<EMAIL>', 'Ithaca', 'NY', '14850');

insert into sponsor_type(description, obj_id, sponsor_type_code, update_timestamp, update_user, ver_nbr)
values('test code', sys_guid(), 'tst', sysdate, 'jhulslander', 1);
  
insert into sponsor (SPONSOR_CODE, SPONSOR_NAME, ACRONYM, SPONSOR_TYPE_CODE, DUN_AND_BRADSTREET_NUMBER, DUNS_PLUS_FOUR_NUMBER, DODAC_NUMBER, CAGE_NUMBER, POSTAL_CODE,
  STATE, COUNTRY_CODE, ROLODEX_ID, AUDIT_REPORT_SENT_FOR_FY, OWNED_BY_UNIT, CREATE_USER, UPDATE_TIMESTAMP, UPDATE_USER, VER_NBR, OBJ_ID)
values('tst', 'tester', null, 'tst', null, null, null, null, '13068',
  'NY', 'USA', 100, null, '01', 'jhulslander', sysdate, 'jhulslander', 1, sys_guid());
  
insert into proposal_type (description, obj_id, proposal_type_code, update_timestamp, update_user, ver_nbr)
values('test type', sys_guid(), 'tst', sysdate, 'jhulslander', 1);

insert into proposal (MAIL_DESCRIPTION, PROPOSAL_SEQUENCE_STATUS, FISCAL_MONTH, FISCAL_YEAR, ACTIVITY_TYPE_CODE, REQUESTED_START_DATE_INITIAL, REQUESTED_START_DATE_TOTAL,
  REQUESTED_END_DATE_INITIAL, REQUESTED_END_DATE_TOTAL, TOTAL_DIRECT_COST_INITIAL, TOTAL_DIRECT_COST_TOTAL, TOTAL_INDIRECT_COST_INITIAL, TOTAL_INDIRECT_COST_TOTAL,
  NUMBER_OF_COPIES, DEADLINE_DATE, DEADLINE_TYPE, MAIL_BY, MAIL_TYPE, MAIL_ACCOUNT_NUMBER, SUBCONTRACT_FLAG, COST_SHARING_INDICATOR, IDC_RATE_INDICATOR, SPECIAL_REVIEW_INDICATOR,
  STATUS_CODE, SCIENCE_CODE_INDICATOR, NSF_CODE, PRIME_SPONSOR_CODE, INITIAL_CONTRACT_ADMIN, IP_REVIEW_ACTIVITY_INDICATOR, CURRENT_AWARD_NUMBER, CFDA_NUMBER, OPPORTUNITY,
{'fraction_non_alphanumeric': 0.10367170626349892, 'fraction_numerical': 0.020638348932085434, 'mean_word_length': 9.328376703841387, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, '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': '1370197', 'n_tokens_mistral': 3546, 'n_tokens_neox': 3210, 'n_words': 712}