/**
* Initiate a connection with the MySQL database. This is called by the
* constructor.
*
* @param string MySQL query or null to operate on the last executed query
* for this instance.
* @return boolean Was the connection successful?
*/
public function connect()
{
$this->_connection = ClsNaanalPDO::getNamedInstance("cats", DATABASE_NAME, DATABASE_USER, DATABASE_PASS, "mysql", DATABASE_HOST);
return true;
}
public function buildListFilter($module)
{
$objNewSQL=new ClsAuieoSQL();
$objFrom=$objNewSQL->addFrom("saved_list_entry");
$joinID=$objFrom->addJoinField("saved_list_id");
$objFromList=$objNewSQL->addFrom("saved_list");
$userJoinID=$objFromList->addJoinField("saved_list_id");
$objFromList->setJoinWith($objFrom,$joinID,$userJoinID);
$joinID=$objFromList->addJoinField("created_by");
$objFromUser=$objNewSQL->addFrom("user","owner_user");
$userJoinID=$objFromUser->addJoinField("user_id");
$objFromUser->setJoinWith($objFromList,$joinID,$userJoinID);
$joinID=$objFromList->addJoinField("data_item_type");
$objFromType=$objNewSQL->addFrom("data_item_type");
$userJoinID=$objFromType->addJoinField("data_item_type_id");
$objFromType->setJoinWith($objFromList,$joinID,$userJoinID);
$objWhere=$objNewSQL->addWhere($objFromType, "module", $module);
$sql=$objNewSQL->render();
$objPDO=ClsNaanalPDO::getNamedInstance();
$objPDO->setQuery($sql);
$arr=$objPDO->getAllAssoc();trace($arr);
}
public function __construct($host, $user, $pass, $dbname, $sqlserver = "mysql")
{
parent::__construct($host, $user, $pass, $dbname, $sqlserver);
}
/**
* returns current database
* @return string
*/
public static function getCurrentDatabase()
{
$dbid = self::getCurrentDatabaseID();
if ($dbid > 0) {
$sql = "select * from `database` where `id`=" . $dbid;
$pdo = ClsNaanalPDO::getNamedInstance();
$pdo->setQuery($sql);
$arrAssoc = $pdo->getAllAssoc();
$database = $arrAssoc[0]["databasename"];
$pdo->statement = null;
return $database;
} else {
return ClsNaanalApplication::getDefaultDatabase();
}
}
