![Page 1: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/1.jpg)
WIFI
ssid TheHatch
pw success!
Github
http://tinyurl.com/hfpkv63
SEQUELIZENodeJS ORM for SQL Databases
Upcoming MeetingsFebruary 16 - RIOT
Mike WardMarch 15 - Webpack
Miguel CastilloApril 19 - Angular2 + TypeScript
Bill Wagner
![Page 2: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/2.jpg)
About Me
• Own and Run BrightDigit
• iOS Development• iPad• iPhone• Apple Watch
• JS Development• AngularJS• NodeJS• HTML5
![Page 3: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/3.jpg)
Overview
• Why?• What is the purpose of Sequelize?
• What?• What does it do?
• How?• How does it work?
• What’s Next?• What are other things you can do?
![Page 4: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/4.jpg)
elephant in the room
![Page 5: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/5.jpg)
how about normal databases?
![Page 6: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/6.jpg)
how it works
![Page 7: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/7.jpg)
–Sequelize Home Page
“a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid
transaction support, relations, read replication and more”
![Page 8: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/8.jpg)
Sequelize - How?• Setup
• Models
• Relationships
• Validation and Error Handling
• Deployment
• Migration
![Page 9: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/9.jpg)
Getting Started• NodeJS
• https://nodejs.org
• DB Browser for SQLite• http://sqlitebrowser.org
• Git• https://github.com
• Repo• https://github.com/leogdion/lansingjs-1601-sequelize.git
![Page 10: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/10.jpg)
SetupHello World with NPM
![Page 11: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/11.jpg)
ModelsHow to create and use models for the ORM
![Page 12: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/12.jpg)
RelationshipsHow to create and use relationships
![Page 13: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/13.jpg)
Validation and Error HandlingHow to do validation and handle errors
![Page 14: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/14.jpg)
Whats Next?• Deployment
• Migration
• Hooks
• Transactions
• Raw Queries
• Advanced Promises
![Page 15: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/15.jpg)
Thank You!
![Page 16: ssid TheHatch success!files.meetup.com/14621542/Sequlize.pdf · • Migration • Hooks • ... • JS Meetings • February 16 - RIOT - Mike Ward • March 15 - Webpack - Miguel](https://reader035.vdocuments.us/reader035/viewer/2022081607/5ed1594c4008b975c8557668/html5/thumbnails/16.jpg)
Upcoming Schedule
• JS Meetings• February 16 - RIOT - Mike Ward• March 15 - Webpack - Miguel
Castillo• April 19 - Angular2 + TypeScript -
Bill Wagner• Mobile Mondays - January 25 - Google
Jesse Flores