/** * Runs the drop and create commands on the fixtures if necessary. * * @param \Cake\TestSuite\Fixture\TestFixture $fixture the fixture object to create * @param Connection $db the datasource instance to use * @param array $sources The existing tables in the datasource. * @param bool $drop whether drop the fixture if it is already created or not * @return void */ protected function _setupTable(TestFixture $fixture, Connection $db, array $sources, $drop = true) { if (!empty($fixture->created) && in_array($db->configName(), $fixture->created)) { return; } $table = $fixture->table; $exists = in_array($table, $sources); if ($drop && $exists) { $fixture->drop($db); $fixture->create($db); } elseif (!$exists) { $fixture->create($db); } else { $fixture->created[] = $db->configName(); $fixture->truncate($db); } }
public function init() { // id, name, created, modified $dbDump = ' 1,Production Demand Pull Factor (exportable demand per capita),2013-09-24 19:33:12,2013-09-24 19:33:12 2,Production Supply Pull Factor (exportable supply per capita),2013-09-24 19:39:29,2013-09-24 19:39:29 3,2011 Wholesale Personal Income per Capita Pull Factor,2013-09-24 19:39:37,2013-09-24 19:39:37 4,Total Establishments: Wholesale Trade per Capita Pull Factor,2013-09-24 19:39:45,2013-09-24 19:39:45 5,2012 Truck Transportation Personal Income per Capita Pull Factor,2013-09-24 19:39:53,2013-09-24 19:39:53 6,Retail Supply Pull Factor (non-exportable supply per capita),2013-09-24 19:40:01,2013-09-24 19:40:01 7,Retail Demand Pull Factor (non-exportable demand per capita),2013-09-24 19:40:10,2013-09-24 19:40:10 8,Total Establishments: Retail Trade per Capita Pull Factor,2013-09-24 19:40:21,2013-09-24 19:40:21 9,Housing Density (units per square mile) Pull Factor,2013-09-24 19:40:27,2013-09-24 19:40:27 10,Metro Dummy Pull factor,2013-09-24 19:40:34,2013-09-24 19:40:34 11,2001-2011 Population Growth Pull Factor,2013-09-24 19:40:43,2013-09-24 19:40:43 12,Median House Value Pull Factor,2013-09-24 19:40:50,2013-09-24 19:40:50 13,Index of Changeable Amenities Pull Factor,2013-09-24 19:40:56,2013-09-24 19:40:56 14,Index of Relatively Static Amenities Pull Factor,2013-09-24 19:41:04,2013-09-24 19:41:04 15,2011 Percentage of 25 Yr & Older Population that have a Bachelor Degree or Higher Pull Factor,2013-09-24 19:41:11,2013-09-24 19:41:11 16,Total Establishments: Arts Entertainment Recreation per Capita Pull Factor,2013-09-24 19:41:18,2013-09-24 19:41:18 17,2011 Percentage of Total Population under 30 years Pull Factor,2013-09-24 19:41:24,2013-09-24 19:41:24 18,Exportable Sector Employment,2013-10-07 14:05:24,2013-10-07 14:05:24 19,Non-Exportable Sector Employment,2013-10-07 14:05:24,2013-10-07 14:05:24 '; $lines = explode("\n", $dbDump); foreach ($lines as $lineNum => $line) { $line = trim($line); if ($line == '') { continue; } $fields = explode(',', $line); $this->records[] = ['id' => $fields[0], 'name' => $fields[1], 'created' => $fields[2], 'modified' => $fields[3]]; } parent::init(); }
public function init() { parent::init(); // 1. Not all fixtures want to use the dev db. if (is_null($this->tableName)) { return; } // 2. We need to do this to ensure that the tables really do use the connection to the // dev db. TableRegistry::remove($this->tableName); $table = TableRegistry::get($this->tableName, ['connection' => ConnectionManager::get('dev')]); //if(!is_null($this->joinTableName)) { //TableRegistry::remove($this->joinTableName); //$n=TableRegistry::get($this->joinTableName, ['connection' => ConnectionManager::get('fixture')]); //} // 3. Now build the query to retrieve the source records $query = new Query(ConnectionManager::get('dev'), $table); $query->find('all'); //if(!is_null($this->order)) $query->order($this->order); //if(!is_null($this->joinTableName)) $query->leftJoin($this->joinTableName,'semesters.id = sections.semester_id'); //$c=$query->count(); // 4. Copy the records /* @var \Cake\ORM\Entity $record */ foreach ($query as $record) { $this->records[] = $record->toArray(); } // 5. Do this again to ensure that the table uses the 'test' connection. TableRegistry::remove($this->tableName); TableRegistry::get($this->tableName, ['connection' => ConnectionManager::get('test')]); //if(!is_null($this->joinTableName)) { //TableRegistry::remove($this->joinTableName); //TableRegistry::get($this->joinTableName, ['connection' => ConnectionManager::get('test')]); //} }
public function init() { $password = (new DefaultPasswordHasher())->hash('testpassword'); $this->records[] = ['id' => 1, 'name' => 'Member User', 'email' => '*****@*****.**', 'password' => $password, 'role' => 'user', 'profile' => '**Test User 1\'s** profile', 'slug' => 'test-user-1', 'stripe_customer_id' => null, 'created' => '2016-02-07 00:14:55', 'modified' => '2016-02-07 00:14:55']; $this->records[] = ['id' => 2, 'name' => 'Non-Member User', 'email' => '*****@*****.**', 'password' => $password, 'role' => 'user', 'profile' => '**Test User 2\'s** profile', 'slug' => 'test-user-2', 'stripe_customer_id' => null, 'created' => '2016-02-07 00:14:55', 'modified' => '2016-02-07 00:14:55']; $this->records[] = ['id' => 3, 'name' => 'Admin User', 'email' => '*****@*****.**', 'password' => $password, 'role' => 'admin', 'profile' => '**Admin User\'s** profile', 'slug' => 'admin-user', 'stripe_customer_id' => null, 'created' => '2016-02-07 00:14:55', 'modified' => '2016-02-07 00:14:55']; parent::init(); }
public function init() { $created = $modified = date('Y-m-d H:i:s'); array_walk($this->records, function (&$record) use($created, $modified) { $record += compact('created'); }); parent::init(); }
/** * */ public function __construct() { parent::__construct(); foreach ($this->records as &$record) { $record['passwd'] = sha1($record['passwd']); //, null, true } }
/** * Add check constraints. * * @param ConnectionInterface $db * @return boolean */ public function create(ConnectionInterface $db) { $result = parent::create($db); $sql = ['ALTER TABLE "comments" ADD CONSTRAINT "comments_status_in_list" CHECK(cakephp_validate_in_list("status", ARRAY[\'awaiting\', \'ham\', \'spam\']));', 'ALTER TABLE "comments" ADD CONSTRAINT "comments_name_min_length" CHECK(cakephp_validate_min_length("name", 4));', 'ALTER TABLE "comments" ADD CONSTRAINT "comments_name_alpha_numeric" CHECK(cakephp_validate_alpha_numeric("name"));']; foreach ($sql as $stmt) { $db->query($stmt); } return $result; }
/** * Records * * @var array */ public function init() { $stoppedAt = new Time(); $startedAt = clone $stoppedAt; $startedAt->modify('-2 hours'); $stoppedAt2 = new Time(); $startedAt2 = clone $stoppedAt2; $startedAt2->modify('-45 seconds'); $this->records = [['id' => 1, 'started_at' => $startedAt, 'stopped_at' => $stoppedAt, 'trackable_id' => 1, 'trackable_type' => 'Todos', 'created' => '2015-10-09 13:19:39', 'modified' => '2015-10-09 13:19:39'], ['id' => 2, 'started_at' => $startedAt, 'stopped_at' => $stoppedAt, 'trackable_id' => 2, 'trackable_type' => 'Todos', 'created' => '2015-10-09 13:19:39', 'modified' => '2015-10-09 13:19:39'], ['id' => 3, 'started_at' => $startedAt2, 'stopped_at' => $stoppedAt2, 'trackable_id' => 2, 'trackable_type' => 'Todos', 'created' => '2015-10-09 13:19:39', 'modified' => '2015-10-09 13:19:39'], ['id' => 4, 'started_at' => '2015-10-14T13:50:21-0300', 'stopped_at' => '2015-10-14T18:50:21-0300', 'trackable_id' => 1, 'trackable_type' => 'Todos', 'created' => '2015-10-14T13:50:21-0300', 'modified' => '2015-10-14T18:50:21-0300'], ['id' => 5, 'started_at' => $startedAt2, 'stopped_at' => $stoppedAt2, 'trackable_id' => 3, 'trackable_type' => 'Todos', 'created' => '2015-10-09 13:19:39', 'modified' => '2015-10-09 13:19:39']]; parent::init(); }
/** * {@inheritdoc} */ public function insert(Connection $db) { if (!parent::insert($db)) { return false; } $entityPopulator = new EntityPopulator($this->table); $populator = new Populator($this->faker); array_walk($this->guessers, array($populator, 'addGuesser')); $populator->addEntity($entityPopulator, $this->number, $this->customColumnFormatters, $this->customModifiers); $populator->execute(['validate' => false]); return true; }
/** * Drops the table from the test datasource * * @param ConnectionInterface $db * @return void */ public function drop(ConnectionInterface $db) { unset(static::$_tableHashes[$this->table]); return parent::drop($db); }
/** * method init * * @return void */ public function init() { $this->records = [['title' => 'The title', 'slug' => 'the-title', 'body' => 'This is the article body.', 'created' => '2015-03-03 16:33:57', 'user_id' => 1], ['title' => 'A title once again', 'slug' => 'a-title-once-again', 'body' => 'And the article body follows.', 'created' => '2015-03-03 16:35:37', 'user_id' => 1], ['title' => 'Title strikes back', 'slug' => 'title-strikes-back', 'body' => 'This is really exciting! Not.', 'created' => '2015-03-03 16:39:22', 'user_id' => 2]]; parent::init(); }
/** * Records * * @var array */ public function init() { $this->records = [['id' => 1, 'ref' => 'Posts', 'ref_id' => 1, 'file' => 'img' . DS . 'upload' . DS . '2015' . DS . '08' . DS . 'testHelper.png', 'name' => 'Lorem ipsum dolor sit amet', 'position' => 0, 'caption' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.'], ['id' => 2, 'ref' => 'Posts', 'ref_id' => 1, 'file' => 'img' . DS . 'upload' . DS . '2015' . DS . '08' . DS . 'testHelper_50x50.jpg', 'name' => 'Lorem ipsum dolor sit amet', 'position' => 0, 'caption' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.'], ['id' => 3, 'ref' => 'Posts', 'ref_id' => 2, 'file' => 'img' . DS . 'upload' . DS . '2015' . DS . '08' . DS . 'document.pdf', 'name' => 'Lorem ipsum dolor sit amet', 'position' => 1, 'caption' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.'], ['id' => 4, 'ref' => 'Pages', 'ref_id' => 2, 'file' => 'img' . DS . 'upload' . DS . '2015' . DS . '08' . DS . 'testHelper.png', 'name' => 'Lorem ipsum dolor sit amet', 'position' => 1, 'caption' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.']]; parent::init(); }
public function init() { $this->records = [['nome' => 'caneta', 'valor' => 12.5], ['id' => 2, 'nome' => 'borracha', 'valor' => 15.5]]; parent::init(); }
/** * Runs the drop and create commands on the fixtures if necessary. * * @param \Cake\TestSuite\Fixture\TestFixture $fixture the fixture object to create * @param Connection $db the datasource instance to use * @param bool $drop whether drop the fixture if it is already created or not * @return void */ protected function _setupTable(TestFixture $fixture, Connection $db = null, $drop = true) { if (!$db) { if (!empty($fixture->connection)) { $db = ConnectionManager::get($fixture->connection, false); } if (!$db) { $db = ConnectionManager::get('test', false); } } if (!empty($fixture->created) && in_array($db->configName(), $fixture->created)) { return; } $schemaCollection = $db->schemaCollection(); $sources = (array) $schemaCollection->listTables(); $table = $fixture->table; $exists = in_array($table, $sources); if ($drop && $exists) { $fixture->drop($db); $fixture->create($db); } elseif (!$exists) { $fixture->create($db); } else { $fixture->created[] = $db->configName(); } }
/** * Records * * @var array */ public function init() { $this->records = [['id' => 1, 'hash' => '31f7a65e315586ac198bd798b6629ce4903d0899476d5741a9f32e2e521b6a66', 'used' => 0, 'time' => 86400, 'created' => date('Y-m-d H:i:s'), 'user_id' => 1, 'hash_type_id' => 1], ['id' => 2, 'hash' => 'cce66316b4c1c59df94a35afb80cecd82d1a8d91b554022557e115f5c275f515', 'used' => 1, 'time' => 86400, 'created' => date('Y-m-d H:i:s'), 'user_id' => 1, 'hash_type_id' => 1], ['id' => 3, 'hash' => 'eb0295d98f37ae9e95102afae792d540137be2dedf6c4b00570ab1d1f355d033', 'used' => 0, 'time' => 86400, 'created' => '2007-03-18 10:39:23', 'user_id' => 1, 'hash_type_id' => 1], ['id' => 4, 'hash' => 'd1c7c99c6e2e7b311f51dd9d19161a5832625fb21f35131fba6da62513f0c099', 'used' => 0, 'time' => 86400, 'created' => date('Y-m-d H:i:s'), 'user_id' => 1, 'hash_type_id' => 2]]; parent::init(); }
public function init() { $this->records = [['ip' => '192.193.194.195', 'url' => 'users/login', 'expire' => strtotime('+5 minutes')], ['ip' => '188.189.190.191', 'url' => 'users/login', 'expire' => strtotime('+1 minutes')], ['ip' => '188.189.190.191', 'url' => 'users', 'expire' => strtotime('+2 minutes')], ['ip' => '188.189.190.191', 'url' => 'users/login', 'expire' => strtotime('+4 minutes')]]; parent::init(); }
public function init() { // stat_category_id value year created modified $dbDump = [1 => ' 1,0.6,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 2,0.5,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 3,0.33,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 4,0.71,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 5,0.52,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 6,0.8,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 7,0.7,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 8,1.11,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 9,3.64,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 10,1,NULL,2013-10-01 19:53:34,,2013-10-01 19:53:34 11,-0.23,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 12,0.49,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 13,1.07,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 14,0.86,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 15,0.8,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 16,0.94,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 17,1.11,NULL,2013-10-01 19:53:34,2013-10-01 19:53:34 18,27169,1969,2013-10-07 20:19:13,2013-10-07 20:19:13 18,25895,1970,2013-10-07 20:19:13,2013-10-07 20:19:13 18,24362,1971,2013-10-07 20:19:13,2013-10-07 20:19:13 18,23612,1972,2013-10-07 20:19:13,2013-10-07 20:19:13 18,24560,1973,2013-10-07 20:19:13,2013-10-07 20:19:13 18,24641,1974,2013-10-07 20:19:13,2013-10-07 20:19:13 18,21398,1975,2013-10-07 20:19:13,2013-10-07 20:19:13 18,21608,1976,2013-10-07 20:19:13,2013-10-07 20:19:13 18,22757,1977,2013-10-07 20:19:13,2013-10-07 20:19:13 18,22228,1978,2013-10-07 20:19:13,2013-10-07 20:19:13 18,22687,1979,2013-10-07 20:19:13,2013-10-07 20:19:13 18,20955,1980,2013-10-07 20:19:13,2013-10-07 20:19:13 18,19999,1981,2013-10-07 20:19:13,2013-10-07 20:19:13 18,17671,1982,2013-10-07 20:19:13,2013-10-07 20:19:13 18,17597,1983,2013-10-07 20:19:13,2013-10-07 20:19:13 18,18680,1984,2013-10-07 20:19:13,2013-10-07 20:19:13 18,18883,1985,2013-10-07 20:19:13,2013-10-07 20:19:13 18,19138,1986,2013-10-07 20:19:13,2013-10-07 20:19:13 18,19317,1987,2013-10-07 20:19:13,2013-10-07 20:19:13 18,19741,1988,2013-10-07 20:19:13,2013-10-07 20:19:13 18,19862,1989,2013-10-07 20:19:13,2013-10-07 20:19:13 18,20440,1990,2013-10-07 20:19:13,2013-10-07 20:19:13 18,20013,1991,2013-10-07 20:19:13,2013-10-07 20:19:13 18,22346,1992,2013-10-07 20:19:13,2013-10-07 20:19:13 18,21980,1993,2013-10-07 20:19:13,2013-10-07 20:19:13 18,23215,1994,2013-10-07 20:19:13,2013-10-07 20:19:13 18,24280,1995,2013-10-07 20:19:13,2013-10-07 20:19:13 18,22177,1996,2013-10-07 20:19:13,2013-10-07 20:19:13 18,21440,1997,2013-10-07 20:19:13,2013-10-07 20:19:13 18,21011,1998,2013-10-07 20:19:14,2013-10-07 20:19:14 18,20884,1999,2013-10-07 20:19:14,2013-10-07 20:19:14 18,20627,2000,2013-10-07 20:19:14,2013-10-07 20:19:14 18,19832,2001,2013-10-07 20:19:14,2013-10-07 20:19:14 18,17422,2002,2013-10-07 20:19:14,2013-10-07 20:19:14 18,16417,2003,2013-10-07 20:19:14,2013-10-07 20:19:14 18,15876,2004,2013-10-07 20:19:14,2013-10-07 20:19:14 18,14918,2005,2013-10-07 20:19:14,2013-10-07 20:19:14 18,14681,2006,2013-10-07 20:19:14,2013-10-07 20:19:14 18,14594,2007,2013-10-07 20:19:14,2013-10-07 20:19:14 18,13920,2008,2013-10-07 20:19:14,2013-10-07 20:19:14 18,12439,2009,2013-10-07 20:19:14,2013-10-07 20:19:14 18,11832,2010,2013-10-07 20:19:14,2013-10-07 20:19:14 18,12182,2011,2013-10-07 20:19:14,2013-10-07 20:19:14 19,18921,1969,2013-10-07 20:19:14,2013-10-07 20:19:14 19,19336,1970,2013-10-07 20:19:14,2013-10-07 20:19:14 19,20065,1971,2013-10-07 20:19:14,2013-10-07 20:19:14 19,20801,1972,2013-10-07 20:19:14,2013-10-07 20:19:14 19,21486,1973,2013-10-07 20:19:14,2013-10-07 20:19:14 19,21597,1974,2013-10-07 20:19:14,2013-10-07 20:19:14 19,21556,1975,2013-10-07 20:19:14,2013-10-07 20:19:14 19,22250,1976,2013-10-07 20:19:14,2013-10-07 20:19:14 19,23407,1977,2013-10-07 20:19:14,2013-10-07 20:19:14 19,24463,1978,2013-10-07 20:19:14,2013-10-07 20:19:14 19,25271,1979,2013-10-07 20:19:14,2013-10-07 20:19:14 19,25327,1980,2013-10-07 20:19:14,2013-10-07 20:19:14 19,25679,1981,2013-10-07 20:19:14,2013-10-07 20:19:14 19,25307,1982,2013-10-07 20:19:14,2013-10-07 20:19:14 19,25134,1983,2013-10-07 20:19:14,2013-10-07 20:19:14 19,25668,1984,2013-10-07 20:19:14,2013-10-07 20:19:14 19,26524,1985,2013-10-07 20:19:14,2013-10-07 20:19:14 19,27440,1986,2013-10-07 20:19:14,2013-10-07 20:19:14 19,28617,1987,2013-10-07 20:19:14,2013-10-07 20:19:14 19,29844,1988,2013-10-07 20:19:14,2013-10-07 20:19:14 19,30306,1989,2013-10-07 20:19:14,2013-10-07 20:19:14 19,31085,1990,2013-10-07 20:19:14,2013-10-07 20:19:14 19,31071,1991,2013-10-07 20:19:14,2013-10-07 20:19:14 19,31154,1992,2013-10-07 20:19:14,2013-10-07 20:19:14 19,31931,1993,2013-10-07 20:19:14,2013-10-07 20:19:14 19,33012,1994,2013-10-07 20:19:14,2013-10-07 20:19:14 19,34204,1995,2013-10-07 20:19:14,2013-10-07 20:19:14 19,34758,1996,2013-10-07 20:19:14,2013-10-07 20:19:14 19,35291,1997,2013-10-07 20:19:14,2013-10-07 20:19:14 19,35949,1998,2013-10-07 20:19:14,2013-10-07 20:19:14 19,36390,1999,2013-10-07 20:19:14,2013-10-07 20:19:14 19,36655,2000,2013-10-07 20:19:14,2013-10-07 20:19:14 19,36765,2001,2013-10-07 20:19:14,2013-10-07 20:19:14 19,36356,2002,2013-10-07 20:19:14,2013-10-07 20:19:14 19,36332,2003,2013-10-07 20:19:14,2013-10-07 20:19:14 19,36524,2004,2013-10-07 20:19:14,2013-10-07 20:19:14 19,36356,2005,2013-10-07 20:19:14,2013-10-07 20:19:14 19,37325,2006,2013-10-07 20:19:14,2013-10-07 20:19:14 19,37375,2007,2013-10-07 20:19:14,2013-10-07 20:19:14 19,36501,2008,2013-10-07 20:19:14,2013-10-07 20:19:14 19,34963,2009,2013-10-07 20:19:14,2013-10-07 20:19:14 19,33964,2010,2013-10-07 20:19:14,2013-10-07 20:19:14 19,34271,2011,2013-10-07 20:19:14,2013-10-07 20:19:14 ', 2 => ' 1,1.5,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 2,2,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 3,0.5,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 4,0.75,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 5,1.43,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 6,0.7,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 7,1.3,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 8,1.18,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 9,1.04,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 10,0.5,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 11,0.26,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 12,0.59,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 13,1.07,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 14,0.8,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 15,0.44,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 16,0.51,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 17,1.12,NULL,2013-10-01 19:53:33,2013-10-01 19:53:33 18,5451,1969,2013-10-07 20:19:09,2013-10-07 20:19:09 18,5805,1970,2013-10-07 20:19:09,2013-10-07 20:19:09 18,5415,1971,2013-10-07 20:19:09,2013-10-07 20:19:09 18,6304,1972,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7040,1973,2013-10-07 20:19:09,2013-10-07 20:19:09 18,6557,1974,2013-10-07 20:19:09,2013-10-07 20:19:09 18,5701,1975,2013-10-07 20:19:09,2013-10-07 20:19:09 18,6669,1976,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7241,1977,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7800,1978,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7550,1979,2013-10-07 20:19:09,2013-10-07 20:19:09 18,6569,1980,2013-10-07 20:19:09,2013-10-07 20:19:09 18,6840,1981,2013-10-07 20:19:09,2013-10-07 20:19:09 18,6447,1982,2013-10-07 20:19:09,2013-10-07 20:19:09 18,6926,1983,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7776,1984,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7707,1985,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7560,1986,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7979,1987,2013-10-07 20:19:09,2013-10-07 20:19:09 18,8851,1988,2013-10-07 20:19:09,2013-10-07 20:19:09 18,8876,1989,2013-10-07 20:19:09,2013-10-07 20:19:09 18,8164,1990,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7924,1991,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7844,1992,2013-10-07 20:19:09,2013-10-07 20:19:09 18,8221,1993,2013-10-07 20:19:09,2013-10-07 20:19:09 18,8861,1994,2013-10-07 20:19:09,2013-10-07 20:19:09 18,9299,1995,2013-10-07 20:19:09,2013-10-07 20:19:09 18,8894,1996,2013-10-07 20:19:09,2013-10-07 20:19:09 18,9125,1997,2013-10-07 20:19:09,2013-10-07 20:19:09 18,10593,1998,2013-10-07 20:19:09,2013-10-07 20:19:09 18,10895,1999,2013-10-07 20:19:09,2013-10-07 20:19:09 18,10658,2000,2013-10-07 20:19:09,2013-10-07 20:19:09 18,9626,2001,2013-10-07 20:19:09,2013-10-07 20:19:09 18,9830,2002,2013-10-07 20:19:09,2013-10-07 20:19:09 18,10097,2003,2013-10-07 20:19:09,2013-10-07 20:19:09 18,10625,2004,2013-10-07 20:19:09,2013-10-07 20:19:09 18,10445,2005,2013-10-07 20:19:09,2013-10-07 20:19:09 18,10064,2006,2013-10-07 20:19:09,2013-10-07 20:19:09 18,10014,2007,2013-10-07 20:19:09,2013-10-07 20:19:09 18,9027,2008,2013-10-07 20:19:09,2013-10-07 20:19:09 18,7837,2009,2013-10-07 20:19:09,2013-10-07 20:19:09 18,8375,2010,2013-10-07 20:19:09,2013-10-07 20:19:09 18,8411,2011,2013-10-07 20:19:09,2013-10-07 20:19:09 19,2943,1969,2013-10-07 20:19:09,2013-10-07 20:19:09 19,2870,1970,2013-10-07 20:19:09,2013-10-07 20:19:09 19,2995,1971,2013-10-07 20:19:09,2013-10-07 20:19:09 19,3279,1972,2013-10-07 20:19:09,2013-10-07 20:19:09 19,3458,1973,2013-10-07 20:19:09,2013-10-07 20:19:09 19,3463,1974,2013-10-07 20:19:09,2013-10-07 20:19:09 19,3793,1975,2013-10-07 20:19:09,2013-10-07 20:19:09 19,3944,1976,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4087,1977,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4254,1978,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4369,1979,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4279,1980,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4421,1981,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4446,1982,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4508,1983,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4736,1984,2013-10-07 20:19:09,2013-10-07 20:19:09 19,4991,1985,2013-10-07 20:19:09,2013-10-07 20:19:09 19,5099,1986,2013-10-07 20:19:09,2013-10-07 20:19:09 19,5550,1987,2013-10-07 20:19:09,2013-10-07 20:19:09 19,5535,1988,2013-10-07 20:19:09,2013-10-07 20:19:09 19,5617,1989,2013-10-07 20:19:09,2013-10-07 20:19:09 19,5701,1990,2013-10-07 20:19:09,2013-10-07 20:19:09 19,5814,1991,2013-10-07 20:19:09,2013-10-07 20:19:09 19,6052,1992,2013-10-07 20:19:09,2013-10-07 20:19:09 19,6271,1993,2013-10-07 20:19:09,2013-10-07 20:19:09 19,6331,1994,2013-10-07 20:19:09,2013-10-07 20:19:09 19,7119,1995,2013-10-07 20:19:09,2013-10-07 20:19:09 19,7312,1996,2013-10-07 20:19:09,2013-10-07 20:19:09 19,7351,1997,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8141,1998,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8175,1999,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8442,2000,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8404,2001,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8440,2002,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8433,2003,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8803,2004,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8892,2005,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8990,2006,2013-10-07 20:19:09,2013-10-07 20:19:09 19,9232,2007,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8966,2008,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8810,2009,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8717,2010,2013-10-07 20:19:09,2013-10-07 20:19:09 19,8931,2011,2013-10-07 20:19:09,2013-10-07 20:19:09 ']; foreach ($dbDump as $areaId => $dumpText) { $lines = explode("\n", $dumpText); foreach ($lines as $lineNum => $line) { $line = trim($line); if ($line == '') { continue; } $fields = explode(',', $line); if ($fields[2] == 'NULL') { $fields[2] = null; } $this->records[] = ['area_id' => $areaId, 'stat_category_id' => $fields[0], 'value' => $fields[1], 'year' => $fields[2], 'created' => $fields[3], 'modified' => $fields[4]]; } } parent::init(); }
public function init() { $this->records = [['id' => 1, 'user_id' => 1]]; parent::init(); }
public function init() { $this->records[] = ['id' => 1, 'user_id' => 1, 'membership_level_id' => 1, 'payment_id' => 1, 'auto_renew' => 1, 'created' => '2016-02-11 05:09:41', 'modified' => '2016-02-11 05:09:41', 'expires' => date('Y-m-d H:i:s', strtotime('+6 month')), 'canceled' => null]; parent::init(); }
/** * method init * * @return void */ public function init() { $hasher = new DefaultPasswordHasher(); $this->records = [['nom' => 'User', 'prenom' => 'First', 'fullname_slug' => 'first_user', 'email' => EMAIL_TO_TEST, 'password' => $hasher->hash('juVni4tr3'), 'role' => 'admin', 'actif' => true, 'created' => '2007-03-18 10:39:23', 'updated' => '2007-03-18 10:41:31'], ['nom' => 'User', 'prenom' => 'Second', 'fullname_slug' => 'second_user', 'email' => '*****@*****.**', 'password' => $hasher->hash('HuaB78lo'), 'actif' => true, 'change_pass_code' => '2400fd3226c673532e8e68d35c8c31115a83f6c3', 'change_pass_date' => '2014-02-04 09:30:21', 'created' => '2007-03-18 10:41:23', 'updated' => '2007-03-18 10:43:31'], ['nom' => 'User', 'prenom' => 'Third', 'fullname_slug' => 'third_user', 'email' => '*****@*****.**', 'password' => $hasher->hash('Mak66uruck'), 'actif' => true, 'created' => '2007-03-18 10:43:23', 'updated' => '2007-03-18 10:45:31']]; parent::init(); }