今天要实现一个Python代码换行输出的功能,记录一下~
需求描述:
根据表名、字段、类型生成4条sql语句,并将结果分4行输出
通过\n实现一次输出,代码实现如下
方案一(4次print):
def test_new_sql():
"""根据表名、待改字段、目标数据类型生成sql"""
table = 'NES_ACCOUNT_BIZ_INFO_EXT'
wd = 'PROF_CODE'
type = 'VARCHAR2(10)'
sql1 = "alter table CS_PLATFORM2.{} rename column {} to {}_bak;".format(table, wd, wd)
sql2 = "alter table CS_PLATFORM2.{} add(PROF_CODE {});".format(table, type)
sql3 = "update CS_PLATFORM2.{} set {} = trim({}_bak);".format(table, wd, wd)
sql4 = "alter table CS_PLATFORM2.{} drop column {}_bak;".format(table, wd)
print('***************')
print(sql1)
print(sql2)
print(sql3)
print(sql4)
print('***************')
效果:
方案二(1次print):
def test_new_sql():
"""根据表名、待改字段、目标数据类型生成sql"""
table = 'NES_ACCOUNT_BIZ_INFO_EXT'
wd = 'PROF_CODE'
type = 'VARCHAR2(10)'
sql1 = "alter table CS_PLATFORM2.{} rename column {} to {}_bak;".format(table, wd, wd)
sql2 = "alter table CS_PLATFORM2.{} add(PROF_CODE {});".format(table, type)
sql3 = "update CS_PLATFORM2.{} set {} = trim({}_bak);".format(table, wd, wd)
sql4 = "alter table CS_PLATFORM2.{} drop column {}_bak;".format(table, wd)
print('***************')
print(sql1 + "\n" + sql2 + "\n" + sql3 + "\n" + sql4)
print('***************')
效果: