var cassandrom = require('cassandrom');

cassandrom.createConnection({ contactPoints: [
  'localhost'
  // , 'another-host',
  ], localDataCenter: 'datacenter1', keyspace: 'keyspace'});

var schema = new cassandrom.Schema({
  userId:   { type: cassandrom.UUIDType, required: true, default: cassandrom.uuid },
  fullName: { type: String, required: true, trim: true },
  username: { type: String, required: true, unique: true, trim: true },
  email:    { type: String, required: true, unique: true, trim: true },
  password: { type: String, required: true },
  date:     { type: Date, default: Date.now, required: true }

}, ['userId']);

var User = cassandrom.model("User", schema);

User.create({
  fullName: 'John Doe',
  username: 'john',
  email: 'john@doe.com',
  password: 'doedoe'
}, function (error, user) {
  if(error) {
    console.log('Error during user save: ' + error);
  } else {
    console.log('User saved ' + user.userId + ' date ' + user.date);
  }
});

User.find({ username: name }, function(error, results) {
  console.log('Find ' + results.length + ' users');
});

User.findOne({ username: name }, function(error, user) {
  console.log('Find found ' + user);
});

schema.statics.findByUserame = function(name, callback) {
  this.findOne({ username: name }, callback);
};

schema.statics.findById = function(id, callback) {
  this.findOne({ userId: id }, callback);
};

User.findOne({ username: name })
    .then(function(user)) {

    }
    .catch(function(error) {

    });

const user = await aUser.findOne({ username: name });