/** * Table setter/getter. * * @return mixed */ public function table($table_name = null) { if (func_num_args() === 0) { return $this->table; } else { $table = gluedb::table($table_name); return $this->set_property('table', $table); } }
/** * Returns compiled SQL string according to given database SQL dialect. * * @param GlueDB_Database $db Database that defines what SQL dialect must be used to compile the fragment. * @param integer $style * * @return string */ public function sql(GlueDB_Database $db = null, $style = self::STYLE_DEFAULT) { // No database given ? Means default database : if (!isset($db)) { $db = gluedb::db(GlueDB_Database::DEFAULTDB); } // Get name of given database instance : $dbname = $db->name(); // Retrieve SQL from cache, or create it and add it to cache if it isn't there yet : if (!isset($this->sql[$dbname][$style])) { $this->sql[$dbname][$style] = $this->compile($db, $style); } // Return SQL : return $this->sql[$dbname][$style]; }
private function test_queries() { $statement = gluedb::insert('glusers', $u)->columns($u->login, $u->password)->values('test1', 'test1')->and('test2', 'test2')->and('test3', 'test3')->prepare(); $statement->execute(); }
/** * Returns the database object this virtual table is stored into. * * @return GlueDB_Database */ public function db() { return gluedb::db($this->dbname); }