Creating the Delivery Database

We need to create two tables for this project. The first will store both the history of force sensitive resistor triggers that occur when packages are delivered and removed as well as the value of the exceeded threshold value. The second table will store known tracking numbers of inbound package deliveries and a date delivery field that will contain the time and date of when the delivery was confirmed by the courier. We’ve done something like this before in Chapter 5, Tweeting Bird Feeder, so we’ll apply that same approach to the creation of the package delivery database.

We will first create the database file using the sqlite3 tool, followed by the creation of the two tables within the packagedelivery database. ...

Get Programming Your Home now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.