public function testFirst()
{
$post = Post::first();
$debug = last(DB::getQueryLog());
$this->assertEquals('Bar', $post->title);
$this->assertEquals('select * from "posts" where "published" = ? and "status" = ? limit 1', $debug['query']);
}
public function run()
{
DB::table('comments')->delete();
$user_id = User::first()->id;
$post_id = Post::first()->id;
DB::table('comments')->insert(array(array('user_id' => $user_id, 'post_id' => $post_id, 'content' => $this->content1, 'created_at' => new DateTime(), 'updated_at' => new DateTime()), array('user_id' => $user_id, 'post_id' => $post_id, 'content' => $this->content2, 'created_at' => new DateTime(), 'updated_at' => new DateTime()), array('user_id' => $user_id, 'post_id' => $post_id, 'content' => $this->content3, 'created_at' => new DateTime(), 'updated_at' => new DateTime()), array('user_id' => $user_id, 'post_id' => $post_id + 1, 'content' => $this->content1, 'created_at' => new DateTime(), 'updated_at' => new DateTime()), array('user_id' => $user_id, 'post_id' => $post_id + 1, 'content' => $this->content2, 'created_at' => new DateTime(), 'updated_at' => new DateTime()), array('user_id' => $user_id, 'post_id' => $post_id + 2, 'content' => $this->content1, 'created_at' => new DateTime(), 'updated_at' => new DateTime())));
}
public function run()
{
DB::table('comments')->delete();
$user_id = User::first()->id;
$post_id = Post::first()->id;
DB::table('comments')->insert(array(array('user_id' => $user_id, 'post_id' => $post_id, 'content' => $this->content1), array('user_id' => $user_id, 'post_id' => $post_id, 'content' => $this->content2), array('user_id' => $user_id, 'post_id' => $post_id, 'content' => $this->content3), array('user_id' => $user_id, 'post_id' => $post_id + 1, 'content' => $this->content1), array('user_id' => $user_id, 'post_id' => $post_id + 1, 'content' => $this->content2), array('user_id' => $user_id, 'post_id' => $post_id + 2, 'content' => $this->content1)));
}
public function indexAction($sub)
{
App::setLocale("en");
if (Input::get("lang") === "nl") {
App::setLocale("nl");
}
return View::make("index/index", ["post" => Post::first()]);
}
public function testSyncInManyToManyRelationship()
{
$post = Post::forceCreate(['title' => 'Post title']);
$tag = Tag::forceCreate(['title' => 'Tag title']);
$post->tags()->sync([$tag->id]);
$this->assertEquals(1, Post::first()->tags->count());
$this->assertEquals('Tag title', Post::first()->tags()->first()->title);
}
public function myaccount($s = "user")
{
$view = $this->getActionView();
if (RequestMethods::post('delete')) {
$del = Post::first(array('id = ?' => RequestMethods::post('id')));
$del->delete();
}
if (RequestMethods::post('block')) {
$block = User::first(array("id = ?" => RequestMethods::post('id')));
$block->live = 0;
$block->save();
}
if (RequestMethods::post('unblock')) {
$block = User::first(array("id = ?" => RequestMethods::post('id')));
$block->live = 1;
$block->save();
}
if (isset($this->_user)) {
$admin = User::first(array("admin = ?" => '1', "id = ?" => $this->user->id));
if (!empty($admin)) {
if ($s != 'post') {
$admin_table = $s::all();
}
if ($s == 'post') {
$database = Registry::get("database");
$conn = $database->initialize();
$admin_table = $conn->query()->from('posts')->join("users", "posts.from_user = users.id")->all();
}
$view->set("admin_table", $admin_table);
} else {
$posts = Post::all(array("from_user = ?" => $this->user->id));
$view->set("posts", $posts);
}
$view->set("admin", $admin)->set('table', $s);
}
}
/**
* Test Non static call for findBySlug is working
*
* @test
*/
public function testNonStaticCallOfFindBySlug()
{
$post1 = $this->makePost('My first post');
$post1->save();
$post = Post::first();
$resultId = $post->findBySlug('my-first-post')->id;
$this->assertEquals($post1->id, $resultId);
}
public function testDeleteWithoutTranslations()
{
Post::forceCreate(['title' => 'Title']);
Post::i18nQuery()->truncate();
$post = Post::first();
$post->delete();
$this->assertCount(0, Post::all());
}
/** @test **/
public function it_fetches_the_cover_associated_with_the_post()
{
$this->createComponent('posts');
$this->createComponent('cover_photos');
$this->insertOn('posts', ['title' => 'Random Blog Post']);
$this->insertOn('cover_photos', ['image' => '/path/to/image.jpg']);
Post::usesOne(CoverPhoto::class);
CoverPhoto::first()->registerTo(Post::first());
$cover = Post::first()->cover_photo;
$this->assertEquals('/path/to/image.jpg', $cover->image);
}
<?php /** * Copyright (c) 2014 Keith Casey. * * This code is designed to accompany the lynda.com video course "Design Patterns in PHP" * by Keith Casey. If you've received this code without seeing the videos, go watch the * videos. It will make way more sense and be more useful in general. */ include_once __DIR__ . '/vendor/autoload.php'; include_once 'posts.php'; echo "<pre style='color:#59E817; background-color:black; word-wrap:break-word;'>"; var_dump(Post::first()); echo '</pre>'; // $post = new Post(); // // $post->title = 'Sample Title'; // $post->body = 'This is the body'; // // $post->save();
public function testBootMethodAgainAndAgain()
{
Post::create(['comments_count' => 2]);
$this->assertEquals(1, Post::count());
$this->assertEquals(6, Post::first()->comments_count);
}
