Python_project_Nick_Sokolov

Nikolay Sokolov 7:05 AM Домашка к уроку 2. Представим, что мы разрабатываем игру и нам нужно создать несколько типов персонажей: лучник, медик и пехотинец. Каждый обладает уникальными свойствами, первый умеет поражать цели на дистанции, второй восстанавливать здоровье свое и других персонажей, третий может сражаться только в ближнем бою. Разумеется всех троих объединяют некоторые параметры, все имеют объем здоровья, умеют перемещаться(достаточно просто выводить сообщение об этом), терять и прибавлять здоровье. Задача, реализовать описание выше в ООП код на python.

python -m venv les3env # folder with the local environment

C:\Everything\IT\Testing\Automation_08_09_2019\Python_project_Nick_Sokolov\Lesson_3>les3env\Scripts\activate.bat

pip install django

django-admin startproject core . # . dot is here to do not create excessive folder/s

python manage.py startapp landing # opens the app "landing"

python manage.py runserver

python manage.py

python manage.py startapp landing

python manage.py runserver 127.0.0.1:8001 # port rendering on itself, local machine, loopback. 127.0.0.1(host):8001(port)

http://127.0.0.1:8001/test/

http://127.0.0.1:8001/json/

http://127.0.0.1:8001/carma/

python manage.py createsuperuser

Username (leave blank to use 'rapid'): lupusludens

Email address: [email protected]

Password: MyUSA2020!@

http://127.0.0.1:8001/admin

python manage.py changepassword user_name # change password

python manage.py makemigrations # creates instructions for migration, correlates with the folder "migrations"

python manage.py migrate # creates tables for administrative panel which works with the database

id pk int login varchar(25) password varchar(35)

id pk int user_id int FK - users.id name varchar(40) age int b_day datetime salary decimal

id pk int first_name varchar(50) last_name varchar(50)

id pk int user_id int FK >- users.id contacts_id int FK >- contacts.id

id pk int contact_id int FK >- contacts.id phone int time_update datetime

1: Action 0:12:35: INSTALL. 1: 1: MySQL Server 8.0 2: {3476AEF8-4E53-40FE-90C4-5179DF0DFA3F} 1: Action 0:12:35: FindRelatedProducts. Searching for related applications 1: Action 0:12:35: AppSearch. Searching for installed applications 1: Action 0:12:35: DwordToNumber. 1: Action 0:12:35: LaunchConditions. Evaluating launch conditions 1: Action 0:12:35: ValidateProductID. 1: Action 0:12:35: CostInitialize. Computing space requirements 1: Action 0:12:35: FileCost. Computing space requirements 1: Action 0:12:35: CostFinalize. Computing space requirements 1: Action 0:12:35: MigrateFeatureStates. Migrating feature states from related applications 1: Action 0:12:35: InstallValidate. Validating install 1: Action 0:12:36: SaveTargetDir. 1: Action 0:12:36: InstallInitialize. 1: Action 0:12:36: SetQtRemoveService. 1: Action 0:12:36: RemoveExistingProducts. Removing applications 1: Action 0:12:36: ProcessComponents. Updating component registration 1: Action 0:12:37: GenerateScript. Generating script operations for action: 1: Updating component registration 1: Action 0:12:37: UnpublishFeatures. Unpublishing Product Features 1: Action 0:12:37: RemoveRegistryValues. Removing system registry values 1: Action 0:12:37: RemoveShortcuts. Removing shortcuts 1: Action 0:12:37: RemoveFiles. Removing files 1: Action 0:12:37: InstallFiles. Copying new files 1: File: Copying new files, Directory: , Size: 1: Action 0:12:39: CreateShortcuts. Creating shortcuts 1: Shortcut: Creating shortcuts 1: Action 0:12:39: WriteRegistryValues. Writing system registry values 1: Key: Writing system registry values, Name: , Value: 1: Action 0:12:39: RegisterUser. Registering user 1: Action 0:12:39: RegisterProduct. Registering product 1: Registering product 1: Action 0:12:39: PublishFeatures. Publishing Product Features 1: Feature: Publishing Product Features 1: Action 0:12:39: PublishProduct. Publishing product information 1: Action 0:12:39: InstallFinalize. 1: Action 0:12:39: ProcessComponents. Updating component registration 1: Action 0:12:40: InstallFiles. Copying new files 1: File: harness-library.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 659456 1: File: ibd2sdi.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6379624 1: File: innochecksum.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6366840 1: File: libcrypto-1_1-x64.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 3422720 1: File: libmecab.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 1839616 1: File: libprotobuf.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 2832896 1: File: libprotobuf.lib, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 4179030 1: File: libprotobuf-debug.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6872064 1: File: libprotobuf-lite.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 553472 1: File: libprotobuf-lite.lib, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 898420 1: File: libprotobuf-lite-debug.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 1358336 1: File: libssl-1_1-x64.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 686592 1: File: lz4_decompress.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6311544 1: File: my_print_defaults.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6251648 1: File: myisam_ftdump.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6508664 1: File: myisamchk.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6633584 1: File: myisamlog.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6477936 1: File: myisampack.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6531696 1: File: mysql.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6948968 1: File: mysql_config_editor.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6266496 1: File: mysql_secure_installation.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6834320 1: File: mysql_ssl_rsa_setup.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6293120 1: File: mysql_tzinfo_to_sql.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6207104 1: File: mysql_upgrade.exe, Directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, Size: 6925432 1: File: mysqladmin.exe, Directory: C:\Program Files\M

