orm備忘

• upsert，存在及更新，不存在則插入

from sqlalchemy.dialects.mysql import insertinsert_stmt = insert(FileModule).values(file_path=par_dict.file, module_key=par_dict.module_key,module_name=par_dict.module_name, project_id=par_dict.project_id)
on_duplicate_key_stmt = insert_stmt.on_duplicate_key_update(module_key=par_dict.module_key,module_name=par_dict.module_name)
db.execute(on_duplicate_key_stmt)
db.commit()
# FileModule是實體類，file和project_id組成唯一索引

https://docs.sqlalchemy.org/en/20/dialects/mysql.html#mysql-insert-on-duplicate-key-update
https://segmentfault.com/a/1190000042750099

• sql in 用法

CoverageReport.report_id.in_(query_param.report_ids)

• 模糊查詢

if query_param.main_thread_stack:filters.add(LogInfo.main_thread_stack.like('%' + query_param.main_thread_stack + '%'))

• python列表字典實現同名列相加

import collections
import functools
import operator
...
batch_map_add.append({"branches": file_detail['branch_covered'],"total_branches": file_detail['branch_total'],"functions": file_detail['function_covered'],"total_functions": file_detail['function_total'],"lines": file_detail['line_covered'],"total_lines": file_detail['line_total']})
...
result = dict(functools.reduce(operator.add,map(collections.Counter, batch_map_add)))