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 a view

Before we finish our database design, we're going to create a view that will simplify access to our data. A view behaves like a table in most respects, but contains no actual data; it's really just a stored SELECT query. Our view will format our data for easier interaction with the GUI.

Views are created using the CREATE VIEW command as follows:

CREATE VIEW data_record_view AS (

Inside the parentheses, we put the SELECT query that will return the table data for our view:

SELECT pc.date AS "Date", to_char(pc.time, 'FMHH24:MI') AS "Time", lt.name AS "Technician", pc.lab_id AS "Lab", pc.plot AS "Plot", pc.seed_sample AS "Seed sample", pc.humidity AS "Humidity", pc.light AS "Light", pc.temperature AS "Temperature", pc.plants AS ...
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