/** * @throws SpoonDatabaseException */ public function testInsert() { $userRecord['username'] = '******'; $userRecord['email'] = '*****@*****.**'; $userRecord['developer'] = 'N'; for ($i = 0; $i < self::NUMBER_OF_ROWS; $i++) { $this->db->insert('users', $userRecord); } }
public function load(\SpoonDatabase $database) { $metaId = $database->insert('meta', array('keywords' => 'Is this a working test?', 'description' => 'Is this a working test?', 'title' => 'Is this a working test?', 'url' => 'is-this-a-working-test')); $categoryId = $database->getVar('SELECT id FROM faq_categories WHERE title = :title AND language = :language LIMIT 1', array('title' => 'Faq for tests', 'language' => 'en')); $database->insert('faq_questions', array('meta_id' => $metaId, 'category_id' => $categoryId, 'user_id' => 1, 'language' => 'en', 'question' => 'Is this a working test?', 'answer' => '<p>I hope so.</p>', 'created_on' => '2015-02-23 00:00:00', 'hidden' => 'N', 'sequence' => 1)); }
/** * @param \SpoonDatabase $database */ public function load(\SpoonDatabase $database) { $metaId = $database->insert('meta', array('keywords' => 'Blogpost for functional tests', 'description' => 'Blogpost for functional tests', 'title' => 'Blogpost for functional tests', 'url' => 'blogpost-for-functional-tests')); $categoryId = $database->getVar('SELECT id FROM blog_categories WHERE title = :title AND language = :language LIMIT 1', array('title' => 'BlogCategory for tests', 'language' => 'en')); $database->insert('blog_posts', array('id' => 1, 'meta_id' => $metaId, 'category_id' => $categoryId, 'user_id' => 1, 'language' => 'en', 'title' => 'Blogpost for functional tests', 'introduction' => '<p>Lorem ipsum dolor sit amet</p>', 'text' => '<p>Lorem ipsum dolor sit amet</p>', 'status' => 'active', 'publish_on' => '2015-02-23 00:00:00', 'created_on' => '2015-02-23 00:00:00', 'edited_on' => '2015-02-23 00:00:00', 'num_comments' => 0)); $database->insert('search_index', array('module' => 'Blog', 'other_id' => 1, 'field' => 'title', 'value' => 'Blogpost for functional tests', 'language' => 'en', 'active' => 'Y')); }
public function load(\SpoonDatabase $database) { $metaId = $database->insert('meta', array('keywords' => 'Slideshow for functional tests', 'description' => 'Slideshow for functional tests', 'title' => 'Slideshow for functional tests', 'url' => 'slideshow-for-functional-tests')); $categoryId = $database->getVar('SELECT id FROM slideshow_categories WHERE title = :title AND language = :language LIMIT 1', array('title' => 'SlideshowCategory for tests', 'language' => 'en')); $database->insert('slideshow_galleries', array('id' => 1, 'meta_id' => $metaId, 'category_id' => $categoryId, 'user_id' => 1, 'language' => 'en', 'title' => 'Slideshow for functional tests', 'description' => '<p>Description of the slideshow</p>', 'width' => 200, 'height' => 200, 'publish_on' => '2015-03-27 00:00:00', 'created_on' => '2015-03-27 00:00:00', 'edited_on' => '2015-03-27 00:00:00')); $database->insert('search_index', array('module' => 'Slideshow', 'other_id' => 1, 'field' => 'title', 'value' => 'Slideshow for functional tests', 'language' => 'en', 'active' => 'Y')); }
/** * @depends testExecute */ public function testInsert() { // data $aData['username'] = '******'; $aData['email'] = '*****@*****.**'; $aData['developer'] = 'N'; // insert one record $this->db->insert('users', $aData); // insert 1000 records for ($i = 0; $i < 1000; $i++) { $array[$i] = $aData; } $this->db->insert('users', $array); }
public function load(\SpoonDatabase $database) { $galleryId = $database->getVar('SELECT id FROM slideshow_galleries WHERE title = :title AND language = :language LIMIT 1', array('title' => 'Slideshow for functional tests', 'language' => 'en')); $database->insert('slideshow_images', array('id' => 1, 'gallery_id' => $galleryId, 'language' => 'en', 'title' => 'Slideshow image for functional tests', 'caption' => '<p>caption of the slideshow image</p>', 'filename' => 'slideshow-image-for-functional-tests')); }
/** * @param \SpoonDatabase $database */ public function load(\SpoonDatabase $database) { $metaId = $database->insert('meta', array('keywords' => 'Faq for tests', 'description' => 'Faq for tests', 'title' => 'Faq for tests', 'url' => 'faqcategory-for-tests')); $database->insert('faq_categories', array('meta_id' => $metaId, 'extra_id' => 0, 'language' => 'en', 'title' => 'Faq for tests', 'sequence' => 1)); }
/** * @param \SpoonDatabase $database */ public function load(\SpoonDatabase $database) { $metaId = $database->insert('meta', array('keywords' => 'BlogCategory for tests', 'description' => 'BlogCategory for tests', 'title' => 'BlogCategory for tests', 'url' => 'blogcategory-for-tests')); $database->insert('blog_categories', array('meta_id' => $metaId, 'language' => 'en', 'title' => 'BlogCategory for tests')); }