Skip to Content
Python GUI Programming with Tkinter
book

Python GUI Programming with Tkinter

by Alan D. Moore
May 2018
Beginner to intermediate content levelBeginner to intermediate
452 pages
11h 26m
English
Packt Publishing
Content preview from Python GUI Programming with Tkinter

Creating the lookup tables

We need to create the following three lookup tables:

  • labs: This lookup table will contain the ID strings for our laboratories.
  • lab_techs: This lookup table will have the names of the lab technicians, identified by their employee ID numbers.
  • plots: This lookup table will have one row for each physical plot, identified by lab and plot numbers. It will also keep track of the current seed sample planted in the plot.

Add the SQL query for creating these tables to create_db.sql as follows:

CREATE TABLE labs (id CHAR(1) PRIMARY KEY);CREATE TABLE lab_techs (id SMALLINT PRIMARY KEY, name VARCHAR(512) UNIQUE NOT NULL);CREATE TABLE plots (lab_id CHAR(1) NOT NULL REFERENCES labs(id),  plot SMALLINT NOT NULL, current_seed_sample ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Python GUI Programming with Tkinter - Second Edition

Python GUI Programming with Tkinter - Second Edition

Alan D. Moore

Publisher Resources

ISBN: 9781788835886Supplemental Content