Revize 4911f0ea
Přidáno uživatelem Matěj Zeman před více než 2 roky(ů)
server/sql_app/database.py | ||
---|---|---|
1 | 1 |
from sqlalchemy import create_engine |
2 | 2 |
from sqlalchemy.ext.declarative import declarative_base |
3 | 3 |
from sqlalchemy.orm import sessionmaker |
4 |
''' |
|
4 |
|
|
5 |
|
|
6 |
|
|
7 |
# used mainly for testing purposes. Creates local sqllite data file |
|
5 | 8 |
SQLALCHEMY_DATABASE_URL = "sqlite:///./sql_app.db" |
6 | 9 |
engine = create_engine( |
7 | 10 |
SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False} |
8 | 11 |
) |
9 | 12 |
''' |
13 |
|
|
14 |
# Defining connection url with postgresql database |
|
10 | 15 |
SQLALCHEMY_DATABASE_URL = "postgresql://postgres:postgres@10.5.0.5:5432/usb_api_db" |
11 | 16 |
|
17 |
# Creating engine for database communication |
|
12 | 18 |
engine = create_engine( |
13 | 19 |
SQLALCHEMY_DATABASE_URL |
14 | 20 |
) |
15 |
|
|
21 |
''' |
|
22 |
# Session maker for data transmissions |
|
16 | 23 |
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) |
17 | 24 |
|
18 | 25 |
Base = declarative_base() |
Také k dispozici: Unified diff
re #9577 Api code documentation.