[Solved] sqlite Database not working?

---

Hello all,
I configured pimatic with for a sqlite database

 "client": "sqlite3",
  "connection": {
    "filename": "pimatic-database.sqlite"
  },

then I tried to open the databse file to show me the tables

pi@raspberrypi ~ $ sqlite3 pimatic-app/pimatic-database.sqlite
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
sqlite> .quit

But no tables are shown

Fresh install? shutdown pimatic services and delete the DB file then start pimatic and wait.
use tail -f pimatic-deamon.log to check the progress of sqlite it can take a while to complete.

After deleting and restarting everything is fine 😃

How can I access the db file?

<?php
Class MyDB extends SQLite3
{

function __construct()
      {
$this->open(’/home/pi/pimatic-app/pimatic-database.sqlite’);
}
}
$db = new MyDB();
if(!$db){
Echo $db->lastErrorMsg();
}else {
echo “Opened database successfully\n”;
}
$sql =<<<EOF
SELECT * from message;EOF;
$ret = $db->query($sql);
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){

echo "ID = ". $row[‘id’] . “\n”;

echo “time = “. $row[‘time’] .”\n”;

echo “level = “. $row[‘level’] .”\n”;

echo “TAGS =  “.$row[‘tags’] .”\n\n”;
}
Echo “Operation done successfully\n”;
$db->close();
?>