April 2018
Beginner
552 pages
13h 58m
English
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') ... |