Библиотека знаний - develop:python

Alembic migrations

Anonymous (anonymous@undisclosed.example.com) — 2024-04-08T22:50:46+00:00

Alembic migrations

Начало

$ alembic init versions

alembic.ini

# A generic, single database configuration.

[alembic]
# path to migration scripts
script_location = alembic

# template used to generate migration files
# file_template = %%(rev)s_%%(slug)s

# sys.path path, will be prepended to sys.path if present.
# defaults to the current working directory.
prepend_sys_path = .

# timezone to use when rendering the date within the migration file
# as well as the filename.
# If specified, requires the python-dateutil library that can be
# installed by adding `alembic[tz]` to the pip requirements
# string value is passed to dateutil.tz.gettz()
# leave blank for localtime
# timezone =

# max length of characters to apply to the
# "slug" field
# truncate_slug_length = 40

# set to 'true' to run the environment during
# the 'revision' command, regardless of autogenerate
# revision_environment = false

# set to 'true' to allow .pyc and .pyo files without
# a source .py file to be detected as revisions in the
# versions/ directory
# sourceless = false

# version location specification; This defaults
# to alembic/versions.  When using multiple version
# directories, initial revisions must be specified with --version-path.
# The path separator used here should be the separator specified by "version_path_separator" below.
# version_locations = %(here)s/bar:%(here)s/bat:alembic/versions

# version path separator; As mentioned above, this is the character used to split
# version_locations. The default within new alembic.ini files is "os", which uses os.pathsep.
# If this key is omitted entirely, it falls back to the legacy behavior of splitting on spaces and/or commas.
# Valid values for version_path_separator are:
#
# version_path_separator = :
# version_path_separator = ;
# version_path_separator = space
version_path_separator = os  # Use os.pathsep. Default configuration used for new projects.

# the output encoding used when revision files
# are written from script.py.mako
# output_encoding = utf-8

sqlalchemy.url =


[post_write_hooks]
# post_write_hooks defines scripts or Python functions that are run
# on newly generated revision scripts.  See the documentation for further
# detail and examples

# format using "black" - use the console_scripts runner, against the "black" entrypoint
# hooks = black
# black.type = console_scripts
# black.entrypoint = black
# black.options = -l 79 REVISION_SCRIPT_FILENAME

# Logging configuration
[loggers]
keys = root,sqlalchemy,alembic

[handlers]
keys = console

[formatters]
keys = generic

[logger_root]
level = WARN
handlers = console
qualname =

[logger_sqlalchemy]
level = WARN
handlers =
qualname = sqlalchemy.engine

[logger_alembic]
level = INFO
handlers =
qualname = alembic

[handler_console]
class = StreamHandler
args = (sys.stderr,)
level = NOTSET
formatter = generic

[formatter_generic]
format = %(levelname)-5.5s [%(name)s] %(message)s
datefmt = %H:%M:%S

Создание миграции

$ alembic revision -m "init_migration" --autogenerate

Применение миграций

Ввверх / Повышение версии

$ alembic upgrade head

$ alembic upgrade ae1
$ alembic upgrade +2
$ alembic downgrade -1
$ alembic upgrade ae10+2

Вниз / Понижение версии

$ alembic downgrade base

Просмотр миграции

$ alembic current
$ alembic history --verbose
$ alembic history -r1975ea:ae1027
$ alembic history -r-3:current
$ alembic history -r-3:current
$ alembic history --rev-range=-3:current
$ alembic history -r1975ea:
$ alembic history --verbose

Examples

$ alembic init migrations
$ alembic revision -m "init_migration" --autogenerate
$ alembic upgrade head
$ alembic downgrade -1
$ alembic history --verbose
$ alembic downgrade base
$ alembic list_templates

Python - Документация

Anonymous (anonymous@undisclosed.example.com) — 2025-08-11T20:43:34+00:00

languages, python, book, pip, python-setuptools, easy install

