| define('SQLITE3_ASSOC', 1);
|
|
|
| class SQLite3 {
|
|
|
| private $prev_query = null;
|
| private $data = [
|
| "SELECT count(*) FROM schedule WHERE uri LIKE '/.2/slackware/slackware-current/ChangeLog.txt';" => [['count(*)' => 1]],
|
| "SELECT count(*) FROM schedule WHERE uri LIKE '/pub/webalizer/webalizer-geodb-latest.tgz';" => [['count(*)' => 1]],
|
| "SELECT * FROM schedule;" => [
|
| [
|
| "renew" => 1,
|
| "timestamp" => 0,
|
| "repeat" => 0,
|
| "proto" => "ftp",
|
| "host" => "localhost",
|
| "user" => "user",
|
| "password" => "password",
|
| "uri" => "uri",
|
| "type" => "type"
|
| ]
|
| ],
|
| ];
|
|
|
| public function exec(...$args) { var_dump($args); return $this; }
|
| public function query(...$args) { $this->prev_query = $args[0]; var_dump($this->prev_query); return $this; }
|
| public function fetchArray(...$args) {
|
| try {
|
| var_dump($ret=array_pop($this->data[$this->prev_query])); return $ret;
|
| return $ret;
|
| } catch (Exception $e) {
|
| var_dump($this->prev_query);
|
| }
|
| }
|
|
|
| }
|