Lines Matching refs:sql

72             $sql = "SELECT *
80             $sql = "SELECT *
87         $schema = $this->sqlite->queryAll($sql, $opt);
102         $sql = "SELECT SC.*, T.*
108         $rows = $this->sqlite->queryAll($sql, [$this->id]);
196         $sql = "DROP TABLE ";
197         $this->sqlite->query($sql . 'data_' . $this->table);
198         $this->sqlite->query($sql . 'multi_' . $this->table);
200         $sql = "DELETE FROM schema_assignments WHERE tbl = '$this->table'";
201         $this->sqlite->query($sql);
203         $sql = "DELETE FROM schema_assignments_patterns WHERE tbl = '$this->table'";
204         $this->sqlite->query($sql);
206         $sql = "SELECT T.id
211         $sql = "DELETE FROM types WHERE id IN ($sql)";
213         $this->sqlite->query($sql, [$this->table]);
215         $sql = "SELECT id
218         $sql = "DELETE FROM schema_cols WHERE sid IN ($sql)";
220         $this->sqlite->query($sql, [$this->table]);
222         $sql = "DELETE FROM schemas WHERE tbl = ?";
223         $this->sqlite->query($sql, [$this->table]);
244         $sql = 'DELETE FROM ';
245         $this->sqlite->query($sql . 'data_' . $this->table);
246         $this->sqlite->query($sql . 'multi_' . $this->table);