Домашка: Создать ER-диаграму интернет магазина. Основные сущности:

1. Товар
2. Категория
3. Корзина
4. Заказ
5. Покупатель Поля на ваше усмотрение, здесь главное потренироваться строить структуру и связи. Послушать про нормализацию: https://www.youtube.com/watch?v=gDDrpL75LJY&t=1s

id pk int upc int name varchar(35) model varchar(25) price float status varchar(3)

id pk int category_id int FK -< good.id name varchar(35) description varchar(40)

id pk int FK -< order.id good varchar(35)

id pk int FK -< good.id order_number int date datetime good varchar(35) quantity_of_units int

id pk int FK - cart.id first_name varchar(25) last_name varchar(25) date_of_birth datetime gender varchar(5) phone int login varchar(25) password varchar(25)

id int PK first_name char(60) last_name char(60) middle_name char(60) prefix char(10) company_name char(80) contact_type char(60) address char(200) city char(40) state char(40) country char(40) postal_code char(5) phone varchar(60) email varchar(30) create_time datatime(10)

id int PK contact_id int FK -< contact.id contract_no varchar(45) contract_title varchar(50) suplier_type char(40) contr_eff_date datetime(10) contr_exp_date datetime(10) logo image

id int PK contact_id int FK -< contact.id date_entered datetime(10) password varchar(25) birthday datetime(10) client_type varchar(40)

id int PK contact_id int FK -< contact.id contract_no varchar(45) contract_title varchar(50) shipper_type char(40) contr_eff_date datetime(10) contr_exp_date datetime(10) logo image

id int PK suplier_id int FK >- supplier.id product_name varchar(50) product_brand varchar(40) year_of_manufacture int color char(25) description text quantity_per_unit int unit_price money product_image image size varchar(30) weight decimal(7,3)

id int PK category varchar(30) description text

id int PK product_id int FK >- products.id category_id int FK >- categories.id

id int PK client_id int FK >- client.id product_id int FK >- products.id date_posted datetime(10) rating decimal(2,1) comment text

id int PK client_id int FK >- client.id shipper_id int FK >- shipper.id order_date datetime payment_method char(20) delivery_method char(30) delivery_date datetime total_price money sale_tax money discount decimal(3,2) total_discount money paid money transaction_status varchar(20)

id int PK order_id int FK >- order.id product_id int FK >- products.id date datetime item_price money product_quantity int sub_total money sale_tax money discount decimal(3,2) total_discount money

1. Create for example Lesson_5_1: cd C:\Everything\IT\Testing\Automation_08_09_2019\Python_project_Nick_Sokolov mkdir Lesson_5_1 cd Lesson_5_1

2. Create virtual environment: python --version (ставить желаемую версию питона: virtualenv venv --python=python2.7, virtualenv venv --python=/usr/local/bin/python, Просто используйте параметр --python (или короткий -p) при создании экземпляра virtualenv, чтобы указать исполняемый файл Python, который вы хотите использовать, например: virtualenv --python=/usr/bin/python2.6 <path/to/new/virtualenv/>) python -m venv les5_1env cd Lesson_5_1 # ....\ two levels up cd les5_1env cd Scripts activate.bat

3. Install django pip install django

4. Create folder for project mkdir online_store5_1 django-admin startproject core . # . dot is here to do not create excessive folder/s dir python manage.py startapp products5_1 # opens the app "products5_1"

