python3+PyQt5使用数据库表视图资源-CSDN下载

135 浏览量 2020-12-25 06:39:18 上传评论收藏 96KB PDF 举报

资源推荐

资源详情

资源评论

python3+PyQt5使用数据库表视图使用数据库表视图

上文提到窗体可以一次性呈现出来自同一记录的各个域，但是对于用户希望能看到多条记录的表来说，就需要使用表格化的视

图了。本文通过python3+pyqt5改写实现了python Qt gui 快速变成15章的例子，用户能够一次看到多条记录。

#!/usr/bin/env python3

import os

import sys

from PyQt5.QtCore import (PYQT_VERSION_STR, QDate, QFile, QRegExp, QVariant, QModelIndex,Qt)

from PyQt5.QtWidgets import (QApplication,QComboBox,

QDateTimeEdit, QDialog, QGridLayout, QHBoxLayout, QLabel,

QLineEdit, QDateEdit,QMessageBox, QPushButton,

QStyleOptionViewItem, QTableView,QVBoxLayout)

from PyQt5.QtGui import QPixmap,QCursor,QRegExpValidator

from PyQt5.QtSql import (QSqlDatabase, QSqlQuery, QSqlRelation,

QSqlRelationalDelegate, QSqlRelationalTableModel,QSqlTableModel)

import qrc_resources

MAC = True

try:

from PyQt5.QtGui import qt_mac_set_native_menubar

except ImportError:

MAC = False

ID = 0

NAME = ASSETID = 1

CATEGORYID = DATE = DESCRIPTION = 2

ROOM = ACTIONID = 3

ACQUIRED = 1

def createFakeData():

import random

print("Dropping tables...")

query = QSqlQuery()

query.exec_("DROP TABLE assets")

query.exec_("DROP TABLE logs")

query.exec_("DROP TABLE actions")

query.exec_("DROP TABLE categories")

QApplication.processEvents()

print("Creating tables...")

query.exec_("""CREATE TABLE actions (

id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL,

name VARCHAR(20) NOT NULL,

description VARCHAR(40) NOT NULL)""")

query.exec_("""CREATE TABLE categories (

id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL,

name VARCHAR(20) NOT NULL,

description VARCHAR(40) NOT NULL)""")

query.exec_("""CREATE TABLE assets (

id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL,

name VARCHAR(40) NOT NULL,

categoryid INTEGER NOT NULL,

room VARCHAR(4) NOT NULL,

FOREIGN KEY (categoryid) REFERENCES categories)""")

query.exec_("""CREATE TABLE logs (

id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL,

assetid INTEGER NOT NULL,

date DATE NOT NULL,

actionid INTEGER NOT NULL,

FOREIGN KEY (assetid) REFERENCES assets,

FOREIGN KEY (actionid) REFERENCES actions)""")

QApplication.processEvents()

print("Populating tables...")

query.exec_("INSERT INTO actions (name, description) "

"VALUES ('Acquired', 'When installed')")

query.exec_("INSERT INTO actions (name, description) "

"VALUES ('Broken', 'When failed and unusable')")

query.exec_("INSERT INTO actions (name, description) "

"VALUES ('Repaired', 'When back in service')")

query.exec_("INSERT INTO actions (name, description) "

"VALUES ('Routine maintenance', "

"'When tested, refilled, etc.')")

query.exec_("INSERT INTO categories (name, description) VALUES "

"('Computer Equipment', "

"'Monitors, System Units, Peripherals, etc.')")

query.exec_("INSERT INTO categories (name, description) VALUES "

"('Furniture', 'Chairs, Tables, Desks, etc.')")

query.exec_("INSERT INTO categories (name, description) VALUES "

"('Electrical Equipment', 'Non-computer electricals')")

today = QDate.currentDate()

floors = list(range(1, 12)) + list(range(14, 28))

monitors = (('17" LCD Monitor', 1),

('20" LCD Monitor', 1),

('21" LCD Monitor', 1),

('21" CRT Monitor', 1),

('24" CRT Monitor', 1))

computers = (("Computer (32-bit/80GB/0.5GB)", 1),

("Computer (32-bit/100GB/1GB)", 1),

("Computer (32-bit/120GB/1GB)", 1),

("Computer (64-bit/240GB/2GB)", 1),

("Computer (64-bit/320GB/4GB)", 1))

