def insert_or_update(self, item: SqlItem, force_insert=False):
try:
return self._insert_or_update(item, force_insert=force_insert)
except Exception as ex:
logger.fatal('Failed to insert item: %s',
pad_util.json_string_dump(item, pretty=True))
raise ex
def _process_awakenings(self, db):
logger.warning('loading awakenings')
for m in self.data.ownable_cards:
items = Awakening.from_csm(m)
for item in items:
try:
db.insert_or_update(item)
except:
human_fix_logger.fatal(
'Failed to insert item (probably new awakening): %s',
pad_util.json_string_dump(item, pretty=True))
def _process_awakenings(self, db):
logger.info('loading awakenings')
for m in self.data.ownable_cards:
items = Awakening.from_csm(m)
for item in items:
try:
db.insert_or_update(item)
except (KeyboardInterrupt, SystemExit):
raise
except:
human_fix_logger.fatal('Failed to insert item (probably new awakening): %s',
pad_util.json_string_dump(item, pretty=True))
sql = 'SELECT COUNT(*) FROM awakenings WHERE monster_id = {}'.format(m.monster_id)
stored_awakening_count = db.get_single_value(sql, op=int)
if len(items) < stored_awakening_count:
human_fix_logger.error('Incorrect awakening count for %s, got %s wanted %s',
m.monster_id, stored_awakening_count, len(items))
def _process_awakenings(self, db):
logger.info('loading awakenings')
for m in self.data.ownable_cards:
items = Awakening.from_csm(m)
for item in items:
try:
db.insert_or_update(item)
except (KeyboardInterrupt, SystemExit):
raise
except Exception:
human_fix_logger.fatal(
'Failed to insert item (probably new awakening): %s',
pad_util.json_string_dump(item, pretty=True))
sql = f'DELETE FROM {Awakening.TABLE} WHERE monster_id = {m.monster_id} AND order_idx >= {len(items)}'
deleted_awos = db.update_item(sql)
if deleted_awos:
logger.info(
f"Deleted {deleted_awos} unused awakenings from monster {m.monster_id}"
)
def run_test(args):
input_dir = args.input_dir
output_dir = args.output_dir
new_output_dir = os.path.join(output_dir, 'new')
pathlib.Path(new_output_dir).mkdir(parents=True, exist_ok=True)
golden_output_dir = os.path.join(output_dir, 'golden')
pathlib.Path(golden_output_dir).mkdir(parents=True, exist_ok=True)
jp_db = merged_database.Database(Server.jp, input_dir)
na_db = merged_database.Database(Server.na, input_dir)
kr_db = merged_database.Database(Server.kr, input_dir)
print('loading JP')
jp_db.load_database(skip_extra=True)
print('loading NA')
na_db.load_database(skip_extra=True)
print('loading KR')
kr_db.load_database(skip_extra=True)
print('merging data')
cross_db = CrossServerDatabase(jp_db, na_db, kr_db)
print('saving merged data')
cross_db.save_all(new_output_dir, True)
# Add sort by something, bonuses seem to be non-deterministicly ordered.
files = {
'all_cards.json': cross_db.all_cards,
'dungeons.json': cross_db.dungeons,
'active_skills.json': cross_db.active_skills,
'leader_skills.json': cross_db.leader_skills,
'enemy_skills.json': cross_db.enemy_skills,
# 'jp_bonuses.json': cross_db.jp_bonuses,
# 'na_bonuses.json': cross_db.na_bonuses,
# 'kr_bonuses.json': cross_db.kr_bonuses,
}
failed_comparisons = 0
bad_records = 0
print('starting diff')
for file, data in files.items():
new_file = os.path.join(new_output_dir, file)
golden_file = os.path.join(golden_output_dir, file)
if not os.path.exists(golden_file):
print('golden file does not exist, creating', golden_file)
shutil.copy(new_file, golden_file)
continue
print('diffing', golden_file, 'against', new_file)
with open(golden_file, encoding="utf-8") as f:
golden_data = json.load(f)
if len(golden_data) != len(data):
print('ERROR')
print(
'ERROR: file lengths differed ({} vs {}), indicates old golden data for {}'
.format(len(golden_data), len(data), file))
print('ERROR')
failed_comparisons += 1
continue
failures = []
for i in range(len(golden_data)):
gold_row = golden_data[i]
new_row = data[i]
gold_str = json_string_dump(gold_row, pretty=True)
new_str = json_string_dump(new_row, pretty=True)
if gold_str != new_str:
failures.append([gold_str, new_str])
if not failures:
continue
fail_count = len(failures)
disp_count = min(fail_count, 6)
print('encountered', fail_count, 'errors, displaying the first',
disp_count)
failed_comparisons += 1
bad_records += fail_count
failure_ids = []
for failure in failures:
gold_str = failure[0]
failure_ids.append(find_ids(gold_str))
print('All failing ids:\n' + '\n'.join(failure_ids))
for i in range(disp_count):
gold_str = failures[i][0]
new_str = failures[i][1]
print('row identifiers:\n{}\n'.format(find_ids(gold_str)))
diff_lines = difflib.context_diff(gold_str.split('\n'),
new_str.split('\n'),
fromfile='golden',
tofile='new',
n=1)
print('\n'.join(diff_lines))
if failed_comparisons:
print('Bad files:', failed_comparisons)
print('Bad records:', bad_records)
exit(1)
