public function save()
{
$pdo_connection = DB::connection();
$success = true;
//the begin of transaction
$pdo_connection->beginTransaction();
try {
$query = $pdo_connection->prepare("INSERT INTO saalistieto (pvm, kellonaika," . " kalalaji, lkm, pituus, paino, vesisto, paikka, tuulenvoimakkuus," . " tuulensuunta, ilmanlampo, vedenlampo, pilvisyys, huomiot," . " saaliskuva, pyydys) VALUES(:pvm, NULLIF(:aika,'')::time, :laji, :lkm," . " NULLIF(:pituus,'')::numeric, NULLIF(:paino,'')::numeric, :vesisto," . " :paikka, :tuulenVoima, :tuulenSuunta," . " NULLIF(:ilmanLampo,'')::integer, NULLIF(:vedenLampo,'')::integer, :pilvisyys," . " :huomiot, :kuva, NULLIF(:pyydys,'default')::integer) RETURNING saalisid");
$query->execute(array('pvm' => $this->date, 'aika' => $this->time, 'laji' => $this->species, 'lkm' => $this->count, 'pituus' => $this->length, 'paino' => $this->weight, 'vesisto' => $this->water_sys, 'paikka' => $this->location, 'tuulenVoima' => $this->wind_speed, 'tuulenSuunta' => $this->wind_dir, 'ilmanLampo' => $this->air_temp, 'vedenLampo' => $this->water_temp, 'pilvisyys' => $this->cloudiness, 'huomiot' => $this->notes, 'kuva' => $this->picture_url, 'pyydys' => $this->trap_id));
$resultRow = $query->fetch();
$this->catch_id = $resultRow['saalisid'];
$catchers;
$username = array($_SESSION['user']);
if (isset($this->friends)) {
$catchers = array_merge($username, $this->friends);
} else {
$catchers = $username;
}
$query_2 = $pdo_connection->prepare("INSERT INTO pyydystaja VALUES(" . ":kalastaja, :saalisid)");
foreach ($catchers as $catcher) {
$query_2->execute(array('kalastaja' => $catcher, 'saalisid' => $this->catch_id));
}
} catch (PDOException $e) {
$success = false;
Kint::dump($e);
Kint::trace();
}
//end of transaction
if (!$success) {
$pdo_connection->rollBack();
} else {
$pdo_connection->commit();
}
}
public function save()
{
$query = DB::connection()->prepare('INSERT INTO Hero (name, primaryattribute, attacktype, primaryrole, damagetype, description) VALUES(:name, :primaryattribute, :attacktype, :primaryrole, :damagetype, :description) RETURNING id');
$query->execute(array('name' => $this->name, 'primaryattribute' => $this->primaryattribute, 'attacktype' => $this->attacktype, 'primaryrole' => $this->primaryrole, 'damagetype' => $this->damagetype, 'description' => $this->description));
$row = $query->fetch();
Kint::trace();
Kint::dump($row);
}
public function save()
{
$query = DB::connection()->prepare('INSERT INTO Aanestys (nimi, aanestysalkaa, aanestysloppuu, kuvaus, onkoid, luojaid) VALUES (:nimi, :aanestysalkaa, :aanestysloppuu, :kuvaus, :onkoid, :luojaid) RETURNING id');
$query->execute(array('nimi' => $this->nimi, 'aanestysalkaa' => $this->aanestysalkaa, 'aanestysloppuu' => $this->aanestysloppuu, 'kuvaus' => $this->kuvaus, 'onkoid' => $this->onkoid, 'luojaid' => $this->luojaid));
$row = $query->fetch();
$this->id = $row['id'];
Kint::trace();
Kint::dump($row);
}
/** Prints stack trace if in developer mode or force flag set
*
* @param bool $force Force dumping?
*
* @return mixed Returns true if trace printed successfully, false otherwise.
*/
public function trace($force = false)
{
if ($force or $this->developerMode) {
Kint::trace();
return true;
} else {
return false;
}
}
public function update()
{
$query = DB::connection()->prepare('UPDATE Requests (name, description, hashtags) VALUES (:name, :start_date, :end_date, :description, :hashtags) RETURNING id');
$query->execute(array('name' => $this->name, 'description' => $this->description, 'hashtags' => $this->hashtags));
$row = $query->fetch();
Kint::trace();
Kint::dump($row);
$this->id = $row['id'];
}
public function update()
{
// JUPDATE:ssa joku vika??
$query = DB::connection()->prepare('INSERT INTO Waybill (customer_id, receiver_id, arrived) VALUES ( :customer_id, :receiver_id, :arrived) RETURNING id');
$query->execute(array('customer_id' => $this->customer_id, 'receiver_id' => $this->receiver_id, 'arrived' => $this->arrived, 'id' => $this->id));
$row = $query->fetch();
Kint::trace();
Kint::dump($row);
$this->id = $row['id'];
}
public function save()
{
$query = DB::connection()->prepare('INSERT INTO Task (description, status, created, person, priority, projectids) VALUES (:description, :status, :created, :person, :priority, :projectids) RETURNING id');
// Get the id of the row via RETURNING id
$query->execute(array('description' => $this->description, 'status' => $this->status, 'created' => date("Y-m-d"), 'person' => $_SESSION['user'], 'priority' => $this->priority, 'projectids' => implode(",", $this->projectids)));
$row = $query->fetch();
// fetch the row so we get the id
Kint::trace();
Kint::dump($row);
// row is false if nothing comes back from db, perhaps from wrong input type
$this->id = $row['id'];
// commented out for debugging
}
public function save()
{
// Lisätään RETURNING id tietokantakyselymme loppuun, niin saamme lisätyn rivin id-sarakkeen arvon
$query = DB::connection()->prepare('INSERT INTO Resepti (reseptin_nimi, annokset, valmisteluaika, kypsymisaika, uunin_asteet, valmistusohje, laatija) VALUES (:reseptin_nimi, :annokset, :valmisteluaika, :kypsymisaika, :uunin_asteet, :valmistusohje, :laatija) RETURNING id');
// Muistathan, että olion attribuuttiin pääse syntaksilla $this->attribuutin_nimi
$query->execute(array('reseptin_nimi' => $this->reseptin_nimi, 'annokset' => $this->annokset, 'valmisteluaika' => $this->valmisteluaika, 'kypsymisaika' => $this->kypsymisaika, 'uunin_asteet' => $this->uunin_asteet, 'valmistusohje' => $this->valmistusohje, 'laatija' => $this->laatija));
// Haetaan kyselyn tuottama rivi, joka sisältää lisätyn rivin id-sarakkeen arvon
$row = $query->fetch();
Kint::trace();
Kint::dump($row);
// Asetetaan lisätyn rivin id-sarakkeen arvo oliomme id-attribuutin arvoksi
// Kint::trace();
// Kint::dump($row);
$this->id = $row['id'];
}
/**
* Dummy method that triggers trace
*/
public function ensure()
{
Kint::trace();
}
public static function kintException($oException)
{
\Kint::dump($oException);
\Kint::trace($oException->getTrace());
}
/**
* Errors handler.
*
* @author Krzysztof Trzos
* @param integer $errno
* @param string $errstr
* @param string $errfile
* @param integer $errline
* @param array $errcontext
* @throws Exception\Fatal
* @since 1.0.0-alpha
* @version 1.0.0-alpha
*/
function error_handler($errno, $errstr, $errfile = '', $errline = 0, $errcontext = [])
{
$iLevel = ob_get_level();
for ($i = 1; $i < $iLevel; $i++) {
ob_get_clean();
}
if (Core::getAppMode() == Core::MODE_DEVELOPMENT) {
\Kint::trace();
ddd($errno, $errstr, $errfile, $errline, $errcontext);
} else {
try {
throw new Exception\Fatal();
} catch (Exception $e) {
$e->handler();
}
}
}
public static function logout()
{
Kint::trace();
$_SESSION['user'] = null;
Redirect::to('/login', array('message' => 'Olet kirjautunut ulos!'));
}
