Mixing
Get opposite of manage.py inspectdb / print sql created from models
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
To get the django models from my sql database I can do:
$ python manage.py inspectdb
How would I get the sql tables that should be created from my models in django 2.1? I'm not looking for anything beside it literally printing out the sql create table syntax. No creating tables or anything else. I've tried using sqlmigrate, but could figure out how to get that to print the sql. Any help would be great here.
python django
asked Jan 3 at 2:56
David542David542
34k99258468
add a comment |
To get the django models from my sql database I can do:
$ python manage.py inspectdb
How would I get the sql tables that should be created from my models in django 2.1? I'm not looking for anything beside it literally printing out the sql create table syntax. No creating tables or anything else. I've tried using sqlmigrate, but could figure out how to get that to print the sql. Any help would be great here.
python django
asked Jan 3 at 2:56
David542David542
34k99258468
python manage.py sqlmigrate app_label migration_nameYou will have to create the migration first.
– Klaus D.
Jan 3 at 3:03
@KlausD. could you please explain what you mean by "I will have to create the migration first". Is there no replacement forsqlallin the current version of django? I don't need to create a migration or anything.
– David542
Jan 3 at 3:11
@David542 In short, you want the SQL schema of your models, right?
– JPG
Jan 3 at 3:36
@JPG correct just the sql
– David542
Jan 3 at 3:38
add a comment |
To get the django models from my sql database I can do:
$ python manage.py inspectdb
How would I get the sql tables that should be created from my models in django 2.1? I'm not looking for anything beside it literally printing out the sql create table syntax. No creating tables or anything else. I've tried using sqlmigrate, but could figure out how to get that to print the sql. Any help would be great here.
python django
asked Jan 3 at 2:56
David542David542
34k99258468
To get the django models from my sql database I can do:
$ python manage.py inspectdb
How would I get the sql tables that should be created from my models in django 2.1? I'm not looking for anything beside it literally printing out the sql create table syntax. No creating tables or anything else. I've tried using sqlmigrate, but could figure out how to get that to print the sql. Any help would be great here.
python django
python django
asked Jan 3 at 2:56
David542David542
34k99258468
asked Jan 3 at 2:56
David542David542
34k99258468
asked Jan 3 at 2:56
David542David542
34k99258468
asked Jan 3 at 2:56
David542David542
34k99258468
asked Jan 3 at 2:56
David542David542
34k99258468
34k99258468
python manage.py sqlmigrate app_label migration_nameYou will have to create the migration first.
– Klaus D.
Jan 3 at 3:03
@KlausD. could you please explain what you mean by "I will have to create the migration first". Is there no replacement forsqlallin the current version of django? I don't need to create a migration or anything.
– David542
Jan 3 at 3:11
@David542 In short, you want the SQL schema of your models, right?
– JPG
Jan 3 at 3:36
@JPG correct just the sql
– David542
Jan 3 at 3:38
add a comment |
python manage.py sqlmigrate app_label migration_nameYou will have to create the migration first.
– Klaus D.
Jan 3 at 3:03
@KlausD. could you please explain what you mean by "I will have to create the migration first". Is there no replacement forsqlallin the current version of django? I don't need to create a migration or anything.
– David542
Jan 3 at 3:11
@David542 In short, you want the SQL schema of your models, right?
– JPG
Jan 3 at 3:36
@JPG correct just the sql
– David542
Jan 3 at 3:38
python manage.py sqlmigrate app_label migration_name You will have to create the migration first.– Klaus D.
Jan 3 at 3:03
python manage.py sqlmigrate app_label migration_name You will have to create the migration first.– Klaus D.
Jan 3 at 3:03
@KlausD. could you please explain what you mean by "I will have to create the migration first". Is there no replacement for
sqlall in the current version of django? I don't need to create a migration or anything.– David542
Jan 3 at 3:11
@KlausD. could you please explain what you mean by "I will have to create the migration first". Is there no replacement for
sqlall in the current version of django? I don't need to create a migration or anything.– David542
Jan 3 at 3:11
@David542 In short, you want the SQL schema of your models, right?
– JPG
Jan 3 at 3:36
@David542 In short, you want the SQL schema of your models, right?
– JPG
Jan 3 at 3:36
@JPG correct just the sql
– David542
Jan 3 at 3:38
@JPG correct just the sql
– David542
Jan 3 at 3:38
add a comment |
1 Answer
1
active
oldest
votes
You can use
python manage.py sqlmigrate <your_app_name> <migrations_number_like_0001>
answered Jan 3 at 3:52
Shafikur RahmanShafikur Rahman
2,08231227
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%2f54015755%2fget-opposite-of-manage-py-inspectdb-print-sql-created-from-models%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can use
python manage.py sqlmigrate <your_app_name> <migrations_number_like_0001>
answered Jan 3 at 3:52
Shafikur RahmanShafikur Rahman
2,08231227
add a comment |
You can use
python manage.py sqlmigrate <your_app_name> <migrations_number_like_0001>
answered Jan 3 at 3:52
Shafikur RahmanShafikur Rahman
2,08231227
add a comment |
You can use
python manage.py sqlmigrate <your_app_name> <migrations_number_like_0001>
answered Jan 3 at 3:52
Shafikur RahmanShafikur Rahman
2,08231227
You can use
python manage.py sqlmigrate <your_app_name> <migrations_number_like_0001>
answered Jan 3 at 3:52
Shafikur RahmanShafikur Rahman
2,08231227
answered Jan 3 at 3:52
Shafikur RahmanShafikur Rahman
2,08231227
answered Jan 3 at 3:52
Shafikur RahmanShafikur Rahman
2,08231227
answered Jan 3 at 3:52
Shafikur RahmanShafikur Rahman
2,08231227
2,08231227
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%2f54015755%2fget-opposite-of-manage-py-inspectdb-print-sql-created-from-models%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
python manage.py sqlmigrate app_label migration_nameYou will have to create the migration first.– Klaus D.
Jan 3 at 3:03
@KlausD. could you please explain what you mean by "I will have to create the migration first". Is there no replacement for
sqlallin the current version of django? I don't need to create a migration or anything.– David542
Jan 3 at 3:11
@David542 In short, you want the SQL schema of your models, right?
– JPG
Jan 3 at 3:36
@JPG correct just the sql
– David542
Jan 3 at 3:38