oracle用字段注释建立视图

from u_工具 import *


oracle_conf = {
    "host": "192.168.1.102",
    "port": 1521,
    "user": "c##admin",
    "password": "admin",
    "db": "orcl"
}
dal = oracle(oracle_conf)

表名 = "student"
视图名 = "view_" + 表名


sql = f'''
    select t.column_name, nvl(t.comments,t.column_name) comments 
    from user_col_comments t 
    where t.table_name = upper('{表名}')
'''
lines = dal.exec(sql).lines
原始列名_list = stream(lines).map(lambda i: i["COLUMN_NAME"]).collect()
注释列名_list = stream(lines).map(lambda i: i["COMMENTS"]).collect()

select部分_str = ""
for (原始列名, 注释列名) in zip(原始列名_list, 注释列名_list):
    单行 = f''',{原始列名} "{注释列名}"\n        '''
    select部分_str += 单行
select部分_str = " " + select部分_str[1:]

sql = f'''
    create view {视图名} as
    select 
        {select部分_str} 
    from 
        {表名} 
'''

print(sql)
# dal.exec(sql).commit()

-- u_工具：https://github.com/hl-mio/u_util/tree/main/python3