[置顶] python脚本sqlite3模块的应用-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

[置顶] python脚本sqlite3模块的应用

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 02:50 PM

pythonsqlite3usrapplicationmodulepin to topScript

#!/usr/bin/python
# -*- coding:utf-8 -*-
import sqlite3
import os

class SQLTest:
'''sqlite数据库接口'''
def __init__(self,path='',verbose=False):
self.verbose = verbose
self.path = path
if os.path.isfile(path):
self.conn = sqlite3.connect(path)
if self.verbose:
print('硬盘上面:[{}].format(path)')
else:
self.conn = sqlite3.connect(':memory:')
if self.verbose:
print('内存上面:[:memory:]')

def setverbose(self,b):
self.verbose = b

def createtable(self,sql):
'''创建数据库表'''
if sql is not None and sql != '':
cu = self.conn.cursor()
if self.verbose:
print('执行sql:[{}]'.format(sql))
cu.execute(sql)
self.conn.commit()
if self.verbose:
print('创建数据库表成功！')
self.close_all(cu)
else:
print('The [{}] is empty or equal None!'.format(sql))

def querytable(self):
sql = 'SELECT name FROM sqlite_master WHERE type="table" ORDER BY name'
cu = self.conn.cursor()
cu.execute(sql)
return cu.fetchall()

def renametable(self,table,newtable):
if table is not None and talbe !='':
sql = 'ALTER TABLE %s RENAME TO "%s" ' % (table,newtable)
cu = self.conn.cursor()
cu.execute(sql)
self.conn.commit()
print('delete table sucess!')
self.close_all(cu)
else:
print('The [{}] is empty or equal None!'.format(sql))

def insert(self,sql,data):
if sql is not None and sql != '':
if data is not None:
cu = self.conn.cursor()
for d in data:
cu.execute(sql,d)
self.conn.commit()
if self.verbose:
print('插入数据库表成功！')
self.close_all(cu)
else:
print('The [{}] is empty or equal None!'.format(sql))

def fetchall(self,sql):
if sql is not None and sql != '':
cu = self.conn.cursor()
if self.verbose:
print('执行sql:[{}]'.format(sql))
cu.execute(sql)
return cu.fetchall()
else:
print('The [{}] is empty or equal None!'.format(sql))

def fetchone(self,sql,data):
if sql is not None and sql != '':
if data is not None:
cu = self.conn.cursor()
cu.execute(sql,(data,))
return cu.fetchall()
else:
print('The [{}] is None!'.format(data))
else:
print('The [{}] is empty or equal None!'.format(sql))

def updata(self,sql,data):
if sql is not None and sql != '':
if data is not None:
cu = self.conn.cursor()
for d in data:
cu.execute(sql,d)
self.conn.commit()
self.close_all(cu)
else:
print('The [{}] is empty or equal None!'.format(sql))

def rowcount(self,table):
sql = 'select count (*) from "%s"' % table
cu = self.conn.cursor()
r = cu.execute(sql)
return (r.fetchone()[0])

def delete(self,sql,data):
if sql is not None and sql != '':
if data is not None:
cu = self.conn.cursor()
for d in data:
cu.execute(sql,d)
self.conn.commit()
self.close_all(cu)
else:
print('The [{}] is empty or equal None!'.format(sql))

def droptable(self,table):
if table is not None and table != '':
sql = 'DROP TABLE IF EXISTS ' + table
cu = self.conn.cursor()
cu.execute(sql)
self.conn.commit()
print('delete table sucess!')
self.close_all(cu)
else:
print('The [{}] is empty or equal None!'.format(sql))

def close_all(self,cu):
try:
if cu is not None:
cu.close()
finally:
if cu is not None:
cu.close()

# function
def drop_table_test(sql,table):
'''删除数据库表测试'''
print('删除数据库表测试 ...')
db.droptable(table)

def create_table_test(sql):
'''创建数据库表测试'''
print('创建数据库表测试 ...')
create_table_sql = '''CREATE TABLE IF NOT EXISTS 'table1'(
'id' integer(32) NOT NULL,
'name' nvarchar(128) NOT NULL,
PRIMARY KEY('id')
)'''
sql.createtable(create_table_sql)

def insert_test(sql):
'''插入数据测试 ...'''
print('插入数据测试 ...')
insert_sql = 'INSERT INTO table1 values(?,?)'
data = [(1,'aaa'),(2,'bbb')]
sql.insert(insert_sql,data)

def fetchall_test(sql):
'''查询所有数据'''
print('查询所有数据 ...')
fetchall_sql = 'SELECT * FROM table1'
r = sql.fetchall(fetchall_sql)
for e in range(len(r)):
print(r[e])

def fetchone_test(sql):
'''查询一条数据'''
print('查询一条数据 ...')
fetchall_sql = 'SELECT * FROM table1 WHERE id = ?'
data = 1
r = sql.fetchone(fetchall_sql,data)
for e in range(len(r)):
print(r[e])

def query_test(sql):
'''有几个表'''
print('有几个表 ...')
print(sql.query_table(db))

def update_test(sql):
'''更新数据'''
print('更新数据 ...')
update_sql = 'UPDATE table1 SET name = ? WHERE id = ?'
data = [('TestA',1),('TestB',2)]
sql.updata(update_sql,data)

def delete_test(db):
'''删除数据'''
print('删除数据 ...')
delete_sql = 'DELETE FROM table1 WHERE name = ? and id = ?'
data = [('TestA',1)]
sql.delete(delete_sql,data)

# self test
if __name__ == '__main__':
sql = SQLTest(verbose=True)
#创建数据库表
create_table_test(sql)
#插入数据
insert_test(sql)
#查询多条数据
fetchall_test(sql)
#查询一条数据
fetchone_test(sql)
#更新数据
update_test(sql)
#查询多条数据
fetchall_test(sql)
#删除一条数据
delete_test(sql)
print(sql.rowcount('table1'))
#查询多条数据
fetchall_test(sql)

#==================================================================================

测试结果

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

抖音怎么置顶自己视频Mar 26, 2024 pm 01:21 PM

抖音里面有用户会拍摄很多的视频作品，一旦视频作品多了以后，各种优秀的视频作品就会被掩埋了，置顶功能就很有用了，那么我们怎么置顶自己的视频作品呢？接下来小编就为大家带来了抖音置顶自己视频作品方法图文教程，还不知道怎么置顶视频的用户快来看看吧。抖音使用教程抖音怎么置顶自己视频1、首先我们打开抖音，点击主界面右下角如图所示的我。2、接着我们进入个人界面后，找到想要置顶的视频作品，点击进入播放即可。3、然后我们在视频界面，点击右下角如图所示的三个点选项。4、最后我们点击新弹出窗口中的置顶即可，返回个人界