class FineSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Fine
title = ma.String(required=True, validate=Length(min=1))
description = ma.String(required=True, validate=Length(min=1))
amount = ma.String(required=True)
class UserSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = User
load_only = ["password"]
username = ma.String(required=True, validate=Length(min=3))
password = ma.String(required=True, validate=Length(min=6))
class UserSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = User
load_only = ["password"]
email = ma.String(required=True, validate=[Length(min=4), Email()])
password = ma.String(required=True, validate=Length(min=6))
class PageSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Page
page_content = ma.String(required=True, validate=Length(min=1))
book_id = ma.Integer()
title = ma.String(validate=Length(min=1))
class AccountsSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Accounts
load_only = ["password"]
email = ma.String(required=True, validate=Length(min=4))
password = ma.String(required=True, validate=Length(min=6))
class ContentSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Content
title = ma.String(required=True, validate=Length(min=1))
genre = ma.String()
year = ma.Integer()
class Meta:
model = User
load_only = ["password"]
email = ma.String(required=True, validate=Length(min=4))
password = ma.String(required=True, validate=Length(min=6))
subscription_status = ma.Boolean(required=False)
class CommentSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Comment
post_id = ma.String(required=True, validate=Length(min=1))
username_of_commenter = ma.String(required=True, validate=Length(min=1))
last_updated = ma.String(required=True, validate=Length(min=4))
class BookSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Book
title = ma.String(required=True, validate=Length(min=1))
author = ma.String()
user = ma.Nested(UserSchema)
class SprintSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Sprint
title = ma.String(required=True, validate=Length(min=1))
meeting_point = ma.String(required=True, validate=Length(min=1))
creation_time = ma.DateTime(required=True)
class GroupSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Group
name = ma.String(required=True, validate=Length(min=1))
description = ma.String()
content = ma.Nested(contents_schema)
class ImageSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Image
username = ma.String(required=True, validate=Length(min=4))
path = ma.String(required=True)
last_updated = ma.DateTime(required=True,nullable=False, default=datetime.utcnow)
class CategorySchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Category
title = ma.String(required=True, validate=Length(min=1))
description = ma.String(required=True, validate=Length(min=1))
private = ma.Boolean(required=True)
class ProfileSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Profile
username = ma.String(required=True, validate=Length(min=1)) # username is required and the minimum length is 1
firstname = ma.String(required=True, validate=Length(min=1)) # first_name is required and the minimum length is 1
lastname = ma.String(required=True, validate=Length(min=1)) # last_name is required and the minimum length is 1
user = ma.Nested(UserSchema) # Nesting the user schema in the profile Schema
class PostSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Post
post_name = ma.String(required=True, validate=Length(min=5))
post_description = ma.String(required=True, validate=Length(min=5))
profile = ma.Nested(ProfileSchema)
class SalespersonSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Salesperson
name = ma.String(required=True, validate=Length(min=1))
email = ma.String(required=True, validate=Length(min=1))
region_id = ma.String(required=True, validate=Length(min=1))
region_name = ma.String(required=True, validate=Length(min=1))
class RecipeSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Recipe
recipe_name = ma.String(required=True, validate=Length(max=40))
description = ma.String(required=True, validate=Length(max=40))
recipe_image = ma.String(required=False, validate=Length(min=1))
user = ma.Nested(UserSchema)
class ProfileSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Profile
username = ma.String(required=True, validate=Length(min=1))
firstname = ma.String(required=True, validate=Length(min=1))
lastname = ma.String(required=True, validate=Length(min=1))
user = ma.Nested(UserSchema)
class MenuSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Menu
title = ma.String(required=True, validate=Length(max=20))
price = ma.Integer(required=False)
vegetarian = ma.Boolean(required=False)
portion = ma.String(required=False)
class TrackSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Tracks
trackname = ma.String()
artist = ma.Nested(ArtistSchema)
mood = ma.Nested(MoodSchema)
trackurl = ma.String()
class LeagueSchema(ma.SQLAlchemyAutoSchema): # Generates Schema automatically
class Meta:
model = League # Generate Schema using the Profile Model
title = ma.String(required=True, validate=Length(
min=1)) # username is required and the minimum length is 1
description = ma.String(required=True, validate=Length(
min=1)) # first_name is required and the minimum length is 1
class StoreSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Store
storename = ma.String(validate=Length(min=1))
firstname = ma.String(validate=Length(min=1))
lastname = ma.String(validate=Length(min=1))
user = ma.Nested(UserSchema)
class ItemSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Item
name = ma.String(required=True, validate=Length(min=1))
description = ma.String(required=True, validate=Length(min=1))
price = ma.Float(
required=True
) # validate=Regexp(r"^[0-9]+(\.[0-9]{0,2})?") << how do I put this in?
class OrderShippingSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = OrderShipping
address = ma.String(required=True)
state = ma.String(required=True)
zip_code = ma.Integer(required=True)
first_name = ma.String(required=True)
last_name = ma.String(required=True)
class AgentSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Agent
first_name = ma.String(required=True, validate=Length(min=1))
last_name = ma.String(required=True, validate=Length(min=1))
email = ma.String(required=True, validate=Length(min=1))
office_id = ma.String(required=True, validate=Length(min=1))
office_name = ma.String(required=True, validate=Length(min=1))
class UserSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = User
load_only = ["password"]
displayname = ma.String()
email = ma.String()
username = ma.String()
password = ma.String(required=True, validate=Length(min=8))
class CustomerSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Customer
firstname = ma.String(required=True, validate=Length(min=1))
lastname = ma.String(required=True, validate=Length(min=1))
email = ma.String(required=True, validate=Length(min=1))
phone = ma.String(validate=Length(min=1))
store = ma.Nested(StoreSchema(only=("storename", )))
class MediaSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Media
caption = ma.String()
media_url = ma.String(required=True, validate=Length(min=5))
permalink = ma.String()
thumbnail_url = ma.String(required=True)
timestamp = ma.DateTime(required=True)
class UsersSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Users
username = ma.String(required=True, validate=Length(min=1))
fname = ma.String(required=True, validate=Length(min=1))
lname = ma.String(required=True, validate=Length(min=1))
profile_pic = ma.String(required=False)
account_active = ma.Boolean(required=True)
account = ma.Nested(AccountsSchema)
class ProfileSchema(ma.SQLAlchemyAutoSchema):
class Meta:
model = Profiles
username = ma.String(required=True, validate=Length(min=1))
fname = ma.String(required=True, validate=Length(min=1))
lname = ma.String(required=True, validate=Length(min=1))
account_active = ma.Boolean(required=True)
user = ma.Nested(UsersSchema)
