Lines Matching refs:sqlite

8      * @param helper_plugin_sqlite $sqlite
11     public function no_apr_namespace(helper_plugin_sqlite $sqlite) {
14         $res = $sqlite->query('SELECT value FROM config WHERE key=?', $key);
15         $no_apr_namespaces_db = $sqlite->res2single($res);
19             $sqlite->query('UPDATE config SET value=? WHERE key=?', $no_apr_namespaces_conf, $key);
21             $res = $sqlite->query('SELECT page, hidden FROM page');
22             $pages = $sqlite->res2arr($res);
26                 $in_hidden_namespace = $this->in_hidden_namespace($sqlite, $id, $no_apr_namespaces_conf);
30                     $sqlite->query('UPDATE page SET hidden=? WHERE page=?', $new_hidden, $id);
39      * @param helper_plugin_sqlite $sqlite
44     public function use_approve_here(helper_plugin_sqlite $sqlite, $id, &$approver=null) {
47         $this->no_apr_namespace($sqlite);
49         $res = $sqlite->query('SELECT page, approver FROM page WHERE page=? AND hidden=0', $id);
50         $row = $sqlite->res2row($res);
59      * @param helper_plugin_sqlite $sqlite
63     public function find_last_approved(helper_plugin_sqlite $sqlite, $id) {
64         $res = $sqlite->query('SELECT rev FROM revision
67         return $sqlite->res2single($res);
71      * @param helper_plugin_sqlite $sqlite
75     public function get_hidden_namespaces_list(helper_plugin_sqlite $sqlite, $no_apr_namespaces=null) {
77             $no_apr_namespaces = $this->no_apr_namespace($sqlite);
90      * @param helper_plugin_sqlite $sqlite
95     public function in_hidden_namespace(helper_plugin_sqlite $sqlite, $id, $no_apr_namespaces=null) {
96         $no_apr_namespaces_list = $this->get_hidden_namespaces_list($sqlite, $no_apr_namespaces);
107      * @param helper_plugin_sqlite $sqlite
110     public function weighted_assignments(helper_plugin_sqlite $sqlite) {
111         $res = $sqlite->query('SELECT id,namespace,approver FROM maintainer');
112         $assignments = $sqlite->res2arr($res);
133      * @param helper_plugin_sqlite $sqlite
139     public function isPageAssigned(helper_plugin_sqlite $sqlite, $id, &$pageApprover=null, $weighted_assignments=null) {
141             $weighted_assignments = $this->weighted_assignments($sqlite);
171      * @param helper_plugin_sqlite $sqlite
173     public function updatePagesAssignments(helper_plugin_sqlite $sqlite)
176         $sqlite->query('DELETE FROM page');
179         $no_apr_namespace = $this->no_apr_namespace($sqlite);
180         $weighted_assignments = $this->weighted_assignments($sqlite);
182             if ($this->isPageAssigned($sqlite, $id, $approver, $weighted_assignments)) {
185                     'hidden' => $this->in_hidden_namespace($sqlite, $id, $no_apr_namespace) ? '1' : '0'
190                 $sqlite->storeEntry('page', $data);