python 封装 oracle数据库，sql处理函数，新增、查询、修改、删除

最新推荐文章于 2024-06-20 22:30:37 发布

天道酬勤_业道酬信

最新推荐文章于 2024-06-20 22:30:37 发布

阅读量589

点赞数

分类专栏：程序人生文章标签： python oracle sql 增删改查处理

本文链接：https://blog.csdn.net/qq_16645423/article/details/104807551

版权

程序人生专栏收录该内容

6 篇文章 1 订阅

订阅专栏

# -*- coding:utf-8 -*-

from django.db import connection
from django.conf import settings
import cx_Oracle


class OperateDB(object):
    """
    op = OperateDB()
    result = op.select(sql)
    [][]
    result = op.select_first(sql)
    []
    del op
    """
    def __init__(self):
        try:
            self.cursor = connection.cursor()
        except cx_Oracle.Error:
            raise

    def __del__(self):
        if self.cursor:
            self.cursor.close()

    def select(self, sql):
        try:
            self.cursor.execute(sql)
            return self.cursor.fetchall()
        except cx_Oracle.Error as e:
            self.cursor.close()
            raise

    def select_first(self, sql):
        try:
            self.cursor.execute(sql)
            return self.cursor.fetchone()
        except cx_Oracle.Error as e:
            self.cursor.close()
            raise


class UpdateDB(object):
    """
    insert update delete
    帶回滾操作

    注意：sql  中的date  type
        sql = "INSERT INTO  table_name (date) values (to_date('2016-10-11', 'yyyy-mm-dd hh24:mi:ss' )"
    up = UpdateDB()
    up.update(sql)
    up.update(sql)
    up.update(sql)
    up.commit()
    """
    def __init__(self):
        try:
            self.db = cx_Oracle.Connection(settings.ROLLBACKDB)
            self.db.begin()
            self.cursor = self.db.cursor()
        except cx_Oracle.Error as e:
            raise

    def update(self, sql):
        try:
            self.cursor.execute(sql)
        except Exception as e:
            self.db.rollback()
            self.cursor.close()
            self.db.close()
            raise

    def commit(self):
        self.db.commit()
        self.cursor.close()
        self.db.close()