python操作Oracle、PostgreSQL，MySql数据库增删改查

VIP文章 uid010102

已于 2022-09-29 09:29:12 修改

阅读量560

点赞数

文章标签：数据库 oracle postgresql mysql python

于 2022-09-28 17:17:37 首次发布

本文链接：https://blog.csdn.net/weixin_43403390/article/details/127093285

版权

python操作Oracle、PostgreSQL，MySql数据库增删改查，工作中可运行案例，直接上代码，供大家参考。

# _*_ coding:UTF-8 _*_

#import ServerConfig
import cx_Oracle
import psycopg2
import pymysql

from dbutils.pooled_db import PooledDB

class ConnDB:
    def __init__(self, user_db):
        self._pool = None
        self._userdb = user_db
        self.conn = self.get_pool_conn()

    def get_pool_conn(self):
        if not self._pool:
            self.init_dbsql_pool()
        return self._pool.connection()

    def init_dbsql_pool(self):
        # dbinfo = ServerConfig.cfgInfo(self._userdb)
        dbinfo = {'username': 'test',
                  'userpwd': 'str(v_dbpwd)',
                  'database': 'testdb',
                  'dbhost': '112.112.112.112',
                  'dbport': 51290,
                  'obj_name': 'oracle'}
        print("Begin to create %s" % dbinfo['dbhost'] + " %s pool ." % dbinfo['obj_name'])
        try:
            if dbinfo['obj_name'] == 'pg' or dbinfo['obj_name'] == 'mysql':
                v_creator = psycopg2
                if dbinfo['obj_name'] == 'pg':
                    v_creator = psycopg2
                elif dbinfo['obj_name'] == 'mysql':
                    v_creator = pymysql
                else:
                    pass
                pool = PooledDB(
                    creator=v_creator,
                    maxconnections=6,
                    mincached=1,
                    maxcached&