query.create.js 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370
  1. var assert = require('assert');
  2. var Waterline = require('../../../lib/waterline');
  3. describe('Collection Query ::', function() {
  4. describe('.create()', function() {
  5. describe('with Auto values', function() {
  6. var query;
  7. before(function(done) {
  8. var waterline = new Waterline();
  9. var Model = Waterline.Model.extend({
  10. identity: 'user',
  11. datastore: 'foo',
  12. primaryKey: 'id',
  13. fetchRecordsOnCreate: true,
  14. attributes: {
  15. id: {
  16. type: 'number'
  17. },
  18. first:{
  19. type: 'string',
  20. defaultsTo: 'Foo'
  21. },
  22. second: {
  23. type: 'string',
  24. defaultsTo: 'Bar'
  25. },
  26. name: {
  27. type: 'string',
  28. defaultsTo: 'Foo Bar'
  29. },
  30. createdAt: {
  31. type: 'number',
  32. autoCreatedAt: true
  33. },
  34. updatedAt: {
  35. type: 'number',
  36. autoUpdatedAt: true
  37. }
  38. }
  39. });
  40. waterline.registerModel(Model);
  41. // Fixture Adapter Def
  42. var adapterDef = { create: function(con, query, cb) { query.newRecord.id = 1; return cb(null, query.newRecord); }};
  43. var connections = {
  44. 'foo': {
  45. adapter: 'foobar'
  46. }
  47. };
  48. waterline.initialize({ adapters: { foobar: adapterDef }, datastores: connections }, function(err, orm) {
  49. if (err) {
  50. return done(err);
  51. }
  52. query = orm.collections.user;
  53. return done();
  54. });
  55. });
  56. it('should set default values', function(done) {
  57. query.create({id: 1}, function(err, status) {
  58. if (err) {
  59. return done(err);
  60. }
  61. assert.equal(status.name, 'Foo Bar');
  62. return done();
  63. });
  64. });
  65. it('should set default values when the value is undefined', function(done) {
  66. query.create({ first: undefined }, function(err, status) {
  67. if (err) {
  68. return done(err);
  69. }
  70. assert.equal(status.first, 'Foo');
  71. return done();
  72. });
  73. });
  74. it('should add timestamps', function(done) {
  75. query.create({}, function(err, status) {
  76. if (err) {
  77. return done(err);
  78. }
  79. assert(status.createdAt);
  80. assert(status.updatedAt);
  81. return done();
  82. });
  83. });
  84. it('should set values', function(done) {
  85. query.create({ name: 'Bob' }, function(err, status) {
  86. if (err) {
  87. return done(err);
  88. }
  89. assert.equal(status.name, 'Bob');
  90. return done();
  91. });
  92. });
  93. it('should strip values that don\'t belong to the schema', function(done) {
  94. query.create({ foo: 'bar' }, function(err, values) {
  95. if (err) {
  96. return done(err);
  97. }
  98. assert(!values.foo);
  99. return done();
  100. });
  101. });
  102. it('should allow a query to be built using deferreds', function(done) {
  103. query.create({ name: 'bob' })
  104. .exec(function(err, result) {
  105. if (err) {
  106. return done(err);
  107. }
  108. assert(result);
  109. return done();
  110. });
  111. });
  112. });
  113. describe('override and disable auto values', function() {
  114. var query;
  115. before(function(done) {
  116. var waterline = new Waterline();
  117. var Model = Waterline.Model.extend({
  118. identity: 'user',
  119. datastore: 'foo',
  120. primaryKey: 'id',
  121. fetchRecordsOnCreate: true,
  122. attributes: {
  123. id: {
  124. type: 'number'
  125. },
  126. name: {
  127. type: 'string',
  128. defaultsTo: 'Foo Bar'
  129. }
  130. }
  131. });
  132. waterline.registerModel(Model);
  133. // Fixture Adapter Def
  134. var adapterDef = { create: function(con, query, cb) { query.newRecord.id = 1; return cb(null, query.newRecord); }};
  135. var connections = {
  136. 'foo': {
  137. adapter: 'foobar'
  138. }
  139. };
  140. waterline.initialize({ adapters: { foobar: adapterDef }, datastores: connections }, function(err, orm) {
  141. if(err) {
  142. return done(err);
  143. }
  144. query = orm.collections.user;
  145. return done();
  146. });
  147. });
  148. it('should NOT add timestamps', function(done) {
  149. query.create({}, function(err, status) {
  150. if (err) {
  151. return done(err);
  152. }
  153. assert(!status.createdAt);
  154. assert(!status.updatedAt);
  155. return done();
  156. });
  157. });
  158. });
  159. describe('override auto values with custom names', function() {
  160. var query;
  161. before(function(done) {
  162. var waterline = new Waterline();
  163. var Model = Waterline.Model.extend({
  164. identity: 'user',
  165. datastore: 'foo',
  166. primaryKey: 'id',
  167. fetchRecordsOnCreate: true,
  168. attributes: {
  169. id: {
  170. type: 'number'
  171. },
  172. name: {
  173. type: 'string',
  174. defaultsTo: 'Foo Bar'
  175. },
  176. customCreatedAt: {
  177. type: 'number',
  178. autoCreatedAt: true
  179. },
  180. customUpdatedAt: {
  181. type: 'number',
  182. autoUpdatedAt: true
  183. }
  184. }
  185. });
  186. waterline.registerModel(Model);
  187. // Fixture Adapter Def
  188. var adapterDef = { create: function(con, query, cb) { query.newRecord.id = 1; return cb(null, query.newRecord); }};
  189. var connections = {
  190. 'foo': {
  191. adapter: 'foobar'
  192. }
  193. };
  194. waterline.initialize({ adapters: { foobar: adapterDef }, datastores: connections }, function(err, orm) {
  195. if (err) {
  196. return done(err);
  197. }
  198. query = orm.collections.user;
  199. return done();
  200. });
  201. });
  202. it('should add timestamps with a custom name', function(done) {
  203. query.create({}, function(err, status) {
  204. if (err) {
  205. return done(err);
  206. }
  207. assert(!status.createdAt);
  208. assert(!status.updatedAt);
  209. assert(status.customCreatedAt);
  210. assert(status.customUpdatedAt);
  211. return done();
  212. });
  213. });
  214. });
  215. describe('cast proper values', function() {
  216. var query;
  217. before(function(done) {
  218. var waterline = new Waterline();
  219. var Model = Waterline.Model.extend({
  220. identity: 'user',
  221. datastore: 'foo',
  222. primaryKey: 'id',
  223. fetchRecordsOnCreate: true,
  224. attributes: {
  225. id: {
  226. type: 'number'
  227. },
  228. name: {
  229. type: 'string'
  230. },
  231. age: {
  232. type: 'number'
  233. }
  234. }
  235. });
  236. waterline.registerModel(Model);
  237. // Fixture Adapter Def
  238. var adapterDef = { create: function(con, query, cb) { query.newRecord.id = 1; return cb(null, query.newRecord); }};
  239. var connections = {
  240. 'foo': {
  241. adapter: 'foobar'
  242. }
  243. };
  244. waterline.initialize({ adapters: { foobar: adapterDef }, datastores: connections }, function(err, orm) {
  245. if (err) {
  246. return done(err);
  247. }
  248. query = orm.collections.user;
  249. return done();
  250. });
  251. });
  252. it('should cast values before sending to adapter', function(done) {
  253. query.create({ name: 'foo', age: '27' }, function(err, values) {
  254. if (err) {
  255. return done(err);
  256. }
  257. assert.equal(values.name, 'foo');
  258. assert.equal(values.age, 27);
  259. return done();
  260. });
  261. });
  262. });
  263. describe('with schema set to false', function() {
  264. var query;
  265. before(function(done) {
  266. var waterline = new Waterline();
  267. var Model = Waterline.Model.extend({
  268. identity: 'user',
  269. datastore: 'foo',
  270. schema: false,
  271. primaryKey: 'id',
  272. fetchRecordsOnCreate: true,
  273. attributes: {
  274. id: {
  275. type: 'number'
  276. }
  277. }
  278. });
  279. waterline.registerModel(Model);
  280. // Fixture Adapter Def
  281. var adapterDef = {
  282. create: function(con, query, cb) { query.newRecord.id = 1; return cb(null, query.newRecord); },
  283. createEach: function(con, query, cb) { return cb(null); }
  284. };
  285. var connections = {
  286. 'foo': {
  287. adapter: 'foobar'
  288. }
  289. };
  290. waterline.initialize({ adapters: { foobar: adapterDef }, datastores: connections }, function(err, orm) {
  291. if (err) {
  292. return done(err);
  293. }
  294. query = orm.collections.user;
  295. return done();
  296. });
  297. });
  298. it('should allow arbitratry values to be set', function(done) {
  299. query.create({ name: 'foo' }, function(err, record) {
  300. if (err) {
  301. return done(err);
  302. }
  303. assert.equal(record.name, 'foo');
  304. return done();
  305. });
  306. });
  307. it('should not be detructive to passed-in arrays', function(done) {
  308. var myPreciousArray = [{ name: 'foo', age: '27' }];
  309. query.createEach(myPreciousArray, function(err) {
  310. if (err) {
  311. return done(err);
  312. }
  313. assert.equal(myPreciousArray.length, 1);
  314. return done();
  315. });
  316. });
  317. });
  318. });
  319. });