public function testFTS()
 {
     $tableName = "test_fts4";
     if (!$this->db->hasTable($tableName)) {
         $this->db->fetchColumn("CREATE VIRTUAL TABLE {$tableName} USING fts4(subject, body)");
         for ($i = 1; $i <= 100; $i++) {
             $id = $this->db->insert($tableName, array('subject' => $i . ' test ' . $i, 'body' => $i . 'hello hollad cccdd aayy' . $i));
         }
     }
     $row = $this->db->query("SELECT * FROM {$tableName} WHERE subject MATCH 'test'");
     return $row;
 }
 /**
  * creat or get a DB
  *
  * @param $dbpath
  * @return SpatialiteShellDriver
  */
 public function createDB($dbpath)
 {
     $driver = new SpatialiteShellDriver($dbpath);
     if (!$driver->hasTable("geometry_columns")) {
         $driver->initDbFile();
     }
     return $driver;
 }