Teste Prático

Question 1

ActiveRecord\Config::initialize(function($cfg)
{
$cfg->set_model_directory(‘./models’);
$cfg->set_connections(
array(
‘development’ => ‘mysql://root@localhost/______’,
)
);
});

Answer 1

Nome da base de dados

Question 2

Criar o modelo

Answer 2

class Book extends \ActiveRecord\Model
{

}

Question 3

Criar as validações

Answer 3

• validates_presence_of
• validates_size_of/validates_length_of
• validates_(in|ex)clusion_of
• validates_format_of
• validates_numericality_of
• validates_uniqueness_of
• validate *custom

Question 4

validates_presence_of

Answer 4

static $validates_presence_of = array(
array(‘title’),
array(‘cover_blurb’, ‘message’ => ‘must be present and witty’)
);

Question 5

validates_size_of/validates_length_of

Answer 5

static $validates_size_of = array(
array(‘title’, ‘within’ => array(1,5), ‘too_short’ => ‘too short!’),
array(‘cover_blurb’, ‘is’ => 20),
array(‘description’, ‘maximum’ => 10, ‘too_long’ => ‘should be short and sweet’)
);

Question 6

validates_(in|ex)clusion_of

Answer 6

static $validates_inclusion_of = array(
array(‘fuel_type’, ‘in’ => array(‘petroleum’, ‘hydrogen’, ‘electric’)),
);

static $validates_exclusion_of = array(
array(‘password’, ‘in’ => array(‘god’, ‘sex’, ‘password’, ‘love’, ‘secret’),
‘message’ => ‘should not be one of the four most used passwords’)
);

Question 7

validates_format_of

Answer 7

static $validates_format_of = array(
array(‘email’, ‘with’ =>’/^[^0-9][A-z0-9]+([.][A-z0-9]+)[@][A-z0-9]+([.][A-z0-9]+)[.][A-z]{2,4}$/’)
array(‘password’, ‘with’ =>’/^.(?=.{8,})(?=.\d)(?=.[a-z])(?=.[A-Z]).*$/’, ‘message’ => ‘is too weak’)
);

Question 8

validates_numericality_of

Answer 8

static $validates_numericality_of = array(
array(‘price’, ‘greater_than’ => 0.01),
array(‘quantity’, ‘only_integer’ => true),
array(‘shipping’, ‘greater_than_or_equal_to’ => 0),
array(‘discount’, ‘less_than_or_equal_to’ => 5, ‘greater_than_or_equal_to’ => 0)
);

Question 9

validates_uniqueness_of

Answer 9

static $validates_uniqueness_of = array(
array(‘name’),
array(array(‘blah’,’bleh’), ‘message’ => ‘blah and bleh!’)
);

Question 10

validate (custom)

Answer 10

public function validate()
{
if ($this->first_name == $this->last_name)
{
$this->errors->add(‘first_name’, “can’t be the same as Last Name”);
$this->errors->add(‘last_name’, “can’t be the same as First Name”);
}
}

Question 11

Métodos CRUD simples

Answer 11

index(), show($id), create(), store(), edit($id), update($id) e delete($id)

Question 12

public function index()
{
$books = Book::all();
//mostrar a vista index passando os dados por parâmetro
}

Answer 12

$this->renderView(‘book’,’index’, [‘books’ => $books]);

Question 13

public function show($id)
{
$book = Book::find($id);
if (is_null($book)) {
//TODO redirect to standard error page
} else {
//mostrar a vista show passando os dados por parâmetro
}
}

Answer 13

$this->renderView(‘book’,’show’, [‘book’ => $book]);

Question 14

public function create()
{
//mostrar a vista create
}

Answer 14

$this->renderView(‘book’,’create’);

Question 15

public function store()
{
$book = new Book($this-> getHTTPPost());
if($book->is_valid()){
$book->save();
//redirecionar para o index
} else {
//mostrar vista create passando o modelo como parâmetro
}
}

Answer 15

$this->redirectToRoute(‘book’,’index’);

$this->renderView(‘book’,’create’, [‘book’ => $book]);

Question 16

public function edit($id)
{
$book = Book::find($id);
if (is_null($book)) {
//TODO redirect to standard error page
} else {
//mostrar a vista edit passando os dados por parâmetro
}
}

Answer 16

