/**
* 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);
}
