wlaurance

var fs = require('fs');
var _ = require('underscore');

process.stdin.on('data', function(d) {
  var files = d.toString().split('\n').filter(function(e){ return e !== ''; });
  files.map(function(fn) {
    var splat = fn.split('-');
    if (splat[0].length <= 2) {
      var copy = _.clone(splat);
      var year = splat[2];

wlaurance

Postgres

###How to * ?

• monitor
• backup
• restore from backup
• replicate
• keep hot spare ready

wlaurance

> function a(){ console.log("I'm function a") }
undefined
> a()
I'm function a
undefined
> a)(
I'm function a

wlaurance

Keybase proof

I hereby claim:

• I am wlaurance on github.
• I am wlaurance (https://keybase.io/wlaurance) on keybase.
• I have a public key ASCWffV_Z3Z87UUiZ4ncnt-0rBTpOqhYcnJaP7BSdBSGawo

To claim this, I am signing this object:

wlaurance

dbm = require("db-migrate")
type = dbm.dataType

table = "users"

exports.up = (db, callback) ->
  sql = """
    create table #{table}(
      "id" uuid PRIMARY KEY
              DEFAULT uuid_generate_v4(),

wlaurance

dbm = require("db-migrate")
async = require 'async'
_ = require 'underscore'
type = dbm.dataType

table = "users_projects"

exports.up = (db, callback) ->
  t = """
    create table #{table}(

wlaurance

dbm = require("db-migrate")
type = dbm.dataType

table = "projects"

exports.up = (db, callback) ->
  sql = """
    create table #{table}(
      "id" uuid PRIMARY KEY
              DEFAULT uuid_generate_v4(),

wlaurance

dbm = require("db-migrate")
async = require 'async'
_ = require 'underscore'
type = dbm.dataType

table = "time_entries"

exports.up = (db, callback) ->
  t = """
    create table #{table}(

wlaurance

pg = require 'pg'
{dev} = require "#{__dirname}/../database"
devConfig = "postgres://#{dev.user}:#{dev.password}@localhost/#{dev.database}"
constring = process.env.HEROKU_POSTGRESQL_NAVY_URL or process.env.TRAVIS_DB_URL or devConfig

{EventEmitter} = require 'events'

Database = (callback) ->
  pg.connect constring, callback

wlaurance

  deleteOne: (key, callback)->
    {time_entry} = TimeEntriesController
    deleteProjectTimeEntries = time_entry.delete().where(time_entry.projectId.equals(key))
    deleteProject = @project.delete().where(@project.id.equals(key))
    deleteUsersProjectsRows = @usersprojects.delete().where(@usersprojects.projectId.equals key)
    t = @transaction()
    start = ->
      async.eachSeries [deleteProjectTimeEntries, deleteUsersProjectsRows, deleteProject],
        (s, cb)->
          t.query s, (err)->