123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372 |
- describe('dateValidator', () => {
- var id = 'testContainer';
- beforeEach(function() {
- this.$container = $(`<div id="${id}"></div>`).appendTo('body');
- });
- afterEach(function() {
- if (this.$container) {
- destroy();
- this.$container.remove();
- }
- });
- var arrayOfObjects = function() {
- return [
- {date: '01/01/2015', name: 'Ted', lastName: 'Right'},
- {date: '01/01/15', name: 'Frank', lastName: 'Honest'},
- {date: '41/01/2015', name: 'Joan', lastName: 'Well'},
- {date: '01/51/2015', name: 'Sid', lastName: 'Strong'}
- ];
- };
- it('should validate an empty string (default behavior)', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date'},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(0, 0, '');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(true, '', 0, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should rewrite an ISO 8601 string to the correct format if a date-string in different format is provided', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'MM/DD/YYYY', correctFormat: true},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '2016-03-18');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(true, '2016-03-18', 1, 'date', undefined, undefined);
- }, 100);
- setTimeout(() => {
- expect(getDataAtCell(1, 0)).toEqual('03/18/2016');
- done();
- }, 130);
- });
- it('should not positively validate a non-date string', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date'},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(0, 0, 'wat');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, 'wat', 0, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should not positively validate a incorrect date string', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date'},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(0, 0, '33/01/2014');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, '33/01/2014', 0, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should not positively validate a date string in wrong format', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date'},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '01/01/15');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, '01/01/15', 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should not positively validate a date string in wrong format (if custom format is provided)', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'DD/MM/YY'},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '01/01/2015');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, '01/01/2015', 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should positively validate a date string in correct format', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date'},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '01/01/2015');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(true, '01/01/2015', 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should positively validate a date string in correct format (if custom format is provided)', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'DD/MM/YY'},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '23/03/15');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(true, '23/03/15', 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- describe('allowEmpty', () => {
- it('should not validate an empty string when allowEmpty is set as `false`', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'DD/MM/YY', allowEmpty: false},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, '', 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should not validate `null` when allowEmpty is set as `false`', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'DD/MM/YY', allowEmpty: false},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, null);
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, null, 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should not validate `undefined` when allowEmpty is set as `false`', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'DD/MM/YY', allowEmpty: false},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, void 0);
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, void 0, 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- });
- describe('correctFormat', () => {
- it('should not make any changes to entered string if correctFormat is not set', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'MM/DD/YY'},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '11/23/2013');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, '11/23/2013', 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should not make any changes to entered string if correctFormat is set to false', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'MM/DD/YY', correctFormat: false},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '11/23/2013');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, '11/23/2013', 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- it('should rewrite the string to the correct format if a date-string in different format is provided', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'MM/DD/YYYY', correctFormat: true},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '1/10/15');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(true, '1/10/15', 1, 'date', undefined, undefined);
- }, 100);
- setTimeout(() => {
- expect(getDataAtCell(1, 0)).toEqual('01/10/2015');
- done();
- }, 130);
- });
- it('should rewrite the string to the correct format if a date-string in different format is provided (for non-default format)', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'DD.MM.YYYY', correctFormat: true},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, '5.3.2016');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(true, '5.3.2016', 1, 'date', undefined, undefined);
- }, 100);
- setTimeout(() => {
- expect(getDataAtCell(1, 0)).toEqual('05.03.2016');
- done();
- }, 130);
- });
- it('should not try to correct format of non-date strings', (done) => {
- var onAfterValidate = jasmine.createSpy('onAfterValidate');
- handsontable({
- data: arrayOfObjects(),
- columns: [
- {data: 'date', type: 'date', dateFormat: 'DD/MM/YY', correctFormat: true},
- {data: 'name'},
- {data: 'lastName'}
- ],
- afterValidate: onAfterValidate
- });
- setDataAtCell(1, 0, 'test non-date string');
- setTimeout(() => {
- expect(onAfterValidate).toHaveBeenCalledWith(false, 'test non-date string', 1, 'date', undefined, undefined);
- done();
- }, 100);
- });
- });
- });
|