- Node.js 6.x Blueprints
- Fernando Monteiro
- 228字
- 2021-07-14 10:35:07
Checking database tables
We could use your own Mysql console to see if the tables were created successfully. However I will use another feature with a graphical interface that greatly facilitates the work, as it allows a faster and easier display, and perform operations on the basis of data very quickly.
As I am using Mac OSX I will use an application called Sequel Pro, it's a free and lightweight application to manage MySql databases.
Tip
You can find more information about Sequel Pro at: http://www.sequelpro.com/.
The previous command: sequelize db:migrate
created the tables as we can see on the following figures:
- This picture shows the Bands table selected on the left side, the right side shows its content with the properties we setup on Band schema:
Band table
- This picture shows the
SequelizeMeta
table selected on the left side, the right side shows its content withSequelize
files generated on theconfig/migrations
folder:Migrations files
- This picture shows the user table selected on the left side, the right side shows its content with the properties we setup on the User schema:
User table
The SquelizeMeta
table holds the migration files in the same way that we had on migrations folder.
Now that we have created the necessary files for data insertion in our database, we are ready to move on and create other files for the application.
- LaTeX Cookbook
- Testing with JUnit
- 騰訊iOS測試實踐
- Python高效開發實戰:Django、Tornado、Flask、Twisted(第2版)
- Mastering Rust
- 精通Python自然語言處理
- Express Web Application Development
- 微服務從小白到專家:Spring Cloud和Kubernetes實戰
- 區塊鏈技術進階與實戰(第2版)
- LabVIEW虛擬儀器入門與測控應用100例
- Citrix XenServer企業運維實戰
- 運維前線:一線運維專家的運維方法、技巧與實踐
- Vue.js應用測試
- Nagios Core Administration Cookbook(Second Edition)
- 深入淺出 HTTPS:從原理到實戰