Blueprint Issues On Non String Types for Put/Delete Methods Error around lower

arlewis2015 commented 7 years ago

All, I believe that an issue still exists up to the latest version V0.12.2 of the library which has the following dependencies(waterline-sequal 0.6.4) . Using Node 6.9.1

Error on attempting to put/delete with Postgres type of UUID or bigint for example cause the following exception message: error: function lower(bigint) does not exist error: function lower(uuid) does not exist

This seems to be the case for any type except String from the database perspective.

I can get the put/delete to work if the database type is set to explicit text/string datatype. Example:Connection

   somePostgresqlServer: {
     adapter: 'sails-postgresql',
     host: 'localhost',
     user: 'test', // optional
     password: 'test1!', // optional
     database: 'Demo', //optional
     caseSensitive :false,
      wlNext: {
    caseSensitive: false
  }
   }

An example model:

/***
* Tests
*
* @description :: TODO: You might write a short summary of how this model works and what it represents here.
* @docs        :: http://sailsjs.org/documentation/concepts/models-and-orm/models
***/
module.exports = {
connection: 'somePostgresqlServer',
tableName:'test',
autoUpdatedAt:false,
autoCreatedAt:false,
autoPk:false,
attributes: {
id:{type:'string',primaryKey:true,
defaultsTo:function() {

return('13dc4b34-6e9f-42c0-9544-d6853776371b');
   }
   },
name:{type:'string'}

}
};

Any thoughts??

sailsbot commented 7 years ago

@arlewis2015 Thanks for posting, we'll take a look as soon as possible. In the meantime, if you haven’t already, please carefully read the issue contribution guidelines and double-check for any missing information above. In particular, please ensure that this issue is about a stability or performance bug with a documented feature; and make sure you’ve included detailed instructions on how to reproduce the bug from a clean install. Finally, don’t forget to include the version of Node.js you tested with, as well as your version of Sails or Waterline, and of any relevant standalone adapters/generators/hooks.

Thank you!

sailsbot commented 7 years ago

@arlewis2015,@sailsbot: Hello, I'm a repo bot-- nice to meet you!

It has been 30 days since there have been any updates or new comments on this page. If this issue has been resolved, feel free to disregard the rest of this message and simply close the issue if possible. On the other hand, if you are still waiting on a patch, please post a comment to keep the thread alive (with any new information you can provide).

If no further activity occurs on this thread within the next 3 days, the issue will automatically be closed.

Thanks so much for your help!

sgress454 commented 7 years ago

Closing this as a dup of #256

balderdashy / sails

Blueprint Issues On Non String Types for Put/Delete Methods Error around lower #5044