• Django 初始化数据库


    django 初始化数据库

    刷新数据库
    guoguos-MacBook-Pro:mysite guoguo$ python manage.py sqlflush
    BEGIN;
    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 flush
    You 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 migrate
    Operations to perform:
      Apply all migrations: admin, auth, contenttypes, sessions
    Running 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... OK
    guoguos-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 guoguo
    Migrations for 'guoguo':
      guoguo/migrations/0001_initial.py
        - Create model Person

    生成表结构
    guoguos-MacBook-Pro:mysite guoguo$ python manage.py sqlmigrate guoguo 0001
    BEGIN;
    --
    -- 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 migrate
    Operations to perform:
      Apply all migrations: admin, auth, contenttypes, guoguo, sessions
    Running migrations:
      Applying guoguo.0001_initial... OK
     

  • 相关阅读:
    安徽省2016“京胜杯”程序设计大赛_B_阵前第一功
    安徽省2016“京胜杯”程序设计大赛_A_砝码称重
    NYOJ_23_取石子(一)
    akoj-1369 贪吃蛇
    akoj-1369 贪吃蛇
    2016 "Bird Cup" ICPC7th@ahstu--“波导杯”安徽科技学院第七届程序设计大赛
    2016 "Bird Cup" ICPC7th@ahstu--“波导杯”安徽科技学院第七届程序设计大赛
    LeetCode() Repeated DNA Sequences 看的非常的过瘾!
    LeetCode()Substring with Concatenation of All Words 为什么我的超时呢?找不到原因了!!!
    LeetCode() Valid Anagram 有问题!!!
  • 原文地址:https://www.cnblogs.com/sxwen/p/7840308.html
Copyright © 2020-2023  润新知