sqlite_app
- Tachibana Yuta (立花 裕太)
- Yoshitaka Fukushima (福島 佳孝)
Table of contents
Introduction
This explanation assumes that the i-PRO camera application development environment has been completed.
If you are not ready to build the development environment, please refer to here to complete it.
Also, in this tutorial, the SDK installation directory is described as ${SDK_DIR}.
Operation overview
sqlite_app is a sample application that runs SQLite from the GUI.
An SD card is required for sqlite_app to work. Only cameras that can insert an SD card can be checked. Also, depending on the camera firmware, it may not be possible to install or operate the camera unless the SD card is formatted in ext4.
A GUI like the one below will be displayed, allowing you to operate the database.
External libraries required for operation
To build with C/C++, need below:
SQLite
To build with Python, need below:
SQLite
Python 3.7.9
The use of external libraries will be explained later.
Directory path of the sample app
The C/C++ source code is stored below.
${SDK_DIR}/src/adamapp/sqlite_app
The Python source code is stored below.
${SDK_DIR}/src/adamapp-py/sqlite_app
How to build the sample app (C/C++)
See here for building with C/C++.
How to build the sample app (Python)
See here for building with Python.
How to use the sample app
If the installation fails, please restart the camera and try again.
It is possible to operate the database from the GUI. Immediately after startup, the following screen will be displayed.
Enter the information as shown in the red frame below and press the UPDATE button.
As shown in the red frame below, the value of sample3 in the record whose sample1 column is 1 has been updated to "test3".
Next, enter as shown in the red frame below and press the INSERT button.
A new record has been inserted into the table, as shown in the red frame below.
Next, enter as shown in the red frame below and press the DELETE button.
One row has been deleted from the table as shown in red line below.
Appendix
Contents of SQL table column
The column names, types and ranges are as follows.
-Name of the column : sample1
Type : integer
Range : 1～9
Notes : Primary Key, Not null-Name of the column : sample2
Type : integer
Range : -1000～1000
Notes : Not null-Name of the column : sample3
Type : text
Range : 64文字
Notes : 特になし