/**
* Application bootstrap configuration
*/
protected static function _setAppConfig()
{
/* paths */
static::option('paths', Module::merge(ptc_path('root') . '/app/config/paths.php'));
ptc_add_path(ptc_array_get(static::$_config, 'paths'));
/* application */
static::option('app', Module::merge(ptc_path('root') . '/app/config/app.php'));
HandyMan::addAlias(ptc_array_get(static::$_config, 'app.aliases'));
if ($locale = ptc_array_get(static::$_config, 'app.locale')) {
setlocale(LC_ALL, $locale . 'UTF-8');
}
if ($timezone = ptc_array_get(static::$_config, 'app.timezone')) {
date_default_timezone_set($timezone);
}
ptc_add_file(ptc_array_get(static::$_config, 'app.files'));
ptc_add_dir(ptc_array_get(static::$_config, 'app.directories'));
ptc_add_dir(ptc_array_get(static::$_config, 'app.namespaces'));
if ($sep = ptc_array_get(static::$_config, 'app.separators')) {
HandyMan::addSeparators($sep);
}
if ($conv = ptc_array_get(static::$_config, 'app.conventions')) {
HandyMan::addConventions($conv);
}
/* database */
static::option('db', Module::merge(ptc_path('root') . '/app/config/db.php'));
if ($db = ptc_array_get(static::$_config, 'db')) {
$loop = static::option('app.test_env') ? $db['develop'] : $db['prod'];
foreach ($loop as $k => $v) {
if (ptc_array_get($v, 'user')) {
DB::add($v, $k);
}
}
}
/* auth */
static::option('auth', Module::merge(ptc_path('root') . '/app/config/auth.php'));
}
$db['database'] = 'database name';
// mysql database name
/*************************************************************/
require_once '../PtcDb.php';
// including the PtcDb class
/* ADDING A CONNECTION, THIS WILL BE THE DEFAULT CONNECTION */
PtcDb::add(array('user' => $db['user'], 'pass' => $db['pass'], 'db' => $db['database']));
/* GETTING THE CONNECTION DETAILS */
$conn_details = PtcDb::getConnection('default');
// gets all connections if name param is not specified
var_dump($conn_details);
/* GETTING THE PDO OBJECT */
$pdo_object = PtcDb::getPdo('default');
/* USING PDO TO EXECUTE QUERIES WITH THE DEFAULT CONNECTION */
$query = PtcDb::prepare('SELECT * FROM some table');
// same as $pdo_object->prepare( );
//$query->execute( );
//var_dump( $query->fetchAll( ) );
/*
* THE FOLLOWING LINES REQUIRE THE PTCQUERYBUILDER.PHP FILE
* COMMENT LINE 45 TO EXECUTE THE REST OF THE CODE
*/
die;
/* ADDING ANOTHER DATABASE CONNECTION WITH THE QUERY BUILDER CLASS SUPPORT */
require_once '../PtcQueryBuilder.php';
// including the Query Builder class
PtcDb::add(array('user' => $db['user'], 'pass' => $db['pass'], 'db' => $db['database'], 'query_builder' => true, 'pdo_attributes' => array(PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC)), 'new connection');
/* GETTING THE QUERY BUILDER OBJECT */
$qb = PtcDb::getQB('new connection');
/* RUNNING THE QUERY BUILDER , REFER TO THE QUERY BUILDER EXAMPLE FILES FOR USAGE */
echo '<b>prepare select statement:</b> ' . $qb->table('test_table')->select('some_column as test')->prepare();
$db['user'] = '******';
// mysql user
$db['pass'] = '******';
// mysql pass
$db['database'] = 'database';
// mysql database name
/*************************************************************/
require_once '../PtcDb.php';
// including the PtcDb class
/* ADDING DATABASE CONNECTION WITH THE QUERY BUILDER CLASS SUPPORT */
require_once '../PtcQueryBuilder.php';
// including the Query Builder class
PtcDb::add(array('user' => $db['user'], 'pass' => $db['pass'], 'db' => $db['database'], 'query_builder' => true));
/* CREATE THE EXAMPLE TABLE */
PtcDb::run("DROP TABLE IF EXISTS `test_table`");
PtcDb::run("CREATE TABLE `test_table` \n\t(\n\t\t`id` int NOT NULL AUTO_INCREMENT, \n\t\tPRIMARY KEY(`id`),\n\t\t`field1` varchar(255),\n\t\t`field2` varchar(255)\n\t)");
require_once '../PtcMapper.php';
// including the ORM class
/* EXTENDING THE CLASS WITH THE TABLE NAME */
class Test_Table extends PtcMapper
{
/* USING THE CLASS NAME AS TABLE */
//protected static $_table = '';
/* MAP FIELD NAMES IF "AS" IS USED IN A SELECT QUERY */
//protected static $_map = array( 'field1' => 'test' );
/* USE THIS PROPERTY IF THE TABLE USES ANOTHER
* COLUMN NAME FOR THE PRIMARY KEY */
//protected static $_uniqueKey = 'id';
/* OBSERVER EXAMPLE, WORKS WITH PTCEVENT COMPONENT */
public static function saved($data, $result)
{
