var gulp = require('gulp');
var gutil = require('gutil');
var dbTask = require('gulp-db')
var shell = require('gulp-shell');

var dbManager = dbTask({
	//Comment out below and use bottom credentials for Heroku
	// host: '127.0.0.1',
	// user: 'root',
	// password: '',
	// dialect: 'mysql'
	//Comment out above and use above for local server
	host: us-cdbr-iron-east-02.cleardb.net,
  username: b220d94c2be53d,
  password: bd11f9e8,
  database: heroku_49f978646a3ea6c
});



gulp.task('drop', dbManager.drop('waypointdb'));
gulp.task('create', dbManager.create('waypointdb'));

gulp.task('reset', ['drop', 'create'], shell.task([
  'echo database test running',
  'node server.js'
]));

gulp.task('populate', shell.task([
	'node db/populate.js'
]));

gulp.task('default');

@@ -342,16 +342,17 @@
 %0A%09host: 
+'
 us-cdbr-
@@ -375,16 +375,17 @@
 ardb.net
+'
 ,%0A  user
@@ -390,16 +390,17 @@
 ername: 
+'
 b220d94c
@@ -405,16 +405,17 @@
 4c2be53d
+'
 ,%0A  pass
@@ -424,16 +424,17 @@
 rd: 
+'
 bd11f9e8
 ,%0A  
@@ -429,16 +429,17 @@
 bd11f9e8
+'
 ,%0A  data
@@ -444,16 +444,17 @@
 tabase: 
+'
 heroku_4
@@ -467,16 +467,17 @@
 46a3ea6c
+'
 %0A%7D);%0A%0A%0A%0A

fix bug