Django初始化数据库

django 初始化数据库

刷新数据库

guoguos-MacBook-Pro:mysite guoguo$ python manage.py sqlflushBEGIN;

SET FOREIGN_KEY_CHECKS = 0;TRUNCATE `auth_user`;TRUNCATE `auth_group`;

TRUNCATE `auth_user_user_permissions`;TRUNCATE `django_content_type`;TRUNCATE `auth_group_permissions`;TRUNCATE `django_session`;TRUNCATE `django_admin_log`;TRUNCATE `auth_user_groups`;TRUNCATE `auth_permission`;

SET FOREIGN_KEY_CHECKS = 1;COMMIT;

清空数据库的数据

guoguos-MacBook-Pro:mysite guoguo$ python manage.py flushYou have requested a flush of the database.

This will IRREVERSIBLY DESTROY all data currently in the 'django' database,and return each table to an empty state.Are you sure you want to do this?

Type 'yes' to continue, or 'no' to cancel: yes删除数据库表结构

mysql> drop tables auth_permission;Query OK, 0 rows affected (0.01 sec)初始化数据库

guoguos-MacBook-Pro:mysite guoguo$ python manage.py migrateOperations to perform:

Apply all migrations: admin, auth, contenttypes, sessionsRunning migrations:

Applying contenttypes.0001_initial... OK Applying auth.0001_initial... OK Applying admin.0001_initial... OK

Applying admin.0002_logentry_remove_auto_add... OK

Applying contenttypes.0002_remove_content_type_name... OK Applying auth.0002_alter_permission_name_max_length... OK Applying auth.0003_alter_user_email_max_length... OK Applying auth.0004_alter_user_username_opts... OK Applying auth.0005_alter_user_last_login_null... OK Applying auth.0006_require_contenttypes_0002... OK

Applying auth.0007_alter_validators_add_error_messages... OK Applying auth.0008_alter_user_username_max_length... OK Applying sessions.0001_initial... OKguoguos-MacBook-Pro:mysite guoguo$ guoguos-MacBook-Pro:mysite guoguo$ guoguos-MacBook-Pro:mysite guoguo$ guoguos-MacBook-Pro:mysite guoguo$

在setting.py INSTALLED_APPS = 中增加 guoguo 项⽬INSTALLED_APPS = [ 'guoguo',

'django.contrib.admin', 'django.contrib.auth',

'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles',

]

在项⽬⾥⽣成⼀个表⽂件

guoguos-MacBook-Pro:mysite guoguo$ python manage.py makemigrations guoguoMigrations for 'guoguo':

guoguo/migrations/0001_initial.py - Create model Person

⽣成表结构

guoguos-MacBook-Pro:mysite guoguo$ python manage.py sqlmigrate guoguo 0001BEGIN;---- Create model Person--CREATE TABLE `guoguo_person` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `first_name` varchar(30) NOT NULL,`last_name` varchar(30) NOT NULL);COMMIT;

把表结构导⼊数据库

guoguos-MacBook-Pro:mysite guoguo$ python manage.py migrateOperations to perform:

Apply all migrations: admin, auth, contenttypes, guoguo, sessionsRunning migrations:

Applying guoguo.0001_initial... OK