/** * Add an article */ public function addArticleAction($content, $languageId) { $row = Lazer::table('article'); $row->language_id = $languageId; $row->content = $content; $row->save(); }
/** * Process query with joined data * @param object $row One row of data * @return Database */ protected function join($row) { $keys['local'] = $this->keys['local']; $keys['foreign'] = $this->keys['foreign']; if ($this->relationType == 'hasAndBelongsToMany') { $join = Database::table($this->getJunction())->groupBy($this->tables['local'] . '_id')->where($this->tables['local'] . '_id', '=', $row->{$keys['local']})->findAll()->asArray(null, $this->tables['foreign'] . '_id'); if (empty($join)) { return array(); } return Database::table($this->tables['foreign'])->where($keys['foreign'], 'IN', $join[$row->{$keys['local']}]); } return Database::table($this->tables['foreign'])->where($keys['foreign'], '=', $row->{$keys['local']}); }
function installDB() { //install users try { \Lazer\Classes\Helpers\Validate::table('users')->exists(); } catch (\Lazer\Classes\LazerException $e) { //Database doesn't exist Lazer::create('users', array('userid' => 'string', 'name' => 'string', 'email' => 'string', 'pass' => 'string', 'role' => 'string')); $users = json_decode(file_get_contents('../users.json')); if ($users != null && count($users) > 0) { $user = Lazer::table('users'); foreach ($users as $jsonUser) { $user->userid = $this->getGUID(); $user->name = $jsonUser->name; $user->email = $jsonUser->email; $user->pass = $this->randomPassword(); $user->role = isset($jsonUser->role) ? $jsonUser->role : 'user'; $user->save(); } } } //install categories try { \Lazer\Classes\Helpers\Validate::table('categories')->exists(); } catch (\Lazer\Classes\LazerException $e) { //Database doesn't exist Lazer::create('categories', array('categoryid' => 'string', 'label' => 'string')); $category = Lazer::table('categories'); $category->categoryid = "travels"; $category->label = 'Travels'; $category->save(); $category->categoryid = "most_creative"; $category->label = 'Most creative'; $category->save(); $category->categoryid = "funniest"; $category->label = 'Funiest'; $category->save(); $category->categoryid = "40"; $category->label = '40'; $category->save(); } //install photos try { \Lazer\Classes\Helpers\Validate::table('photos')->exists(); } catch (\Lazer\Classes\LazerException $e) { //Database doesn't exist Lazer::create('photos', array('photoid' => 'string', 'userid' => 'string', 'filepath' => 'string', 'status' => 'string')); } //install rates try { \Lazer\Classes\Helpers\Validate::table('rates')->exists(); } catch (\Lazer\Classes\LazerException $e) { //Database doesn't exist Lazer::create('rates', array('photoid' => 'string', 'userid' => 'string', 'categoryid' => 'string', 'rate' => 'string')); } }
public function delete() { try { $subject = Lazer::table($this->_table)->find($this->id)->delete(); return true; } catch (LazerException $e) { return false; } return false; }