Алан Гибизов

from tkinter import Button, Entry, StringVar, Tk
from tkinter.constants import E, END
from tkinter.filedialog import askopenfilename


class App(Tk):
    def __init__(self):
        super().__init__()
        self.resizable(False, False)
        self.title('InClass')

        # !org
        self.labelORG = Button(self, text='Предприятие')
        self.labelORG.grid(row=1, sticky=E)

        self.stringORG = StringVar()
        self.entryORG = Entry(self, textvariable=self.stringORG)
        self.entryORG.grid(row=1, column=1, columnspan=2)

        self.buttonORG = Button(self, text='Выбрать:', command=self._select_CSV_table())  # , self.entryORG
        self.buttonORG.grid(row=1, column=3)

    def _select_CSV_table(self):
        my_path = askopenfilename(filetypes=(('CSV file', '*.csv'), ('Any', '*')))
        self.entryORG.delete(0, END)
        self.entryORG.insert(0, my_path)
        print(my_path)


if __name__ == '__main__':
    app = App()
    app.mainloop()

import sqlite3


def test_db(db):
    try:
        db_cursor = db.cursor()
        db_cursor.execute("CREATE TABLE IF NOT EXISTS users (login TEXT, password TEXT)")
        db.commit()
        return True
    except DBError:  # тут надо правильную ошибку правильно обрабатывать, я не копался, какую именно и как
        return False


def add_user_into_db(db, login, password):
    if test_db(db):
        добавить_пользователя(login, password)


def select_from_db(db, sel):
    if test_db(db):
        return список_пользователей(sel)


if __name__ == '__main__':
    login = 'my_login'
    password = 'my_password'
    sel = 'string_for_select'
    with sqlite3.connect('users_base.db') as db:
        add_user_into_db(db=db, login=login, password=password)
        print(select_from_db(db=db, sel=sel))

import tkinter as tk
import sqlite3
from tkinter import ttk


class Main(tk.Frame):
    def __init__(self, root):
        super().__init__(root)
        self.db = db
        self.init_main()

    def init_main(self):
        lbl_main = tk.Label(text='TXT', fg='#336B87', font=('Modern', 220), bg='#2A3132')
        btn_database_workers = tk.Button(padx=7, pady=2, text='', bg='#336B87',
                                         activebackground='#336B87',
                                         compound=tk.TOP, font=('Ubuntu', 72), bd=10, command=self.open_database)
        lbl_main.pack()
        btn_database_workers.pack()

        lbl_main.place(x=5, y=-45)
        btn_database_workers.place(x=750, y=45)

    def open_database(self):
        Child()


class Child(tk.Toplevel):
    def __init__(self):
        super().__init__(root)
        self.init_child()
        self.db = db
        self.db.cur = self.db.conn.cursor()
        self.view = app
        self.view_records()

    def retrieve_input(self):
        entry1_text = self.entry1.get(1.0, tk.END)
        entry2_text = self.entry2.get(1.0, tk.END)
        self.records(entry1_text, entry2_text)

    def init_child(self):
        self.title('Child')
        self.geometry('950x400')
        self['bg'] = '#2A3132'
        self.resizable(False, False)

        self.entry1 = tk.Text(self, height=2, width=11, font=('Ubuntu', 15), bd=5)
        self.entry1.pack()
        self.entry1.place(x=3, y=180)

        self.entry2 = tk.Text(self, height=2, width=11, font=('Ubuntu', 15), bd=5)
        self.entry2.pack()
        self.entry2.place(x=3, y=245)

        self.tree = ttk.Treeview(self, column=('clm1', 'clm2', 'clm3'), show='headings')
        self.tree.heading('#1', text='ID')
        self.tree.heading('#2', text='Name')
        self.tree.heading('#3', text='IP')
        self.tree.pack()

        delete_btn = tk.Button(self, text='Delete', padx=25, pady=10, font=('Ubuntu', 15),
                               bd=8, bg='#336B87', command=self.delete_records)
        delete_btn.pack()
        delete_btn.place(x=0, y=0)

        add_btn = tk.Button(self, text='Add', padx=36, pady=10, font=('Ubuntu', 15), bd=8, bg='#336B87',
                            command=lambda: self.retrieve_input())
        add_btn.pack()
        add_btn.place(x=0, y=75)

    def records(self, name, ip):
        self.db.insert_data(str(name), str(ip))
        self.view_records()

    def view_records(self):
        self.db.cur.execute('''SELECT * FROM tbl''')
        [self.tree.delete(i) for i in self.tree.get_children()]
        [self.tree.insert('', 'end', values=row) for row in self.db.cur.fetchall()]

    def delete_records(self):
        for selection_item in self.tree.selection():
            self.db.cur.execute('''DELETE FROM tbl WHERE id=?''', (self.tree.set(selection_item, '#1'),))
        self.db.conn.commit()
        self.view_records()


class DB:
    def __init__(self):
        self.conn = sqlite3.connect('oop_test.db')
        self.cur = self.conn.cursor()
        self.cur.execute(
            '''CREATE TABLE IF NOT EXISTS tbl(id INTEGER PRIMARY KEY,name TEXT ,ip TEXT)''')
        self.conn.commit()

    def insert_data(self, name, ip):
        self.cur.execute('''INSERT INTO tbl(name, ip) VALUES (?, ?)''', (name, ip))
        self.conn.commit()


if __name__ == '__main__':
    root = tk.Tk()
    db = DB()
    app = Main(root)
    app.pack()
    x = root.winfo_screenwidth()
    y = root.winfo_screenheight()
    root.geometry('{}x{}'.format(int(x * 0.8), int(y * 0.8)))
    root['bg'] = '#2A3132'
    root.title('Main')
    root.state('zoomed')
    root.mainloop()