function filterArgument($argument, $argumentType, $value) { if ($argumentType == 'array') { return explode(',', $value); } return $argumentType == 'int' ? intval($value) : ACloud_Sys_Core_S::sqlEscape($value); }
function buildClause($arrays, $expr = null) { if (!is_array($arrays) && !$expr) { return ''; } $sets = " SET "; if ($expr) { foreach ($expr as $v) { $sets .= " " . $v . ","; } } if ($arrays) { foreach ($arrays as $k => $v) { $sets .= " " . ACloud_Sys_Core_S::sqlMetadata($k) . " = " . ACloud_Sys_Core_S::sqlEscape($v) . ","; } } $sets = trim($sets, ","); return $sets ? $sets : ''; }
function getDataByPrimaryKeyRange($tableSetting, $start, $end) { $generalDataService = ACloud_Sys_Core_Common::loadSystemClass('generaldata', 'config.service'); $dataSql = sprintf('SELECT * FROM %s WHERE %s >= %s AND %s <= %s', ACloud_Sys_Core_S::sqlMetadata($tableSetting['name']), ACloud_Sys_Core_S::sqlMetadata($tableSetting['primary_key']), ACloud_Sys_Core_S::sqlEscape($start), ACloud_Sys_Core_S::sqlMetadata($tableSetting['primary_key']), ACloud_Sys_Core_S::sqlEscape($end)); return $generalDataService->executeSql($dataSql); }
function sqlSingle($array, $strip = true) { if (!ACloud_Sys_Core_S::isArray($array)) { return ''; } $array = ACloud_Sys_Core_S::sqlEscape($array, $strip, true); $str = ''; foreach ($array as $key => $val) { $str .= ($str ? ', ' : ' ') . ACloud_Sys_Core_S::sqlMetadata($key) . '=' . $val; } return $str; }
function get($name) { return $this->fetchOne(sprintf("SELECT * FROM %s WHERE name = %s", $this->tablename, ACloud_Sys_Core_S::sqlEscape($name))); }
function delete($id) { return $this->query(sprintf("DELETE FROM %s WHERE app_id = %s", $this->tablename, ACloud_Sys_Core_S::sqlEscape($id))); }
function deleteSqlLogByTimestamp($startTime, $endTime) { $this->query(sprintf("DELETE FROM %s WHERE created_time >= %s AND created_time <= %s", $this->tablename, ACloud_Sys_Core_S::sqlEscape($startTime), ACloud_Sys_Core_S::sqlEscape($endTime))); return $this->affected_rows(); }
function getsByAppId($appId) { return $this->fetchAll(sprintf("SELECT * FROM %s WHERE app_id = %s ", $this->tablename, ACloud_Sys_Core_S::sqlEscape($appId))); }