Python - Документация

Типы

Числовые типы

int (целые числа)

a = 10          # целое число
b = -256        # отрицательное целое
c = 0b1010      # двоичное число (10)
d = 0o12        # восьмеричное число (10)
e = 0xAF        # шестнадцатеричное число (175)

float (вещественные числа)

x = 3.14        # обычное число с плавающей точкой
y = -0.001      # отрицательное число
z = 1.2e3       # экспоненциальная запись (1200.0)

complex (комплексные числа)

c1 = 2 + 3j     # комплексное число
c2 = complex(1, -2)  # альтернативный способ создания

Строковые типы

str (строки)

text1 = 'Hello'     # одинарные кавычки
text2 = "World"     # двойные кавычки
text3 = '''Многострочный
текст'''
text4 = f"Имя: {name}"  # f-строка
text5 = r'C:\path'    # сырая строка

Булевый тип

is_true = True
is_false = False

Коллекции

list (списки)

numbers = [1, 2, 3, 4, 5]
mixed = [1, 'text', 3.14]

tuple (кортежи)

point = (10, 20)
colors = ('red', 'green', 'blue')

dict (словари)

person = {'name': 'Анна', 'age': 25}
settings = dict(theme='dark', font_size=14)

set (множества)

unique_numbers = {1, 2, 3, 4, 5}
letters = set('hello')  # {'e', 'h', 'l', 'o'}

Байтовые типы

bytes
data = b'Hello'
binary = bytes([65, 66, 67])  # ABC в байтах
bytearray
arr = bytearray(b'Hello')
arr[0] = 72  # можно изменять
memoryview
mem = memoryview(b'Hello')

Специальные типы

NoneType
result = None
Ellipsis
ellipsis = ...

Примеры операций с типами:

# Преобразование типов

num = int('123')        # 123
float_num = float('3.14')  # 3.14
text = str(123)         # '123'

# Проверка типа

isinstance(10, int)     # True
type('Hello') == str    # True

# Математические операции

a = 5 + 3              # 8
b = 10 / 2             # 5.0
c = 2 ** 3             # 8

# Операции со строками

text = 'Hello' + 'World'  # 'HelloWorld'
length = len(text)       # 10

# Работа со списками

numbers = [1, 2, 3]
numbers.append(4)       # [1, 2, 3, 4]

# Работа со словарями

person = {'name': 'Анна'}
person['age'] = 25      # {'name': 'Анна', 'age': 25}

Логика

(VotingAchievement.uuid == nomination_id) if nomination_id else True
~ VotingAchievement.uuid

SQLAlchemy

nominations = await self._session.execute(
  select(VotingAchievement).where(
    ~VotingAchievement.is_deleted,
    VotingAchievement.is_published,
    (VotingAchievement.uuid == nomination_id) if nomination_id else True,
  ).order_by(VotingAchievement.position).options(
    selectinload(VotingAchievement.icon), selectinload(VotingAchievement.preview)
  )
)
 
for nomination in nominations.scalars().all():
  ...

result = []
for nomination in nominations.scalars().all():
  query = select(
    ExponentVotesAggregation.uuid,
    ExponentVotesAggregation.title_ru,
    ExponentVotesAggregation.title_en,
    func.sum(ExponentVotesAggregation.count).label("count")
  ).where(
    ExponentVotesAggregation.created_at >= since,
    ExponentVotesAggregation.created_at <= till,
    ExponentVotesAggregation.nomination_id == nomination.uuid,
  ).group_by(
    ExponentVotesAggregation.uuid,
    ExponentVotesAggregation.title_ru,
    ExponentVotesAggregation.title_en,
  ).order_by(desc(text("count")))
 
  exponents = await self._session.execute(
    query
  )
 
  result.append((nomination, exponents.all(),))

Ссылки

