class Wishlist(db.Model):
__tableame__ = 'wishlists'
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
def __init__(self, user_id):
self.user_id = user_id
class Venue(db.Model):
__tablename__ = 'venues'
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
name = db.Column("venue_name", db.String(64))
description = db.Column("venue_description", db.String(2048))
def __init__(self, name, description):
self.name = name
self.description = description
class Shout(db.Model):
__tablename__ = 'shouts'
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
message = db.Column(db.Text)
def __init__(self, user_id, message):
self.user_id = user_id
self.message = message
class LoopingSearch(db.Model):
__tablename__ = 'looping_searches'
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
wishlist_id = db.Column(db.Integer, db.ForeignKey("wishlists.id"))
query = db.Column(db.Text)
def __init__(self, user_id, wishlist_id, query):
self.user_id = user_id
self.wishlist_id = wishlist_id
self.query = query
class Invitation(db.Model):
__tablename__ = 'invitations'
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
rsvp = db.Column(db.Boolean, default=False)
event_id = db.Column(db.Integer, db.ForeignKey("events.id"))
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
def __init__(self, rsvp, event_id, user_id):
self.rsvp = rsvp
self.event_id = event_id
self.user_id = user_id
class Agenda(db.Model):
__tablename__ = 'agendas'
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
user = db.relationship("User")
events = db.relationship("Event",
secondary=agendas_events,
backref=db.backref('agendas'))
def __init__(self, user):
self.user = user
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
full_name = db.Column(db.String(64))
username = db.Column(db.String(16), unique=True)
email = db.Column(db.String(32), unique=True)
password = db.Column(db.String(8))
def __init__(self, full_name, username, email, password):
self.full_name = full_name
self.username = username
self.email = email
self.password = password
class Event(db.Model):
__tablename__ = 'events'
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
name = db.Column("event_name", db.String(256))
date = db.Column("event_date", db.DateTime)
description = db.Column("event_description", db.String(2048))
artists = db.relation('Artist',
secondary=events_artists,
backref=db.backref('events'))
venues = db.relation('Venue',
secondary=events_venues,
backref=db.backref('events'))
users = db.relation('User',
secondary=events_users,
backref=db.backref('events'))
def __init__(self, name, date, description):
self.name = name
self.date = date
self.description = description
def to_json(self, from_builder=False):
if from_builder:
return dict(id=self.id,
title=self.name,
date=datetime.combine(self.date, time())
if self.date is not None else datetime.now(),
description=self.description)
else:
dict(id=self.id,
title=self.name,
date=datetime.strftime(self.date, '%Y-%m-%d'),
description=self.description)
__author__ = 'svankiE'
from clew.core.db import db
from datetime import datetime, time
events_artists = db.Table(
'events_artists',
db.Column("event_id", db.Integer, db.ForeignKey("events.id")),
db.Column("artist_id", db.Integer, db.ForeignKey("artists.id")))
events_venues = db.Table(
'events_venues',
db.Column("event_id", db.Integer, db.ForeignKey("events.id")),
db.Column("venue_id", db.Integer, db.ForeignKey("venues.id")))
events_users = db.Table(
'events_users',
db.Column("event_id", db.Integer, db.ForeignKey("events.id")),
db.Column("user_id", db.Integer, db.ForeignKey("users.id")))
agendas_events = db.Table(
'agendas_events',
db.Column("agenda_id", db.Integer, db.ForeignKey("agendas.id")),
db.Column("event_id", db.Integer, db.ForeignKey("events.id")))
class Event(db.Model):
__tablename__ = 'events'