main.py

from kivy.lang import Builder
import sqlite3
from kivy.clock import mainthread
from kivy.app import App
from kivy.uix.popup import Popup
from kivy.uix.screenmanager import ScreenManager, Screen, SwapTransition
from kivy.uix.layout import Layout
from kivy.uix.boxlayout import BoxLayout
from kivy.uix.gridlayout import GridLayout
from kivy.uix.floatlayout import FloatLayout
from kivy.uix.stacklayout import StackLayout
from kivy.uix.scrollview import ScrollView
from kivy.uix.textinput import TextInput
from kivy.uix.label import Label
from kivy.uix.button import Button
from kivy.core.text import LabelBase
from sqlite3.dbapi2 import IntegrityError


Builder.load_file('main.kv', encoding='utf8')

LabelBase.register(name='regular', fn_regular='OpenSans-Regular.ttf')
LabelBase.register(name='bold', fn_regular='OpenSans-Bold.ttf')


def db_execute(*args):  # executing sqlite db
    con = sqlite3.connect("chordpad.db")
    cur = con.cursor()
    cur.execute(*args)
    con.commit()
    con.close()


# create database file
db_execute(
    '''CREATE TABLE IF NOT EXISTS chordpad (
        id TEXT NOT NULL UNIQUE, title TEXT NOT NULL UNIQUE, text TEXT)''')


current_pad_text = ''
current_pad_title = ''
current_pad_id = ''


class RenamePadDialog(Popup):
    def rename_chordpad(self):
        global current_pad_id, current_pad_title
        new_file_name = self.ids.rename_name.text.strip()
        try:
            if new_file_name == '':
                self.ids.rename_name.hint_text = "Illegal name!"
                self.ids.rename_name.text = ''
                self.ids.rename_name.focus = True
            else:
                db_execute('''UPDATE chordpad SET id = ?, title = ? WHERE id = ?''',
                           (new_file_name, new_file_name, current_pad_id))
                current_pad_title = new_file_name
                current_pad_id = new_file_name
                self.dismiss()
                App.get_running_app().root.get_screen(
                    "reading").ids.filename_rlabel.text = current_pad_title
                App.get_running_app().root.get_screen(
                    "editing").ids.filename_label.text = current_pad_title
        except IntegrityError:
            self.ids.rename_name.hint_text = "Name already exists!"
            self.ids.rename_name.text = ''
            self.ids.rename_name.focus = True

    def current_pad_title(self):
        current_pad = f'Rename {current_pad_id}'
        return current_pad

    def rename_hint_text(self):
        return current_pad_id


class SaveAsDialog(Popup):  # save dialog popup
    def save_as(self):
        global current_pad_text, current_pad_title, current_pad_id
        file_name = self.ids.filename.text.strip()
        try:
            if file_name == '':
                self.ids.filename.hint_text = "Illegal name!"
                self.ids.filename.text = ''
                self.ids.filename.focus = True
            else:
                db_execute('''INSERT INTO chordpad (id, title, text) VALUES (?, ?, ?)''',
                           (file_name, file_name, text_to_save))
                current_pad_text = text_to_save
                current_pad_title = file_name
                current_pad_id = file_name
                self.dismiss()
                App.get_running_app().root.get_screen("menu").on_enter()
                App.get_running_app().root.get_screen(
                    "reading").ids.reading_label.text = current_pad_text
                App.get_running_app().root.get_screen(
                    "reading").ids.filename_rlabel.text = current_pad_title
                App.get_running_app().root.get_screen(
                    "editing").ids.filename_label.text = current_pad_title
        except IntegrityError:
            self.ids.filename.hint_text = "Name already exists!"
            self.ids.filename.text = ''
            self.ids.filename.focus = True


class SaveChangesDialog(Popup):
    def save_changes(self):
        global current_pad_text
        db_execute(''' UPDATE chordpad SET text = ? WHERE id = ? ''',
                   (text_to_save, current_pad_id))
        current_pad_text = text_to_save
        self.dismiss()
        App.get_running_app().root.get_screen(
            "reading").ids.reading_label.text = current_pad_text

    def current_pad_title(self):
        current_pad = f'Save changes to {current_pad_id}'
        return current_pad


