<?php if (!defined('__XE__')) { exit; } $query = new Query(); $query->setQueryId("insertPoint"); $query->setAction("insert"); $query->setPriority(""); ${'member_srl249_argument'} = new Argument('member_srl', $args->{'member_srl'}); ${'member_srl249_argument'}->checkFilter('number'); ${'member_srl249_argument'}->checkNotNull(); if (!${'member_srl249_argument'}->isValid()) { return ${'member_srl249_argument'}->getErrorMessage(); } if (${'member_srl249_argument'} !== null) { ${'member_srl249_argument'}->setColumnType('number'); } ${'point250_argument'} = new Argument('point', $args->{'point'}); ${'point250_argument'}->checkFilter('number'); ${'point250_argument'}->ensureDefaultValue('0'); ${'point250_argument'}->checkNotNull(); if (!${'point250_argument'}->isValid()) { return ${'point250_argument'}->getErrorMessage(); } if (${'point250_argument'} !== null) { ${'point250_argument'}->setColumnType('number'); } $query->setColumns(array(new InsertExpression('`member_srl`', ${'member_srl249_argument'}), new InsertExpression('`point`', ${'point250_argument'}))); $query->setTables(array(new Table('`xe_point`', '`point`'))); $query->setConditions(array());
<?php if (!defined('__XE__')) { exit; } $query = new Query(); $query->setQueryId("getModuleCategories"); $query->setAction("select"); $query->setPriority(""); if (isset($args->moduleCategorySrl)) { ${'moduleCategorySrl2_argument'} = new ConditionArgument('moduleCategorySrl', $args->moduleCategorySrl, 'in'); ${'moduleCategorySrl2_argument'}->createConditionValue(); if (!${'moduleCategorySrl2_argument'}->isValid()) { return ${'moduleCategorySrl2_argument'}->getErrorMessage(); } } else { ${'moduleCategorySrl2_argument'} = NULL; } if (${'moduleCategorySrl2_argument'} !== null) { ${'moduleCategorySrl2_argument'}->setColumnType('number'); } ${'sort_index3_argument'} = new Argument('sort_index', $args->{'sort_index'}); ${'sort_index3_argument'}->ensureDefaultValue('title'); if (!${'sort_index3_argument'}->isValid()) { return ${'sort_index3_argument'}->getErrorMessage(); } $query->setColumns(array(new StarExpression())); $query->setTables(array(new Table('`xe_module_categories`', '`module_categories`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_category_srl`', $moduleCategorySrl2_argument, "in"))))); $query->setGroups(array()); $query->setOrder(array(new OrderByColumn(${'sort_index3_argument'}, "asc")));
/** * Test UPDATE query with a JOIN * @group update * @covers Query::getQuery */ function testUpdateQueryWithJoin() { $column_values = array('a.my_column1' => 'value1'); $q = new Query('my_table', 'ma'); $q->setAction(Query::ACTION_UPDATE)->setUpdateColumnValues($column_values)->join('other_table ob', 'ob.something = ma.my_column')->add('a.my_column3', array(1, 2, 3)); $query = $q->getQuery(); $actual = "{$query}"; $expected = "UPDATE `my_table` AS ma "; $expected .= "JOIN`other_table` AS ob ON (ob.something = ma.my_column)"; $expected .= "SET`a`.`my_column1`='value1'"; $expected .= "WHERE `a`.`my_column3` IN (1,2,3)"; $this->assertEquals(preg_replace('/\\s/', '', $expected), preg_replace('/\\s/', '', $actual)); }
<?php if (!defined('__XE__')) { exit; } $query = new Query(); $query->setQueryId("updatePackage"); $query->setAction("update"); $query->setPriority(""); ${'path1_argument'} = new Argument('path', $args->{'path'}); ${'path1_argument'}->checkNotNull(); if (!${'path1_argument'}->isValid()) { return ${'path1_argument'}->getErrorMessage(); } if (${'path1_argument'} !== null) { ${'path1_argument'}->setColumnType('varchar'); } ${'have_instance2_argument'} = new Argument('have_instance', $args->{'have_instance'}); ${'have_instance2_argument'}->checkNotNull(); if (!${'have_instance2_argument'}->isValid()) { return ${'have_instance2_argument'}->getErrorMessage(); } if (${'have_instance2_argument'} !== null) { ${'have_instance2_argument'}->setColumnType('char'); } ${'updatedate3_argument'} = new Argument('updatedate', $args->{'updatedate'}); ${'updatedate3_argument'}->checkNotNull(); if (!${'updatedate3_argument'}->isValid()) { return ${'updatedate3_argument'}->getErrorMessage(); } if (${'updatedate3_argument'} !== null) {
<?php if (!defined('__XE__')) { exit; } $query = new Query(); $query->setQueryId("deleteModuleExtraVars"); $query->setAction("delete"); $query->setPriority(""); ${'module_srl178_argument'} = new ConditionArgument('module_srl', $args->module_srl, 'equal'); ${'module_srl178_argument'}->checkFilter('number'); ${'module_srl178_argument'}->checkNotNull(); ${'module_srl178_argument'}->createConditionValue(); if (!${'module_srl178_argument'}->isValid()) { return ${'module_srl178_argument'}->getErrorMessage(); } if (${'module_srl178_argument'} !== null) { ${'module_srl178_argument'}->setColumnType('number'); } $query->setTables(array(new Table('`xe_module_extra_vars`', '`module_extra_vars`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srl178_argument, "equal"))))); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
/** * @param string $packageName * @param string $counterName * @param float $value * @return string */ public function compare($packageName, $counterName, $value) { $query = new Query(); $query->setAction(Query::ACTION_COMPARE); $query->setPackage($packageName); $query->setCounter($counterName); $query->setValue($value); return $this->query($query); }