Add database seeding to gulpfile

joeltaylor · joeltaylor · commit 93c87f03ed7b · 2015-05-19T23:08:45.000-04:00
diff --git a/gulpfile.js b/gulpfile.js
@@ -21,6 +21,8 @@ var svgmin       = require('gulp-svgmin');
 var svgstore     = require('gulp-svgstore');
 var _            = require('lodash');
 var run          = require('run-sequence');
+var Chance       = require('chance');
+var db           = require('./services/db');
 
 // -------------------------------------
 //   Variables
@@ -226,3 +228,55 @@ gulp.task('icons', function() {
     .pipe(svgstore({ inlineSvg: true }))
     .pipe(gulp.dest(options.icons.destDir));
 });
+
+// -------------------------------------
+//   Task: Seeds
+// -------------------------------------
+gulp.task('seeds', function() {
+  var chance = new Chance();
+  for(i = 0; i < 50; i++) {
+    var title = chance.sentence({words: 5});
+    var slug = title.toLowerCase().replace(/[^a-zA-Z0-9\s]/g,"").replace(/\s/g,'-');
+    var body = chance.paragraph();
+    var url = chance.url();
+    var published_at = chance.date({year: 2014});
+    db.query('INSERT INTO articles (title, slug, body, url, published_at, news, approved) VALUES ($1, $2, $3, $4, $5, true, true);',
+      [title, slug, body, url, published_at],
+      function(){}
+    );
+  }
+  for (i = 0; i < 7; i++) {
+    var githubId = chance.integer({min: 1, max: 6000});
+    var email = chance.email();
+    var name = chance.name();
+    var avatarUrl = 'https://avatars.githubusercontent.com/u/' + chance.pick([6965062,3412,10722,6797535,2618,30208]) + '?v=3';
+    db.query('INSERT INTO users (github_id, email, name, avatar_url) VALUES ($1, $2, $3, $4);',
+      [githubId, email, name, avatarUrl],
+      function(){}
+    );
+  }
+
+  for(i = 0; i < 50; i++) {
+    var title = chance.sentence({words: 5});
+    var slug = title.toLowerCase().replace(/[^a-zA-Z0-9\s]/g,"").replace(/\s/g,'-');
+    var body = chance.paragraph();
+    var url = chance.url();
+    var published_at = chance.date({year: 2014});
+    var userId = chance.d6();
+    db.query('INSERT INTO articles (user_id, title, slug, body, url, published_at, news, approved) VALUES ($1, $2, $3, $4, $5, $6, false, true);',
+      [userId, title, slug, body, url, published_at],
+      function(){}
+    );
+  }
+
+   for(i = 0; i < 50; i++) {
+    var userId = chance.d6();
+    var body = chance.paragraph();
+    var articleId = chance.integer({min: 51, max: 100});
+    db.query('INSERT INTO comments (user_id, approved, body, article_id) VALUES ($1, true, $2, $3);',
+      [userId, body, articleId],
+      function(){}
+    );
+  }
+
+});
