BigQuery 中的 md5

Google

使用BigQuery中的md5生成文章

Python
from Google.cloud import bigquery
# 连接到BigQuery客户端
client = bigquery.Client()
# 选择数据集和表
dataset_id = 'your_dataset_id'
table_id = 'your_table_id'
table_ref = client.dataset(dataset_id).table(table_id)
# 执行查询
query = f"""
SELECT md5(text_column) as hashed_text
FROM <code>{table_ref}</code>
"""
query_job = client.query(query)
# 获取查询结果
results = query_job.result()
# 遍历结果并生成文章
article = ""
for row in results:
    hashed_text = row.hashed_text
    article += hashed_text
print(article)

Python
# 生成文章
article = ""
for i, row in enumerate(results):
    hashed_text = row.hashed_text
    if i == len(results) // 2:
        article += "<strong>中间段落标题</strong>\n\n"
    article += hashed_text + " "
print(article)