Exemplos de query em Python

Exemplo n.º 1

    DC_TNS_NAME
)


if __name__ == "__main__" :
    """ 为一柜通新增营业部运营参数脚本 """

    try:

        MSG_INFO = {}
        MSG_INFO["MSG_NO"] = 0
        MSG_INFO["MSG_STR"] = "初始消息空间"

        ''' 获取 任务运行参数 '''
        sqlStr = "select * from insbusi_inserneworginfo where insert_org_flag = '0';"
        xList = mySqlConn.query(sqlStr)

        if len(xList) == 0:
            MSG_INFO["MSG_NO"] = 100001
            MSG_INFO["MSG_STR"] = "没有要增加的记录，请检查参数表中的处理标志！"
            raise Exception (MSG_INFO)

        for init in xList:

            bSysName = "一柜通_{0}".format(init["org_code"])

            # 动态生成任务名称
            taskName = "{0}_{1}".format(bSysName, globParaList["YGT_ORACLE_HOST"])
            init["task_name"] = taskName

            # 保留的日志文件

Exemplo n.º 2

import os
import datetime
import json
import time
import schedule
import threading

from apps.runscripts.Ext_Functions.CommFuncs import C_PrintLog, Get_Param_Info, \
    cxOracle, Print_Dict_KandV, Gen_Now_Date, Dict2List

os.environ['DJANGO_SETTINGS_MODULE'] = 'YwzcWebSys.settings'
from apps.commset.GetSysInfo import mySqlConn

strSql = "select param_value from YwzcWebSys.commset_sysparam where param_en_name='CALENDAR_SOURCE'"

CParam = mySqlConn.query(strSql)
CParam = eval(CParam[0]["param_value"].replace("\r\n", "").replace(" ", ""))

print(CParam)

# 创建到账户库的链接
TNS_NAME = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=%s)(PORT=%s)))(CONNECT_DATA=(SERVICE_NAME=%s)))' % (
    CParam["ORACLE_HOST"], CParam["ORACLE_PORT"],
    CParam["ORACLE_SERVICE_NAME"])
oraConn = cxOracle(CParam["ORACLE_USER_NAME"], CParam["ORACLE_USER_PASSWD"],
                   TNS_NAME)

oraStrSql = "SELECT * FROM {0} A".format(CParam["TABLE_NAME"])

rtnDatas = oraConn.QueryDict(oraStrSql)