Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

How it works...

When the script is first run, it will create a new SQLite database file called mydatabase.db, which will add a table named recordeddata. The table is generated by createTable(), which runs the following SQLite command:

CREATE TABLE recordeddata 
( 
    itm_date DEFAULT (date('now','localtime')), 
    itm_time DEFAULT (time('now','localtime')), 
    itm_name, 
    itm_value 
) 

The new table will contain the following data items:

Name	Description
itm_date	Used to store the date of the data sample. When the data record is created, the current date (using date('now','localtime')) is applied as the default value.
itm_time	Used to store the time of the data sample. When the data record is created, the current time (using time('now','localtime') ...