public static function insert($table, $data)
{
Trace::addMessage(__CLASS__, sprintf('Inserting into table:"%s" with data:"%s"', $table, print_r($data, true)));
$result = parent::insert($table, $data);
Trace::addMessage(__CLASS__, sprintf('Insert into %s finished', $table));
return $result;
}
/**
*
* Создает объект права
* @param string $path строка набора объектов разделенная символом "/"
*/
public static function create($path, $title = '')
{
// Разрезаем путь
$path = self::getPath($path);
// Для каждого элемента пути
$parentId = 0;
$fullPath = '';
foreach ($path as $key => $row) {
// Получаем каждый элемент (имя, parent)
$condition = array('parentId' => $parentId, 'name' => $row);
if (empty($fullPath)) {
$fullPath .= $row;
} else {
$fullPath .= '/' . $row;
}
$el = DBSimple::get(ACL_TABLE, $condition);
// Если элемент не существует, создаем его
if (empty($el)) {
$insertCondition = $condition;
$insertCondition['fullPath'] = $fullPath;
$parentId = DBSimple::insert(ACL_TABLE, $insertCondition);
} else {
$parentId = $el['id'];
}
}
/**
* Если указан тайтл, то сохраняем его
*/
if (!empty($title)) {
$whereCondition = array('id' => $parentId);
$setCondition = array('title' => $title);
DBSimple::update(ACL_TABLE, $setCondition, $whereCondition);
}
return $parentId;
}
public static function dbFixture($tableName, $data)
{
$sql = sprintf(' TRUNCATE `%s` ', $tableName);
\Faid\DB::post($sql);
//
foreach ($data as $row) {
\Faid\DBSimple::insert($tableName, $row);
}
}
public function onInsert(\Extasy\ORM\QueryBuilder $queryBuilder)
{
if (empty($this->aValue)) {
return;
}
foreach ($this->aValue as $row) {
$row = IntegerHelper::toNatural($row);
DBSimple::insert($this->tableName, array($this->innerKey => $this->document->id->getValue(), $this->foreighnKey => $row));
}
}
protected function createTable()
{
$sql = <<<SQL
create table `test_document` (
\t`id` int not null auto_increment,
\t`name` varchar(255 ) not null default '',
\tprimary key (`id`)
);
SQL;
DB::post($sql);
DBSimple::insert(Model::TableName, array('name' => 'sitemap document'));
}
protected function storeValue()
{
$userId = $this->document->id->getValue();
if (empty($userId)) {
return;
}
DBSimple::delete(self::UIDTable, array('user_id' => $userId));
foreach ($this->aValue as $network => $uid) {
$network = Network::getByName($network);
DBSimple::insert(self::UIDTable, array('date' => date('Y-m-d H:i:s'), 'network_id' => $network->id->getValue(), 'user_id' => $this->document->id->getValue(), 'uid' => $uid));
}
}
public static function quickRegister($user, $authPassed, $method = 'default')
{
if (!empty($_SERVER['REMOTE_ADDR'])) {
$ip = $_SERVER['REMOTE_ADDR'];
if ('::1' == $ip) {
$ip = '127.0.0.1';
}
} else {
$ip = '127.0.0.1';
}
$userId = !empty($user) ? $user->id->getValue() : 0;
\Faid\DBSimple::insert(self::TableName, array('host' => ip2long($ip), 'date' => date('Y-m-d H:i:s'), 'user_id' => $userId, 'status' => !empty($authPassed) ? self::SuccessStatus : self::FailStatus, 'method' => $method));
\CMSLog::addMessage(__CLASS__, sprintf('Login attemp into user with id="%d", operation status - %s', $userId, !empty($authPassed) ? 'success' : 'fail'));
}
public function setUp()
{
parent::setUp();
self::dropTable();
$sql = <<<SQL
\t\tCREATE TABLE `test_model` (
\t\t \tid int not null auto_increment,
\t\t \tname varchar(255) not null,
\t\t \tprimary key (`id` )
\t\t)
SQL;
DB::post($sql);
DBSimple::insert('test_model', array('id' => 1, 'name' => self::fixtureName));
}
public function setUp()
{
DB::post('truncate table test_model');
DBSimple::insert('test_model', array('id' => 1, 'name' => self::fixtureName));
}
