2023-02-28

        for index, rows in df.iterrows():
            item['child'] = {'code': rows['sbj_code'], 'name': rows['sbj_name']}
            chi_data.append(item)

oracle批量插入数据

-- 分组批量更新数据
merge into
schemas.table1 mc
using
(
SELECT
mc.TABLE_ID,
new_mc.NEW_TABLE_NAME,
new_mc.TABLE_NAME_EN,
new_mc.TABLE_ADDRESS
FROM
schemas.table1 mc
LEFT JOIN
(
SELECT
TABLE_ID,
concat('TABLE_NAME', to_char(rownum, 'fm999900')) NEW_TABLE_NAME,
concat('TABLE_NAME_EN_', to_char(rownum, 'fm999900')) TABLE_NAME_EN,
concat('TABLE_ADDRESS_', to_char(rownum, 'fm999900')) TABLE_ADDRESS
FROM (
SELECT TABLE_NAME FROM schemas.table1 GROUP BY TABLE_NAME
)a
) new_mc ON mc.TABLE_NAME = new_mc.TABLE_NAME

)new_mc

on ( mc.TABLE_ID = new_mc.TABLE_ID )
when matched then
update set
mc.TABLE_NAME = new_mc.NEW_TABLE_NAME,
mc.TABLE_NAME_EN = new_mc.TABLE_NAME_EN,
mc.TABLE_ADDRESS = new_mc.TABLE_ADDRESS