var OrientDB = require("orientjs");

var server = OrientDB({
 host: 'localhost',
 port: 2424,
 username: 'root',
 password: 'root',
 servers : [{host : 'localhost', port : 2424}]
});

var database;

createTestDb(server,"test","memory")
.then(function(db){
	database = db;
})
.then(function(){
	return database.createFn("getList",function(name){

		return db.query('select from OUser where name = ?',name)
	});
})
.then(function(){
	return database.query('select getList(:name)', { params : { name : 'admin'}});
})
.then(function(res){
	console.log(res);
	console.log(JSON.stringify(res));
	return deleteTestDb(server,"test","memory");
})
.then(function(){
	server.close();
})






function deleteTestDb(server, name, type) {
  type = type || 'memory';
  return server.exists(name, type)
    .then(function (exists) {
      if (exists) {
        return server.drop({
          name: name,
          storage: type
        });
      }
      else {
        return undefined;
      }
    })
    .then(function () {
      return undefined;
    });
}

function createTestDb(server, name, type) {
  type = type || 'memory';
  return server.exists(name, type)
    .then(function (exists) {
      if (exists) {
        return server.drop({
          name: name,
          storage: type
        });
      }
      else {
        return false;
      }
    })
    .then(function () {
      return server.create({
        name: name,
        type: 'graph',
        storage: type
      });
    })
    .then(function (db) {
      return db;
    });
}