<script src="localDB.js"></script>

  localDB.schema("users", ["id", "username", "email", "age"]);
  localDB.schema("posts", ["title", "description", "userID"]);

  localDB.add("users", {
    id: 1
    username: "Max",
    email: "[email protected]",
    age: 34
  });

  localDB.remove('users', {is: {username: "max"}});
  
  //{is: {}} is like "==="
  //{not :{}} is like "!=="
  //{gt :{}} is like ">"
  //{gte :{}} is like ">="
  //{lt :{}} is like "<="
  //{lte :{}} is like "<="
  //{has :{arr: 32}} search for field in an array
  
  

  localDB.update('users', {is: {username: "max"}}, {set: {age: 35 } );
  
  //if you have an array item you can use pull or push method
  localDB.update('users', {is: {username: "max"}}, {push: {arr: 34}} );
  localDB.update('users', {is: {username: "max"}}, {pull: {arr: 34}} );
  

  var cursor = localDB.find('users', {is: {username: 'max'}});
  //var cursor = localDB.find('users', {gt: {age: 30}});
  
  //find method return cursor object that contain this methods:
  cursor.count() //return number of your items
  cursor.fetch() // return an array
  cursor.limit() // limit(0, 5) return just five items
  cursor.where({not: {username: 'max'}}) // return cursor object
  
  

  localDB.watch('add', function(obj, colname){
    //
  });
  
  localDB.watch('remove', function(obj, colname){
    //
  });
   
  localDB.watch('update', function(obj, colname){
    //
  });
  

  localDB.empty(users);
  

  localDB.collections();