python - 如何使用 kivy 和 RecycleView 编辑 SQLite 数据库值
问题描述
我正在尝试使用 kivy 在 python 中显示 sqlite3 数据库。在这里测试了 ikolim 的解决方案,它可以按预期将数据库内容显示到 RecycleView 的按钮标签中:
当按下按钮时,会按预期显示弹出和编辑功能:
它确实会编辑所选按钮的文本,如下一个屏幕截图所示..:
..但不是 sqlite 数据库值。是否可以将用户在 Kivy 应用程序中所做的更改反映到 sqlite 数据库中的值?
以下是代码:
测试.py
import sqlite3
from kivy.app import App
from kivy.uix.boxlayout import BoxLayout
from kivy.uix.recycleview.views import RecycleDataViewBehavior
from kivy.uix.button import Button
from kivy.properties import BooleanProperty, ListProperty, StringProperty, ObjectProperty
from kivy.uix.recyclegridlayout import RecycleGridLayout
from kivy.uix.behaviors import FocusBehavior
from kivy.uix.recycleview.layout import LayoutSelectionBehavior
from kivy.uix.popup import Popup
connection = sqlite3.connect("demo.db", isolation_level=None)
cursor = connection.cursor()
class TextInputPopup(Popup):
obj = ObjectProperty(None)
obj_text = StringProperty("")
def __init__(self, obj, **kwargs):
super(TextInputPopup, self).__init__(**kwargs)
self.obj = obj
self.obj_text = obj.text
class SelectableRecycleGridLayout(FocusBehavior, LayoutSelectionBehavior,
RecycleGridLayout):
''' Adds selection and focus behaviour to the view. '''
class SelectableButton(RecycleDataViewBehavior, Button):
''' Add selection support to the Button '''
index = None
selected = BooleanProperty(False)
selectable = BooleanProperty(True)
def refresh_view_attrs(self, rv, index, data):
''' Catch and handle the view changes '''
self.index = index
return super(SelectableButton, self).refresh_view_attrs(rv, index, data)
def on_touch_down(self, touch):
''' Add selection on touch down '''
if super(SelectableButton, self).on_touch_down(touch):
return True
if self.collide_point(*touch.pos) and self.selectable:
return self.parent.select_with_touch(self.index, touch)
def apply_selection(self, rv, index, is_selected):
''' Respond to the selection of items in the view. '''
self.selected = is_selected
def on_press(self):
popup = TextInputPopup(self)
popup.open()
def update_changes(self, txt):
self.text = txt
class RV(BoxLayout):
data_items = ListProperty([])
def __init__(self, **kwargs):
super(RV, self).__init__(**kwargs)
self.get_users()
def get_users(self):
cursor.execute("CREATE TABLE IF NOT EXISTS Callbacks(cName TEXT, cID INT, cbTime INT, cbRems TEXT)")
cursor.execute("INSERT INTO Callbacks VALUES ('Client1','1','1500','Test1')")
cursor.execute("INSERT INTO Callbacks VALUES ('Client2','2','1600','Test2')")
cursor.execute("INSERT INTO Callbacks VALUES ('Client3','3','1700','Test3')")
connection.commit()
cursor.execute("SELECT * FROM Callbacks ORDER BY ROWID DESC")
rows = cursor.fetchall()
# create data_items
for row in rows:
for col in row:
self.data_items.append(col)
for row in rows:
print(self.data_items)
class TestApp(App):
title = "Kivy RecycleView & SQLite3 Demo"
def build(self):
return RV()
if __name__ == "__main__":
TestApp().run()
测试.kv
#:kivy 1.10.0
<TextInputPopup>:
title: "Popup"
size_hint: None, None
size: 400, 400
auto_dismiss: False
BoxLayout:
orientation: "vertical"
TextInput:
id: txtinput
text: root.obj_text
Button:
size_hint: 1, 0.2
text: "Save Changes"
on_release:
root.obj.update_changes(txtinput.text)
root.dismiss()
Button:
size_hint: 1, 0.2
text: "Cancel Changes"
on_release: root.dismiss()
<SelectableButton>:
# Draw a background to indicate selection
canvas.before:
Color:
rgba: (.0, 0.9, .1, .3) if self.selected else (0, 0, 0, 1)
Rectangle:
pos: self.pos
size: self.size
<RV>:
BoxLayout:
orientation: "vertical"
GridLayout:
size_hint: 1, None
size_hint_y: None
height: 25
cols: 4
Label:
text: "Name"
Label:
text: "ID"
Label:
text: "CB Time"
Label:
text: "Remarks"
BoxLayout:
RecycleView:
viewclass: 'SelectableButton'
data: [{'text': str(x)} for x in root.data_items]
SelectableRecycleGridLayout:
cols: 4
default_size: None, dp(26)
default_size_hint: 1, None
size_hint_y: None
height: self.minimum_height
orientation: 'vertical'
multiselect: True
touch_multiselect: True
解决方案
为了反映对 的更改sql
,您需要使用update
命令来更新sql
表。
推荐阅读
- math - 不均匀分配项目的方程
- python - 当数字小于前一个数字时拆分数据帧
- python - 如何在 django 中将自定义用户注册为学生
- angular - 为 post API 自动转换日期字符串格式
- mpi - 所有进程的 my_rank = 0,如何解决?
- python - 在字符串格式化期间并非所有参数都转换(在 Python cursor.execute 中使用“问号”占位符)
- linux - 使用 VBScript 指定绝对路径
- c# - 如何表示多维数组 String[,] 的所有可能对
- slurm - 在文件输出中使用 SBATCH 作业名称作为变量
- mips - MIPS 流水线寄存器长度(IF/ID、ID/EX、EX/MEM、MEM/WB)