olx-db-wonsky 0.1.1

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: