Backend\Modules\Blog\Installer\Installer::installExampleData PHP Method

    private function installExampleData($language)
    {
        // get db instance
        $db = $this->getDB();
        // check if blogposts already exist in this language
        if (!(bool) $db->getVar('SELECT 1
             FROM blog_posts
             WHERE language = ?
             LIMIT 1', array($language))) {
            // insert sample blogpost 1
            $db->insert('blog_posts', array('id' => 1, 'category_id' => $this->defaultCategoryId, 'user_id' => $this->getDefaultUserID(), 'meta_id' => $this->insertMeta('Nunc sediam est', 'Nunc sediam est', 'Nunc sediam est', 'nunc-sediam-est'), 'language' => $language, 'title' => 'Nunc sediam est', 'introduction' => file_get_contents(PATH_WWW . '/src/Backend/Modules/Blog/Installer/Data/' . $language . '/sample1.txt'), 'text' => file_get_contents(PATH_WWW . '/src/Backend/Modules/Blog/Installer/Data/' . $language . '/sample1.txt'), 'status' => 'active', 'publish_on' => gmdate('Y-m-d H:i:00'), 'created_on' => gmdate('Y-m-d H:i:00'), 'edited_on' => gmdate('Y-m-d H:i:00'), 'hidden' => 'N', 'allow_comments' => 'Y', 'num_comments' => '2'));
            // add Search index blogpost 1
            $this->addSearchIndex('Blog', 1, array('title' => 'Nunc sediam est', 'text' => file_get_contents(PATH_WWW . '/src/Backend/Modules/Blog/Installer/Data/' . $language . '/sample1.txt')), $language);
            // insert sample blogpost 2
            $db->insert('blog_posts', array('id' => 2, 'category_id' => $this->defaultCategoryId, 'user_id' => $this->getDefaultUserID(), 'meta_id' => $this->insertMeta('Lorem ipsum', 'Lorem ipsum', 'Lorem ipsum', 'lorem-ipsum'), 'language' => $language, 'title' => 'Lorem ipsum', 'introduction' => file_get_contents(PATH_WWW . '/src/Backend/Modules/Blog/Installer/Data/' . $language . '/sample1.txt'), 'text' => file_get_contents(PATH_WWW . '/src/Backend/Modules/Blog/Installer/Data/' . $language . '/sample1.txt'), 'status' => 'active', 'publish_on' => gmdate('Y-m-d H:i:00', time() - 60), 'created_on' => gmdate('Y-m-d H:i:00', time() - 60), 'edited_on' => gmdate('Y-m-d H:i:00', time() - 60), 'hidden' => 'N', 'allow_comments' => 'Y', 'num_comments' => '0'));
            // add Search index blogpost 2
            $this->addSearchIndex('Blog', 2, array('title' => 'Lorem ipsum', 'text' => file_get_contents(PATH_WWW . '/src/Backend/Modules/Blog/Installer/Data/' . $language . '/sample1.txt')), $language);
            // insert example comment 1
            $db->insert('blog_comments', array('post_id' => 1, 'language' => $language, 'created_on' => gmdate('Y-m-d H:i:00'), 'author' => 'Davy Hellemans', 'email' => '[email protected]', 'website' => 'http://www.spoon-library.com', 'text' => 'awesome!', 'type' => 'comment', 'status' => 'published', 'data' => null));
            // insert example comment 2
            $db->insert('blog_comments', array('post_id' => 1, 'language' => $language, 'created_on' => gmdate('Y-m-d H:i:00'), 'author' => 'Tijs Verkoyen', 'email' => '[email protected]', 'website' => 'http://www.sumocoders.be', 'text' => 'wicked!', 'type' => 'comment', 'status' => 'published', 'data' => null));
        }
    }