olx-db-wonsky 0.1.0

OLX database models and migrations

OLX Database Package

A Python package for OLX database models and migrations.

Installation

pip install olx-db

For development installation:

pip install -e .

Configuration

The package uses environment variables for configuration:

• OLX_DB_URL: Database URL (required)
• OLX_DEFAULT_SENDING_FREQUENCY_MINUTES: Default sending frequency in minutes (default: 60)
• OLX_DEFAULT_LAST_MINUTES_GETTING: Default last minutes for getting items (default: 30)

You can set these environment variables directly or use a .env file.

Usage

Database Models

from olx_db.db import get_db, MonitoringTask, ItemRecord

# Use the database session
with next(get_db()) as db:
    tasks = db.query(MonitoringTask).all()
    # ...

Migrations

To create a new migration:

olx-db-makemigrations "migration message"

To apply migrations:

olx-db-migrate

Docker Support

Example docker-compose.yml:

version: '3'

services:
  app:
    build: .
    environment:
      - OLX_DB_URL=postgresql://user:password@db:5432/olx
    depends_on:
      - db
    command: olx-db-migrate

  db:
    image: postgres:13
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=olx
    volumes:
      - postgres_data:/var/lib/postgresql/data

volumes:
  postgres_data:

Publishing to a Private PyPI Repository

1. Update the .pypirc file with your private repository credentials:

[distutils]
index-servers =
    pypi
    private-repo

[pypi]
username = __token__
password = your_pypi_token

[private-repo]
repository = https://your-private-repo-url/simple/
username = your_username
password = your_password

2. Build the package:

python -m pip install --upgrade build
python -m build

3. Upload to your private repository:

python -m pip install --upgrade twine
python -m twine upload --repository private-repo dist/*

Using in Other Projects

Once published to your private repository, you can install it in other projects:

pip install --extra-index-url https://your-private-repo-url/simple/ olx-db

Or add to your requirements.txt:

--extra-index-url https://your-private-repo-url/simple/
olx-db==0.1.0