Home > Article > Backend Development > Simple encapsulation method for Python's Sql database addition, deletion, modification and query operations
The example of this article shares with you how to use Python to simply encapsulate the addition, deletion, modification and query of the database for your reference. The specific content is as follows
1.insert
import mysql.connector import os import codecs #设置数据库用户名和密码 user='root';#用户名 pwd='root';#密码 host='localhost';#ip地址 db='mysql';#所要操作数据库名字 charset='UTF-8' cnx = mysql.connector.connect(user=user,password=pwd, host=host, database=db) #设置游标 cursor = cnx.cursor(dictionary=True) #插入数据 #print(insert('gelixi_help_type',{'type_name':'\'sddfdsfs\'','type_sort':'283'})) def insert(table_name,insert_dict): param=''; value=''; if(isinstance(insert_dict,dict)): for key in insert_dict.keys(): param=param+key+"," value=value+insert_dict[key]+',' param=param[:-1] value=value[:-1] sql="insert into %s (%s) values(%s)"%(table_name,param,value) cursor.execute(sql) id=cursor.lastrowid cnx.commit() return id
2.delete
def delete(table_name,where=''): if(where!=''): str='where' for key_value in where.keys(): value=where[key_value] str=str+' '+key_value+'='+value+' '+'and' where=str[:-3] sql="delete from %s %s"%(table_name,where) cursor.execute(sql) cnx.commit()
3.select
#取得数据库信息 # print(select({'table':'gelixi_help_type','where':{'help_show': '1'}},'type_name,type_id')) def select(param,fields='*'): table=param['table'] if('where' in param): thewhere=param['where'] if(isinstance (thewhere,dict)): keys=thewhere.keys() str='where'; for key_value in keys: value=thewhere[key_value] str=str+' '+key_value+'='+value+' '+'and' where=str[:-3] else: where='' sql="select %s from %s %s"%(fields,table,where) cursor.execute(sql) result=cursor.fetchall() return result
4.showtable,showcolumns
#显示建表语句 #table string 表名 #return string 建表语句 def showCreateTable(table): sql='show create table %s'%(table) cursor.execute(sql) result=cursor.fetchall()[0] return result['Create Table'] #print(showCreateTable('gelixi_admin')) #显示表结构语句 def showColumns(table): sql='show columns from %s '%(table) print(sql) cursor.execute(sql) result=cursor.fetchall() dict1={} for info in result: dict1[info['Field']]=info return dict1
The above is the Python Sql database addition, deletion, modification and query operations Related operations, I hope it will be helpful to everyone's learning.
For more related articles on simple encapsulation methods of Python's Sql database addition, deletion, modification and query operations, please pay attention to the PHP Chinese website!