/** * The homepage expects widgets having IDs 1, 2, 3, and 4 to exist, as it uses these * as "sample widgets". */ protected function createHomepageWidgets() { for ($id = 1; $id <= 4; $id++) { $w = getWidget(); DB\query("UPDATE widgets SET id = ? WHERE id = ?", array($id, $w->id)); } }
function setUp() { parent::setUp(); $this->loginAsNormalUser(); # Clear out the address-balance cache to assert a "new" address doesn't cause breakage... DB\query("DELETE FROM bitcoin_addresses WHERE address = ?", array($this->btcAddr())); }
function withLock($bitcoinAddr, \Closure $action) { $lockName = "bitcoin-address-{$bitcoinAddr}"; $r = DB\queryAndFetchAll("SELECT GET_LOCK('{$lockName}', 0)"); if ($r[0][0] == 1) { $action(); DB\query("SELECT RELEASE_LOCK('{$lockName}')"); return true; } else { return false; } }
public function updatePassword($encryptedPass) { DB\query('UPDATE users SET password = ? WHERE id = ?', array($encryptedPass, $this->id)); $this->passwordEncrypted = $encryptedPass; }
private function updateEndingDate(Widget $w, DateTime $dt) { DB\query("UPDATE widgets SET ending = ? WHERE id = ?", array($dt, $w->id)); }