Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.


Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Pre-populating a table


4 Posts   1414 Views


6 June 2008 at 7:20am (Last edited: 6 June 2008 7:21am), 4085 Posts

How can I make a Silverstripe module that will build a database table that comes pre-populated with several records? (A look-up table, for instance).


20 June 2008 at 4:34am 4085 Posts

Any ideas on this? I know it can be done.


20 June 2008 at 5:33pm Forum Moderator, 5511 Posts

Have a look at the Blog and Forum modules - by default they create Holders and example posts / threads etc

    * Create default blog setup
   function requireDefaultRecords() {
      if(!DataObject::get_one('BlogHolder')) {
         $blogholder = new BlogHolder();
         $blogholder->Title = "Blog";
         $blogholder->URLSegment = "blog";
         $blogholder->Status = "Published";
         $widgetarea = new WidgetArea();
         $blogholder->SideBarID = $widgetarea->ID;
         $blogholder->publish("Stage", "Live");
         $managementwidget = new BlogManagementWidget();
         $managementwidget->ParentID = $widgetarea->ID;
         $tagcloudwidget = new TagCloudWidget();
         $tagcloudwidget->ParentID = $widgetarea->ID;
         $archivewidget = new ArchiveWidget();
         $archivewidget->ParentID = $widgetarea->ID;
         $blog = new BlogEntry();
         $blog->Title = _t('BlogHolder.SUCTITLE', "SilverStripe blog module successfully installed");
         $blog->URLSegment = 'sample-blog-entry';
         $blog->setDate(date("Y-m-d H:i:s",time()));
         $blog->Tags = _t('BlogHolder.SUCTAGS',"silverstripe, blog");
         $blog->Content = _t('BlogHolder.SUCCONTENT',"Congratulations, the SilverStripe blog module has been successfully installed. This blog entry can be safely deleted. You can configure aspects of your blog (such as the widgets displayed in the sidebar) in [url=admin]the CMS[/url].");
         $blog->Status = "Published";
         $blog->ParentID = $blogholder->ID;
         $blog->publish("Stage", "Live");
         Database::alteration_message("Blog page created","created");


21 June 2008 at 1:34am 4085 Posts

Perfect. That's exactly the code I was looking for. Thanks.