deleteFrom() public static method

deleteFrom('table') => "DELETE FROM table"
public static deleteFrom ( string $table ) : WhereRule
$table string
return phprs\ezsql\rules\basic\WhereRule
Sql Class Documentation
Exemplo n.º 1
0
 public function deleteUserByAccount($account)
 {
     $this->db->beginTransaction();
     try {
         $res = Sql::select('uid')->from('uc_members')->where('username=?', $account)->forUpdate()->get($this->db);
         if (count($res) == 0) {
             $this->db->rollBack();
             return false;
         }
         $uid = $res[0]['uid'];
         Sql::deleteFrom('pre_common_member_profile')->where('uid=?', $uid)->exec($this->db);
         Sql::deleteFrom('uc_members')->where('uid=?', $uid)->exec($this->db);
         $this->db->commit();
     } catch (Exception $e) {
         $this->db->rollBack();
         throw $e;
     }
     return true;
 }
Exemplo n.º 2
0
 public function testDelete3()
 {
     // DELETE FROM tab WHERE a=1 ORDER BY b LIMIT 1
     $this->db->setExpected('DELETE FROM tab WHERE a=? ORDER BY b LIMIT 1', 1);
     Sql::deleteFrom('tab')->where('a=?', 1)->orderBy('b')->limit(1)->exec($this->db);
 }