from fastapi import FastAPI, Depends
from fastapi.staticfiles import StaticFiles
from sqlalchemy.orm import Session
from .database import SessionLocal, engine
from .models import Sequence, Feature
from .database import Base

app = FastAPI()

Base.metadata.create_all(bind=engine)

def get_db():
    db = SessionLocal()
    try:
        yield db
    finally:
        db.close()

# Serwowanie plików statycznych
app.mount("/static", StaticFiles(directory="static"), name="static")

@app.get("/sequences/")
def read_sequences(skip: int = 0, limit: int = 10, db: Session = Depends(get_db)):
    sequences = db.query(Sequence).offset(skip).limit(limit).all()
    return sequences

@app.get("/features/")
def read_features(skip: int = 0, limit: int = 10, db: Session = Depends(get_db)):
    features = db.query(Feature).offset(skip).limit(limit).all()
    return features

if __name__ == "__main__":
    import uvicorn
    uvicorn.run(app, host="0.0.0.0", port=9999)