<?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")));
Example #3
0
 /**
  * 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;
Example #6
0
 /**
  * @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);
 }