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