Create database crud using MariaDB python raspberry pi
Budget: $10 – $30 USD
create a step-by-step instruction in raspberry pi to create a local Database using MariaDB, and create tables.
Also, create the functions in python to connect to de local database, make Crud functions: Create a row, read a row, update the row, delete the row, get all table data, delete all table data.
Tables :
User : [ id, email, name , last_name , hash_password ]
Reports [ id_Vehiculo, DATE, GROUP, BATERI, Position, SPEED, RPM, DISTANCE_W_MIL, DISTANCE_SINCE_DTC_CLEAR, ALERT ]
Auth : [ user_id, login_date, expire_date ]
You need to prove that works on the raspberry pi zero w.
if the raspberry pi reboot because loses energy, the python program has to start and the server database too
if you have experience, you could move faster.
Also, create the functions in python to connect to de local database, make Crud functions: Create a row, read a row, update the row, delete the row, get all table data, delete all table data.
Tables :
User : [ id, email, name , last_name , hash_password ]
Reports [ id_Vehiculo, DATE, GROUP, BATERI, Position, SPEED, RPM, DISTANCE_W_MIL, DISTANCE_SINCE_DTC_CLEAR, ALERT ]
Auth : [ user_id, login_date, expire_date ]
You need to prove that works on the raspberry pi zero w.
if the raspberry pi reboot because loses energy, the python program has to start and the server database too
if you have experience, you could move faster.