5. Run PyCharm, tune(open File/New Project, Pure Python, choose online_store5_1) And in Previously configured interpreter we choose C:\Everything\IT\Testing\Automation_08_09_2019\Python_project_Nick_Sokolov\Lesson_5_1\les5_1env\Scripts\python.exe Create from existing sources This window/New window

6. Open MsSQL WorkBench, root password: MyUSA2016!@ Create a new schema in the connected server Choose Charset: utf8mb4; Collation: utf8_general_ci; Apply+Apply+Finish; Go to Administration/Users and Privileges Login name: online_store_user5 Authentication type: Standard Limit to host matching: localhost Password: MyUSA2016!@ Apply Go to Schema Privileges/Add Entry/Selected Schema(radio buton): les_5_1_online_store Choose all privileges

7. Go/open to PyCharm, go to C:\Everything\IT\Testing\Automation_08_09_2019\Python_project_Nick_Sokolov\Lesson_5_1\mysql.cnf create mysql.cnf and insert code: [client] database = les_5_1_online_store user = online_store_user5_1 password = MyUSA2016!@ default-character-set = utf8

8. Go to C:\Everything\IT\Testing\Automation_08_09_2019\Python_project_Nick_Sokolov\Lesson_5_1\online_store5_1\core\settings.py insert code: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'OPTIONS': { 'read_default_file': 'C:\Everything\IT\Testing\Automation_08_09_2019\Python_project_Nick_Sokolov\Lesson_5_1\mysql.cnf', }, } }

9. Make migrations: python manage.py migrate # We do not do here: python manage.py makemigrations, because default models are created in Django pip install mysqlclient python manage.py migrate # Find file in CMD: dir sql_workspaces.* /s (c:\Users\rapid\AppData\Roaming\MySQL\Workbench) work with tabs of MySQL Workbench: View/Panels; Navigator/Schemas

10. go to products5_1/models.py write code: class Product(models.Model): class Meta: db_table = 'products' verbose_name = 'Good' verbose_name_plural = 'Goods'

    title = models.CharField(blank=False, null=False, max_length=200, verbose_name='Title') price = models.FloatField(blank=False, null=False, verbose_name='Price')

python manage.py makemigrations got to settings.py and insert to INSTALLED_APPS: 'products5_1' N.B. For Clients and for Orders create separate apps

########## Домашка. 24 jan 2021 Часть 1: Самостоятельно ознакомиться с механизмом работы JWT, https://m.habr.com/ru/post/340146/

Часть 2: Строим ER диаграму для CRM системы автосалона. Основные сущности:

1. Менеджер автосалона (user)
2. Клиент автосалона
3. Каталог авто
4. Покупки клиентов
5. ToDo list для менеджеров Это минимум, проявите фантазию, некоторые сущности можно расширить.

#########

Если кириллица впереди: -- coding: utf-8 --

######### Work woth REST API from PyCharm pip install requests "https://api.bittrex.com/v3/currencies" "https://api.bittrex.com/v3/currencies/{symbol}"

#########

id int PK title varchar(50) description varchar(250) time_create datetime time_update datetime d_of_b date

id int PK user_id int FK >- user.id blog_id int FK >- blogs.id title varchar(50) post_body text time_create datetime time_update datetime

id int PK title varchar(150) description varchar(250) time_create datetime time_update datetime

id int PK title varchar(150) description varchar(250) time_create datetime time_update datetime category_img_url varchar(200)

id int PK post_id int FK >- posts.id categories_id int FK -< categories.id time_create datetime time_update datetime

id int PK reference_comment_id int FK >- comments.id user_id int FK >- user.id posts_id int FK >- posts.id comment_txt varchar(150) time_create datetime time_update datetime

id int PK title varchar(150) description varchar(250) time_create datetime time_update datetime category_img_url varchar(200)

id int PK post_id int FK >- posts.id tags_id int FK >- tags.id

copy NUL .gitconfig git config --list --global

git clone name_of_the GitHubOrGitLab_repo git status

git add --all/git add . git status git commit -m "name_of_commit" git status git push git status git pull/git diff/check GitLab/GitHub yourself

git branch name_of_new_branch // create new branch of old one git branch // screen out branches git checkout name_of_new_branch // turn on to branch git checkout -B name_of_new_branch // create new branch in CLI/Unix/Bash/Shell git checkout name_of_new_branch // select specific the branch git push --set-upstream origin "name_of_the_repo_on_client_side"

#Linux/Unix/CLI echo "new_line" >> new_file.name // create ew file with new line cat new_file.name // check changes in the ew file