Table.js

'use strict';


var dynamoose = require('../');
dynamoose.AWS.config.update({
  accessKeyId: 'AKID',
  secretAccessKey: 'SECRET',
  region: 'us-east-1'
});

dynamoose.local();

var Schema = dynamoose.Schema;
var Table = dynamoose.Table;

var should = require('should');


describe('Table tests', function () {
  this.timeout(10000);

  var schema = new Schema({id: Number, name: String, childern: [Number], address: {street: String, city: String}});
  var globalIndexSchema = new Schema({
    ownerId: {
      type: Number,
      validate: function (v) {
        return v > 0;
      },
      hashKey: true
    },
    breed: {
      type: String,
      rangeKey: true,
      index: {
        global: true,
        rangeKey: 'color',
        name: 'BreedGlobalIndex',
        project: true, // ProjectionType: ALL
        throughput: 5 // read and write are both 5
      }
    },
    name: {
      type: String,
      required: true,
      index: {
        global: true,
        name: 'NameGlobalIndex',
        project: true, // ProjectionType: ALL
        throughput: 5 // read and write are both 5
      }
    },
    color: {
      type: String,
      default: 'Brown'
    }
  });

  var table = new Table('person', schema, null, dynamoose);
  var globalIndexTable = new Table('dog', globalIndexSchema, null, dynamoose);

  it('Create simple table', function (done) {

    table.create(function (err) {
      should.not.exist(err);
      done();
    });
  });

  it('Describe simple table', function (done) {

    table.describe(function (err, data) {
      should.not.exist(err);
      should.exist(data);
      done();
    });
  });

  it('Delete simple table', function (done) {

    table.delete(function (err, data) {
      should.not.exist(err);
      should.exist(data);
      done();
    });
  });

  it('Describe missing table', function (done) {
    var missing = new Table('missing', schema, null, dynamoose);


    missing.describe(function (err, data) {
      should.exist(err);
      should.not.exist(data);
      err.code.should.eql('ResourceNotFoundException');
      done();
    });
  });

  it('Create table with global index with non indexed range key', function (done) {

    globalIndexTable.create(function (err) {
      should.not.exist(err);
      done();
    });
  });

  it('Delete table with global index', function (done) {

    globalIndexTable.delete(function (err, data) {
      should.not.exist(err);
      should.exist(data);
      done();
    });
  });

  it('create DMSong with limited projection', function (done) {
    var Song = dynamoose.model('DMSong', {
      id: {
        type: Number,
        required: true,
        hashKey: true,
      },
      band: {
        type: String,
        required: true,
        trim: true
      },
      album: {
        type: String,
        required: true,
        trim: true,
        index: {
          global: true,
          rangeKey: 'id',
          name: 'albumIndex',
          project: ['band', 'album'],
          throughput: 5 // read and write are both 5
        }
      },
      song: {
        type: String,
        required: true,
        trim: true,
        index: {
          global: true,
          rangeKey: 'id',
          name: 'songIndex',
          project: true, // ProjectionType: ALL
          throughput: 5 // read and write are both 5
        }
      },
      track: {
        type: Number,
        required: false,
      }
    },
    {
      create: true, update: true
    });
    var tom_sawyer = new Song({id: 1, band: 'Rush', album: 'Moving Pictures', song: 'Tom Sawyer', track: 1});
    tom_sawyer.save();
    var params = {TableName: 'DMSong'};
    setTimeout(function() {
      dynamoose.ddb().describeTable(params, function (err, data) {
        if (err) {
          done(err);
        }
        else {
          var found = false;
          for (var i in data.Table.GlobalSecondaryIndexes) {
            var gsi = data.Table.GlobalSecondaryIndexes[i];
            if (gsi.IndexName === 'albumIndex') {
              should.equal(gsi.Projection.ProjectionType, 'INCLUDE');
              found = true;
            }
          }
          should.equal(found, true);
          delete dynamoose.models.DMSong;
          done();
        }
      });
    }, 2000);
  });
  it('update DMSong with broader projection', function (done) {
    var Song = dynamoose.model('DMSong', {
      id: {
        type: Number,
        required: true,
        hashKey: true,
      },
      band: {
        type: String,
        required: true,
        trim: true
      },
      album: {
        type: String,
        required: true,
        trim: true,
        index: {
          global: true,
          rangeKey: 'id',
          name: 'albumIndex',
          project: true, // ProjectionType: ALL
          throughput: 5 // read and write are both 5
        }
      },
      song: {
        type: String,
        required: true,
        trim: true,
        index: {
          global: true,
          rangeKey: 'id',
          name: 'songIndex',
          project: true, // ProjectionType: ALL
          throughput: 5 // read and write are both 5
        }
      },
      track: {
        type: Number,
        required: false,
      }
    },
    {
      create: true,
      update: true,
      waitForActive: true
    });

    var red_barchetta = new Song({id: 2, band: 'Rush', album: 'Moving Pictures', song: 'Red Barchetta', track: 2});
    red_barchetta.save();

    var params = {TableName: 'DMSong'};
    setTimeout(function() {
      dynamoose.ddb().describeTable(params, function (err, data) {
        if (err) {
          done(err);
        }
        else {
          // console.log("---------------------REVISED TABLE");
          // console.log(JSON.stringify(data, null, 2));
          var found = false;
          for (var i in data.Table.GlobalSecondaryIndexes) {
            var gsi = data.Table.GlobalSecondaryIndexes[i];
            if (gsi.IndexName === 'albumIndex') {
              should.equal(gsi.Projection.ProjectionType, 'ALL');
              found = true;
            }
          }
          should.equal(found, true);
          done();
        }
      });
    }, 2000);
  });
});