public function persist()
{
$db = new Database();
if ($this->id == null) {
$db->execute('INSERT INTO followers (user, follower) VALUES (?, ?)', array($this->user, $this->follower));
$this->id = $db->lastInsertId();
} else {
$req = 'UPDATE followers SET user = ?, follower = ? WHERE id = ?';
$db->execute($req, array($this->user, $this->follower, $this->id));
}
}
public function persist()
{
$db = new Database();
if ($this->id == null) {
$req = 'INSERT INTO article (title, content, articleDate, streamType, url, stream_id) VALUES (?, ?, ?, ?, ?, ?)';
$db->execute($req, array($this->title, $this->content, $this->articleDate, $this->streamType, $this->url, $this->stream_id));
$this->id = $db->lastInsertId();
} else {
$req = 'UPDATE article SET title = ?, content = ?, articleDate = ?, streamType = ?, url = ?, stream_id = ? WHERE id = ?';
$db->execute($req, array($this->title, $this->content, $this->articleDate, $this->streamType, $this->url, $this->stream_id, $this->id));
}
}
public function persist()
{
$db = new Database();
if ($this->id == null) {
$req = 'INSERT INTO stream_email (server, account, password, port, firstUpdate) VALUES (?, ?, ?, ?, ?)';
$db->execute($req, array($this->server, $this->account, $this->password, $this->port, $this->firstUpdate));
$this->id = $db->lastInsertId();
} else {
$req = 'UPDATE stream_email SET server = ?, account = ?, password = ?, port = ?, firstUpdate = ? WHERE id = ?';
$db->execute($req, array($this->server, $this->account, $this->password, $this->port, $this->firstUpdate, $this->id));
}
}
public function persist()
{
$db = new Database();
if ($this->id == null) {
$req = 'INSERT INTO blog (account, article) VALUES (?, ?)';
$db->execute($req, array($this->account, $this->article));
$this->id = $db->lastInsertId();
} else {
$req = 'UPDATE blog SET account = ?, article = ? WHERE id = ?';
$db->execute($req, array($this->account, $this->article, $this->id));
}
}
/**
* @covers Database::execute
* @covers Database::rowCount
*/
public function testExecute()
{
$this->assertEquals(1, $this->db->execute('INSERT INTO test (name) VALUES (?)', 'Value 4'), LoggerApp::getLastError());
$this->assertEquals(1, $this->db->execute("INSERT INTO test (name) VALUES (?)", array('teste')), LoggerApp::getLastError());
$this->assertEquals(1, $this->db->rowCount(), 'Erro no numero de linhas inseridas');
$this->assertEquals(5, $this->db->execute("UPDATE test SET name = name || ?", '_teste'), LoggerApp::getLastError());
$this->assertEquals(5, $this->db->rowCount(), 'Erro no numero de linhas alteradas');
$this->assertFalse(LoggerApp::hasError(), LoggerApp::getLastError());
$this->assertEquals(0, $this->db->execute("DELETE INVALIDTest SET name = ?", 'teste 2'), 'Comando inválido');
$this->assertTrue(LoggerApp::hasError(), 'Erro inválido');
$this->assertEquals(0, $this->db->rowCount(), 'Nenhuma linha afetada');
}
public function persist()
{
$db = new Database();
if ($this->id == null) {
$req = 'INSERT INTO accounts (authentification, username, email, userKey, active, accountLevel, picture) VALUES (?, ?, ?, ?, ?, ?, ?)';
$db->execute($req, array($this->authentification, $this->username, $this->email, $this->userKey, $this->active, $this->accountLevel, $this->picture));
$this->id = $db->lastInsertId();
} else {
$req = 'UPDATE accounts SET authentification = ?, username = ?, email = ?, userKey = ?, active = ?, accountLevel = ?, picture = ? WHERE id = ?';
$db->execute($req, array($this->authentification, $this->username, $this->email, $this->userKey, $this->active, $this->accountLevel, $this->picture, $this->id));
}
}
public function persist()
{
$db = new Database();
if ($this->id == null) {
$req = 'INSERT INTO stream_category (stream, category, streamType) VALUES (?, ?, ?)';
$db->execute($req, array($this->stream, $this->category, $this->streamType));
$this->id = $db->lastInsertId();
} else {
$req = 'UPDATE stream_category SET stream = ?, category = ?, streamType = ? WHERE id = ?';
$db->execute($req, array($this->stream, $this->category, $this->streamType, $this->id));
}
}
public function ListDistrictProcess($param)
{
parent::query('SELECT * FROM dy_location_district WHERE ds_city_id = :city_id ORDER BY ds_id ASC');
parent::bind(':city_id', $param['city_id']);
parent::execute();
return parent::resultset();
}
public function SearchLogCountProcess()
{
parent::query('SELECT COUNT(lo_id) FROM log_search');
parent::execute();
$data = parent::single();
return $data['COUNT(lo_id)'];
}
/**
* @param array $options single_column
*/
public function execute(array $options = null)
{
$data = $this->_compile();
if (isset($this->select)) {
if (isset($this->limit) && $this->_parameter_first('limit') == 1) {
$return = $this->_database->one($data['sql'], $data['values'], $options);
} else {
$return = $this->_database->many($data['sql'], $data['values'], $options);
}
} else {
$this->_database->execute($data['sql'], $data['values']);
$return = $this->_database->last_insert_id();
}
$this->clear();
return $return;
}
public function persist()
{
$db = new Database();
$firstUpdate = date(Database::DATE_FORMAT, strtotime($this->firstUpdate));
$lastUpdate = date(Database::DATE_FORMAT, strtotime($this->lastUpdate));
if ($this->id == null) {
$req = 'INSERT INTO stream_twitter (channel, firstUpdate, lastUpdate) VALUES (?, ?, ?)';
$data = array($this->channel, $firstUpdate, $lastUpdate);
$db->execute($req, $data);
$this->id = $db->lastInsertId();
} else {
$req = 'UPDATE stream_twitter SET channel = ?, firstUpdate = ?, lastUpdate = ? WHERE id = ?';
$data = array($this->channel, $firstUpdate, $lastUpdate, $this->id);
$db->execute($req, $data);
}
}
public function DeleteItem($id = 0)
{
$db = new Database();
$db->query("DELETE FROM menuitem WHERE `Id`=:id");
$db->bind(':id', $id);
$db->execute();
header("Location: index.php");
}
public function EditItemsInOrderProcess($param)
{
parent::query('UPDATE dd_order_detail SET odt_amount = :amount WHERE odt_order_id = :order_id AND odt_product_id = :product_id');
parent::bind(':amount', $param['amount']);
parent::bind(':order_id', $param['order_id']);
parent::bind(':product_id', $param['product_id']);
parent::execute();
}
public function DeletePhotoProcess($param)
{
parent::query('DELETE FROM dy_image WHERE (im_id = :image_id AND im_member_id = :member_id AND im_post_id = :post_id)');
parent::bind(':member_id', $param['member_id']);
parent::bind(':image_id', $param['image_id']);
parent::bind(':post_id', $param['post_id']);
parent::execute();
}
public function EditProductProcess($param)
{
parent::query('SELECT * FROM dd_product');
parent::execute();
parent::execute();
$dataset = parent::resultset();
return $dataset;
}
function __construct()
{
require_once $_SERVER['DOCUMENT_ROOT'] . '/restfulController/application/database.php';
$database = new Database();
$query = "SELECT * FROM Menu LEFT JOIN Content ON Menu.MenuContentKey = Content.ContentKey ORDER BY Menu.MenuID ASC";
$this->Menu = $database->execute($query);
$database->close();
}
public function CommentAlreadyCheckingProcess($param)
{
parent::query('SELECT ac_id FROM dy_activity WHERE (ac_member_id = :member_id) AND (ac_action = "new_comment") AND (ac_to_post_id = :post_id)');
parent::bind(':member_id', $param['member_id']);
parent::bind(':post_id', $param['post_id']);
parent::execute();
return parent::single();
}
public static function createTable(Database &$db)
{
$sql = 'CREATE TABLE ' . self::pluralForm(get_called_class()) . ' (';
foreach (self::getFields() as $k => $v) {
echo "{$k} -> {$v}\n";
}
$sql .= ')';
return $db->execute($sql);
}
public function ListAmphurProcess($param)
{
echo 'province_id: ' . $param['province_id'];
parent::query('SELECT * FROM th_amphur WHERE amphur_province_id = :province_id AND amphur_postcode != "00000"');
parent::bind(':province_id', $param['province_id']);
parent::execute();
$dataset = parent::resultset();
return $dataset;
}
/**
* Delete Comments
*
* @param int $id
* @return bool
*/
public function deleteComment($id)
{
$this->db->query("DELETE FROM comments \n\t\t\t\tWHERE id = :id");
$this->db->bind(':id', $id);
//Execute
if ($this->db->execute()) {
return true;
} else {
return false;
}
}
/**
* Tests Database::execute($sql,$values), with two arguments, i.e., with
* variable bindings
*
* @dataProvider provider
*/
public function testExecuteParamsBinding($a, $b, $c)
{
$sql = 'INSERT INTO tests (id,fieldvarchar,fieldint) VALUES (?,?,?)';
$values = array($a, $b, $c);
$rs = Database::execute($sql, $values);
$this->assertTrue($rs !== false, 'INSERT failed!');
$sql = "SELECT id,fieldvarchar,fieldint FROM tests WHERE id=" . $a;
$rs = Database::query($sql);
$this->assertTrue($rs !== false && $rs->nextRow(), 'SELECT failed!');
$this->assertEquals(array($a, $b, $c), array($rs->getId(), $rs->getFieldVarchar(), $rs->getFieldInt()), 'Database contents incorrect');
}
public function ListKeywordProcess($param)
{
parent::query('SELECT * FROM dy_keyword WHERE kw_total > 0 ORDER BY kw_total DESC LIMIT 100');
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
$dataset[$k]['kw_create_time_facebook_format'] = parent::date_facebookformat($var['kw_create_time']);
$dataset[$k]['kw_update_time_facebook_format'] = parent::date_facebookformat($var['kw_update_time']);
}
return $dataset;
}
private function getAllId(Database $database)
{
$query = 'SELECT id FROM accounts';
$result = $database->execute($query);
$allId = array();
$fetch = $result->fetch();
while ($fetch) {
array_push($allId, $fetch['id']);
$fetch = $result->fetch();
}
return $allId;
}
public function CheckingBankTransferProcess($param)
{
parent::query('SELECT mf_id FROM dd_money_transfer WHERE mf_to_bank = :bank_id');
parent::bind(':bank_id', $param['bank_id']);
parent::execute();
$dataset = parent::single();
if (empty($dataset['mf_id'])) {
return true;
} else {
return false;
}
}
public function UpdateReadProcess($param)
{
parent::query('SELECT pd_read FROM dd_product WHERE pd_id = :product_id');
parent::bind(':product_id', $param['product_id']);
parent::execute();
$data = parent::single();
$read = $data['pd_read'] + 1;
parent::query('UPDATE dd_product SET pd_read = :read,pd_visit_time = :visit_time WHERE pd_id = :product_id');
parent::bind(':product_id', $param['product_id']);
parent::bind(':read', $read);
parent::bind(':visit_time', date('Y-m-d H:i:s'));
parent::execute();
}
public function getByUser(UserEntity $user)
{
$db = new Database();
$result = $db->execute("SELECT * FROM passwords WHERE account = ?", array($user->getId()))->fetch();
if ($result) {
$password = new PasswordEntity();
$password->setId($result['id']);
$password->setUser($result['account']);
$password->setPassword($result['password']);
return $password;
}
return null;
}
public function regi()
{
$database = new Database();
$database->query("INSERT INTO users VALUES (Null,'" . $this->Login . "', '" . $this->Password . "', '" . $this->Email . "', now(),now(),'unblock')");
$database->bind(':Id', Null);
$database->bind(':Login', $this->Login);
$database->bind(':Password', $this->Password);
$database->bind(':Email', $this->Email);
$database->bind(':blockunblock', 'unblock');
$database->execute();
//$query = "INSERT INTO users VALUES (Null,'".$this->Login."', '".$this->Password."', '".$this->Email."', now(),now(),'unblock')";
return $query;
}
public function CountNotificationProcess($param)
{
parent::query('SELECT COUNT(ac_id)
FROM dy_activity
LEFT JOIN dy_post ON ac_to_post_id = po_id
LEFT JOIN dy_member ON ac_member_id = me_id
LEFT JOIN dy_comment ON ac_to_comment_id = cm_id
WHERE (ac_action = "new_comment" OR ac_action = "thanks_post") AND (po_member_id = :member_id) AND (ac_member_id != :member_id) AND (ac_status = "unread")');
parent::bind(':member_id', $param['member_id']);
parent::execute();
$data = parent::single();
return $data['COUNT(ac_id)'];
}
/**
* @return boolean Returns true when successful.
*/
private static function text($connection, $type, $function, $line, $text = '')
{
// Check dependencies
Validator::required(isset($connection, $type, $function, $line, $text), __METHOD__);
// Get time
$sysstamp = time();
// Save in database
$query = Database::prepare($connection, "INSERT INTO ? (time, type, function, line, text) VALUES ('?', '?', '?', '?', '?')", array(LYCHEE_TABLE_LOG, $sysstamp, $type, $function, $line, $text));
$result = Database::execute($connection, $query, null, null);
if ($result === false) {
return false;
}
return true;
}
static function findByUsername($username)
{
$database = new Database();
$query = 'SELECT * FORM User WHERE UserName = :un';
$varMap = array(':un' => $username);
$result = $database->execute($query, $varMap);
if (count($result) > 1) {
throw new Exception("Multiple username: {$username} found!");
} else {
if (count($result) == 1) {
return $result[0];
}
}
return false;
}