本文整理汇总了Python中qiita_db.metadata_template.prep_template.PrepTemplate.metadata_headers方法的典型用法代码示例。如果您正苦于以下问题:Python PrepTemplate.metadata_headers方法的具体用法?Python PrepTemplate.metadata_headers怎么用?Python PrepTemplate.metadata_headers使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类qiita_db.metadata_template.prep_template.PrepTemplate
的用法示例。
在下文中一共展示了PrepTemplate.metadata_headers方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: array_agg
# 需要导入模块: from qiita_db.metadata_template.prep_template import PrepTemplate [as 别名]
# 或者: from qiita_db.metadata_template.prep_template.PrepTemplate import metadata_headers [as 别名]
with TRN:
# a few notes: just getting the preps with duplicated values; ignoring
# column 'sample_id' and tables 'study_sample', 'prep_template',
# 'prep_template_sample'
sql = """SELECT table_name, array_agg(column_name::text)
FROM information_schema.columns
WHERE column_name IN %s
AND column_name != 'sample_id'
AND table_name LIKE 'prep_%%'
AND table_name NOT IN (
'prep_template', 'prep_template_sample')
GROUP BY table_name"""
# note that we are looking for those columns with duplicated names in
# the headers
headers = set(PrepTemplate.metadata_headers()) & \
set(SampleTemplate.metadata_headers())
if headers:
TRN.add(sql, [tuple(headers)])
overlapping = dict(TRN.execute_fetchindex())
else:
overlapping = None
if overlapping is not None:
# finding actual duplicates
for table_name, cols in viewitems(overlapping):
# leaving print so when we patch in the main system we know that
# nothing was renamed or deal with that
print table_name
with TRN: