如何从数据库中获取数据并在 kivy+python 中显示在表中 [英] How to fetch data from database and show in table in kivy+python

问题描述

list.py

导入kivykivy.require('1.9.0') # 替换为你当前的 kivy 版本！将 sqlite3 导入为 lite从 kivy.uix.screenmanager 导入屏幕从 kivy.app 导入应用程序从 kivy.lang 导入生成器从 kivy.uix.boxlayout 导入 BoxLayout从 kivy.core.window 导入窗口Window.clearcolor = (0, 0.517, 0.705, 1)Window.size = (500, 330)从easygui导入msgboxcon = lite.connect('demo.db')con.text_factory = strcur = con.cursor()类测试屏幕(屏幕):经过def get_user(self):cur.execute("SELECT * FROM `user` order by id asc")self.rows = cur.fetchall()打印(self.rows)类列表(应用程序):定义构建(自我):self.root = Builder.load_file('list.kv')返回 TestScreen().get_user()如果 __name__ == '__main__':列表().运行()

以上代码获取结果，但我不知道如何像表格一样列出

如何从数据库中检索数据并在表中列出

id 名称
1个ABC
2 定义

当点击行时，它会在新窗口中显示包含带有编辑值的文本类型.

提前致谢

解决方案

解决方案是使用

list.py

import kivy

kivy.require('1.9.0')  # replace with your current kivy version !
import sqlite3 as lite
from kivy.uix.screenmanager import Screen
from kivy.app import App
from kivy.lang import Builder
from kivy.uix.boxlayout import BoxLayout
from kivy.core.window import Window

Window.clearcolor = (0, 0.517, 0.705, 1)

Window.size = (500, 330)
from easygui import msgbox


con = lite.connect('demo.db')
con.text_factory = str
cur = con.cursor()

class TestScreen(Screen):
    pass

    def get_user(self):

        cur.execute("SELECT * FROM `user` order by id asc")
        self.rows = cur.fetchall()

        print(self.rows)

class List(App):
    def build(self):
        self.root = Builder.load_file('list.kv')
        return TestScreen().get_user()



if __name__ == '__main__':
    List().run()

above code fetch result but i dont know how to list like table

How to retrieve data from database and list in table like

id Name
1 abc
2 def

When click on row then it show in new window contain text type with edit value.

Thanks in advance

解决方案

The solution is to use RecycleView with SelectableButton, SelectableRecycleGridLayout, Popup and TextInput. Please refer to the example below for details.

Example

main.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


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):
        connection = sqlite3.connect("demo.db")
        cursor = connection.cursor()

        cursor.execute("SELECT * FROM Users ORDER BY UserID ASC")
        rows = cursor.fetchall()

        # create data_items
        for row in rows:
            for col in row:
                self.data_items.append(col)


class TestApp(App):
    title = "Kivy RecycleView & SQLite3 Demo"

    def build(self):
        return RV()


if __name__ == "__main__":
    TestApp().run()

test.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: 2

            Label:
                text: "User ID"
            Label:
                text: "User Name"

        BoxLayout:
            RecycleView:
                viewclass: 'SelectableButton'
                data: [{'text': str(x)} for x in root.data_items]
                SelectableRecycleGridLayout:
                    cols: 2
                    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

Output

这篇关于如何从数据库中获取数据并在 kivy+python 中显示在表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！