}
}
//Create a class representation of the table "Articles"
class Articles extends \EntityPHP\Entity
{
protected $title;
protected $content;
protected $author;
//__structure() method is mandatory and must return an array
public static function __structure()
{
return array('title' => 'VARCHAR(255)', 'content' => 'TEXT', 'author' => 'Authors');
}
}
//Init connection to the database
\EntityPHP\Core::connectToDB('localhost', 'entityphp', '3n7i7iPHP', 'entityphp');
//Generate the database (this method should be execute only once)
\EntityPHP\Core::generateDatabase();
//Create a new author
$author = new Authors(array('firstname' => 'Jean', 'lastname' => 'Peplu'));
//And store it to our table!
Authors::add($author);
//Create a new article
$article = new Articles(array('title' => 'It should work!', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.
Ab assumenda dicta doloribus eaque earum, ex inventore libero
odio perferendis possimus quaerat quidem quo ullam?', 'author' => $author));
//And store it to our table!
Articles::add($article);
//Create a second article
$article = new Articles(array('title' => 'It should work again!', 'content' => 'Ex inventore libero odio perferendis possimus quaerat quidem quo ullam?
Lorem ipsum dolor sit amet, consectetur adipisicing elit.
<?php
// Require framework core
require_once '../../system/Core.class.php';
// Init core
\Eliya\Core::init();
// Init DB
require_once '../vendors/EntityPHP/src/EntityPHP.php';
$sql = \Eliya\Config('main')->SQL;
\EntityPHP\Core::connectToDB($sql['HOST'], $sql['USER'], $sql['PASSWORD'], $sql['DATABASE']);
// Include all models files
\Eliya\Core::requireDirContent('../models');
// Generate the dabatase based on our models
\EntityPHP\Core::generateDatabase();
Model_Categories::add(new Model_Categories('Billet d\'humeur'));
Model_Categories::add(new Model_Categories('Quoi d\'neuf Mario ?'));
Model_Categories::add(new Model_Categories('Analyse de personnage'));
Model_Categories::add(new Model_Categories('L\'entreprise Nintendo'));
Model_Categories::add(new Model_Categories('Découverte de jeu'));
Model_Categories::add(new Model_Categories('Anthologie musicale'));
Model_Categories::add(new Model_Categories('Produits dérivés'));
Model_Groups::add(new Model_Groups(['group_name' => 'Anonymes', 'can_manage_categories' => 0, 'can_manage_users' => 0, 'can_write_articles' => 0, 'can_edit_other_articles' => 0, 'can_publish_other_articles' => 0, 'can_read_unpublished_articles' => 0]));
$group_redactors = Model_Groups::add(new Model_Groups(['group_name' => 'Rédacteurs', 'can_manage_categories' => 0, 'can_manage_users' => 0, 'can_write_articles' => 1, 'can_edit_other_articles' => 0, 'can_publish_other_articles' => 0, 'can_read_unpublished_articles' => 0]));
Model_Groups::add(new Model_Groups(['group_name' => 'Rédacteurs en chef', 'can_manage_categories' => 1, 'can_manage_users' => 0, 'can_write_articles' => 1, 'can_edit_other_articles' => 0, 'can_publish_other_articles' => 1, 'can_read_unpublished_articles' => 1]));
$group_admin = Model_Groups::add(new Model_Groups(['group_name' => 'Admins', 'can_manage_categories' => 1, 'can_manage_users' => 1, 'can_write_articles' => 1, 'can_edit_other_articles' => 1, 'can_publish_other_articles' => 1, 'can_read_unpublished_articles' => 1]));
