Any way for converting SQL to node-orm2 Model

[hoseinmobasher]

Hello,
I am beginner in node-orm2. I want to know any way to convert my sql table code to node-orm2 model.

Please introduce a way to convert? Should i do it with self programming, or node-orm2 has any tools.

Cheers,
Hossein

[dresende]

It does not have any tools yet to do it. You always have to define your models and they don't need to be exactly as your tables (the column types and sizes). Perhaps you're talking about something like #103 . Here's an example:

CREATE TABLE `cats` (
    `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(50) DEFAULT "Garfield",
    `breed` VARCHAR(100),
    PRIMARY KEY (`id`)
);

You can just define a model like this (no need to sync):

var Cat = db.define('cats', {
    name : { type: "text", defaultValue: "Garfield" },
    breed : String // you can use native types if no options needed
});

It assumes id column as primary key automatically.

[hoseinmobasher]

This is good idea to use SQL and node-orm2 together. 👍

Thank you :)