$this->renderView(‘book’, ‘edit’, [‘book’ => $book]);

Question 17

public function update($id)
{
$book = Book::find($id);
$book->update_attributes($this-> getHTTPPost());
if($book->is_valid()){
$book->save();
//redirecionar para o index
} else {
//mostrar vista edit passando o modelo como parâmetro
}
}

Answer 17

$this->redirectToRoute(‘book’,’index’);

$this->renderView(‘book’,’edit’, [‘book’ => $book]);

Question 18

public function delete($id)
{
$book = Book::find($id);
$book->delete();
//redirecionar para o index
}

Answer 18

$this->redirectToRoute(‘book’,’index’);

Question 19

Vista Create Simples
__________
__________________
<input></input>
<?php if(isset($book->errors)){ echo $book->errors->on(‘name’); }?>
_____

Answer 19

<div>
<label>Nome:</label>

</div>

Question 20

Vista Edit Simples
__________
__________________
<input></input>
<?php if (isset($book->errors)) { echo $book->errors->on(‘name’); } ?>

_____

Answer 20

<div>
<label>Nome:</label>

</div>

Question 21

Relacionamentos

Answer 21

static $belongs_to = array(
array(‘book’)
);

static $has_many = array(
array(‘chapters’)
);

Question 22

Vista Create com Relacionamentos

Answer 22

<label>Genre:</label><br></br>
<select>
<?php foreach($genres as $genre){?>
<option> <?= $genre->name; ?></option>
<?php } ?>
</select>

Question 23

Vista Edit com Relacionamentos

Answer 23

<label>Genre:</label><br></br>
<select>
<?php foreach($genres as $genre){?>
<?php if($genre->id == $book->genre_id) { ?>
<option><?= $genre->name;
?> </option>
<?php }else { ?>
<option> <?= $genre->name;
?></option>
<?php }
} ?>
</select>

Question 24

Método Index com Relacionamentos

Answer 24

public function index($id){
$book = Book::find($id);
$chapters = $book->chapters;
$this->renderView(‘chapter’, ‘index’, [‘chapters’ =>
$chapters]);
}

Question 25

Vista Create Com Relacionamentos passar id

Answer 25

<input></input>

Question 26

Método Store com Relacionamentos

Answer 26

public function store(){
$chapter = new Chapter($this-> getHTTPPost());
if($chapter->is_valid()){
$chapter->save();
$this->redirectToRoute(‘chapter’,’index’,[‘id’=>$chapter->book_id]);
} else {
$this->renderView(‘chapter’, ‘create’, [‘chapter’=>$chapter]);
}
}

Question 27

Método Create com Relacionamentos

Answer 27

public function create($id)
{
$book = Book::find($id);
$this->renderView(‘chapter’, ‘create’, [‘book’ => $book]);
}

Question 28

Metodo Show com Relacionamentos

Answer 28

public function show($id)
{
$chapter = Chapter::find($id);
if (is_null($chapter)) {
//TODO redirect to standard error page
} else {
$book_id = $chapter->book_id;
$book = Book::find($book_id);
// Show the “show” view and pass the data as parameters
$this->renderView(‘chapter’, ‘show’, [‘book’ => $book, ‘chapter’ => $chapter, ‘book_id’ => $book_id]);
}
}

Question 29

Método Edit com Relacionamentos

Answer 29

public function edit($id)
{
$chapter = Chapter::find($id);

    if (is_null($chapter)) {
        //TODO redirect to standard error page
    } else {
        $this->renderView('chapter', 'edit', ['chapter' => $chapter]);
    }
}

Question 30

Método Update com Relacionamentos

Answer 30

public function update($id)
{
$chapter = Chapter::find($id);
$chapter->update_attributes($this->getHTTPPost());
if ($chapter->is_valid()) {
$chapter->save();
$this->redirectToRoute(‘chapter’, ‘index’, [‘id’ => $chapter->book_id]);
} else {
$this->renderView(‘chapter’, ‘edit’, [‘chapter’ => $chapter]);
}
}

Question 31

Método Delete com Relacionamentos

Answer 31

public function delete($id)
{
$chapter = Chapter::find($id);
$book_id = $chapter->book_id;
$chapter->delete();
$this->redirectToRoute(‘chapter’, ‘index’, [‘id’ => $book_id]);
}