Ejemplo n.º 1
0
 public static function setupRedBeans()
 {
     $config = Config::get();
     if (!isset($config['db']['host'])) {
         throw new Exception('Config[db][host] not set. Check api.conf in project folder.');
     }
     if (!isset($config['db']['db'])) {
         throw new Exception('Config[db][db] not set. Check api.conf in project folder.');
     }
     if (!isset($config['db']['user'])) {
         throw new Exception('Config[db][user] not set. Check api.conf in project folder.');
     }
     if (!isset($config['db']['password'])) {
         throw new Exception('Config[db][password] not set. Check api.conf in project folder.');
     }
     R::setup('mysql:host=' . $config['db']['host'] . ';dbname=' . $config['db']['db'], $config['db']['user'], $config['db']['password'], true);
     R::exec('SET NAMES utf8mb4');
     R::freeze(true);
 }
Ejemplo n.º 2
0
 static function deleteModel($model)
 {
     return R::exec('UPDATE models SET deleted=1 WHERE name = ?', [$model]);
 }
Ejemplo n.º 3
0
<?php

require_once 'models/Answer.php';
use RedBean_Facade as R;
$payload = $app->request()->getBody();
$params = array('userid' => 'userid', 'questionid' => 'questionid', 'answer' => 'answer');
$payload = array_intersect_key($payload, $params);
if (empty($payload['questionid'])) {
    throw new \Exception('questionid is required!', 412);
}
$quetion = R::findOne('question', '`id` = ?', array($payload['questionid']));
if (!$quetion) {
    throw new \Exception('Question not found', 404);
}
$answer = new Answer($payload, $quetion);
$answer->validateAnswer();
R::exec('INSERT INTO `answer` (`userid`, `questionid`, `answer`) VALUES (:userid, :questionid, :answer)', array(':userid' => $answer->getValue('userid'), ':questionid' => $answer->getValue('questionid'), ':answer' => $answer->getValue('answer')));
$app->result = $answer->getValues();