/** * assembles the table from the schema and provides it to PHPUnit * * @return PHPUnit_Extensions_Database_DataSet_QueryDataSet assembled schema for PHPUnit **/ public final function getDataSet() { $dataset = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); // add all the tables for the project here // THESE TABLES *MUST* BE LISTED IN THE SAME ORDER THEY WERE CREATED!!!! $dataset->addTable("profile"); $dataset->addTable("tweet"); $dataset->addTable("favorite"); return $dataset; }
/** * assembles the table from the schema and provides it to PHPUnit * * @return PHPUnit_Extensions_Database_DataSet_QueryDataSet assembled schema for PHPUnit **/ public final function getDataSet() { $dataset = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); // add all the tables for the project here // THESE TABLES *MUST* BE LISTED IN THE SAME ORDER THEY WERE CREATED!!!! $dataset->addTable("organization"); $dataset->addTable("volunteer"); //$dataset->addTable("administrator"); $dataset->addTable("listingType"); $dataset->addTable("listing"); $dataset->addTable("message"); return $dataset; }
public function setUp() { $this->pdo = DBUnitTestUtility::getSQLiteMemoryDB(); parent::setUp(); $this->dataSet = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); $this->dataSet->addTable('table1'); $this->dataSet->addTable('query1', ' SELECT t1.column1 tc1, t2.column5 tc2 FROM table1 t1 JOIN table2 t2 ON t1.table1_id = t2.table2_id '); }
public function createQueryDataset($tables) { $ds = new \PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); foreach ($tables as $table => $query) { $ds->addTable($table, $query); } return $ds; }
public function test_cur() { $userMapper = new userMapper($this->db); $s1 = new current_student(); $s1->setId(800895555); $userMapper->insert($s1); $this->assertEquals(1, $this->getConncetion()->getRowCount('id')); $expected = $this->createFlatDataSet(__DIR__ . '/db_insertData.xml'); $actual = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); $actual->addTable('current_student'); $this->assertDataSetsEqual($expected, $actual); }
public function testDeleteItems() { $model = $this->_getModel(); $model->deleteItems(1); $dataSet = new \PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); foreach (static::$_tables as $table) { if ($table == 'ClientsAndGroups' or $table == 'DuplicateMacAddresses' or $table == 'SoftwareDefinitions') { continue; } $table = static::$serviceManager->get("Database\\Table\\{$table}")->table; $dataSet->addTable($table, "SELECT hardware_id FROM {$table}"); } $this->assertDataSetsEqual($this->_loadDataSet('DeleteItems'), $dataSet); }
public final function getDataSet() { $dataset = new \PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); //Add all the tables for the project here $dataset->addTable("profile"); $dataset->addTable("image"); $dataset->addTable("tag"); $dataset->addTable("comment"); $dataset->addTable("vote"); $dataset->addTable("imageTag"); $dataset->addTable("follower"); return $dataset; }
/** * Test the Joomla\Log\Logger\Database::addEntry method. * * @return void * * @since 1.0 */ public function testAddEntry01() { $config = array('db' => self::$driver); $logger = new Database($config); // Get the expected database from XML. $expected = $this->createXMLDataSet(__DIR__ . '/stubs/S01E01.xml'); // Add the new entries to the database. $logger->addEntry(new LogEntry('Testing Entry 02', Log::INFO, null, '2009-12-01 12:30:00')); $logger->addEntry(new LogEntry('Testing3', Log::EMERGENCY, 'deprecated', '2010-12-01 02:30:00')); // Get the actual dataset from the database. $actual = new \PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); $actual->addTable('jos_log_entries'); // Verify that the data sets are equal. $this->assertDataSetsEqual($expected, $actual); }
/** * assembles the table from the schema and provides it to PHPUnit * * @return \PHPUnit_Extensions_Database_DataSet_QueryDataSet assembled schema for PHPUnit **/ public final function getDataSet() { $dataset = new \PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); //add all the tables for the project here //THESE TABLES *MUST* BE LISTED IN THE SAME ORDER THEY WERE CREATED! $dataset->addTable("company"); $dataset->addTable("crew"); $dataset->addTable("access"); $dataset->addTable("user"); $dataset->addTable("schedule"); $dataset->addTable("request"); $dataset->addTable("shift"); return $dataset; }
/** * Test the JLoggerDatabase::addEntry method. */ public function testAddEntry02() { // Setup the logger. $config = array('db_driver' => 'sqlite', 'db_database' => ':memory:', 'db_prefix' => 'jos_'); $logger = new JLoggerDatabase($config); TestReflection::setValue($logger, 'dbo', JFactory::$database); // Get the expected database from XML. $expected = $this->createXMLDataSet(__DIR__ . '/stubs/database/S01E01.xml'); // Add the new entries to the database. $logger->addEntry(new JLogEntry('Testing Entry 02', JLog::INFO, null, '2009-12-01 12:30:00')); $logger->addEntry(new JLogEntry('Testing3', JLog::EMERGENCY, 'deprecated', '2010-12-01 02:30:00')); // Get the actual dataset from the database. $actual = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); $actual->addTable('jos_log_entries'); // Verify that the data sets are equal. $this->assertDataSetsEqual($expected, $actual); }
/** * assembles the table from the schema and provides it to PHPUnit * * @return PHPUnit_Extensions_Database_DataSet_QueryDataSet assembled schema for PHPUnit **/ public final function getDataSet() { $dataset = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); // add all the tables for the project here // THESE TABLES *MUST* BE LISTED IN THE SAME ORDER THEY WERE CREATED!!!! $dataset->addTable("segment"); $dataset->addTable("user"); $dataset->addTable("trail"); $dataset->addTable("comment"); $dataset->addTable("rating"); $dataset->addTable("trailRelationship"); return $dataset; }
/** * Test the JLoggerDatabase::addEntry method. */ public function testAddEntry02() { // Setup the basic configuration. @(include_once JPATH_TESTS . '/config.php'); if (class_exists('JTestConfig')) { $config = new JTestConfig(); } // Setup the basic configuration. $config = array('db_driver' => $config->dbtype, 'db_host' => $config->host, 'db_user' => $config->user, 'db_pass' => $config->password, 'db_database' => $config->db, 'db_prefix' => $config->dbprefix); $logger = new JLoggerDatabaseInspector($config); // Get the expected database from XML. $expected = $this->createXMLDataSet(__DIR__ . '/stubs/database/S01E01.xml'); // Add the new entries to the database. $logger->addEntry(new JLogEntry('Testing Entry 02', JLog::INFO, null, '2009-12-01 12:30:00')); $logger->addEntry(new JLogEntry('Testing3', JLog::EMERGENCY, 'deprecated', '2010-12-01 02:30:00')); // Get the actual dataset from the database. $actual = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); $actual->addTable('jos_log_entries'); // Verify that the data sets are equal. $this->assertDataSetsEqual($expected, $actual); }
/** * assembles the table from the schema and provides it to PHPUnit * * @return PHPUnit_Extensions_Database_DataSet_QueryDataSet assembled schema for PHPUnit **/ public final function getDataSet() { $dataset = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); // add all the tables for the project here // THESE TABLES *MUST* BE LISTED IN THE SAME ORDER THEY WERE CREATED!!!! $dataset->addTable("user"); $dataset->addTable("unitOfMeasure"); $dataset->addTable("alertLevel"); $dataset->addTable("vendor"); $dataset->addTable("product"); $dataset->addTable("productAlert"); $dataset->addTable("location"); $dataset->addTable("finishedProduct"); $dataset->addTable("productLocation"); $dataset->addTable("movement"); $dataset->addTable("notification"); return $dataset; }
public function testDataSet() { if ($this->__debug) { echo __METHOD__ . "\n"; } // Assert 1 $dataSet = self::$__conn->createDataSet(['session']); $expected = $this->getDataSet('session'); $this->assertDataSetsEqual($expected, $dataSet); // Assert 2 $dataSet = new PHPUnit_Extensions_Database_DataSet_QueryDataSet(self::$__conn); $dataSet->addTable('session', 'SELECT sess_key FROM session'); $expectedDataSet = $this->getDataSet('special'); $this->assertDataSetsEqual($expectedDataSet, $dataSet); }
/** * @covers ::update */ public function testUpdate() { $carTable = new CarTable($this->pdo); $cars = $carTable->findAll(); $this->assertCount(2, $cars); /** * Alter first car */ $firstCar = $cars[0]; $this->assertFalse($firstCar->isAltered()); $firstCar->set('horsepower', 21); $this->assertTrue($firstCar->isAltered()); $carTable->update($firstCar); /** * Alter second car */ $secondCar = $cars[1]; $this->assertFalse($secondCar->isAltered()); $secondCar->set('horsepower', 41); $this->assertTrue($secondCar->isAltered()); $carTable->update($secondCar); /** * Assert data set */ $expectedCsvDataSet = new \PHPUnit_Extensions_Database_DataSet_CsvDataSet(); $expectedCsvDataSet->addTable('cars', dirname(__FILE__) . '/../Fixture/cars_after-update.csv'); $expectedDataSet = new \PHPUnit_Extensions_Database_DataSet_DataSetFilter($expectedCsvDataSet); $expectedDataSet->setExcludeColumnsForTable('cars', ['modified', 'created']); $dataSet = new \PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); $dataSet->addTable('cars', 'SELECT * FROM `cars`'); $dataSet = new \PHPUnit_Extensions_Database_DataSet_DataSetFilter($dataSet); $dataSet->setExcludeColumnsForTable('cars', ['modified', 'created']); $this->assertDataSetsEqual($expectedDataSet, $dataSet); }
/** * Verify successful update of organization contact. */ public function testUpdateOrganizationWithAll() { // Insert a row in civicrm_contact creating organization contact $op = new PHPUnit_Extensions_Database_Operation_Insert(); $op->execute($this->_dbconn, $this->createXMLDataSet(dirname(__FILE__) . '/dataset/contact_org.xml')); $params = array('id' => 24, 'organization_name' => 'WebAccess India Pvt Ltd', 'legal_name' => 'WebAccess', 'sic_code' => 'ABC12DEF', 'contact_type' => 'Organization'); $this->callAPISuccess('Contact', 'Update', $params); // Check updated civicrm_contact against expected. $expected = $this->createXMLDataSet(dirname(__FILE__) . '/dataset/contact_org_upd.xml'); $actual = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->_dbconn); $actual->addTable('civicrm_contact'); $expected->matches($actual); }
public function testWithDatasetOnly() { // Create a dataset from live table through sql dataset // This is also a kind of live data only $ds1 = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); $ds1->addTable('user'); $ds2 = $this->getArrayDataset(); $filterDataSet = new PHPUnit_Extensions_Database_DataSet_DataSetFilter($ds2); $filterDataSet->addIncludeTables(array('user')); $this->assertDataSetsEqual($ds1, $filterDataSet); }