Refcards: The Beginnings of an Interface

- The latest development in the evolution of the Refcards-System is the creation of a primitive interface;
- Now I can add records to my SQLite3 database through an interface;
- The interface has a button called "Add entry" which upon clicking adds the text ("gets" it) from the Entry and Text widgets in the interface and adds them ("INSERTs" them) directly into the database;
- I've been using Tkinter to create the interface ("frontend") and SQLite3 in Python for the database ("backend");

	from Tkinter import *
	import os
	import sqlite3
	os.chdir('C:\\FILEPATH')
	# TO RUN ON FIRST PASS, TO CREATE OR OPEN DATABASE AND CREATE FIRST TABLE.
	# conn = sqlite3.connect("refcards2019b.db")
	# cursor = conn.cursor()
	# cursor.execute("""CREATE TABLE refcards(date TEXT, note TEXT)""")
	# conn.commit()
	def insert(date,note):
	conn = sqlite3.connect("refcards2019b.db")
	cursor = conn.cursor()
	cursor.execute("INSERT INTO refcards VALUES (?,?)",(date, note))
	conn.commit()
	conn.close()
	def add_command():
	insert(date_text.get(), T.get("1.0","end-1c"))
	root = Tk()
	date_label = Label(root, text='Date')
	date_label.grid(row=0, column=0)
	date_text = StringVar()
	date_entry = Entry(root, textvariable=date_text)
	date_entry.grid(row=0, column=1)
	note_label = Label(root, text='Note')
	note_label.grid(row=1, column=0)
	T = Text(root, height=20, width=20)
	T.grid(row=2, column=1)
	add_button = Button(root, text="Add entry", width=12, command=add_command)
	add_button.grid(row=4, column=3)
	root.mainloop()

view raw RefcardsFrontEnd.py hosted with ❤ by GitHub

Tkinter Text Widgets in Python

- I have been working hard on my Refcards-System idea, in Python;
- I want it to be a simple database with simple interface where you can add records to a given table and then view your "notes" or "Refcards";
- The idea is to have a GUI to flip through Refcards in the database;

	import sqlite3
	import os
	from Tkinter import *
	root = Tk()
	S = Scrollbar(root)
	T = Text(root, height=8, width=75)
	S.pack(side=RIGHT, fill=Y)
	T.pack(side=LEFT, fill=Y)
	S.config(command=T.yview)
	T.config(yscrollcommand=S.set)
	os.chdir('C:\\FILEPATH')
	conn = sqlite3.connect("refcards2019.db")
	cursor = conn.cursor()
	sql = "SELECT * FROM refcards"
	cursor.execute(sql)
	# note = cursor.fetchone()[2]
	note = cursor.fetchall()[1][2]
	T.insert(END, note)
	mainloop( )
	conn.close()

view raw TkinterTextWidgetWithSQLite3.py hosted with ❤ by GitHub

The Return of The Refcards-System

- As you know, I've been working on a project in Python called The Refcards-System, or "Refcard-Project" if you will;
- I have been incrementally improving the system;
- Now I have a working version that incorporates an SQLite database in Python;
- The next step is to have a kind of small text editor open up to view records in the database;

	import sqlite3
	import os
	import time
	# Choose the filepath you want the database to reside in.
	os.chdir('C:\\FILEPATH')
	# Creates the database on the first run, otherwise just connects to it.
	conn = sqlite3.connect("refcards2019.db")
	cursor = conn.cursor()
	# To be used on the first "run" to create the first TABLE in the database.
	# cursor.execute("""CREATE TABLE refcards(id INTEGER PRIMARY KEY AUTOINCREMENT,
	# date TEXT, note TEXT)""")
	# conn.commit()
	# A timestamp in a useful format.
	t = time.strftime('%Y%m%d%H%M')
	# Prompt to write the actual note.
	c = raw_input('Write note: ')
	# Inserts timestamp and note into the refcards TABLE as a record.
	cursor.execute("""INSERT INTO refcards(date, note)
	VALUES(?,?)""", (t,c))
	# Operations on database tables must be "committed".
	conn.commit()
	# I use this to print the contents of the TABLE,
	# just to see that it worked properly.
	# This section can be skipped.
	sql = "SELECT * FROM refcards"
	cursor.execute(sql)
	print cursor.fetchall()
	# Close connection to database.
	conn.close()

view raw refcards2019.py hosted with ❤ by GitHub