如何将sql插入语句转换为1个liner并在python中逐个运行？

Question

嗨，我是 python 新手，所以问这个问题。我已在文件中插入查询。 我必须将它们一一处决。 你能帮我看看我该怎么做吗？它们保存在文本文件中。他们不在 1 班轮中。我们如何将它们制作成 1 个衬垫或将它们转换为数据帧？

例子： 插入语句.txt

INSERT INTO imedical_cleansing_rule_metadata
(
  Data_Set_Name,
  Region,
  Layer,
  Table_Name,
  Column_Name,
  Column_Seq,
  EC2_Source_Path,
  EC2_Target_Path,
  Is_Active,
  s3_tgt_path,
  Rule,
  Spectrum_Table_Name,
  Sub_Rule
)
VALUES
(
  'JGVCC',
  'ASPAC',
  'Raw_Layer',
  'DM_GENESYS_CONVERSTION_AGG',
  'queue_name',
  2,
  '/medaff/Scripts/Incoming_Src_Files/',
  '/medaff/eureka/RawLayer/JGVCC/ASPAC/Genesys/DM_GENESYS_CONVERSTION_AGG/',
  'N',
  's3://itx-{}-jg-aspac/jgvcc/Raw_Layer/DM_GENESYS_CONVERSTION_AGG/',
  'rule1;rule3;rule4;rule2;rule6;rule19',
  'lnd_jgvcc_aspac_genesys_call_detail',
  NULL
);


INSERT INTO imedical_cleansing_rule_metadata
(
  Data_Set_Name,
  Region,
  Layer,
  Table_Name,
  Column_Name,
  Column_Seq,
  EC2_Source_Path,
  EC2_Target_Path,
  Is_Active,
  s3_tgt_path,
  Rule,
  Spectrum_Table_Name,
  Sub_Rule
)
VALUES
(
  'JGVCC',
  'ASPAC',
  'Raw_Layer',
  'DM_EUAVCC_CASE_CRM',
  'parent_case_number',
  1,
  '/medaff/Scripts/Incoming_Src_Files/',
  '/medaff/eureka/RawLayer/JGVCC/ASPAC/CRM/DM_EUAVCC_CASE_CRM/',
  'N',
  's3://itx-{}-jg-aspac/jgvcc/Raw_Layer/DM_EUAVCC_CASE_CRM/',
  'rule1;rule3;rule4;rule2;rule6;rule19',
  'lnd_jgvcc_aspac_crm_activity',
  NULL
);

Answer 1

如果所有查询都由一个空行分隔，您可以读取它们并将其存储在列表中：

with open("insert_statement.txt", "r") as file:
    query_list = file.read().split("\n\n\n")
    query_list = [query.replace('\n', ' ') for query in query_list]

for query in query_list:
    print(query)
    #  execute(query)