class DeletePadDialog(Popup):
    def delete_pad(self):
        global current_pad_id, current_pad_title, current_pad_text
        db_execute(''' DELETE FROM chordpad WHERE title = ? ''',
                   (current_pad_id,))
        self.dismiss()
        App.get_running_app().root.current = "menu"
        current_pad_title = 'Untitled - Chordpad'
        current_pad_text = ''
        App.get_running_app().root.get_screen(
            "reading").ids.reading_label.text = current_pad_text
        App.get_running_app().root.get_screen(
            "editing").ids.chordpad.text = current_pad_text
        App.get_running_app().root.get_screen(
            "reading").ids.filename_rlabel.text = current_pad_title
        App.get_running_app().root.get_screen(
            "editing").ids.filename_label.text = current_pad_title

    def current_pad_title(self):
        current_pad = f'Delete {current_pad_id}'
        return current_pad


class MenuScreen(Screen):  # main menu screen
    @mainthread
    def on_enter(self):
        global current_pad_text, current_pad_title
        self.ids.pads.clear_widgets()
        con = sqlite3.connect("chordpad.db")
        cur = con.cursor()
        cur.execute(''' SELECT id, title, text FROM chordpad ''')
        for item in reversed(cur.fetchall()):
            pad_id = str(item[0])
            pad_title = item[1]
            button = Button(text=pad_title, size_hint=(
                1, 0.07), font_size=self.width/20)
            self.ids.pads.add_widget(button)
            self.ids[pad_id] = button
            button.bind(on_release=self.return_button_id_on_press)
        con.close()

    def return_button_id_on_press(self, instance):
        global current_pad_text, current_pad_id, current_pad_title
        con = sqlite3.connect("chordpad.db")
        cur = con.cursor()
        cur.execute(''' SELECT ? FROM chordpad''', (instance.text,))
        current_pad_title = cur.fetchone()[0]
        current_pad_id = list(self.ids.keys())[
            list(self.ids.values()).index(instance)]
        self.manager.get_screen(
            "editing").ids.filename_label.text = current_pad_title
        self.manager.get_screen(
            "reading").ids.filename_rlabel.text = current_pad_title
        cur.execute(''' SELECT text FROM chordpad WHERE id = ?''',
                    (current_pad_id,))
        current_pad_text = cur.fetchone()[0]
        self.manager.get_screen("editing").ids.chordpad.text = current_pad_text
        self.manager.get_screen(
            "reading").ids.reading_label.text = current_pad_text
        self.manager.current = "reading"
        con.close()

    def new_chordpad(self):
        global current_pad_text, current_pad_id, current_pad_title
        current_pad_text = ''
        current_pad_id = ''
        current_pad_title = "Untitled - Chordpad"
        self.manager.get_screen("editing").ids.chordpad.text = current_pad_text
        self.manager.get_screen(
            "editing").ids.filename_label.text = current_pad_title
        self.manager.get_screen(
            "reading").ids.filename_rlabel.text = current_pad_title

    def back_to_chordpad(self):  # set untitled if back to chordpad on start
        global current_pad_text, current_pad_title
        try:
            if current_pad_text == '':
                current_pad_title = 'Untitled - Chordpad'
                self.manager.get_screen(
                    "editing").ids.chordpad.text = current_pad_text
                self.manager.get_screen(
                    "editing").ids.filename_label.text = current_pad_title
                self.manager.get_screen(
                    "reading").ids.filename_rlabel.text = current_pad_title
        except:
            pass


class ChordpadScreen(Screen):  # editing mode screen
    def put_text(self, item):  # intro, verse, etc. auto enter
        if self.ids.chordpad.text == "":
            self.ids.chordpad.insert_text(f"{item}: ")
        else:
            self.ids.chordpad.do_backspace()
            self.ids.chordpad.insert_text(f"\n{item}: ")

    def put_chord(self, item):
        self.ids.chordpad.insert_text(f"{item} ")

    def check_if_saved(self, change_screen):
        global text_to_save
        if self.ids.chordpad.text != "" and self.ids.filename_label.text == "Untitled - Chordpad":
            text_to_save = self.ids.chordpad.text
            SaveAsDialog().open()
            self.manager.current = change_screen

        elif current_pad_text != self.ids.chordpad.text:
            text_to_save = self.ids.chordpad.text
            SaveChangesDialog().open()
            self.manager.current = change_screen
        else:
            self.manager.current = change_screen

    def delete_pad(self):
        if current_pad_title == 'Untitled - Chordpad':
            pass
        else:
            DeletePadDialog().open()

    def rename_chordpad(self):
        if current_pad_title == 'Untitled - Chordpad':
            pass
        else:
            RenamePadDialog().open()


class ReadingModeScreen(Screen):
    def delete_pad(self):
        if current_pad_title == 'Untitled - Chordpad':
            pass
        else:
            DeletePadDialog().open()


class AboutScreen(Screen):
    pass


class ScreenOrganize(ScreenManager):
    pass


class ChordpadApp(App):
    def build(self):
        return ScreenOrganize()


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