PHP DB::shouldReceive方法代碼示例

 public function testconnect()
 {
     $table = "test";
     DB::shouldReceive('table')->once()->andReturn(Mockery::mock(['insert' => true]));
     $result = $this->database->connect($table);
     $this->assertInstanceOf('Sharad\\Systeminfo\\SqlDatabase', $result);
 }

 /**
  * @test
  **/
 public function canStartForeignKeysCheckIfSupported()
 {
     $mock_exec = m::mock('StdClass')->shouldReceive('exec')->once()->with('SET FOREIGN_KEY_CHECKS=1;')->getMock();
     $mock_getPdo = m::mock('StdClass')->shouldReceive('getPdo')->once()->andReturn($mock_exec)->getMock();
     DB::shouldReceive('connection')->once()->andReturn($mock_getPdo);
     DbHelperStub::startForeignKeysCheck();
 }

 public function testMakeAssembly()
 {
     $item = $this->newInventory();
     DB::shouldReceive('beginTransaction')->once()->andReturn(true);
     DB::shouldReceive('commit')->once()->andReturn(true);
     Event::shouldReceive('fire')->once()->andReturn(true);
     $item->makeAssembly();
     $this->assertTrue($item->is_assembly);
 }

 public function testStockMove()
 {
     $stock = $this->newInventoryStock();
     $newLocation = Location::create(['name' => 'New Location']);
     DB::shouldReceive('beginTransaction')->once()->shouldReceive('commit')->once();
     Event::shouldReceive('fire')->once();
     $stock->moveTo($newLocation);
     $this->assertEquals(2, $stock->location_id);
 }

 public function testUpdateCache()
 {
     $comment = new Comment();
     $comment->post_id = 1;
     $comment->syncOriginal();
     $comment->post_id = 2;
     DB::shouldReceive('update')->with('UPDATE `posts` SET `num_comments` = `num_comments` - 1 WHERE `id` = 1')->once();
     DB::shouldReceive('update')->with('UPDATE `posts` SET `num_comments` = `num_comments` + 1 WHERE `id` = 2')->once();
     $this->manager->updateCache($comment);
 }

 public function testInventoryTransactionCheckout()
 {
     $transaction = $this->newTransaction();
     DB::shouldReceive('startTransaction')->once();
     DB::shouldReceive('commit')->once();
     $transaction->checkout(5, 'Checking out', 25);
     $this->assertEquals(5, $transaction->quantity);
     $this->assertEquals(InventoryTransaction::STATE_COMMERCE_CHECKOUT, $transaction->state);
     $stock = $transaction->getStockRecord();
     $this->assertEquals('Checking out', $stock->reason);
     $this->assertEquals(25, $stock->cost);
 }

 public function testHandleCommits()
 {
     $subject = new Middleware();
     $parameter = 'request';
     $response = 'magic beans';
     $callback = function ($request) use($parameter, $response) {
         expect($request)->equals($parameter);
         return $response;
     };
     DB::shouldReceive('beginTransaction')->withNoArgs()->once();
     EventStore::shouldReceive('publishQueue')->withNoArgs()->once();
     DB::shouldReceive('rollBack')->withNoArgs()->never();
     DB::shouldReceive('commit')->withNoArgs()->once();
     expect($subject->handle('request', $callback))->equals($response);
 }

 public function testDown()
 {
     $queryBuilder = m::mock('Illuminate\\Database\\Query\\Builder');
     $queryBuilder->shouldReceive('truncate')->times(4);
     DB::shouldReceive('getDriverName')->andReturn('mysql');
     DB::shouldReceive('statement')->with('SET FOREIGN_KEY_CHECKS=0;')->once();
     DB::shouldReceive('statement')->with('SET FOREIGN_KEY_CHECKS=1;')->once();
     DB::shouldReceive('table')->with('cities')->once()->andReturn($queryBuilder);
     DB::shouldReceive('table')->with('users')->once()->andReturn($queryBuilder);
     DB::shouldReceive('table')->with('countries')->once()->andReturn($queryBuilder);
     DB::shouldReceive('table')->with('logs')->once()->andReturn($queryBuilder);
     $fixtures = new \Mayconbordin\L5Fixtures\Fixtures(['location' => __DIR__ . '/_data']);
     $fixtures->down();
     $this->assertEquals(4, sizeof($fixtures->getFixtures()));
 }

 public function testGetTotalVariantStock()
 {
     $this->newCategory();
     $this->newMetric();
     $coke = Inventory::create(['name' => 'Coke', 'description' => 'Delicious Pop', 'metric_id' => 1, 'category_id' => 1]);
     $cherryCoke = $coke->createVariant('Cherry Coke');
     $cherryCoke->makeVariantOf($coke);
     $vanillaCherryCoke = $cherryCoke->createVariant('Vanilla Cherry Coke');
     $vanillaCherryCoke->makeVariantOf($cherryCoke);
     DB::shouldReceive('beginTransaction')->once()->andReturn(true);
     DB::shouldReceive('commit')->once()->andReturn(true);
     Event::shouldReceive('fire')->once()->andReturn(true);
     $location = $this->newLocation();
     // Allow duplicate movements configuration option
     Config::shouldReceive('get')->twice()->andReturn(true);
     // Stock change reasons (one for create, one for put, for both items)
     Lang::shouldReceive('get')->times(4)->andReturn('Default Reason');
     $cherryCoke->createStockOnLocation(20, $location);
     $vanillaCherryCoke->createStockOnLocation(20, $location);
     $this->assertEquals(40, $coke->getTotalVariantStock());
 }

 public function testFire()
 {
     DB::shouldReceive('statement')->once()->andReturn('foo');
     $cmd = $this->getMockBuilder('Andizzle\\Zapper\\Console\\MigrateCommand')->disableOriginalConstructor()->getMock();
     $cmd->fire();
 }

 function it_can_return_computed_column_type_info()
 {
     Cache::shouldReceive('has')->withAnyArgs()->once()->andReturn(false);
     Cache::shouldReceive('put')->withAnyArgs()->once();
     $type = \Mockery::mock('Doctrine\\DBAL\\Types\\Type');
     $type->shouldReceive('getName')->andReturn('Type');
     $column = \Mockery::mock('Doctrine\\DBAL\\Schema\\Column');
     $column->shouldReceive('getName')->andReturn('Column');
     $column->shouldReceive('getType')->andReturn($type);
     $table = \Mockery::mock('Doctrine\\DBAL\\Schema\\Table');
     $table->shouldReceive('getName')->andReturn('Table');
     $table->shouldReceive('getColumn')->withAnyArgs()->andReturn($column);
     $schemaManager = \Mockery::mock('Doctrine\\DBAL\\Schema\\AbstractSchemaManager');
     DB::shouldReceive('getDoctrineSchemaManager')->once()->andReturn($schemaManager);
     $schemaManager->shouldReceive('listTables')->once()->andReturn(['Table' => $table]);
     $this->getColumnType('Table', 'Column')->shouldBe('Type');
     \Mockery::close();
 }

 /**
  * @test
  * @depends it_runs_the_main_process_steps_in_a_database_transaction
  */
 function it_does_a_rollback_for_main_process_steps_if_an_exception_is_thrown()
 {
     DB::shouldReceive('beginTransaction')->once();
     DB::shouldReceive('rollBack')->once();
     $processor = new TestPipelineProcessor([], null, self::EXCEPTION_IN_MAIN_STEP);
     /** @var DataObjectInterface $data */
     $data = $this->getMockBuilder(DataObjectInterface::class)->getMock();
     try {
         $processor->process($data);
     } catch (\Exception $e) {
         // caught only to let test pass and check rollBack
     }
 }

 public function testExists()
 {
     DB::shouldReceive('table')->with('test')->andReturnSelf();
     DB::shouldReceive('where')->with('id', 1)->andReturnSelf();
     DB::shouldReceive('first')->andReturn($this->model);
     $this->model->shouldReceive('getTable')->once()->andReturn('test');
     $this->model->shouldReceive('getKeyName')->once()->andReturn('id');
     $result = $this->repository->exists(1);
     $this->assertTrue($result);
 }

 public function test_insert()
 {
     DB::shouldReceive('table->insert')->once();
     $repository = new DatabaseExceptionRepository();
     $repository->insert($attributes = ['user_id' => 9, 'critical' => true, 'class' => 'LogicNotFoundException', 'message' => 'This is a logic exception!', 'file' => 'AbstractFactory.php', 'line' => 100, 'trace' => 'trace', 'url' => 'https://watermark.local/asdasd', 'ip' => '24.57.183.293', 'user_agent' => 'user agent string here']);
 }

 public function testDatabaseNeedsInstallFalse()
 {
     DB::shouldReceive('connection')->once()->andReturnSelf()->shouldReceive('getDatabaseName')->once()->andReturn('a_database_name');
     $this->assertFalse($this->installer->databaseNeedsInstall());
 }