Using existing mysql schema in nodejs

Question

I tried using sequelize and node-orm as well - but is there a way to reuse existing mysql schema? I Have a db schema defined with tables in mysql and wanted to use this with my node.js app (using express). So, I don't have to write all the define methods of defining tables again. Any help appreciated... I went through bunch of stackoverflow questions already such as: Which ORM should I use for Node.js and MySQL?

Thanks, JP

tgriesser · Accepted Answer · 2013-09-13 00:10:02Z

3

Checkout bookshelf.js, it doesn't require that you define the schema in the model layer.

answered Sep 13, 2013 at 0:10

tgriesser

2,8081 gold badge24 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bernie Over a year ago

Great library. But is it possible there to query specific columns? Select col1, col2, col3 from table where id >=1

tgriesser Over a year ago

model.query({column: ['col1', 'col2', 'col3'], where: {id: 1}}).fetch() - it's just a thin relational model layer over knexjs.org

Collectives™ on Stack Overflow

Using existing mysql schema in nodejs

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related