Add mapsTo test

dxg · dxg · commit a6f458ba5307 · 2014-05-07T21:35:05.000+10:00
diff --git a/test/integration/model-get.js b/test/integration/model-get.js
@@ -1,7 +1,9 @@
+var _        = require('lodash');
 var should   = require('should');
 var helper   = require('../support/spec_helper');
 var common   = require('../common');
 var ORM      = require('../../');
+var protocol = common.protocol();
 
 describe("Model.get()", function() {
 	var db     = null;
@@ -11,7 +13,7 @@ describe("Model.get()", function() {
 	var setup = function (cache) {
 		return function (done) {
 			Person = db.define("person", {
-				name   : String
+				name   : { type: 'text', mapsTo: 'fullname' }
 			}, {
 				cache  : cache,
 				methods: {
@@ -49,6 +51,33 @@ describe("Model.get()", function() {
 		return db.close();
 	});
 
+	describe("mapsTo", function () {
+		if (protocol == 'mongodb') return;
+
+		before(setup(true));
+
+		it("should create the table with a different column name than property name", function (done) {
+			var sql;
+
+			if (protocol == 'sqlite') {
+				sql = "PRAGMA table_info(?)";
+			} else {
+				sql = "SELECT column_name FROM information_schema.columns WHERE table_name = ?";
+			}
+
+			db.driver.execQuery(sql, [Person.table], function (err, data) {
+				should.not.exist(err);
+
+				var names = _.pluck(data, protocol == 'sqlite' ? 'name' : 'column_name')
+
+				should.equal(typeof Person.properties.name, 'object');
+				should.notEqual(names.indexOf('fullname'), -1);
+
+				done();
+			});
+		});
+	});
+
 	describe("with cache", function () {
 		before(setup(true));
 
