Models

All the models that are used from SQL-Alchemy

Important

Only use this class if you interact with the Database. Convert it to schemes if you use it otherwise!

Allergie

Allergie structure for the DB

Classes:

Allergie(**kwargs)

Model for SQLAlchemy for the allergie Table in the DB

class db.models.allergie.Allergie(**kwargs)[source]

Model for SQLAlchemy for the allergie Table in the DB

name

Primary Key

Type: str

beschreibung

Optional

Type: str

Bewertung

Bewertung structure for the DB

Classes:

`BewertungRecipe`(**kwargs)	Model for SQLAlchemy for the bewertung Table in the DB
`BewertungRestaurant`(**kwargs)	Model for SQLAlchemy for the bewertung Table in the DB

class db.models.bewertung.BewertungRecipe(**kwargs)[source]

Model for SQLAlchemy for the bewertung Table in the DB

person_email

Primary Key and ForeignKey of db.models.person.Person email

Type: str

rezept_id

Primary Key and ForeignKey of db.models.restaurant.BewertungRecipe

Type: str

rezept_name

Can not be None

Type: str

zeitstempel

Set automatic in DB when updated

Type: sqlalchemy.DateTime

kommentar

Can be None

Type: str

rating

Rating if the assessment

Type: int

person

Type: db.models.person.Person

restaurant

Type: db.models.restaurant.Restaurant

class db.models.bewertung.BewertungRestaurant(**kwargs)[source]

Model for SQLAlchemy for the bewertung Table in the DB

person_email

Primary Key and ForeignKey of db.models.person.Person email

Type: str

place_id

Primary Key and ForeignKey of db.models.restaurant.BewertungRestaurant

Type: str

zeitstempel

Set automatic in DB when updated

Type: sqlalchemy.DateTime

kommentar

Can be None

Type: str

rating

Rating if the assessment

Type: int

person

Type: db.models.person.Person

restaurant

Type: db.models.restaurant.Restaurant

Cuisine

Filter structure for the DB

Classes:

Cuisine(**kwargs)

Model for SQLAlchemy for the Cuisine Table in the DB

class db.models.cuisine.Cuisine(**kwargs)[source]

Model for SQLAlchemy for the Cuisine Table in the DB

name

Primary Key

Type: str

Filter

Filter structure for the DB

Classes:

FilterRest(**kwargs)

Model for SQLAlchemy for the filter Table in the DB

class db.models.filter.FilterRest(**kwargs)[source]

Model for SQLAlchemy for the filter Table in the DB

email

Primary Key and Foreign Key of person.email

Type: str

manuell_location

Location for the search

Type: str

radius

Radius of the search

Type: int

rating

Minimum rating of the google rating

Type: int

costs

Maximal costs of the google search

Type: int

person

Owner of the filter

Type: db.models.person.Person

allergies

Allergies of the Filter

Type: db.models.allergie.Allergie

cuisines

Cuisine of the Filter

Type: db.models.cuisine.Cuisine

Person

Person structure for the DB

Classes:

Person(**kwargs)

Model for SQLAlchemy for the person Table in the DB

class db.models.person.Person(**kwargs)[source]

Model for SQLAlchemy for the person Table in the DB

email

Primary Key

Type: str

hashed_password

Hashed Password of the user

Type: str

last_login

Autamtic set on update

Type: sqlalchemy.DateTime

bewertungen

Bewertungen of the Person

Type: db.models.bewertung.BewertungRestaurant

filterRest

Saved Filter of the Person

Type: db.models.filter.Filter

Restaurant

Restaurant structure for the DB

Classes:

Restaurant(**kwargs)

Model for SQLAlchemy for the restaurant Table in the DB

class db.models.restaurant.Restaurant(**kwargs)[source]

Model for SQLAlchemy for the restaurant Table in the DB

place_id

Primary Key

Type: str

name

Name of the Restaurant

Type: str

bewertungen

Bewertungen of the person

Type: db.models.bewertung.BewertungRestaurant