public function __construct(IComponentContainer $parent = NULL, $name = NULL) { parent::__construct($parent, $name); $this->db = dibi::getConnection(); self::$count++; // $this->setWebloaderPaths(); }
/** * Component factory. * @see Nette/ComponentContainer#createComponent() */ protected function createComponentDataGrid($name) { $grid = new DataGrid(); $grid->bindDataTable(dibi::getConnection()->dataSource('SELECT authorId as id, name, surname, class,', Model::sqlClassName(Model::getSchoolYear()) . 'as classMark, (SELECT COUNT(workId) FROM [works] WHERE author=authorId) as sum FROM [authors] ')); $grid->addColumn('name', 'Jméno'); $grid->addColumn('surname', 'Příjmení')->addDefaultSorting('asc'); $grid->addColumn('class', 'Maturita')->getCellPrototype()->style('text-align: center;'); $grid->addColumn('classMark', 'Třída')->getCellPrototype()->style('text-align: right;'); $grid->addColumn('sum', 'Počet prací')->getCellPrototype()->style('text-align: right;')->class('pages'); $grid->addActionColumn('Akce'); $grid->keyName = 'id'; $grid->addAction('Smazat', 'delete!', NULL, FALSE, DataGridAction::WITH_KEY); $grid['name']->addFilter(); $grid['surname']->addFilter(); $grid['class']->addSelectboxFilter(); $grid['classMark']->addSelectboxFilter(); $grid['sum']->addSelectboxFilter(); $grid->multiOrder = FALSE; $grid->itemsPerPage = $this->getCookiesItemsCount(15); $renderer = $grid->getRenderer(); $renderer->paginatorFormat = '%label% %input% z %count%'; $renderer->infoFormat = 'Autoři %from%. - %to%. z %count% | Zobrazit: %selectbox% | %reset%'; $renderer->onRowRender[] = array($this, 'OnRowRendered'); //$grid->rememberState = TRUE; $this->addComponent($grid, $name); return; }
/** * Constractor creates connection and checks/creates tables stucture */ public function __construct() { $dibiConfig = dibi::getConnection()->getConfig(); $dbname = isset($dibiConfig['dbname']) ? $dibiConfig['dbname'] : $dibiConfig['database']; $config = array('driver' => 'sqlite', 'profiler' => Environment::getConfig('perform')->storage_profiler, 'database' => realpath(Environment::getConfig('perform')->modelCache) . '/' . $dbname . '-storage.sdb'); parent::__construct($config, 'storage'); if (!$this->getDatabaseInfo()->hasTable('fields')) { $this->query('CREATE TABLE [fields] ([id] INTEGER NOT NULL PRIMARY KEY, [name] VARCHAR(100) NOT NULL, [table] VARCHAR(50) NOT NULL, [hash] VARCHAR(32) NOT NULL, [type] VARCHAR(50)); CREATE UNIQUE INDEX [fields_idx] on [fields] ( [name], [table]);'); } if (!$this->getDatabaseInfo()->hasTable('tables')) { $this->query('CREATE TABLE [tables] ( [id] INTEGER NOT NULL PRIMARY KEY, [name] VARCHAR(100) NOT NULL UNIQUE, [hash] VARCHAR(32) NOT NULL);'); } if (!$this->getDatabaseInfo()->hasTable('views')) { $this->query('CREATE TABLE [views] ( [id] INTEGER NOT NULL PRIMARY KEY, [name] VARCHAR(100) NOT NULL UNIQUE, [hash] VARCHAR(32) NOT NULL);'); } if (!$this->getDatabaseInfo()->hasTable('indexes')) { $this->query('CREATE TABLE [indexes] ([id] INTEGER NOT NULL PRIMARY KEY, [name] VARCHAR(100) NOT NULL, [table] VARCHAR(50) NOT NULL, [hash] VARCHAR(32) NOT NULL, [unique] BOOLEAN); CREATE UNIQUE INDEX [indexes_idx] on [indexes] ( [name], [table]);'); } }
protected function setUp() { $this->db = dibi::getConnection("ormion"); $this->db->delete("comments")->execute(); $this->db->delete("pages")->execute(); $this->db->query("insert into [pages]", array("name" => "Clanek", "description" => "Popis", "text" => "Text", "visits" => 0, "allowed" => true), array("name" => "Article", "description" => "Description", "text" => "Text emericky.", "visits" => 5, "allowed" => false), array("name" => "Nepovolený článek", "description" => "Popis nepovoleného článku", "text" => "Dlouhý text. By byl delší než tento.", "visits" => 3, "allowed" => false), array("name" => "Jinačí článek", "description" => "Ryze alternativní popis", "text" => "Duchaplný text.", "visits" => 8, "allowed" => true)); }
protected function setUp() { $this->db = dibi::getConnection("ormion"); $this->db->delete("pages")->execute(); // id, name, description, text, created, allowed $this->db->query("insert into [pages]", array("name" => "Clanek", "description" => "Popis", "text" => "Text", "visits" => 0, "allowed" => true), array("name" => "Article", "description" => "Description", "text" => "Text emericky.", "visits" => 5, "allowed" => false), array("name" => "Nepovolený článek", "description" => "Popis nepovoleného článku", "text" => "Dlouhý text. By byl delší než tento.", "visits" => 3, "allowed" => false), array("name" => "Jinačí článek", "description" => "Ryze alternativní popis", "text" => "Duchaplný text.", "visits" => 8, "allowed" => true)); $fluent = $this->db->select("*")->from("pages"); $this->object = new Ormion\Collection($fluent, "Page"); }
/** * Component factory. * @see Nette/ComponentContainer#createComponent() */ protected function createComponentDataGrid($name) { $grid = new DataGrid(); $grid->bindDataTable(dibi::getConnection()->dataSource('SELECT workId as id, title, CONCAT_WS(" ", name, surname) as authorName, award, year, type, pages, added, edited FROM [works] join [authors] on author = authorId', 'WHERE %and', $this->where)); $grid->addActionColumn('Akce'); $grid->addColumn('title', 'Název', 50)->addDefaultSorting('asc'); if (!isset($this->where['authorId'])) { $grid->addColumn('authorName', 'Autor'); } $grid->addNumericColumn('year', 'Ročník')->getCellPrototype()->style('min-width: 75px;'); $grid->addDateColumn('added', 'Vytvořena', '%d.%m.%Y'); $grid->addDateColumn('edited', 'Upravena', '%H:%M:%S %d.%m.%Y')->getCellPrototype()->style('white-space: nowrap;'); $grid->addColumn('award', 'Cena'); $grid->addColumn('type', 'Typ'); $grid->addNumericColumn('pages', 'Stran')->getCellPrototype()->style('text-align: right;')->class = 'pages'; $grid->keyName = 'id'; $grid->addAction('Smazat', 'delete!', NULL, FALSE, DataGridAction::WITH_KEY); if ($this->advanced) { $grid['title']->addFilter(); $grid['authorName']->addFilter(); $grid['year']->addSelectboxFilter(); $grid['award']->addSelectboxFilter(); $grid['type']->addSelectboxFilter(); $grid['type']->addSelectboxFilter(); $grid['added']->addDateFilter(); $grid['edited']->addDateFilter(); if (isset($grid['pages'])) { $grid['pages']->addSelectboxFilter(); } } //$grid->itemsPerPage = ; $grid->multiOrder = FALSE; $grid->itemsPerPage = $this->getCookiesItemsCount(15); $renderer = $grid->getRenderer(); $renderer->paginatorFormat = '%label% %input% z %count%'; $renderer->infoFormat = 'Práce %from% - %to% z %count% | Zobrazit: %selectbox% | %reset%'; $renderer->onRowRender[] = array($this, 'worksOnRowRendered'); if (!$grid->paginator->itemCount) { $renderer->wrappers['form']['.class'] .= " hidden"; } //$grid->rememberState = TRUE; $this->addComponent($grid, $name); return; }
/** * @param string SQL command or table name, as data source * @param DibiConnection connection */ public function __construct($sql, DibiConnection $connection = NULL) { if (strpos($sql, ' ') === FALSE) { // table name $this->sql = $sql; } else { // SQL command $this->sql = '(' . $sql . ') AS [source]'; } $this->connection = $connection === NULL ? dibi::getConnection() : $connection; }
/** * Connect to DB, inherit credentials from constructor */ private function connect() { $this->connectionId = 'DB_CONNECTION_' . md5(implode(',', $this->credentials)); if (defined($this->connectionId) === FALSE) { $connection = dibi::connect($this->credentials, $this->connectionId); // Tracy panel if (TRACY === TRUE) { $panel = new Dibi\Bridges\Tracy\Panel(); $panel->register($connection); } define($this->connectionId, TRUE); } $this->connection = dibi::getConnection($this->connectionId); }
private function generatedConfig() { $tableInfo = dibi::getConnection("ormion")->getDatabaseInfo()->getTable("pages"); $cfg = Ormion\Config::fromTableInfo($tableInfo); $this->assertEquals(array("id", "name", "description", "text", "visits", "created", "allowed"), $cfg->getColumns()); $this->assertEquals(dibi::TEXT, $cfg->getType("name")); $this->assertEquals(dibi::INTEGER, $cfg->getType("id")); $this->assertEquals(dibi::TIME, $cfg->getType("created")); $this->assertEquals(dibi::BOOL, $cfg->getType("allowed")); $this->assertTrue($cfg->isNullable("description")); $this->assertFalse($cfg->isNullable("text")); $this->assertFalse($cfg->isNullable("name")); $this->assertTrue($cfg->isPrimaryAutoIncrement()); $this->assertEquals("id", $cfg->getPrimaryColumn()); }
protected function createComponentWorks($name) { //url as link, //title, $grid = new DataGrid(); $grid->bindDataTable(dibi::getConnection()->dataSource('SELECT url as link, authorUrl, title, award, year,', Model::sqlWorkClassName() . 'as workClass,', 'type, pages, [read] FROM [works] JOIN [authors] on author = authorId WHERE authorUrl=%s', $this->id)); $grid->addColumn('title', 'Název')->addDefaultSorting('asc')->getCellPrototype()->addClass('first'); $grid->addNumericColumn('year', 'Rok')->getCellPrototype()->style('text-align: center;'); $grid->addColumn('workClass', 'Třída')->getCellPrototype()->style('text-align: center;'); $grid->addColumn('award', 'Ocenění'); $grid->addColumn('type', 'Typ'); $grid->addNumericColumn('pages', 'Stran')->getCellPrototype()->style('text-align: right'); $grid->addColumn('read', 'Čtenost')->getCellPrototype()->style('text-align: right;'); /* $grid->addActionColumn('Akce'); $grid['title']->addFilter(); $grid['authorName']->addFilter(); $grid['year']->addSelectboxFilter(); $grid['award']->addSelectboxFilter(); $grid['type']->addSelectboxFilter(); $grid['pages']->addSelectboxFilter(); */ $grid->itemsPerPage = 0; $grid->multiOrder = FALSE; $renderer = $grid->getRenderer(); $renderer->paginatorFormat = '%label% %input% z %count%'; $renderer->infoFormat = 'Práce %from% - %to% z %count% | Zobrazit: %selectbox% | %reset%'; $renderer->onRowRender[] = array($this, 'worksOnRowRendered'); //$renderer->onCellRender[] = array($this, 'gridOnCellRendered'); //$grid->rememberState = TRUE; return $grid; //$this->addComponent($grid, $name); }
protected function createComponentAuthors($name) { $grid = new DataGrid(); $search = ""; if (isset($this->searchFull)) { foreach ($this->search as $one) { //$search .= "name LIKE '%".$one."%' OR surname LIKE '% ".$one."%' OR "; $search .= "name RLIKE '(^| ){$one}' OR surname RLIKE '(^| ){$one}' OR "; } foreach ($this->searchFull as $one) { $search .= "name RLIKE '(^| )" . $one . " ' OR surname RLIKE '(^| )" . $one . " ' OR "; } $search = substr($search, 0, -3); } $grid->bindDataTable(dibi::getConnection()->dataSource('SELECT authorUrl as link, name, surname,', $this->formColumns(array('class')), Model::sqlClassName(Model::getSchoolYear()) . 'as classMark,', Model::sqlSumWorks() . 'as [sum],', Model::sqlSumReads() . 'as [read]', 'FROM [authors]', 'WHERE %and', $this->where, '%if', isset($search), 'AND %sql', $search, '%end')); $grid->addColumn('name', 'Jméno')->getCellPrototype()->addClass('first'); $grid->addColumn('surname', 'Příjmení')->addDefaultSorting('asc'); if ($this->notCol('class')) { $grid->addColumn('class', 'Maturita')->getCellPrototype()->style('text-align: center;'); } $grid->addColumn('classMark', 'Třída')->getCellPrototype()->style('text-align: right;'); $grid->addColumn('sum', 'Počet prací')->getCellPrototype()->style('text-align: right;'); $grid->addColumn('read', 'Čtenost')->getCellPrototype()->style('text-align: right;'); $grid->multiOrder = FALSE; $grid->displayedItems = array('vše', 5, 8, 10, 20, 50, 100); $grid->itemsPerPage = $this->getCookiesItemsCount(8); $grid->nothingMessage = "Žádný autor nebyl nalezen."; $grid->hiddenFiltering = TRUE; $renderer = $grid->getRenderer(); $renderer->paginatorFormat = '%label% %input% z %count%'; $renderer->infoFormat = 'Autoři %from% - %to% z %count% | Zobrazit: %selectbox% | %reset%'; $renderer->onRowRender[] = array($this, 'authorsOnRowRendered'); //$renderer->onCellRender[] = array($this, 'gridOnCellRendered'); return $grid; //$this->addComponent($grid, $name); }
<!DOCTYPE html><link rel="stylesheet" href="data/style.css"> <h1>Query Language Named Arguments Examples | dibi</h1> <?php require __DIR__ . '/../dibi/dibi.php'; date_default_timezone_set('Europe/Prague'); dibi::connect(array('driver' => 'sqlite3', 'database' => 'data/sample.s3db')); dibi::getConnection()->getSubstitutes()->test = 'test_'; dibi::getConnection()->getSubstitutes()->{''} = 'testtoo_'; // SELECT $name = 'K%'; $timestamp = mktime(0, 0, 0, 10, 13, 1997); $id_list = array(1, 2, 3); // If the argument implements IDibiArguments, it is removed from the arguments // and added to the named argument collections. // If the %nmd modifier is used for a positional argument, it is also added // to the named argument collections. It should be an array or object implementing // the ArrayAccess interface. // Any named argument is a colon with identifier with optional percent sign and // value modifier. // Original substitutions are still present. dibi::test(' SELECT COUNT(*) as [count] %nmd FROM [:test:customers] WHERE [name] LIKE :name AND [added] > :timestamp%d OR [customer_id] IN :id_list%in ORDER BY [name]', new ArrayObject(['timestamp' => new DibiDateTime($timestamp)]), new DibiArguments(['name' => $name, 'id_list' => $id_list]));
public static function disconnect() { dibi::getConnection()->disconnect(); }
public static function init() { return new self(dibi::getConnection(), NEnvironment::getCache(), NEnvironment::getContext()); }
/** * Entity manager factory * * @param DibiConnection $connection * @return ActiveMapper\Manager */ public static function getManager(DibiConnection $connection = NULL) { if ($connection == NULL) { $connection = \dibi::getConnection(); } return new static($connection); }
<?php namespace App; require_once __DIR__ . "/bootstrap.php"; use Nette\Debug, Nette\Framework, dibi; Debug::timer('benchmark'); $memory = memory_get_peak_usage(); echoBeginHtml(); /********************************************************************************************************************************/ // Setum entity manager $em = new \ActiveMapper\Manager(\dibi::getConnection()); echo "<h1>All authors</h1>"; // Get all authors $authors = $em->findAll('App\\Models\\Author'); foreach ($authors as $author) { Debug::dump($author->name); Debug::dump($author->blog->name); } echo "<h1>Author by ID #3</h1>"; // Get author by id $author = $em->find('App\\Models\\Author', 3); Debug::dump($author->name); Debug::dump($author->blog->name); /********************************************************************************************************************************/ // Benchmark data Debug::barDump(Framework::NAME . " " . Framework::VERSION . " " . Framework::REVISION); Debug::barDump("dibi " . dibi::VERSION . " " . dibi::REVISION); Debug::barDump($mappingTime = number_format(Debug::timer('benchmark') * 1000, 1, '.', ' ') . "ms", "Mapping Time"); Debug::barDump($mappingMemory = number_format((memory_get_peak_usage() - $memory) / 1000, 1, '.', ' ') . "kB", "Mapping Memory"); echo '<p><a href="http://github.com/Vrtak-CZ/ActiveMapper/blob/master/examples/index.php" target="_blank">' . 'Show code on GitHub</a> - <a href="http://am.vrtak-cz.net/coverage">Show coverage</a></p>';
public function __construct() { $this->connection = dibi::getConnection(); }
/** * Getter for dibi connection * @return DibiConnection */ public static function getConnection() { if (!self::$connection) { self::$connection = dibi::getConnection(); } return self::$connection; }
public function __construct() { parent::__construct('', \dibi::getConnection()); }
public function copyTmpRecordToMd() { setMickaLog("Copy record to TMP", 'DEBUG', 'MdRecord.copyTmpRecordToMd'); $rs = array(); if (isset($this->md_record['md']) === FALSE || count($this->md_record['md']['RECNO']) < 1) { setMickaLog("Record not found", 'ERROR', 'MdRecord.copyTmpRecordToMp'); $rs['report'] = 'Record not found'; return $rs; } if ($this->md_record['user_right'] != 'w' || $this->user == 'guest') { setMickaLog("Not rights", 'ERROR', 'MdRecord.copyTmpRecordToMp'); $rs['report'] = 'Not rights'; return $rs; } // data z tmp $recno_tmp = $this->md_record['md']['RECNO']; $this->setTableMode('tmp'); $md = $this->getMd($where_col = 'recno', $where_value = $recno_tmp); $data_tmp = array(); $data_tmp = $this->md_record['md']; // data z md $this->setTableMode('md'); $tmp_table_md_values = TMPTABLE_PREFIX . '_md_values'; $md = $this->getMd($where_col = 'uuid', $where_value = $data_tmp['UUID']); if ($md['report'] == 'Record not found') { // Nový záznam setMickaLog("New record to MD", 'DEBUG', 'MdRecord.copyTmpRecordToMp'); $data['uuid'] = $data_tmp['UUID']; $data['md_standard'] = $data_tmp['MD_STANDARD']; $data['lang'] = 'eng'; // FIXME: optimalizace $data_md = array(); $recno = $this->setNewMd($data); $data_md['lang'] = $data_tmp['LANG']; $data_md['data_type'] = $data_tmp['DATA_TYPE']; $data_md['last_update_user'] = $this->user; $data_md['last_update_date'] = DB_DRIVER == 'mssql2005' ? str_replace('-', '', getNewDate()) : getNewDate(); $data_md['edit_group'] = $data_tmp['EDIT_GROUP'] != '' ? $data_tmp['EDIT_GROUP'] : $this->user; $data_md['view_group'] = $data_tmp['VIEW_GROUP'] != '' ? $data_tmp['VIEW_GROUP'] : $this->user; $data_md['x1'] = $data_tmp['X1'] != '' ? $data_tmp['X1'] : NULL; $data_md['y1'] = $data_tmp['Y1'] != '' ? $data_tmp['Y1'] : NULL; $data_md['x2'] = $data_tmp['X2'] != '' ? $data_tmp['X2'] : NULL; $data_md['y2'] = $data_tmp['Y2'] != '' ? $data_tmp['Y2'] : NULL; $data_md['the_geom'] = $data_tmp['THE_GEOM'] != '' ? $data_tmp['THE_GEOM'] : NULL; $data_md['range_begin'] = $data_tmp['RANGE_BEGIN'] != '' ? $data_tmp['RANGE_BEGIN']->format('Y-m-d') : NULL; $data_md['range_end'] = $data_tmp['RANGE_END'] != '' ? $data_tmp['RANGE_END']->format('Y-m-d') : NULL; $data_md['md_update'] = $data_tmp['MD_UPDATE'] != '' ? $data_tmp['MD_UPDATE'] : NULL; $data_md['title'] = $data_tmp['TITLE'] != '' ? $data_tmp['TITLE'] : NULL; $data_md['valid'] = $data_tmp['VALID']; $data_md['prim'] = $data_tmp['PRIM']; if (DB_DRIVER == 'oracle') { $xml = $data_tmp['PXML'] != '' ? $data_tmp['PXML'] : NULL; if ($xml != '') { $conn = dibi::getConnection()->driver->getResource(); setXmlToClob($conn, $this->table_md, 'xmldata', "recno={$recno}", $xml); } } elseif (DB_DRIVER == 'postgre') { //$data_md['pxml%sql'] = ($data_tmp['PXML'] != '') ? "XMLPARSE(DOCUMENT '" . $data_tmp['PXML'] . "')" : NULL; $data_md['xmldata'] = $data_tmp['PXML'] != '' ? $data_tmp['PXML'] : NULL; } elseif (DB_DRIVER == 'mssql2005') { $data_md['xmldata'] = $data_tmp['PXML'] != '' ? $data_tmp['PXML'] : NULL; } else { $data_md['pxml'] = $data_tmp['PXML'] != '' ? $data_tmp['PXML'] : NULL; } $this->setMd($recno, $data_md); setXmldata2Pxml($this->table_md, $recno); $sql = array(); array_push($sql, "\n\t\t\t\tINSERT INTO md_values (recno, md_id, md_value, md_path, lang , package_id)\n\t\t\t\tSELECT %i, md_id, md_value, md_path, lang , package_id FROM {$tmp_table_md_values} WHERE recno=%i\n\t\t\t", $recno, $recno_tmp); $result = _executeSql('insert', $sql, array('all')); } elseif ($md['report'] == 'ok' && $md['right'] == 'w') { // Update záznamu $data_md = array(); $recno = $md['md']['RECNO']; $data_md['lang'] = $data_tmp['LANG']; $data_md['data_type'] = $data_tmp['DATA_TYPE']; $data_md['last_update_user'] = $this->user; $data_md['last_update_date'] = DB_DRIVER == 'mssql2005' ? str_replace('-', '', getNewDate()) : getNewDate(); $data_md['edit_group'] = $data_tmp['EDIT_GROUP'] != '' ? $data_tmp['EDIT_GROUP'] : $this->user; $data_md['view_group'] = $data_tmp['VIEW_GROUP'] != '' ? $data_tmp['VIEW_GROUP'] : $this->user; $data_md['x1'] = $data_tmp['X1'] != '' ? $data_tmp['X1'] : NULL; $data_md['y1'] = $data_tmp['Y1'] != '' ? $data_tmp['Y1'] : NULL; $data_md['x2'] = $data_tmp['X2'] != '' ? $data_tmp['X2'] : NULL; $data_md['y2'] = $data_tmp['Y2'] != '' ? $data_tmp['Y2'] : NULL; $data_md['the_geom'] = $data_tmp['THE_GEOM'] != '' ? $data_tmp['THE_GEOM'] : NULL; $data_md['range_begin'] = $data_tmp['RANGE_BEGIN'] != '' ? $data_tmp['RANGE_BEGIN']->format('Y-m-d') : NULL; $data_md['range_end'] = $data_tmp['RANGE_END'] != '' ? $data_tmp['RANGE_END']->format('Y-m-d') : NULL; $data_md['md_update'] = $data_tmp['MD_UPDATE'] != '' ? $data_tmp['MD_UPDATE'] : NULL; $data_md['title'] = $data_tmp['TITLE'] != '' ? $data_tmp['TITLE'] : NULL; $data_md['valid'] = $data_tmp['VALID']; $data_md['prim'] = $data_tmp['PRIM']; if (DB_DRIVER == 'oracle') { //$data_md['pxml%sql'] = ($data_tmp['PXML'] != '') ? "XMLType('" . $data_tmp['PXML'] . "')" : NULL; $xml = $data_tmp['PXML'] != '' ? $data_tmp['PXML'] : NULL; if ($xml != '') { $conn = dibi::getConnection()->driver->getResource(); setXmlToClob($conn, $this->table_md, 'xmldata', "recno={$recno}", $xml); } } elseif (DB_DRIVER == 'postgre') { //$data_md['pxml%sql'] = ($data_tmp['PXML'] != '') ? "XMLPARSE(DOCUMENT '" . $data_tmp['PXML'] . "')" : NULL; $data_md['xmldata'] = $data_tmp['PXML'] != '' ? $data_tmp['PXML'] : NULL; } elseif (DB_DRIVER == 'mssql2005') { $data_md['xmldata'] = $data_tmp['PXML'] != '' ? $data_tmp['PXML'] : NULL; } else { //$data_md['pxml'] = ($data_tmp['PXML'] != '') ? $data_tmp['PXML'] : NULL; } $this->setMd($recno, $data_md); setXmldata2Pxml($this->table_md, $recno); $this->deleteMdValues($recno, 100, -1, -1, array()); $sql = array(); array_push($sql, "\n\t\t\t\tINSERT INTO md_values (recno, md_id, md_value, md_path, lang , package_id)\n\t\t\t\tSELECT %i, md_id, md_value, md_path, lang , package_id FROM {$tmp_table_md_values} WHERE recno=%i\n\t\t\t", $recno, $recno_tmp); $result = _executeSql('insert', $sql, array('all')); } else { $rs['report'] = $md['report']; return $rs; } unset($md); $rs['report'] = 'ok'; return $rs; }
/** * Table constructor. * @param DibiConnection * @return void */ public function __construct(DibiConnection $connection = NULL) { $this->connection = $connection === NULL ? dibi::getConnection() : $connection; $this->setup(); }
public static function init() { return new self(dibi::getConnection(), NEnvironment::getCache(self::MODULE_NAME)); }
/** @return DibiConnection */ public function createDibi() { return dibi::getConnection(); }