where to add prefixes to tables?

[calidion]

where to add prefixes to tables?

[dresende]

You mean a generic prefix?

[calidion]

for example.

i have a range of test models in the same database.

for the same model user, i can test different sets with the only need to change the prefix.

for

models.setPrefix("pre_");

models.define('user')
,
table pre_user will be visited

if i use
models.setPrefix('aaa__');
models.define('user')
then
aaa_user will be visited.

[dresende]

Ok, this can be an option. If I understood, you need something like:

var orm = require("orm");

orm.connect("....", function (err, db) {
    db.settings.set("models.namePrefix", "pre_"); // not sure the settings name is this

    var Person1 = db.define("person", { // will use table "pre_person"
        // ...
    });

    // ...

    db.settings.unset("models.namePrefix");

    var Person2 = db.define("person", { // will use table "person"
        // ...
    });
});

[calidion]

yes, it works now?

[dresende]

No but I'll do it :)

[dresende]

The setting name is actually model.namePrefix. Please try it.

[calidion]

great! but after npm update, it seems the package not updated yet.

[dresende]

Yes, I need to close some things before publishing a new version. For now you might want to try:

npm install dresende/node-orm2

It should fetch directly from github.

[calidion]

thanks, i will wait for your update:)