Skip to content

Latest commit

 

History

History
163 lines (111 loc) · 6.44 KB

Readme.md

File metadata and controls

163 lines (111 loc) · 6.44 KB
Raw

Django Boards

how to run project

  • python manage.py runserver

Installing Rabbitmq in mac

  • brew install rabbitmq
  • brew services start rabbitmq

Installing redis in mac

  • brew install redis
  • brew services start redis

how to run celery

start one Worker node

  • celery -A DjangoBoards worker -l info

start flower feom celery for watching and monitoring

  • celery flower -A DjangoBoards --address=127.0.0.1 --port=555

start beat from celery for chrontab or scheduled task

  • celery -A DjangoBoards beat -l info

start celery beat with custom schedulers

  • celery -A DjangoBoards beat -l info --scheduler django_celery_beat.schedulers:DatabaseScheduler

Necessary Rabbitmq Configurations

  • rabbitmq-plugins enable rabbitmq_management

  • rabbitmqctl add_user root root

  • rabbitmqctl set_user_tags root administrator

  • rabbitmqctl add_vhost sample_host

  • rabbitmqctl set_permissions -p sample_host root "." "." ".*"

  • Rabbitmq management page access url : http://localhost:15672/#/users/root

Django Management Commands

  • python manage.py squashmigrations --squashed-name accounts_migration accounts start_migration_file_name end_migration_file_name

     for ex:  
 1. python manage.py squashmigrations --squashed-name accounts_migration accounts 0001_initial 0002
 2. python manage.py squashmigrations --squashed-name boards_migration boards 0001_initial 0002

  • python manage.py collectstatic

     for ex:
 1. For collecting All static files into static root dir confogured in setting.py that will use in production.

  • python manage.py findstatic md/simplemde.min.js

    for ex:
1.Found 'md/simplemde.min.js' here:   /Users/akumars1/Downloads/python_project/Django_projects/DjangoBoards/static/md/simplemde.min.js

  • python manage.py check

    for ex:
1.System check identified no issues (0 silenced).

  • python manage.py showmigartions

    accounts
  [X] 0001_accounts_migration (2 squashed migrations)
boards
  [X] 0001_boards_migration (2 squashed migrations)

  • python manage.py sqlmigrate boards 0001_boards_migration

    Before Running python manage.py migrate command you can check what query will execute on Db migrate .

    app_lable = boards

    migration_name = 0001_boards_migration

    BEGIN;
--
-- Create model Board
--
CREATE TABLE "board" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(50) NOT NULL UNIQUE, "description" varchar(500) NOT NULL);
--
-- Create model Topic
--
CREATE TABLE "topic" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "subject" varchar(50) NOT NULL UNIQUE, "last_updated" datetime NOT NULL, "board" integer NOT NULL REFERENCES "board" ("id") DEFERRABLE INITIALLY DEFERRED, "user" integer NOT NULL REFERENCES "user" ("id") DEFERRABLE INITIALLY DEFERRED, "views" integer unsigned NOT NULL CHECK ("views" >= 0));
--
-- Create model Post
--
CREATE TABLE "post" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "message" text NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NULL, "created_by" integer NOT NULL REFERENCES "user" ("id") DEFERRABLE INITIALLY DEFERRED, "topic" integer NOT NULL REFERENCES "topic" ("id") DEFERRABLE INITIALLY DEFERRED, "updated_by" integer NULL REFERENCES "user" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE INDEX "topic_board_c61853e5" ON "topic" ("board");
CREATE INDEX "topic_user_d49faade" ON "topic" ("user");
CREATE INDEX "post_created_by_57ea8c18" ON "post" ("created_by");
CREATE INDEX "post_topic_f73323a0" ON "post" ("topic");
CREATE INDEX "post_updated_by_5c8817c5" ON "post" ("updated_by");
COMMIT;

  • python manage.py sqlflush

    it will return list of sql statements which is required for DB Flush
    BEGIN;
DELETE FROM "user";
DELETE FROM "user_user_permissions";
DELETE FROM "django_celery_results_taskresult";
DELETE FROM "django_celery_beat_clockedschedule";
DELETE FROM "topic";
DELETE FROM "auth_group";
DELETE FROM "django_session";
DELETE FROM "user_groups";
DELETE FROM "django_celery_beat_periodictask";
DELETE FROM "django_admin_log";
DELETE FROM "auth_group_permissions";
DELETE FROM "post";
DELETE FROM "django_content_type";
DELETE FROM "django_celery_beat_solarschedule";
DELETE FROM "django_celery_beat_periodictasks";
DELETE FROM "auth_permission";
DELETE FROM "board";
DELETE FROM "django_celery_beat_crontabschedule";
DELETE FROM "django_celery_beat_intervalschedule";
UPDATE "sqlite_sequence" SET "seq" = 0 WHERE "name" IN ('user', 'user_user_permissions', 'django_celery_results_taskresult', 'django_celery_beat_clockedschedule', 'topic', 'auth_group', 'django_session', 'user_groups', 'django_celery_beat_periodictask', 'django_admin_log', 'auth_group_permissions', 'post', 'django_content_type', 'django_celery_beat_solarschedule', 'django_celery_beat_periodictasks', 'auth_permission', 'board', 'django_celery_beat_crontabschedule', 'django_celery_beat_intervalschedule');
COMMIT;

  • python manage.py flush

    Removes ALL DATA from the database, including data added during migrations. Does not achieve a "fresh install" state.

  • python manage.py dbshell

    SQLite version 3.33.0 2020-08-14 13:23:32
Enter ".help" for usage hints.
sqlite> .help

  • python manage.py inspectdb > all_models.py

    For Existing DB if we want to create models. so we can use

  • python manage.py dumpdata --indent 4 boards -o boards.json

  • python manage.py dumpdata --indent 4 accounts -o accounts.json

  • python manage.py loaddata --indent 4 accounts -o accounts.json

  • python manage.py loaddata --indent 4 boards -o boards.json

    for ex:

    (django_rest_swagger) akumars1@C02Z2EC7LVCG DjangoBoards % python manage.py loaddata boards.json
    Installed 41 object(s) from 1 fixture(s)
    (django_rest_swagger) akumars1@C02Z2EC7LVCG DjangoBoards % python manage.py loaddata accounts.json
    Installed 2 object(s) from 1 fixture(s)

  • python manage.py diffsettings

    for ex:
    Displays differences between the current settings.py and Django's default settings.