Create the following script, called mysqlite_adc.py:
#!/usr/bin/python3 #mysql_adc.py import sqlite3 import datetime import data_adc as dataDevice import time import os DEBUG=True SHOWSQL=True CLEARDATA=False VAL0=0;VAL1=1;VAL2=2;VAL3=3 #Set data order FORMATBODY="%5s %8s %14s %12s %16s" FORMATLIST="%5s %12s %10s %16s %7s" DATEBASE_DIR="/var/databases/datasite/" DATEBASE=DATEBASE_DIR+"mydatabase.db" TABLE="recordeddata" DELAY=1 #approximate seconds between samples def captureSamples(cursor): if(CLEARDATA):cursor.execute("DELETE FROM %s" %(TABLE)) myData = dataDevice.device() myDataNames=myData.getName() if(DEBUG):print(FORMATBODY%("##",myDataNames[VAL0], myDataNames[VAL1],myDataNames[VAL2], myDataNames[VAL3])) for x in range(10): ...
