MySQL Utilities

mysql.coffee

fs          = require "fs"
Client      = require("mysql").Client

createClient = ->
  client            = new Client()
  client.user       = "user"
  client.password   = "password"
  client.database   = "database"

  client

select = (query, parameters, callback) ->
  client = createClient()
  client.connect ->
    client.query query, parameters, (error, results, fields) ->
      throw error if error
      callback results, fields
      client.end()

queries = {}
for file in fs.readdirSync __dirname + "/../queries"
  queries[file] = fs.readFileSync __dirname + "/../queries/" + file , "utf8"

orders.eco

<% @select @queries.orders, [ @cusomterId ], (results) -> : %>
  <% for order in results: %>
    <div>Order Id: <%= order.id %></div>
    <% @select @queries.orderItems, [ order.id ], (results) -> : %>
      <% for item in results: %>
        <p><%= item.quantity %> of <%= item.productDescription %></p>
      <% end %>
    <% end %>
  <% end %>
<% end %>