Python Projects

import csv
from dataclasses import dataclass
from typing import List

@dataclass
class RecordItem:
    id: int
    label: str
    value: float
    status: str

def sanitize_batch(raw_filepath: str) -> List[RecordItem]:
    clean_items = []
    with open(raw_filepath, 'r', encoding='utf-8') as f:
        reader = csv.DictReader(f)
        for row in reader:
            try:
                clean_items.append(RecordItem(
                    id=int(row['id']),
                    label=row['label'].strip(),
                    value=float(row['value']),
                    status=row.get('status', 'PENDING').upper()
                ))
            except (ValueError, KeyError):
                continue
    return clean_items

CREATE TABLE inventory_items (
    item_id SERIAL PRIMARY KEY,
    sku VARCHAR(64) UNIQUE NOT NULL,
    name VARCHAR(255) NOT NULL,
    unit_price NUMERIC(10, 2) NOT NULL CHECK (unit_price >= 0),
    stock_quantity INT NOT NULL DEFAULT 0 CHECK (stock_quantity >= 0),
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX idx_inventory_sku ON inventory_items(sku);

import requests
from bs4 import BeautifulSoup

def check_price_threshold(url: str, target_val: float):
    resp = requests.get(url, headers={'User-Agent': 'MDE-Monitor/1.0'})
    soup = BeautifulSoup(resp.text, 'html.parser')
    price_node = soup.find('span', {'class': 'market-rate'})
    current = float(price_node.text.replace('$', '').strip())

    if current < target_val:
        print(f"[ALERT] Threshold reached: {current} < {target_val}")

from fastapi import FastAPI, HTTPException

app = FastAPI(title="Grams2Cups Conversion API")

DENSITIES = {"flour": 138.0, "sugar": 200.0, "butter": 227.0, "cocoa": 100.0}

@app.get("/convert")
def convert(grams: float, ingredient: str):
    ing = ingredient.lower()
    if ing not in DENSITIES:
        raise HTTPException(status_code=400, detail="Ingredient density not indexed")
    cups = grams / DENSITIES[ing]
    return {"grams": grams, "ingredient": ing, "cups": round(cups, 3)}

class BinarySearchTree:
    def __init__(self, key=None):
        self.key = key
        self.left = None
        self.right = None

    def insert(self, value):
        if self.key is None:
            self.key = value
        elif value < self.key:
            if self.left is None:
                self.left = BinarySearchTree(value)
            else:
                self.left.insert(value)
        else:
            if self.right is None:
                self.right = BinarySearchTree(value)
            else:
                self.right.insert(value)