cases.js

var makeShiftForSheet = function (sheet, rowShift, columnShift, props) {
  props = props || {};
  sheet.getRange("A1:E").moveTo(sheet.getRange(1 + rowShift, 1 + columnShift));
  var Fixture = Tamotsu.Table.define(Object.assign({ sheetName: sheet.getName(), rowShift: rowShift, columnShift: columnShift }, props));

  return Fixture;
};

var cases_ = function() {
  module('Table');

  test('define', function() {
    var Fixture1 = Tamotsu.Table.define({ sheetName: 'Agents' });
    strictEqual(Fixture1.sheetName, 'Agents');
    strictEqual(Fixture1.idColumn, '#');
    strictEqual(Fixture1.autoIncrement, true);
    strictEqual(Fixture1.rowShift, 0);
    strictEqual(Fixture1.columnShift, 0);
    
    var Fixture2 = Tamotsu.Table.define({ sheetName: 'No data' });
    strictEqual(Fixture2.sheetName, 'No data');
  });

  test('define with row shift', function () {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents shifted', rowShift: 2, columnShift: 1 });
    strictEqual(Fixture.rowShift, 2);
    strictEqual(Fixture.columnShift, 1);
  });

  test('define with class properties', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents', something: 'Something' });
    strictEqual(Fixture.something, 'Something');
  });

  test('define with instance properties', function() {
    var Fixture = Tamotsu.Table.define({
      sheetName: 'Agents',
    }, {
      fullName: function() {
        return this['First Name'] + ' ' + this['Last Name'];
      },
    });
    var fixture = Fixture.first();
    strictEqual(fixture.fullName(), 'Charles Bartowski');
  });

  test('define with a sheet having a column named "class"', function() {
    var Fixture = Tamotsu.Table.define({
      sheetName: 'class',
    });
    var fixture = Fixture.first();
    strictEqual(fixture['class'], '');
  });
  
  test('define with a sheet having non-autoincrement id', function() {
    withRollback_('String id', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName(), autoIncrement: false });
      var fixture = Fixture.create({ '#': 'ccc', 'Food': 'Tempura' });
      strictEqual(fixture['#'], 'ccc');
      strictEqual(fixture['Food'], 'Tempura');
    });
  });
  
  test('baseRange', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    deepEqual(Fixture.baseRange().getA1Notation(), 'A1');
  });
  
  test('baseRange with row & column shift', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents shifted', rowShift: 2, columnShift: 1 });
    deepEqual(Fixture.baseRange().getA1Notation(), 'B3');
  });
  
  test('lastRange', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    deepEqual(Fixture.lastRange().getA1Notation(), 'E4');
  });
  
  test('lastRange with row & column shift', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents shifted', rowShift: 2, columnShift: 1 });
    deepEqual(Fixture.lastRange().getA1Notation(), 'F6');
  });
  
  test('columns', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    deepEqual(Fixture.columns(), ['#', 'First Name', 'Last Name', 'Gender', 'Salary']);
  });

  test('columns with row & column shift', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents shifted', rowShift: 2, columnShift: 1 });
    deepEqual(Fixture.columns(), ['#', 'First Name', 'Last Name', 'Gender', 'Salary']);
  });

  test('columns by cache', function() {
    var Fixture1 = Tamotsu.Table.define({ sheetName: 'Agents' });
    var Fixture2 = Tamotsu.Table.define({ sheetName: 'No data' });
    deepEqual(Fixture1.columns(), ['#', 'First Name', 'Last Name', 'Gender', 'Salary']);
    deepEqual(Fixture2.columns(), ['#', 'Attr']);
  });

  test('columnIndexOf', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    deepEqual(Fixture.columnIndexOf('Gender'), 3);
  });

  test('columnABCFor',function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    strictEqual(Fixture.columnABCFor('First Name'), 'B');
  });

  test('first', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixture = Fixture.first();
    strictEqual(fixture['#'], 1);
    strictEqual(fixture['First Name'], 'Charles');
    strictEqual(fixture['Last Name'], 'Bartowski');
    strictEqual(fixture['Gender'], 'Male');
    strictEqual(fixture['Salary'], 100);
    strictEqual(fixture.row_, 2);
  });

  test('first with row & column shift', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents shifted', rowShift: 2, columnShift: 1 });
    var fixture = Fixture.first();
    strictEqual(fixture['#'], 1);
    strictEqual(fixture['First Name'], 'Charles');
    strictEqual(fixture['Last Name'], 'Bartowski');
    strictEqual(fixture['Gender'], 'Male');
    strictEqual(fixture['Salary'], 100);
    strictEqual(fixture.row_, 4);
  });

  test('first with no records', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'No data' });
    strictEqual(Fixture.first(), null);
  });

  test('last', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixture = Fixture.last();
    strictEqual(fixture['#'], 3);
    strictEqual(fixture['First Name'], 'John');
    strictEqual(fixture['Last Name'], 'Casey');
    strictEqual(fixture['Gender'], 'Male');
    strictEqual(fixture['Salary'], 200);
    strictEqual(fixture.row_, 4);
  });

  test('last with row & column shift', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents shifted', rowShift: 2, columnShift: 1 });
    var fixture = Fixture.last();
    strictEqual(fixture['#'], 3);
    strictEqual(fixture['First Name'], 'John');
    strictEqual(fixture['Last Name'], 'Casey');
    strictEqual(fixture['Gender'], 'Male');
    strictEqual(fixture['Salary'], 200);
    strictEqual(fixture.row_, 6);
  });

  test('last with no records', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'No data' });
    strictEqual(Fixture.last(), null);
  });

  test('find', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixture = Fixture.find(2);
    strictEqual(fixture['#'], 2);
    strictEqual(fixture['First Name'], 'Sarah');
    strictEqual(fixture['Last Name'], 'Walker');
    strictEqual(fixture['Gender'], 'Female');
    strictEqual(fixture['Salary'], 300);
    strictEqual(fixture.row_, 3);
  });

  test('find with row & column shift', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents shifted', rowShift: 2, columnShift: 1 });
    var fixture = Fixture.find(2);
    strictEqual(fixture['#'], 2);
    strictEqual(fixture['First Name'], 'Sarah');
    strictEqual(fixture['Last Name'], 'Walker');
    strictEqual(fixture['Gender'], 'Female');
    strictEqual(fixture['Salary'], 300);
    strictEqual(fixture.row_, 5);
  });

  test('find by invalid id', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    try {
      var fixture = Fixture.find(999);
      strictEqual(1, 2); // for failure
    } catch (e) {
      strictEqual(e, 'Record not found [id=999]');
    }
  });

  test('find by not "#" column', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Other id', idColumn: 'id' });
    strictEqual(Fixture.find(3)['country'], 'U.K.');
  });

  test('find by string id', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'String id' });
    strictEqual(Fixture.find('aaa')['Food'], 'Sushi');
  });

  test('all', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    Fixture.all().forEach(function(record, i) {
      strictEqual(record['#'], i + 1);
      strictEqual(record.row_, i + 2);
    });
  });

  test('pluck', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    deepEqual(Fixture.pluck('Last Name'), ['Bartowski', 'Walker', 'Casey']);
  });

  test('sum', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    strictEqual(Fixture.sum('Salary'), 600);
  });

  test('max', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    strictEqual(Fixture.max('Salary'), 300);
  });

  test('min', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    strictEqual(Fixture.min('Salary'), 100);
  });

  test('new', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixture = new Fixture({ 'First Name': 'Devon', 'Last Name': 'Woodcomb', 'Invalid attr': 'ignore it' });
    strictEqual(fixture['First Name'], 'Devon');
    strictEqual(fixture['Last Name'], 'Woodcomb');
    strictEqual(fixture['Gender'], undefined);
    strictEqual(fixture['Invalid attr'], undefined);
  });

  test('validate on', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture1 = Tamotsu.Table.define({ sheetName: sheet.getName() }, {
        validate: function(on) {
          strictEqual(on, 'create');
        },
      });
      Fixture1.create({});

      var Fixture2 = Tamotsu.Table.define({ sheetName: sheet.getName() }, {
        validate: function(on) {
          strictEqual(on, 'update');
        },
      });
      Fixture2.first().save();
    });
  });

  test('validate as save', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({
        sheetName: sheet.getName()
      }, {
        validate: function(on) {
          if (!this['First Name']) this.errors['First Name'] = "can't be blank";
        },
      });
      var fixture = new Fixture();
      strictEqual(fixture.save(), false);
      strictEqual(fixture.errors['First Name'], "can't be blank");
    });
  });

  test('validate as create', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({
        sheetName: sheet.getName()
      }, {
        validate: function(on) {
          if (!this['First Name']) this.errors['First Name'] = "can't be blank";
        },
      });
      strictEqual(Fixture.create({}), false);
    });
  });

  test('validate string id presence', function() {
    withRollback_('String id', function(sheet) {
      var Fixture = Tamotsu.Table.define({
        sheetName: sheet.getName(),
        autoIncrement: false,
      });
      strictEqual(Fixture.create({ 'Food': 'Tempura' }), false);
    });
  });

  test('create', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = Fixture.create({ 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Salary': 0 });
      strictEqual(fixture.row_, 5);
      strictEqual(fixture['#'], 4);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Salary'], 0);
      var values = sheet.getRange('A5:E5').getValues()[0];
      strictEqual(values[0], 4);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], '');
      strictEqual(values[4], 0);
    });
  });

  test('create with row & column shift', function() {
    withRollback_('Agents shifted', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: 'Agents shifted', rowShift: 2, columnShift: 1 });
      var fixture = Fixture.create({ 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Salary': 0 });
      strictEqual(fixture.row_, 7);
      strictEqual(fixture['#'], 4);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Salary'], 0);
      var values = sheet.getRange('B7:F7').getValues()[0];
      strictEqual(values[0], 4);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], '');
      strictEqual(values[4], 0);
    });
  });

  test('create into empty table', function() {
    withRollback_('No data', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = Fixture.create({ 'Attr': 'Test' });
      strictEqual(fixture.row_, 2);
      var values = sheet.getRange('A2:B2').getValues()[0];
      strictEqual(values[0], 1);
      strictEqual(values[1], 'Test');
    });
  });

  test('create with a given id value', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = Fixture.create({ '#': 0, 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Gender': 'Male', 'Salary': 50 });
      strictEqual(fixture.row_, 5);
      strictEqual(fixture['#'], 0);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Gender'], 'Male');
      strictEqual(fixture['Salary'], 50);
      var values = sheet.getRange('A5:E5').getValues()[0];
      strictEqual(values[0], 0);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], 'Male');
      strictEqual(values[4], 50);
    });
  });

  test('batchCreate', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixtures = Fixture.batchCreate([
        { 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Gender': 'Male', 'Salary': 50 },
        { 'First Name': 'Bryce', 'Last Name': 'Larkin', 'Gender': 'Male', 'Salary': 400 },
      ]);
      strictEqual(fixtures[0].row_, 5);
      strictEqual(fixtures[0]['#'], 4);
      strictEqual(fixtures[0]['First Name'], 'Morgan');
      strictEqual(fixtures[0]['Last Name'], 'Grimes');
      strictEqual(fixtures[0]['Gender'], 'Male');
      strictEqual(fixtures[0]['Salary'], 50);
      strictEqual(fixtures[1].row_, 6);
      strictEqual(fixtures[1]['#'], 5);
      strictEqual(fixtures[1]['First Name'], 'Bryce');
      strictEqual(fixtures[1]['Last Name'], 'Larkin');
      strictEqual(fixtures[1]['Gender'], 'Male');
      strictEqual(fixtures[1]['Salary'], 400);
      var values = sheet.getRange('A5:E6').getValues();
      strictEqual(values[0][0], 4);
      strictEqual(values[0][1], 'Morgan');
      strictEqual(values[0][2], 'Grimes');
      strictEqual(values[0][3], 'Male');
      strictEqual(values[0][4], 50);
      strictEqual(values[1][0], 5);
      strictEqual(values[1][1], 'Bryce');
      strictEqual(values[1][2], 'Larkin');
      strictEqual(values[1][3], 'Male');
      strictEqual(values[1][4], 400);
    });
  });

  test('createOrUpdate with a record without id', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = new Fixture({ 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Gender': 'Male', 'Salary': 50 });
      strictEqual(Fixture.createOrUpdate(fixture), fixture);
      strictEqual(fixture.row_, 5);
      strictEqual(fixture['#'], 4);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Gender'], 'Male');
      strictEqual(fixture['Salary'], 50);
      var values = sheet.getRange('A5:E5').getValues()[0];
      strictEqual(values[0], 4);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], 'Male');
      strictEqual(values[4], 50);
    });
  });

  test('createOrUpdate with attributes without id', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var attributes = { 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Gender': 'Male', 'Salary': 50 };
      var fixture = Fixture.createOrUpdate(attributes);
      strictEqual(fixture.row_, 5);
      strictEqual(fixture['#'], 4);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Gender'], 'Male');
      strictEqual(fixture['Salary'], 50);
      var values = sheet.getRange('A5:E5').getValues()[0];
      strictEqual(values[0], 4);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], 'Male');
      strictEqual(values[4], 50);
    });
  });

  test('createOrUpdate with a record with not existing id', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = new Fixture({ '#': 999, 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Gender': 'Male', 'Salary': 50 });
      strictEqual(Fixture.createOrUpdate(fixture), fixture);
      strictEqual(fixture.row_, 5);
      strictEqual(fixture['#'], 999);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Gender'], 'Male');
      strictEqual(fixture['Salary'], 50);
      var values = sheet.getRange('A5:E5').getValues()[0];
      strictEqual(values[0], 999);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], 'Male');
      strictEqual(values[4], 50);
    });
  });

  test('createOrUpdate with attributes with not existing id', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var attributes = { '#': 999, 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Gender': 'Male', 'Salary': 50 };
      var fixture = Fixture.createOrUpdate(attributes);
      strictEqual(fixture.row_, 5);
      strictEqual(fixture['#'], 999);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Gender'], 'Male');
      strictEqual(fixture['Salary'], 50);
      var values = sheet.getRange('A5:E5').getValues()[0];
      strictEqual(values[0], 999);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], 'Male');
      strictEqual(values[4], 50);
    });
  });

  test('createOrUpdate with a record with existing id', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = new Fixture({ '#': 1, 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Gender': 'Male', 'Salary': 50 });
      strictEqual(Fixture.createOrUpdate(fixture), true);
      strictEqual(fixture.row_, 2);
      strictEqual(fixture['#'], 1);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Gender'], 'Male');
      strictEqual(fixture['Salary'], 50);
      var values = sheet.getRange('A2:E2').getValues()[0];
      strictEqual(values[0], 1);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], 'Male');
      strictEqual(values[4], 50);
    });
  });

  test('createOrUpdate with attributes with existing id', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var attributes = { '#': 1, 'First Name': 'Morgan', 'Last Name': 'Grimes', 'Gender': 'Male', 'Salary': 50 };
      strictEqual(Fixture.createOrUpdate(attributes), true);
      var fixture = Fixture.find(1);
      strictEqual(fixture.row_, 2);
      strictEqual(fixture['#'], 1);
      strictEqual(fixture['First Name'], 'Morgan');
      strictEqual(fixture['Last Name'], 'Grimes');
      strictEqual(fixture['Gender'], 'Male');
      strictEqual(fixture['Salary'], 50);
      var values = sheet.getRange('A2:E2').getValues()[0];
      strictEqual(values[0], 1);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], 'Male');
      strictEqual(values[4], 50);
    });
  });

  test('save as create', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = new Fixture({ 'First Name': 'Morgan', 'Last Name': 'Grimes' });
      fixture.save();
      var values = sheet.getRange('A5:E5').getValues()[0];
      strictEqual(values[0], 4);
      strictEqual(values[1], 'Morgan');
      strictEqual(values[2], 'Grimes');
      strictEqual(values[3], '');
      strictEqual(values[4], '');
    });
  });

  test('save as update', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = Fixture.first();
      fixture['First Name'] = 'Devon';
      fixture['Last Name'] = 'Woodcomb';
      fixture.save();
      var values = sheet.getRange('B2:C2').getValues()[0];
      strictEqual(values[0], 'Devon');
      strictEqual(values[1], 'Woodcomb');
    });
  });

  test('update attributes', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = Fixture.first();
      strictEqual(fixture.updateAttributes({ 'First Name': 'Chuck', 'Salary': 500 }), true);
      strictEqual(fixture['#'], 1);
      strictEqual(fixture['First Name'], 'Chuck');
      strictEqual(fixture['Last Name'], 'Bartowski');
      strictEqual(fixture['Gender'], 'Male');
      strictEqual(fixture['Salary'], 500);
      var values = sheet.getRange('A2:E2').getValues()[0];
      strictEqual(values[0], 1);
      strictEqual(values[1], 'Chuck');
      strictEqual(values[2], 'Bartowski');
      strictEqual(values[3], 'Male');
      strictEqual(values[4], 500);
    });
  });

  test('destroy', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = Fixture.first();
      fixture.destroy();
      fixture = Fixture.first();
      strictEqual(2, fixture['#'])
      strictEqual(fixture['First Name'], 'Sarah')
      strictEqual(fixture['Last Name'], 'Walker')
      strictEqual(fixture['Gender'], 'Female')
      strictEqual(fixture['Salary'], 300)
      strictEqual(fixture.row_, 2)
    });
  });

  test('getAttributes', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var attributes = Fixture.first().getAttributes();
    strictEqual(attributes['#'], 1);
    strictEqual(attributes['First Name'], 'Charles');
    strictEqual(attributes['Last Name'], 'Bartowski');
    strictEqual(attributes['Gender'], 'Male');
    strictEqual(attributes['Salary'], 100);
    strictEqual(attributes['row_'], undefined);
  });

  test('where', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixtures = Fixture
        .where(function(agent) { return agent['Gender'] === 'Male'; })
        .all();
    strictEqual(fixtures.length, 2);
    strictEqual(fixtures[0]['First Name'], 'Charles');
    strictEqual(fixtures[1]['First Name'], 'John');
  });

  test('where then get no result', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixtures = Fixture
        .where(function(agent) { return agent['First Name'] === 'Devon'; })
        .all();
    deepEqual(fixtures, []);
  });

  test('where with chained predicates', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixtures = Fixture
        .where(function(agent) { return agent['Gender'] === 'Male'; })
        .where(function(agent) { return agent['First Name'].indexOf('a') > -1; })
        .all();
    strictEqual(fixtures.length, 1);
    strictEqual(fixtures[0]['First Name'], 'Charles');
  });

  test('where with object condition', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixtures = Fixture.where({ 'Gender': 'Male', 'Last Name': 'Bartowski' }).all();
    strictEqual(fixtures.length, 1);
    strictEqual(fixtures[0]['First Name'], 'Charles');
  });

  test('where then pluck', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var genders = Fixture
        .where(function(agent) { return agent['Gender'] === 'Male'; })
        .pluck('Gender');
    strictEqual(genders.length, 2);
    deepEqual(genders, ['Male', 'Male']);
  });

  test('where then sum', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var total = Fixture
        .where(function(agent) { return agent['Gender'] === 'Male'; })
        .sum('Salary');
    strictEqual(total, 300);
  });

  test('where then max', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var total = Fixture
        .where(function(agent) { return agent['Gender'] === 'Male'; })
        .max('Salary');
    strictEqual(total, 200);
  });

  test('where then min', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var total = Fixture
        .where(function(agent) { return agent['Gender'] === 'Male'; })
        .min('Salary');
    strictEqual(total, 100);
  });

  test('where then update', function() {
    withRollback_('Agents', function(sheet) {
      var Fixture = Tamotsu.Table.define({ sheetName: sheet.getName() });
      var fixture = Fixture
          .where(function(agent) { return agent['Gender'] === 'Female'; })
          .all()[0];
      fixture['First Name'] = 'Eleanor';
      fixture['Last Name'] = 'Bartowski';
      fixture.save();
      var values = sheet.getRange('B3:C3').getValues()[0];
      strictEqual(values[0], 'Eleanor');
      strictEqual(values[1], 'Bartowski');
    });
  });

  test('where then get first', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixture = Fixture
        .where(function(agent) { return agent['Gender'] === 'Male'; })
        .first();
    strictEqual(fixture['First Name'], 'Charles');
  });

  test('where then get last', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixture = Fixture
        .where(function(agent) { return agent['Gender'] === 'Male'; })
        .last();
    strictEqual(fixture['First Name'], 'John');
  });

  test('order', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixtures = Fixture
        .order(function(t1, t2) { return t1['Salary'] < t2['Salary'] ? -1 : 1; })
        .all();
    strictEqual(3, fixtures.length);
    strictEqual(fixtures[0]['First Name'], 'Charles');
    strictEqual(fixtures[1]['First Name'], 'John');
    strictEqual(fixtures[2]['First Name'], 'Sarah');
  });

  test('order with string comparator as asc', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixtures = Fixture.order('Salary').all();
    strictEqual(3, fixtures.length);
    strictEqual(fixtures[0]['First Name'], 'Charles');
    strictEqual(fixtures[1]['First Name'], 'John');
    strictEqual(fixtures[2]['First Name'], 'Sarah');
  });

  test('order with string comparator as desc', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixtures = Fixture.order('First Name DESC').all();
    strictEqual(3, fixtures.length);
    strictEqual(fixtures[0]['First Name'], 'Sarah');
    strictEqual(fixtures[1]['First Name'], 'John');
    strictEqual(fixtures[2]['First Name'], 'Charles');
  });
  
  test('order with string comparator as combined', function() {
    var Fixture = Tamotsu.Table.define({ sheetName: 'Agents' });
    var fixtures = Fixture.order('Gender desc, Salary DESC').all();
    strictEqual(3, fixtures.length);
    strictEqual(fixtures[0]['First Name'], 'John');
    strictEqual(fixtures[1]['First Name'], 'Charles');
    strictEqual(fixtures[2]['First Name'], 'Sarah');
  });
};