// creates a simple foam class
foam.CLASS({
  name: 'Guitar',
  properties: [ 'id', 'name', 'color', 'brand', 'price' ]
});

// an array of Guitars
var guitarArray = foam.dao.ArrayDAO.create();

guitarArray.put(Guitar.create({
  id: 1,
  color: 'black',
  brand: 'fender',
  name: 'dave murray signature',
  price: 2000
}));

guitarArray.put(Guitar.create({
  id: 2,
  color: 'sunburst',
  brand: 'fender',
  name: 'clapton signature',
  price: 2400
}));

guitarArray.put(Guitar.create({
  id: 3,
  color: 'white',
  brand: 'fender',
  name: 'hendrix signature',
  price: 2700
}));

guitarArray.put(Guitar.create({
  id: 4,
  color: 'appetite amber',
  brand: 'gibson',
  name: 'slash',
  price: 5000
}));

guitarArray.put(Guitar.create({
  id: 5,
  color: 'red',
  brand: 'seizi',
  name: 'seizi one',
  price: 900
}));

// creates a memory persistence(MDAO) layer for the Guitars class.
var guitarDAO = foam.dao.MDAO.create({ of: Guitar });

// IndexedDB DAO
// guitarDAO = foam.dao.IDBDAO.create({model: Guitar});

// Local-storage DAO
// guitarDAO = foam.dao.StorageDAO.create({ model: Guitar });

// An IndexedDB DAO Cached in an in-memory DAO
// guitarDAO = foam.dao.CachingDAO.create(foam.dao.MDAO.create({ of: Guitar }), foam.dao.IDBDAO.create({ of: Guitar }));

// load the array of guitars into our memory database (MDAO)
guitarDAO.bulkLoad(guitarArray);

// we declare mLang here, the foam "modelled language"
// in simple terms, mlang is foam's own "SQL syntax"
// it's used to filter and manipulate DAO operations.
// https://github.com/foam-framework/foam2/blob/master/src/foam/mlang/mlang.js
var expr = foam.mlang.Expressions.create();

// returns all the guitars
guitarDAO
.select() 
// when a "sink" function isn't provided, FOAM defaults it to an ArraySink
// which puts the results in a "a" prop 
.then(function(db) {
  console.log('count: ', db.array.length);
  console.log('count: ', db.array[0].price);
});

// counts the guitars 
// short-circuits it and returns only the count number
guitarDAO
.select(expr.COUNT())
.then(function(count) {
  console.log('count: ', count.value);
});

// give me all gibsons
guitarDAO
.where(expr.EQ(Guitar.BRAND, 'gibson'))
.select()
.then(function(guitars) {
  console.log('gibsons count: ', guitars.array.length);
  console.log(guitars.array[0].name);
});

// give me all gibsons or seizis using OR
guitarDAO.where(expr.OR(expr.EQ(Guitar.BRAND, 'seizi'), expr.EQ(Guitar.BRAND, 'gibson')))
.select()
.then(function(guitars) {
  console.log('seizi or gibsons count: ', guitars.array.length);
});

// give me all gibsons or fenders using IN
guitarDAO.where(expr.IN(Guitar.BRAND, ['gibson', 'fender']))
.select()
.then(function(guitars) {
  console.log(guitars.array.length);
});

// give me all fenders with a price below 2500
guitarDAO
.where(expr.AND(expr.LT(Guitar.PRICE, 2500), expr.EQ(Guitar.BRAND, 'fender')))
.select()
.then(function(guitars) {
  console.log(guitars.array.length);
});

// give me all guitars where brand starts with `g` or name starts with `s`
guitarDAO.where(expr.OR(expr.STARTS_WITH(Guitar.BRAND, 'g'), expr.STARTS_WITH(Guitar.NAME, 's')))
.select()
.then(function(guitars) {
  console.log(guitars.array.length);
});

// using contains
guitarDAO.where(expr.CONTAINS(Guitar.NAME, 'sh'))
.select()
.then(function(guitars) {
  console.log(guitars.array.length); // 1 , slash
});

// using contains_ic (ignoring case)
guitarDAO.where(expr.CONTAINS_IC(Guitar.NAME, 'SH'))
.select()
.then(function(guitars) {
  console.log(guitars.array.length); // 1 , slash
});

// give me all fenders and order by price

// this is a custom sink function
// this function will be applied on each guitar instance.
var sinkFn = function (guitar) { console.log(guitar.price) }

guitarDAO.where(expr.EQ(Guitar.BRAND, 'fender'))
.orderBy(expr.DESC(Guitar.PRICE))
.select({ put: sinkFn })
.then();

// give me only two guitars
guitarDAO.limit(2)
.select()
.then(function(g) {
  console.log(g.array.length);
});

// give me only two guitars
// and sum their prices
guitarDAO
.limit(2)
.select(expr.SUM(Guitar.PRICE))
.then(function(prices) {
  console.log(prices.value);
});

// sums all guitars prices
guitarDAO.select(expr.SUM(Guitar.PRICE))
.then(function(g) {
  console.log(g.value);
});

// returns the most expensive guitar
guitarDAO.select(expr.MAX(Guitar.PRICE))
.then(function(g) {
  console.log(g.value);
});

// returns the cheapest guitar
guitarDAO.select(expr.MIN(Guitar.PRICE))
.then(function(g) {
  console.log(g.value);
});

// TimingDAO extends the ProxyDAO which require us to setup a delegated class.
// it adds timing functionality to specific DAO operations.
// ie: time spent in a "select()" operation.

var timing = foam.dao.TimingDAO.create({ name: 'guitar-timer', delegate: guitarDAO });

// time spent in a default ArraySink select()
timing.select().then();
// Timing:  timer-guitar-select   0.445  ms