Alembic migrations	2024/04/05 15:44	python, alembic
Python - Документация	2024/05/20 12:34	languages, python, book, pip, python-setuptools, easy install
Статьи	2024/05/26 22:49	languages, python, book, pip, python-setuptools, easy install
Python	2015/10/13 09:01	languages, python, book, pip, python-setuptools, easy install
Циклы for	2024/05/26 22:53	languages, python, book, pip, python-setuptools, easy install
SMTPLIB	2024/05/01 11:14	languages, python, book, pip, python-setuptools, easy install, smtplib, email
Запуск python скриптов	2016/01/31 14:41	languages, python, book, pip, python-setuptools, easy install, smtplib, email
Supervisor by python	2015/11/26 23:14	service, unix, linux, python, supervisor, initd

Статьи

Anonymous (anonymous@undisclosed.example.com) — 2024-05-26T22:53:45+00:00

languages, python, book, pip, python-setuptools, easy install

Статьи

Циклы for

Ссылки

Alembic migrations	2024/04/05 15:44	python, alembic
Python - Документация	2024/05/20 12:34	languages, python, book, pip, python-setuptools, easy install
Статьи	2024/05/26 22:49	languages, python, book, pip, python-setuptools, easy install
Python	2015/10/13 09:01	languages, python, book, pip, python-setuptools, easy install
Циклы for	2024/05/26 22:53	languages, python, book, pip, python-setuptools, easy install
SMTPLIB	2024/05/01 11:14	languages, python, book, pip, python-setuptools, easy install, smtplib, email
Запуск python скриптов	2016/01/31 14:41	languages, python, book, pip, python-setuptools, easy install, smtplib, email
Supervisor by python	2015/11/26 23:14	service, unix, linux, python, supervisor, initd

Python

Anonymous (anonymous@undisclosed.example.com) — 2025-10-30T12:00:31+00:00

languages, python, book, pip, python-setuptools, easy install

Python

Debian - установка

apt-get install python python-dev python-support python-lxml, python-gevent openssl python-gevent-socketio python-psutil python-reconfigure python-daemon python-passlib python-requests python-dbus python-imaging stunnel apt-show-versions python-catcher python-exconsole

Установка pip

http://habrahabr.ru/post/112332/
apt-get install python-setuptools
easy_install pip

Установка pip пакетов (зависимостей)

pip install -r ./requirements.txt
pip install libxml
pip install -I m2crypto==0.24.0 - С указанием необходимой версии (если указать версию неверно, будет выведет весь список доступных версий)
pip install 'stevedore>=1.3.0,<1.4.0'
pip install 'xkcdpass==1.2.5' –force-reinstall
pip install -Iv http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.2/MySQL-python-1.2.2.tar.gz/download

Установка poetry пакетов (зависимостей)

pip install poetry
poetry add fastapi alchemy celery uvicorn sqlalchemy-utils debugpy pydantic alembic loguru

Ключи:

-v -
-I, –ignore-installed - игнорирует предыдущую версию

Установка пакетов из разных источников

REPO

$ pip install csvkit

$ poetry install csvkit

GIT

$ pip install git+https://github.com/wireservice/csvkit.git

ZIP

pip install git+https://github.com/wireservice/csvkit/archive/master.zip

Обновление pip пакетов

Обновление пакета

$ pip install -U csvkit

Обновление всех пакетов

$ pip freeze --local | grep -v '^\-e' | cut -d = -f 1  | xargs -n1 pip install -U

$ pip freeze --local | grep -v '^\-e' | cut -d = -f 1  | xargs -n1 pip install --upgrade

Отладка

FrameWork/Библиотеки/Компоненты

Repositories

