【sqlite】python操作sqlite3（含测试）

个人小项目或者小团队，sqllite很适用，数据库封装操作如下

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time    : 2025-02-08 13:57
# @Author  : duxiaowei
# @File    : connect_sqllite.py
# @Software: PyCharm
"""
sqllite操作,
"""
import sqlite3class DBlite():def __init__(self):self.conn = sqlite3.connect('X:\Tools\git\data\gitea.db')self.cursor = self.conn.cursor()# print("成功连接到数据库")# 查询def select(self, query):try:self.cursor.execute(query)# 获取所有查询结果results = self.cursor.fetchall()return resultsexcept sqlite3.Error as e:print("===>sqllite==【查询】==异常！", e)finally:self.cursor.close()self.conn.close()def change(self, *args, **kwargs):try:# 插入多行数据self.cursor.execute(*args, **kwargs)self.conn.commit()print("===>sqllite==【操作】==成功！")except sqlite3.Error as e:print("===>sqllite==【操作】==异常！", e)finally:self.cursor.close()self.conn.close()# 查询所有用户
# select_query = "SELECT * FROM pytest_result where file_name='D:\\code\\python\\test_登录.py'"
# result = DBlite().select(select_query)
# print(result)
# # --------------------------------------------------------
# 插入数据
# students = [
#     ('D:\\code\\python\\test_登录5.py', 'test_aaa', 0, 1),
#     ('D:\\code\\python\\test_登录6.py', 'test_abb', 0, 1),
# ]
# for i in students:
#     sql = "INSERT INTO pytest_result (file_name, def_name, status, result) VALUES (?,?,?,?)"
#     DBlite().change(sql,i)# # ---------------删除-----------------------------------------
# sql = "delete FROM pytest_result where file_name=?"
# arg = ['D:\\code\\python\\test_登录6.py']
# DBlite().change(sql, arg)
# # # --------------------------------------------------------
# sql = "UPDATE pytest_result SET status = 0 WHERE def_name = ?"
#
# arg = ['test_aac']
# DBlite().change(sql, arg)
# # --------------------------------------------------------