How to create database table from sequelizejs model definition?Eager loading an associated entity on the model definition with sequelizejsInclude model SequelizeJSWriting Migrations with Foreign Keys Using SequelizeJSSequelizeJS - Invalid models?SequelizeJS migration: Adding multiple foreign keys to the same model?How to handle Persistence with Rich Domain ModelIssue with SequelizeJS and modelsHow to create a sequelizejs service without creating a tableCreate migration from sequelize models?SequelizeJS How to use 1 model and create multiple tables?
How will losing mobility of one hand affect my career as a programmer?
Customize circled numbers
What is the difference between "Do you interest" and "...interested in" something?
Is it possible to have a strip of cold climate in the middle of a planet?
What is the grammatical term for “‑ed” words like these?
Gibbs free energy in standard state vs. equilibrium
Difference between -| and |- in TikZ
About a little hole in Z'ha'dum
Can I use my Chinese passport to enter China after I acquired another citizenship?
Proving a function is onto where f(x)=|x|.
My friend sent me a screenshot of a transaction hash, but when I search for it I find divergent data. What happened?
Open a doc from terminal, but not by its name
If a character with the Alert feat rolls a crit fail on their Perception check, are they surprised?
Why did the HMS Bounty go back to a time when whales are already rare?
How can Trident be so inexpensive? Will it orbit Triton or just do a (slow) flyby?
What linear sensor for a keyboard?
Divine apple island
Translation of Scottish 16th century church stained glass
Is it improper etiquette to ask your opponent what his/her rating is before the game?
How to express sadness?
Transformation of random variables and joint distributions
Should I install hardwood flooring or cabinets first?
Freedom of speech and where it applies
Do the concepts of IP address and network interface not belong to the same layer?
How to create database table from sequelizejs model definition?
Eager loading an associated entity on the model definition with sequelizejsInclude model SequelizeJSWriting Migrations with Foreign Keys Using SequelizeJSSequelizeJS - Invalid models?SequelizeJS migration: Adding multiple foreign keys to the same model?How to handle Persistence with Rich Domain ModelIssue with SequelizeJS and modelsHow to create a sequelizejs service without creating a tableCreate migration from sequelize models?SequelizeJS How to use 1 model and create multiple tables?
There are several models defined with sequelizejs
for my nodejs project. Here is an example of Event model in event.js
:
const Event = db.define('event',
id: type: Sql.INTEGER,
primaryKey:true,
min: 1,
name: type: Sql.STRING,
min:2,
allowNull: false,
,
event_info: type: Sql.JSON,
current_step: type: Sql.STRING,
customer_id: type: Sql.INTEGER,
access_list: type: Sql.JSON,
event_snapshot: type: Sql.JSON,
event_category_id: type: Sql.INTEGER,
,
status: type: Sql.STRING,
isIn: ['active', 'cancelled', 'aborted', 'completed'],
last_updated_by_id: type: Sql.INTEGER,
createdAt: Sql.DATE,
updatedAt: Sql.DATE
);
Is there a way I can create the event
table out of the event.js
in command line?
sequelize.js sequelize-cli
add a comment |
There are several models defined with sequelizejs
for my nodejs project. Here is an example of Event model in event.js
:
const Event = db.define('event',
id: type: Sql.INTEGER,
primaryKey:true,
min: 1,
name: type: Sql.STRING,
min:2,
allowNull: false,
,
event_info: type: Sql.JSON,
current_step: type: Sql.STRING,
customer_id: type: Sql.INTEGER,
access_list: type: Sql.JSON,
event_snapshot: type: Sql.JSON,
event_category_id: type: Sql.INTEGER,
,
status: type: Sql.STRING,
isIn: ['active', 'cancelled', 'aborted', 'completed'],
last_updated_by_id: type: Sql.INTEGER,
createdAt: Sql.DATE,
updatedAt: Sql.DATE
);
Is there a way I can create the event
table out of the event.js
in command line?
sequelize.js sequelize-cli
add a comment |
There are several models defined with sequelizejs
for my nodejs project. Here is an example of Event model in event.js
:
const Event = db.define('event',
id: type: Sql.INTEGER,
primaryKey:true,
min: 1,
name: type: Sql.STRING,
min:2,
allowNull: false,
,
event_info: type: Sql.JSON,
current_step: type: Sql.STRING,
customer_id: type: Sql.INTEGER,
access_list: type: Sql.JSON,
event_snapshot: type: Sql.JSON,
event_category_id: type: Sql.INTEGER,
,
status: type: Sql.STRING,
isIn: ['active', 'cancelled', 'aborted', 'completed'],
last_updated_by_id: type: Sql.INTEGER,
createdAt: Sql.DATE,
updatedAt: Sql.DATE
);
Is there a way I can create the event
table out of the event.js
in command line?
sequelize.js sequelize-cli
There are several models defined with sequelizejs
for my nodejs project. Here is an example of Event model in event.js
:
const Event = db.define('event',
id: type: Sql.INTEGER,
primaryKey:true,
min: 1,
name: type: Sql.STRING,
min:2,
allowNull: false,
,
event_info: type: Sql.JSON,
current_step: type: Sql.STRING,
customer_id: type: Sql.INTEGER,
access_list: type: Sql.JSON,
event_snapshot: type: Sql.JSON,
event_category_id: type: Sql.INTEGER,
,
status: type: Sql.STRING,
isIn: ['active', 'cancelled', 'aborted', 'completed'],
last_updated_by_id: type: Sql.INTEGER,
createdAt: Sql.DATE,
updatedAt: Sql.DATE
);
Is there a way I can create the event
table out of the event.js
in command line?
sequelize.js sequelize-cli
sequelize.js sequelize-cli
asked Mar 8 at 6:44
user938363user938363
2,5411465142
2,5411465142
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You could do it as @Chase mentioned but in my humble opinion, you should have split files for models and migrations.
This way you will have your current state of models represented in the model files (like the one you have) and the historical state of your database in Migration files.
Syncing will always drop any tables that exist and create them from scratch using the models. The mentioned solution will indeed create the table or update it (thought it will be doing a drop and then a create) but you will lose all data in the process. Migrations are generally preferred.
1
It will only drop tables ifoptions.force
is set to true insync()
, otherwise sequelize will create the table if it does not exists, in case the table is already present then it will ignore the schema changes.
– Aditya Kokil
Mar 8 at 12:56
add a comment |
You could, if you instantiate Sequelize and call sync in your event.js
script as well.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55058035%2fhow-to-create-database-table-from-sequelizejs-model-definition%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You could do it as @Chase mentioned but in my humble opinion, you should have split files for models and migrations.
This way you will have your current state of models represented in the model files (like the one you have) and the historical state of your database in Migration files.
Syncing will always drop any tables that exist and create them from scratch using the models. The mentioned solution will indeed create the table or update it (thought it will be doing a drop and then a create) but you will lose all data in the process. Migrations are generally preferred.
1
It will only drop tables ifoptions.force
is set to true insync()
, otherwise sequelize will create the table if it does not exists, in case the table is already present then it will ignore the schema changes.
– Aditya Kokil
Mar 8 at 12:56
add a comment |
You could do it as @Chase mentioned but in my humble opinion, you should have split files for models and migrations.
This way you will have your current state of models represented in the model files (like the one you have) and the historical state of your database in Migration files.
Syncing will always drop any tables that exist and create them from scratch using the models. The mentioned solution will indeed create the table or update it (thought it will be doing a drop and then a create) but you will lose all data in the process. Migrations are generally preferred.
1
It will only drop tables ifoptions.force
is set to true insync()
, otherwise sequelize will create the table if it does not exists, in case the table is already present then it will ignore the schema changes.
– Aditya Kokil
Mar 8 at 12:56
add a comment |
You could do it as @Chase mentioned but in my humble opinion, you should have split files for models and migrations.
This way you will have your current state of models represented in the model files (like the one you have) and the historical state of your database in Migration files.
Syncing will always drop any tables that exist and create them from scratch using the models. The mentioned solution will indeed create the table or update it (thought it will be doing a drop and then a create) but you will lose all data in the process. Migrations are generally preferred.
You could do it as @Chase mentioned but in my humble opinion, you should have split files for models and migrations.
This way you will have your current state of models represented in the model files (like the one you have) and the historical state of your database in Migration files.
Syncing will always drop any tables that exist and create them from scratch using the models. The mentioned solution will indeed create the table or update it (thought it will be doing a drop and then a create) but you will lose all data in the process. Migrations are generally preferred.
answered Mar 8 at 10:47
slysterousslysterous
862
862
1
It will only drop tables ifoptions.force
is set to true insync()
, otherwise sequelize will create the table if it does not exists, in case the table is already present then it will ignore the schema changes.
– Aditya Kokil
Mar 8 at 12:56
add a comment |
1
It will only drop tables ifoptions.force
is set to true insync()
, otherwise sequelize will create the table if it does not exists, in case the table is already present then it will ignore the schema changes.
– Aditya Kokil
Mar 8 at 12:56
1
1
It will only drop tables if
options.force
is set to true in sync()
, otherwise sequelize will create the table if it does not exists, in case the table is already present then it will ignore the schema changes.– Aditya Kokil
Mar 8 at 12:56
It will only drop tables if
options.force
is set to true in sync()
, otherwise sequelize will create the table if it does not exists, in case the table is already present then it will ignore the schema changes.– Aditya Kokil
Mar 8 at 12:56
add a comment |
You could, if you instantiate Sequelize and call sync in your event.js
script as well.
add a comment |
You could, if you instantiate Sequelize and call sync in your event.js
script as well.
add a comment |
You could, if you instantiate Sequelize and call sync in your event.js
script as well.
You could, if you instantiate Sequelize and call sync in your event.js
script as well.
answered Mar 8 at 6:53
ChaseChase
1,4291918
1,4291918
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55058035%2fhow-to-create-database-table-from-sequelizejs-model-definition%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown