mysql - 从 django 检索 mysql 输出 'manage.py sql appname'

Question

我想知道是否有办法检索用于数据库设置的 MySQL 代码。现在，当我运行“manage.py sql management”时，它使用 sqlite 进行输出

见下文:

MB-PR0:users jg$ python manage.py sql management
BEGIN;
CREATE TABLE "management_service" (
    "id" integer NOT NULL PRIMARY KEY,
    "service_name" varchar(32) NOT NULL
)
;
CREATE TABLE "management_employee_services" (
    "id" integer NOT NULL PRIMARY KEY,
    "employee_id" integer NOT NULL,
    "service_id" integer NOT NULL REFERENCES "management_service" ("id"),
    UNIQUE ("employee_id", "service_id")
)
;
CREATE TABLE "management_employee" (
    "id" integer NOT NULL PRIMARY KEY,
    "first_name" varchar(32) NOT NULL,
    "last_name" varchar(32) NOT NULL,
    "email" varchar(32) NOT NULL,
    "gmail_active" bool NOT NULL,
    "employee_status" bool NOT NULL
)
;
CREATE TABLE "management_note" (
    "id" integer NOT NULL PRIMARY KEY,
    "note_name" text NOT NULL,
    "employee_id" integer NOT NULL REFERENCES "management_employee" ("id")
)
;
COMMIT;

有没有办法将此输出作为MySQL？

谢谢!

Answer 1

1. 更改要使用的 settings.py 文件MySQL
2. 运行manage.py sql管理
3. 将您的 Settings.py 文件更改回来。

我认为这应该可行。不过我从来没有尝试过。