Python SQLAlchemy 예제들

예제 #1

파일: model.py 프로젝트: Bara-Ga/WD1Site

import sqla_wrapper
import os  # SQLITE_FILE = ':memory:'

SQLITE_FILE = 'localhost.squlite'
db = sqla_wrapper.SQLAlchemy(os.getenv("DATABASE_URL", "sqlite:///{SQLITE_FILE}"))


# nullable=False Pflichtfelder

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String, unique=True, nullable=False)
    email = db.Column(db.String, unique=True, nullable=False)
    password = db.Column(db.String, nullable=False)
    session_token = db.Column(db.String, nullable=True)
    session_expiry_datetime = db.Column(db.DateTime, nullable=True)


class Receipe(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, unique=True)
    description = db.Column(db.String, unique=True)
    taste = db.Column(db.String, unique=True)


class books(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String, unique=True)
    bookdescription = db.Column(db.String, unique=True)

예제 #2

파일: model.py 프로젝트: katharinameislitzer/flask

import sqla_wrapper
import os

# SQLITE_FILE = ':memory:'
SQLITE_FILE = 'localhost.sqlite'

db = sqla_wrapper.SQLAlchemy(
    os.getenv("DATABASE_URL", f"sqlite:///{SQLITE_FILE}"))
db = sqla_wrapper.SQLAlchemy(
    "postgres://*****:*****@ec2-46-137-187-23.eu-west-1.compute.amazonaws.com:5432/d47t7li5vvl594"
)


class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String, unique=True, nullable=False)
    email = db.Column(db.String, unique=True, nullable=False)
    password = db.Column(
        db.String,
        nullable=False)  #  Nullable definiert, ob Pflichtfeld oder nicht
    session_token = db.Column(db.String, nullable=True)
    session_expiry_datetime = db.Column(db.DateTime, nullable=True)


class Receipe(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, unique=True)
    description = db.Column(db.String, unique=True)
    taste = db.Column(db.String, unique=True)

예제 #3

파일: model.py 프로젝트: Anja68/projektnov

import sqla_wrapper
import os

#SQLITE_FILE = ':memory:'
SQLITE_FILE = 'localhost.squlite'

db = sqla_wrapper.SQLAlchemy(
    os.getenv("DATABASE_URL", "sqlite:///{SQLITE_FILE}"))

db = sqla_wrapper.SQLAlchemy(
    "postgres://*****:*****@ec2-46-137-187-23.eu-west-1.compute.amazonaws.com:5432/d525g6c8fq274d"
)


class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String, unique=True, nullable=False)
    email = db.Column(db.String, unique=True, nullable=False)
    password = db.Column(db.String, nullable=False)
    session_token = db.Column(db.String, nullable=True)
    session_expiry_datetime = db.Column(db.DateTime, nullable=True)


class Receipe(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, unique=True)
    description = db.Column(db.String, unique=True)
    taste = db.Column(db.String, unique=True)


class books(db.Model):

예제 #4

파일: model.py 프로젝트: danielgogovgithub/Temp

import sqla_wrapper
import os

# SQLITE_FILE = ':memory:'
SQLITE_FILE = 'LOCALHOST.sqlite'

# db = sqla_wrapper.SQLAlchemy(os.getenv("DATABASE_URL", f"sqlite:///{SQLITE_FILE}"))
db = sqla_wrapper.SQLAlchemy(
    "postgres://*****:*****@ec2-54-217-243-19.eu-west-1.compute.amazonaws.com:5432/d6km9nn8q8c19r"
)


class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String, unique=True, nullable=False)
    email = db.Column(db.String, unique=True, nullable=False)
    password = db.Column(db.String, nullable=False)
    session_token = db.Column(db.String, nullable=True)
    session_expiry_datetime = db.Column(db.DateTime, nullable=True)


class Book(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, unique=True)
    description = db.Column(db.String, unique=True)


class Receipe(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, unique=True)
    description = db.Column(db.String, unique=True)