printers = (("Laser Printer (4 ppm)", 1),

("Laser Printer (6 ppm)", 1),

("Laser Printer (8 ppm)", 1),

("Laser Printer (16 ppm)", 1))

chairs = (("Secretary Chair", 2),

("Executive Chair (Basic)", 2),

("Executive Chair (Ergonimic)", 2),

("Executive Chair (Hi-Tech)", 2))

desks = (("Desk (Basic, 3 drawer)", 2),

("Desk (Standard, 3 drawer)", 2),

("Desk (Executive, 3 drawer)", 2),

("Desk (Executive, 4 drawer)", 2),

("Desk (Large, 4 drawer)", 2))

furniture = (("Filing Cabinet (3 drawer)", 2),

("Filing Cabinet (4 drawer)", 2),

("Filing Cabinet (5 drawer)", 2),

("Bookcase (4 shelves)", 2),

("Bookcase (6 shelves)", 2),

("Table (4 seater)", 2),

("Table (8 seater)", 2),

("Table (12 seater)", 2))

electrical = (("Fan (3 speed)", 3),

("Fan (5 speed)", 3),

("Photocopier (4 ppm)", 3),

("Photocopier (6 ppm)", 3),

("Photocopier (8 ppm)", 3),

("Shredder", 3))

query.prepare("INSERT INTO assets (name, categoryid, room) "

"VALUES (:name, :categoryid, :room)")

logQuery = QSqlQuery()

logQuery.prepare("INSERT INTO logs (assetid, date, actionid) "

"VALUES (:assetid, :date, :actionid)")

assetid = 1

for i in range(20):

room = "{0:02d}{1:02d}".format(

random.choice(floors), random.randint(1, 62))

for name, category in (random.choice(monitors),

random.choice(computers), random.choice(chairs),

random.choice(desks), random.choice(furniture)):

query.bindValue(":name", name)

query.bindValue(":categoryid", category)

query.bindValue(":room", room)

query.exec_()

logQuery.bindValue(":assetid", assetid)

剩余9页未读，继续阅读

评论收藏

内容反馈

weixin_38630091

粉丝: 7

python3+PyQt5使用数据库表视图

Python3+PyQt5基础：实现QListView搜索过滤及获取多列数据

python3+PyQt5使用数据库窗口视图

采用python3+pyqt5制作的串口调试助手pyqt5_serial，可以在MACOX和linux上直接运行

Python + PyQt5搭建一个图书管理系统

毕业设计：基于Python+Pyqt5的管理信息系统课程设计。.zip

PYQT5+sqlite数据库+QTableWidget自定义表格显示

pyqt5 Python 桌面应用程序源码 带数据库

python3+PyQt5 数据库编程--增删改实例

管理系统系列--Python3 + PyQt5搭建一个图书管理系统.zip

PyQt5 + MySQL简单示例

PYTHON+QT+GUI快速编程+PYQT编程指南

基于Python+pyqt5实现的仿360精美界面源代码

库房管理系统，使用python+pyqt5开发.zip

python+pyqt5实现KFC点餐收银系统

基于Python+Pyqt5的进销存管理系统源码.zip

python+pyqt图书管理系统

编译原理课程设计——词法分析程序设计Python+PyQt5+MySQL实现.zip

基于python+PyQt+MySQL的酒店管理系统. 毕业设计

【源码】数据可视化：基于 Pyecharts + PyQT 实现的动态实时【拖拉拽】大屏范例1-互联网企业数据分析.zip

非官方的简易中国铁路列车运行图系统，基于Python + PyQt5

notepad:nodepat 由 python3.4+pyqt5

基于python-contrib-opencv+dlib+pyqt5的视频读取人脸录入检测项目源码.zip

我国四个直辖市2021年历史天气爬虫及相关分析 python爬虫+MySQL数据库+可视化分析+图形界面

毕业设计，课程设计-基于python+pyqt6实现图纸管理系统

python3+PyQt5 使用三种不同的简便项窗口部件显示数据的方法

python3.4 64位+pyqt5.4

python-pyqt5-demo

PYQT5+MYSQL+数据库+QTableWidget+QMessageBox+QDialog+右键菜单写的小程序分享一下

MobileNetV1 & MobileNetV2 简介

5G移动通信：从理论到实践

最新资源

pyqt5 Python 桌面应用程序源码带数据库