id column is mandatory - Githubissues

coresmart / persistencejs

persistence.js is an asynchronous Javascript database mapper library. You can use it in the browser, as well on the server (and you can share data models between them).

1.72k stars 240 forks source link

I'm trying a simple task of extracting an identity from a table. That table doesn't have an id column(it's key column is called Key). Persistence generates sql that expects the id column and then fails.

var File = persistence.define('Components', {
    Key: 'TEXT',
    Published: 'TEXT'
});

//...

File.findBy(session, tx, 'Key', sha, function(obj) { ... });

Results in the sql:

SELECT `root`.id AS Components_id, `root`.`Key` AS `Components_Key`, `root`.`Published` AS `Components_Published`
FROM `Components` AS `root`  WHERE (1=1 AND `root`.`Key` = ?) LIMIT 1

Is there any way to suppress the selection of an id column?

coresmart / persistencejs

id column is mandatory #27