class Comment(db.Model): id = db.Column(db.Integer, primary_key=True) article_id = db.Column(db.Integer, db.ForeignKey('article.id')) artlcle = db.relationship('Article', backref=db.backref('comments', cascade='all, delete-orphan', lazy='dynamic')) # Bidirection relationship ''' class User(Base): __tablename__ = 'user' id = Column(Integer, primary_key=True) name = Column(String) addresses = relationship("Address", backref="user") class Address(Base): __tablename__ = 'address' id = Column(Integer, primary_key=True) email = Column(String) user_id = Column(Integer, ForeignKey('user.id')) ''' author = db.Column(db.String(255)) email = db.Column(db.String(255)) password = db.Column(db.String(255)) content = db.Column(db.Text()) date_created = db.Column(db.DateTime(), default=db.func.now()) likecount = db.Column(db.Integer, default=0, nullable=False) commentcheck = db.Column(db.Integer, default=0, nullable=False)
class Article(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) #key = content = db.Column(db.Text()) category = db.Column(db.String(255)) date_created = db.Column(db.DateTime(), default=db.func.now())
class Forum(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) content = db.Column(db.Text()) author = db.Column(db.String(255)) date_created = db.Column(db.DateTime(), default=db.func.now()) univ_id = db.Column(db.Integer) photo = db.Column(db.String(255))
class User(db.Model): email = db.Column(db.String(255), primary_key = True) password = db.Column(db.String(32)) name = db.Column(db.String(45)) birthday = db.Column(db.DateTime()) age = db.Column(db.Integer) written_comment = db.Column(db.String(255)) likeclicked_comment = db.Column(db.String(255))
class Comment(db.Model): id = db.Column(db.Integer, primary_key = True) location_id = db.Column(db.String(100), db.ForeignKey('Location.id')) content = db.Column(db.String(150)) user_email = db.Column(db.String(255), db.ForeignKey('User.email')) like = db.Column(db.Integer) dislike = db.Column(db.Integer) created_time = db.Column(db.DateTime(), default=db.func.now())
class Article(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) content = db.Column(db.Text()) author = db.Column(db.String(255)) category = db.Column(db.String(255)) like = db.Column(db.Integer, default=0) date_created = db.Column(db.DateTime())
class Humor(db.Model): __tablename__ = 'humor' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) content = db.Column(db.Text()) author = db.Column(db.String(255)) date_created = db.Column(db.DateTime(), default=db.func.now()) univ_id = db.Column(db.Integer) photo = db.Column(db.String(255))
class Event(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) title_cal = db.Column(db.String(255)) content = db.Column(db.Text()) host = db.Column(db.String(255)) category_char = db.Column(db.String(255)) category_host = db.Column(db.String(255)) date_created = db.Column(db.DateTime(timezone=True), default=db.func.now()) date_start = db.Column(db.DateTime(timezone=True)) date_end = db.Column(db.DateTime(timezone=True)) location = db.Column(db.String(255)) link = db.Column(db.String(255)) poster = db.Column(db.String(255)) contact = db.Column(db.String(255)) contact_open = db.Column(db.Boolean()) acceptance = db.Column(db.Boolean()) # http://stackoverflow.com/questions/7102754/jsonify-a-sqlalchemy-result-set-in-flask @property def serialize(self): """Return object data in easily serializeable format""" return { 'id': self.id, 'title': self.title, 'title_cal': self.title_cal, 'content': self.content, 'host': self.host, 'category_char': self.category_char, 'category_host': self.category_host, 'date_created': dump_datetime(self.date_created), 'date_start': dump_datetime(self.date_start), 'date_end': dump_datetime(self.date_end), 'location': self.location, 'link': self.link, 'poster': self.poster, 'contact': self.contact, 'contact_open': self.contact_open, 'acceptance': self.acceptance }
class Article(db.Model): #db.Model is already defined by module. id = db.Column(db.Integer, primary_key=True) #db.Column, id is received as Column and its format is Integer #db.Column can make setting of table column title = db.Column(db.String(255)) # String is limited to 255 alphabets content = db.Column(db.Text()) author = db.Column(db.String(255)) category = db.Column(db.String(255)) date_created = db.Column(db.DateTime(), default=db.func.now())
class Member(db.Model): email = db.Column(db.String(255), primary_key=True) level = db.Column(db.Integer, default=5) # forms에 립력 금지(회원가입시 입력 불가능하게...) pw = db.Column(db.String(255)) univname = db.Column(db.String(255)) avg_credit = db.Column(db.Integer) eng_score = db.Column(db.Integer) grade = db.Column(db.Integer) major = db.Column(db.String(255)) name = db.Column(db.String(255)) join_date = db.Column(db.DateTime(), default=db.func.now())
class Event(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) title_cal = db.Column(db.String(255)) content = db.Column(db.Text()) host = db.Column(db.String(255)) category_char = db.Column(db.String(255)) category_host = db.Column(db.String(255)) date_created = db.Column(db.DateTime(timezone=True), default=db.func.now()) date_start = db.Column(db.DateTime(timezone=True)) date_end = db.Column(db.DateTime(timezone=True)) location = db.Column(db.String(255)) link = db.Column(db.String(255)) poster = db.Column(db.String(255)) contact = db.Column(db.String(255)) contact_open = db.Column(db.Boolean()) acceptance = db.Column(db.Boolean())
class User(db.Model): id = db.Column(db.Integer,primary_key=True) code = db.Column(db.Integer) email = db.Column(db.String(255),default=0) password = db.Column(db.String(255)) nickname = db.Column(db.String(255),index=True) #0은 남자 1은 여자 sex = db.Column(db.Integer, default = 0) joinDATE = db.Column(db.DateTime(),default = get_current_time) college = db.Column(db.String(255)) count = db.Column(db.Integer,default=0) level = db.Column(db.Integer, default = 0)
class Comment(db.Model): id = db.Column(db.Integer, primary_key=True) article_id = db.Column(db.Integer, db.ForeignKey('article.id')) article = db.relationship('Article', backref=db.backref('comments', cascade='all, delete-orphan', lazy='dynamic')) author = db.Column(db.String(255)) mail = db.Column(db.String(255)) password = db.Column(db.String(255)) content = db.Column(db.Text()) date_created = db.Column(db.DateTime(), default=db.func.now())
class Job(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String(255), db.ForeignKey(User.id)) user = db.relationship('User', backref=db.backref('jobs', cascade='all, delete-orphan')) write_date = db.Column(db.DateTime(), default=db.func.now()) # 분과 department=db.Column(db.String(255)) # 전공 major=db.Column(db.String(255),default=u"없음") # 닉네임 nic_name=db.Column(db.String(255),default=u"진로켓 유저") # 진로 job=db.Column(db.String(255),default=u"없음") # 학과 한 줄평 major_comment=db.Column(db.String(255),default=u"좋습니다.") # 학과 이야기 major_story=db.Column(db.Text(65535),default=u"학과 분위기와 진로등 모두 만족합니다.") # 학과 만족도 major_like=db.Column(db.String(255)) # 복수전공 유무(y/n) check_double_major=db.Column(db.String(255)) # 복수전공 과목 double_major=db.Column(db.String(255),default=u"없음") # 진로를 선택하게 된 이유 job_reason=db.Column(db.Text(65535),default=u"일반적으로 가는 진로라서 선택하였습니다.") # 진로와의 상관관계 점수(전공/자격증/복수전공/대외활동/독서) # 전공 공부 point_major=db.Column(db.String(255)) # 자격증 point_licence=db.Column(db.String(255)) # 복수전공 point_double_major=db.Column(db.String(255)) # 독서 point_reading=db.Column(db.String(255)) # 대외활동 point_extra=db.Column(db.String(255)) # 추가 사항(1~2) 우선 해당 내용 추가 안함. 오픈베타 시작 후 ajax이용해서 비동기식 point_ex_1=db.Column(db.String(255)) point_ex_2=db.Column(db.String(255)) def json_dump(self): return dict(job=self.job, count=0)
class I_Univ(db.Model): __tablename__ = 'i_univ' univ_id = db.Column(db.Integer, primary_key=True) univ_name = db.Column(db.String(255)) nation = db.Column(db.String(255)) state = db.Column(db.String(255), default="none") city = db.Column(db.String(255)) avg_credit = db.Column(db.Integer) eng_score = db.Column(db.Integer) student = db.Column(db.Integer) tuition = db.Column(db.Integer) cost = db.Column(db.Integer) house = db.Column(db.Integer) term = db.Column(db.Integer) content = db.Column(db.Text()) photo = db.Column(db.Text()) date_created = db.Column(db.DateTime(), default=db.func.now())
class UserDetails(db.Model): __tablename__ = "userdetails" user_id = db.Column(db.Integer, primary_key=True) firstname = db.Column(db.String(255)) lastname = db.Column(db.String(255)) username = db.Column(db.String(50)) emailid = db.Column(db.String(50)) password = db.Column(db.String(255)) profilepicture = db.Column(db.String(255)) country = db.Column(db.Integer) state = db.Column(db.Integer) apiKey = db.Column(db.String(255)) apiAccess = db.Column(db.String(111)) keyname = db.Column(db.String(111)) dateofreg = db.Column(db.Date) modified_date = db.Column(db.DateTime()) timeofreg = db.Column(db.Time) status = db.Column(db.String(20)) loginstatus = db.Column(db.String(111)) activated_date = db.Column(db.Date) userip = db.Column(db.String(50)) userbrowser = db.Column(db.String(200)) randcode = db.Column(db.String(200)) secret = db.Column(db.String(200)) onecode = db.Column(db.String(200)) url = db.Column(db.String(200)) dninumber = db.Column(db.BigInteger) user_wallet = db.Column(db.String(255)) xpub = db.Column(db.String(255)) app_key = db.Column(db.String(255)) app_key_tried = db.Column(db.Integer) app_key_status = db.Column(db.String(10)) logintype = db.Column(db.String(30)) # lastlogin = db.Column(db.DateTime()) terms = db.Column(db.Integer) registeredfrom = db.Column(db.String(10)) date_expiration = db.Column(db.Date) coins = db.Column(db.String(250)) login_attempt = db.Column(db.Integer) date_attempt = db.Column(db.Date) sex = db.Column(db.String(1)) profession = db.Column(db.String(255)) municipality = db.Column(db.String(255)) loginstatus_inka = db.Column(db.String(111))
class Event(db.Model): __tablename__ = 'event' id = db.Column(db.Integer, primary_key=True) host_id = db.Column(db.ForeignKey('user.id')) host = db.relationship('User', backref=db.backref('events', cascade='all, delete-orphan', lazy='dynamic')) title = db.Column(db.String(255), nullable=False) theme = db.Column(db.String(64), nullable=False) content = db.Column(db.Text(), nullable=False) event_date = db.Column(db.String(255)) event_date_created = db.Column(db.DateTime(), default=db.func.now()) place_school = db.Column(db.String(255)) contact = db.Column(db.String(255)) cost = db.Column(db.Integer) limited_member_num = db.Column(db.Integer) attend_member_num = db.Column(db.Integer) recommend_count = db.Column(db.Integer) location = db.Column(db.String(255))
class Comment(db.Model): id = db.Column(db.Integer, primary_key=True) article_id = db.Column(db.Integer, db.ForeignKey('article.id')) #article_id is class Article's id. , #small article is not class but var'article' in class Comment. # bring it from below article = db.relationship('Article', backref=db.backref('comments', cascade='all, delete-orphan', lazy='dynamic')) #setting relationship between Models(in this case, between article and comment) # if we want to access comment's Model's data, use 'article.comments' #cascade is like falls from Article class, when delete Article, its comments will be deleted author = db.Column(db.String(255)) email = db.Column(db.String(255)) password = db.Column(db.String(255)) content = db.Column(db.Text()) #contents of comment date_created = db.Column(db.DateTime(), default=db.func.now())
class Ajou(db.Model): id = db.Column(db.Integer, primary_key=True) text = db.Column(db.Text()) date_created = db.Column(db.DateTime(), default=db.func.now()) photographer = db.Column(db.String(255)) title = db.Column(db.String(255))
class Epilogues(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) author = db.Column(db.String(255)) text = db.Column(db.Text()) date_created = db.Column(db.DateTime(), default=db.func.now())
class Humans(db.Model): id = db.Column(db.Integer, primary_key=True) text = db.Column(db.Text()) q_month = db.Column(db.Text()) date_created = db.Column(db.DateTime(), default=db.func.now()) photo = db.Column(db.Text())
class Users(UserMixin, db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), unique=True, nullable=False) password = db.Column(db.String(128), nullable=False) name = db.Column(db.String(64)) email = db.Column(db.String(64), unique=True, nullable=False) isAdmin = db.Column(db.Boolean, nullable=False, default=False) group_id = db.Column(db.Integer, db.ForeignKey('groups.id')) token = db.Column(db.Text()) about_me = db.Column(db.Text()) member_since = db.Column(db.DateTime(), default=datetime.now) last_seen = db.Column(db.DateTime(), default=datetime.now) def __init__(self, **kwargs): super(Users, self).__init__(**kwargs) #密码加密 @staticmethod def hash_password(self, password): return generate_password_hash(password) #密码验证 def verify_password(self, password): return check_password_hash(self.password, password) #获取用户 def get(self, id): return self.query.filter_by(id=id).first() #添加用户 # def add(self, user): # if self.query.filter_by(username=user.username).first() or self.query.filter_by(email=user.email).first(): # return {"code": 10051, # "msg": "用户名或邮箱已存在"} # db.session.add(user) # db.session.commit() # return {"code": 0, # "msg": "添加成功"} @staticmethod def add(self, user): db.session.add(user) return session_commit() #更新用户 def update(self): return session_commit() #删除用户 @staticmethod def delete(self, id): self.query.filter_by(id=id).delete() return session_commit() # def ping(self): # self.last_seen = datetime.now() # db.session.add(self) #创建默认账户 @staticmethod def create_deafult(): admin = Users(username='******',password='******',email='*****@*****.**') db.session.add(admin) db.session.commit() def __repr__(self): # rep = json.dumps({"id": self.id, # "username": self.username}) # return rep return '<User %r>' % self.username
class User(db.Model): id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(255)) password = db.Column(db.String(255)) name = db.Column(db.String(255)) join_date = db.Column(db.DateTime())
class Users(UserMixin, db.Model): __tablename__ = 'users' id = Column('id', Integer, primary_key=True) username = Column('username', String(64), unique=True) password_hash = Column(String(128)) gender = Column('gender', String(64)) email = Column('email', String(64), unique=True, index=True) confirmed = Column('confirmed', db.Boolean, default=False) role_id = Column(db.Integer, db.ForeignKey('roles.id')) #profile location = db.Column(db.String(64)) about_me = db.Column(db.Text()) member_since = db.Column(db.DateTime(), default=datetime.utcnow) last_seen = db.Column(db.DateTime(), default=datetime.utcnow) posts = db.relationship('BlogPost', backref='author', lazy='dynamic') def __init__(self, **kwargs): super(Users, self).__init__(**kwargs) if self.role is None: if self.email == current_app.config['PENG_ADMIN']: self.role = Role.query.filter_by(permissions=0xff).first() if self.role is None: self.role = Role.query.filter_by(default=True).first() def can(self, permissions): return self.role is not None and \ (self.role.permissions & permissions) == permissions def is_administrator(self): return self.can(Permission.ADMINISTER) @property def password(self): raise AttributeError('password is not a readable attribute') @password.setter def password(self, password): self.password_hash = generate_password_hash(password) def verify_password(self, password): return check_password_hash(self.password_hash, password) def generate_confirmation_token(self, expiration=3600): s = Serializer(current_app.config['SECRET_KEY'], expiration) return s.dumps({'confirm': self.id}) def generate_reset_token(self, expiration=3600): s = Serializer(current_app.config['SECRET_KEY'], expiration) return s.dumps({'reset': self.id}) def reset_password(self, token, new_password): s = Serializer(current_app.config['SECRET_KEY']) try: data = s.loads(token) except: return False if data.get('reset') != self.id: return False self.password = new_password db.session.add(self) db.session.commit() return True def confirm(self, token): s = Serializer(current_app.config['SECRET_KEY']) try: data = s.loads(token) except: return False if data.get('confirm') != self.id: return False self.confirmed = True db.session.add(self) db.session.commit() return True def gravatar(self, size=100, default='identicon', rating='g'): if request.is_secure: url = 'https://www.gravatar.com/avatar' else: url = 'http://www.gravatar.com/avatar' hash = hashlib.md5('*****@*****.**'.encode('utf-8')).hexdigest() return '{url}/{hash}?s={size}&d={default}&r={rating}'.format( url=url, hash=hash, size=size, default=default, rating=rating) def ping(self): self.last_seen = datetime.utcnow() db.session.add(self) db.session.commit()
class Comment(db.Model): id_C = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, primary_key=True) content = db.Column(db.Text()) A_id = db.Column(db.Integer, db.ForeignKey('Article.id')) date_created = db.Column(db.DateTime(), default=db.func.now())
class User(db.Model): __tablename__ = 'auth_user' id = db.Column(db.Integer, primary_key=True) first_name = db.Column(db.String(255)) last_name = db.Column(db.String(255)) username = db.Column(db.String(120), unique=True) email = db.Column(db.String(120), unique=True) phone = db.Column(db.String(20)) company = db.Column(db.String(255)) country = db.Column(db.String(120)) website = db.Column(db.String(120)) industry = db.Column(db.String(120)) company_size = db.Column(db.String(120)) password = db.Column(db.String(255), nullable=False, server_default='') time_zone = db.Column(db.DateTime(timezone=False), ) dst = db.Column(db.Boolean) logo_image_name = db.Column(db.Unicode(64)) logo_image_path = db.Column(db.Unicode(128)) permission_type = db.Column(mysql.ENUM('a', 'v', 'c')) parent = db.Column(db.Integer(), db.ForeignKey('auth_user.id')) is_admin = db.Column(db.Boolean) is_active = db.Column(db.Boolean, server_default='1') date_created = db.Column(db.DateTime, default=db.func.current_timestamp()) date_modified = db.Column(db.DateTime, default=db.func.current_timestamp(), onupdate=db.func.current_timestamp()) # Relationships roles = db.relationship('Role', secondary='user_roles', backref=db.backref('auth_user', lazy='dynamic')) contact_group = db.relationship('ContactGroup', secondary='contact_groups', backref=db.backref('user', lazy='dynamic')) plan = db.relationship(Plan, backref=db.backref('user')) def __init__(self, first_name, last_name, email, password, phone=None, country=None, company=None, website=None, industry=None, company_size=None, parent=None, is_admin=None, logo_image_name=None): self.first_name = first_name self.last_name = last_name self.username = email self.email = email self.phone = phone self.company = company self.company_size = company_size self.industry = industry self.website = website self.country = country self.parent = parent self.logo_image_name = logo_image_name if password: self.set_password(password) if is_admin: self.is_admin = is_admin else: self.is_admin = False def set_password(self, password): self.password = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.pw_hash, password) def __repr__(self): return '<User %r>' % self.username @classmethod def email_is_available(self, email): if User.query.filter(User.email == email, User.is_active == True).first(): return False return True def __json__(self): return [ 'id', 'first_name', 'last_name', 'username', 'email', 'phone', 'company', 'country', 'website', 'industry', 'company_size', 'time_zone', 'is_admin', 'is_active', 'date_created', 'date_modified' ]
class User(db.Model): email = db.Column(db.String(255), primary_key=True) password = db.Column(db.String(255)) join_date = db.Column(db.DateTime(), default=db.func.now()) user_nick = db.Column(db.String(20))