PHP Sasik\Db DbSingleton示例

示例#1

文件： Children.php 项目： sasik-github/Children

 public function addParent(Parents $parent)
 {
     $parent->save();
     $this->parents[] = $parent;
     $mapper = DbSingleton::getParentChildrenMapper();
     $mapper->addRelation($parent, $this);
 }

示例#2

文件： index.php 项目： sasik-github/Children

<?php

define('APPLICATION_PATH', __DIR__ . '/../');
define('CONFIG', APPLICATION_PATH . '/configs/config.json');
require_once APPLICATION_PATH . "vendor/autoload.php";
$config = new \Noodlehaus\Config(CONFIG);
$app = new Silex\Application();
$app['debug'] = $config->get('debug');
$dbOptions = $config->get('db');
define('APP_KEY', $config->get('app_key'));
$app->register(new Silex\Provider\DoctrineServiceProvider(), ['db.options' => $dbOptions]);
\Sasik\Db\DbSingleton::setDb($app['db']);
$app->mount('/', new Sasik\Controllers\IndexControllerProvider());
$app->run();

示例#3

文件： Tokens.php 项目： sasik-github/Children

 public function delete()
 {
     $mapper = DbSingleton::getTokensMapper();
     return $mapper->delete($this->id);
 }

示例#4

文件： testDb.php 项目： sasik-github/Children

 * User: sasik
 * Date: 7/17/15
 * Time: 3:05 PM
 */
define('APPLICATION_PATH', __DIR__ . '/../');
define('CONFIG', APPLICATION_PATH . '/configs/config.json');
require_once APPLICATION_PATH . "vendor/autoload.php";
use Sasik\Models\Children;
use Sasik\Models\Parents;
use Sasik\Models\Tokens;
$config = new \Noodlehaus\Config(CONFIG);
$app = new Silex\Application();
$app['debug'] = true;
$app->register(new Silex\Provider\DoctrineServiceProvider(), ['db.options' => $config->get('db')]);
\Sasik\Db\DbSingleton::setDb($app['db']);
$db = \Sasik\Db\DbSingleton::getDb();
/**
 * ОСТОРОЖНО
 */
foreach (['children', 'parents', 'tokens', 'children_to_parents'] as $table) {
    $query = $db->createQueryBuilder();
    $query->delete($table)->execute();
    //    $db->fetchAll('DELETE FROM ' . $table );
}
//$db->delete('children', []);
//$db->delete('parents', []);
//$db->delete('tokens', []);
//$db->delete('children_to_parents', []);
$childrens = [Children::createObj(['name' => 'Children' . uniqid()]), Children::createObj(['name' => 'TestChildren']), Children::createObj(['name' => 'Children' . uniqid()]), Children::createObj(['name' => 'Children' . uniqid()]), Children::createObj(['name' => 'Children' . uniqid()])];
saveAll($childrens);
$parents = [Parents::createObj(['login' => 'Parent' . uniqid(), 'password' => uniqid()]), Parents::createObj(['login' => 'TestParent', 'password' => 'ParentPass']), Parents::createObj(['login' => 'Parent' . uniqid(), 'password' => uniqid()]), Parents::createObj(['login' => 'Parent' . uniqid(), 'password' => uniqid()])];

示例#5

文件： Message.php 项目： sasik-github/Children

 public function save()
 {
     $mapper = DbSingleton::getMessageMapper();
     $params = ['parent_id' => $this->parent_id, 'child_id' => $this->child_id, 'message' => $this->message, 'date' => $this->date];
     $this->doSave($mapper, $params);
 }

示例#6

文件： Parents.php 项目： sasik-github/Children

 public function addChildren(Children $children)
 {
     $children->save();
     $this->childrens[] = $children;
     $mapper = DbSingleton::getParentChildrenMapper();
     $mapper->addRelation($this, $children);
 }