脚本宝典收集整理的这篇文章主要介绍了Python中使用pymsql连接数据库,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
From app import app import pyMySQL import config class Database: aurl = config.aurl user = config.user password =config.password db = config.db charset = config.charset def __inIT__(self): self.connection = pymySQL.connect(host=self.aurl, user=self.user, password=self.password, database=self.db, charset=self.charset) self.cursor = self.connection.cursor() #插入 def insert(self, query, params): inset_id=0 try: self.cursor.execute(query, params) inset_id=self.connection.insert_id() #返回插入行的id self.connection.COMmit() return inset_id except Exception as e: # 若有异常就回滚; self.connection.rollback() app.LOGger.info("Error: insert to fecth data", e) return inset_id finally: self.connection.close() # 关闭连接 #查询 def query(self, query, params): try: self.cursor.execute(query, params) return self.cursor.fetchall() except Exception as e: PRint("Error: unable to fecth data") app.logger.info("Error: query to fecth data",e) finally: self.connection.close() # 关闭连接 #查询一个 def queryone(self, query, params): try: self.cursor.execute(query, params) return self.cursor.fetchall() except Exception as e: print("Error: unable to fecth data") app.logger.info("Error: queryone to fecth data",e) finally: self.connection.close() # 关闭连接 #更新 def update(self,sql,params): row=0 try: row=self.cursor.execute(sql, params) self.connection.commit() return row except Exception as e: # 若有异常就回滚; self.connection.rollback() app.logger.info("Error: update to fecth data", e) return row finally: self.connection.close() # 关闭连接 # 删除 def delete(self,sql,params): row=0 try: row=self.cursor.execute(sql, params) self.connection.commit() return str(row) except Exception as e: # 若有异常就回滚; self.connection.rollback() app.logger.info("Error: delete to fecth data", e) return row finally: self.connection.close() # 关闭连接 # def __del__(self): # self.connection.close() if __name__ == '__main__': pass
以上是脚本宝典为你收集整理的Python中使用pymsql连接数据库全部内容,希望文章能够帮你解决Python中使用pymsql连接数据库所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。