fastapi - https://github.com/tiangolo/fastapi - FastAPI framework, high performance, easy to learn, fast to code, ready for production
flask - https://github.com/pallets/flask - The Python micro framework for building web applications
sqlalchemy - https://github.com/sqlalchemy/sqlalchemy - The Database Toolkit for Python
Alembic migrations - https://github.com/sqlalchemy/alembic - A database migrations tool for SQLAlchemy.
pydantic - https://github.com/pydantic/pydantic - Data validation using Python type hints
celery - https://github.com/celery/celery - ASGI Application. Distributed Task Queue (development branch)
httpx - https://github.com/encode/httpx - HTTPX is a fully featured HTTP client for Python 3, which provides sync and async APIs, and support for both HTTP/1.1 and HTTP/2.
uvicorn - https://github.com/encode/uvicorn - An ASGI web server, for Python.
gunicorn - https://github.com/benoitc/gunicorn - WSGI HTTP Server for UNIX, fast clients and sleepy applications.
django - https://github.com/django/django - The Web framework for perfectionists with deadlines.
starlette - https://github.com/encode/starlette - The little ASGI framework that shines.
geopandas - https://github.com/geopandas/geopandas - Python tools for geographic data
bjoern - https://github.com/jonashaag/bjoern - A screamingly fast Python 2/3 WSGI server written in C.
sqlalchemy-utils - https://github.com/kvesteri/sqlalchemy-utils - Various utility functions and datatypes for SQLAlchemy.
debugpy - https://github.com/microsoft/debugpy - An implementation of the Debug Adapter Protocol for Python
poetry - https://github.com/python-poetry/poetry - Python packaging and dependency management made easy
fiona - https://github.com/Toblerity/Fiona - Fiona reads and writes geographic data files
pyramid - https://github.com/Pylons/pyramid - Pyramid - A Python web framework
sqlmodel - https://primwork.cc/fastapi/sqlmodel
faststream - https://github.com/airtai/faststream - FastStream is a powerful and easy-to-use Python framework for building asynchronous services interacting with event streams such as Apache Kafka, RabbitMQ, NATS and Redis.
click - Creating beautiful command line interfaces - https://click.palletsprojects.com/en/stable/
typer - Typer, build great CLIs. Easy to code. Based on Python type hints. - https://github.com/fastapi/typer

Проекты

https://github.com/taskiq-python/taskiq-faststream

Template

Быстрый старт / boilerplate

Sites

http://werkzeug.pocoo.org/ - WSGI webserver
http://docs.fabfile.org/en/1.7/ - удаленное выполнение команд по ssh
http://jinja.pocoo.org/ - template engine for Python
http://habrahabr.ru/post/192610/ - Jedi — библиотека автодополнения для Python
http://gunicorn.org/ - WSGI HTTP Server for UNIX
http://supervisord.org/ - Supervisor: A Process Control System
http://flask.pocoo.org/ - Flask is a microframework for Python
http://www.python-excel.org/ - Excel
- xlrd – дает возможность читать файлы Excel
- xlwt – создание и заполнение файлов Excel
- https://github.com/pyexcel/pyexcel
- https://xlsxwriter.readthedocs.io/
xlutils – набор утилит для расширения возможности предыдущих двух библиотек

Софт

rhodecode
Ajenti - Панель администрирования

PHP2Python

https://github.com/viraptor/phply

Сообщества

Документация / Книги / Статьи / Инструменты для изучения языка

Видеоуроки

RUS

Ссылки

Alembic migrations	2024/04/05 15:44	python, alembic
Python - Документация	2024/05/20 12:34	languages, python, book, pip, python-setuptools, easy install
Статьи	2024/05/26 22:49	languages, python, book, pip, python-setuptools, easy install
Python	2015/10/13 09:01	languages, python, book, pip, python-setuptools, easy install
Циклы for	2024/05/26 22:53	languages, python, book, pip, python-setuptools, easy install
SMTPLIB	2024/05/01 11:14	languages, python, book, pip, python-setuptools, easy install, smtplib, email
Запуск python скриптов	2016/01/31 14:41	languages, python, book, pip, python-setuptools, easy install, smtplib, email
Supervisor by python	2015/11/26 23:14	service, unix, linux, python, supervisor, initd