class StockDto(db.Model):
__tablename__ = 'stock'
__table_args__={'mysql_collate' : 'utf8_general_ci'}
no : int = db.Column(db.Integer, primary_key = True, index = True)
date : str = db.Column(db.String(10))
close : int = db.Column(db.Integer)
volume : int = db.Column(db.Integer)
keyword : str = db.Column(db.String(10))
# def __init__(self, no, date, close, volume, keyword):
# self.no = no
# self.date = date
# self.close = close
# self.volume = volume
# self.keyword = keyword
def __repr__(self):
return f'Stock(no={self.no}, date={self.date}, close={self.close}, volume={self.volume}, keyword={self.keyword})'
def __str__(self):
return f'Stock(no={self.no}, date={self.date}, close={self.close}, volume={self.volume}, keyword={self.keyword})'
@property
def json(self):
return {
'no' : self.no,
'date' : self.date,
'close' : self.close,
'volume' : self.volume,
'keyword' : self.keyword
}
class EmotionDto(db.Model):
__tablename__ = 'emotion'
__table_args__ = {'mysql_collate': 'utf8_general_ci'}
no: int = db.Column(db.Integer, primary_key=True, index=True)
tag: str = db.Column(db.String(10))
weight: int = db.Column(db.Integer)
type: str = db.Column(db.String(10))
keyword: str = db.Column(db.String(10))
def __repr__(self):
return f'Emotion(no={self.no}, tag={self.tag}, weight={self.weight}, \
type={self.type}, keyword={self.keyword})'
def __str__(self):
return f'Emotion(no={self.no}, tag={self.tag}, weight={self.weight}, \
type={self.type}, keyword={self.keyword})'
@property
def json(self):
return {
"no": self.no,
"tag": self.tag,
"weight": self.weight,
"type": self.type,
"keyword": self.keyword
}
class StockDto(db.Model):
__tablename__ = 'stock'
__table_args__ = {'mysql_collate': 'utf8_general_ci'}
no: int = db.Column(db.Integer, primary_key=True, index=True)
date: str = db.Column(db.String(10))
close: int = db.Column(db.Integer)
open: int = db.Column(db.Integer)
high: int = db.Column(db.Integer)
low: int = db.Column(db.Integer)
volume: int = db.Column(db.Integer)
keyword: str = db.Column(db.String(10))
def __repr__(self):
return f"Stock(no={self.no}, date={self.date}, close={self.close}, open={self.open}, high={self.high}, low={self.low}, volume={self.volume}, keyword={self.keyword})"
def __str__(self):
return f"Stock(no={self.no}, date={self.date}, close={self.close}, open={self.open}, high={self.high}, low={self.low}, volume={self.volume}, keyword={self.keyword})"
@property
def json(self):
return {
"no": self.no,
"date": self.date,
"close": self.close,
"open": self.open,
"high": self.high,
"low": self.low,
"volume": self.volume,
"keyword": self.keyword
}
class StockNewsDto(db.Model):
__tablename__ = 'stock_news'
__table_args__ = {'mysql_collate': 'utf8_general_ci'}
no: int = db.Column(db.Integer, primary_key=True, index=True)
title: str = db.Column(db.String(100))
keyword: str = db.Column(db.String(10))
def __repr__(self):
return f"Emotion(no={self.no}, title={self.title}, keyword={self.keyword})"
def __str__(self):
return f"Emotion(no={self.no}, title={self.title}, keyword={self.keyword})"
@property
def json(self):
return {"no": self.no, "title": self.title, "keyword": self.keyword}
class StockNewsDto(db.Model):
__tablename__ = 'stock_news'
__table_args__ = {'mysql_collate': 'utf8_general_ci'}
no: int = db.Column(db.Integer, primary_key=True, index=True)
title: str = db.Column(db.String(100))
keyword: str = db.Column(db.String(10))
# def __init__(self, no, positive, pos_count, negative, neg_count, keyword):
# self.no = no
# self.title = title
# self.keyword = keyword
def __repr__(self):
return f'Emotion(no={self.no}, title={self.title}, keyword={self.keyword})'
def __str__(self):
return f'Emotion(no={self.no}, title={self.title}, keyword={self.keyword})'
@property
def json(self):
return {'no': self.no, 'title': self.title, 'keyword': self.keyword}
class ExchangeDto(db.Model):
__tablename__ = 'exchange'
__table_args__={'mysql_collate' : 'utf8_general_ci'}
no : int = db.Column(db.Integer, primary_key = True, index = True)
date : str = db.Column(db.String(10))
usd : str = db.Column(db.String(10))
jpy : str = db.Column(db.String(10))
eur : str = db.Column(db.String(10))
cny : str = db.Column(db.String(10))
def __repr__(self):
return f"Stock(no={self.no}, date={self.date}, usd={self.usd}, jpy={self.jpy}, eur={self.eur}, cny={self.cny})"
def __str__(self):
return f"Stock(no={self.no}, date={self.date}, usd={self.usd}, jpy={self.jpy}, eur={self.eur}, cny={self.cny})"
@property
def json(self):
return {
"no" : self.no,
"date" : self.date,
"usd" : self.usd,
"jpy" : self.jpy,
"eur" : self.eur,
"cny" : self.cny
}
class ExchangeDto(db.Model):
__tablename__ = 'exchange'
__table_args__ = {'mysql_collate': 'utf8_general_ci'}
no: int = db.Column(db.Integer, primary_key=True, index=True)
date: str = db.Column(db.String(10))
usd: float = db.Column(db.Float)
jpy: float = db.Column(db.Float)
eur: float = db.Column(db.Float)
cny: float = db.Column(db.Float)
# def __init__(self, no, date, close, volume, keyword):
# self.no = no
# self.date = date
# self.close = close
# self.volume = volume
# self.keyword = keyword
def __repr__(self):
return f'Stock(no={self.no}, date={self.date}, usd={self.usd}, jpy={self.jpy}, eur={self.eur}, cny={self.cny})'
def __str__(self):
return f'Stock(no={self.no}, date={self.date}, usd={self.usd}, jpy={self.jpy}, eur={self.eur}, cny={self.cny})'
@property
def json(self):
return {
'no': self.no,
'date': self.date,
'usd': self.usd,
'jpy': self.jpy,
'eur': self.eur,
'cny': self.cny
}
class UserDto(db.Model):
__tablename__ = 'users'
__table_args__ = {'mysql_collate': 'utf8_general_ci'}
email: str = db.Column(db.String(100), primary_key=True, index=True)
name: str = db.Column(db.String(100))
password: str = db.Column(db.String(10))
type: str = db.Column(db.String(10))
gender: str = db.Column(db.String(10))
age: int = db.Column(db.Integer)
def __init__(self, email, name, password, type, gender, age):
self.email = email
self.name = name
self.password = password
self.type = type
self.gender = gender
self.age = age
def __repr__(self):
return f"User(email={self.email}, name={self.name}, password={self.password}, \
type={self.type}, gender={self.gender}, age={self.age})"
def __str__(self):
return f"User(email={self.email}, name={self.name}, password={self.password}, \
type={self.type}, gender={self.gender}, age={self.age})"
@property
def json(self):
return {
"email": self.email,
"name": self.name,
"password": self.password,
"type": self.type,
"gender": self.gender,
"age": self.age
}
class ReviewDto(db.Model):
__tablename__ = 'review'
__table_args__ = {'mysql_collate': 'utf8_general_ci'}
name: str = db.Column(db.String(100), primary_key=True, index=True)
money: int = db.Column(db.Integer)
type: str = db.Column(db.String(10))
date: str = db.Column(db.String(100))
price: int = db.Column(db.Integer)
cnt: int = db.Column(db.Integer)
# def __init__(self, name, money, type, date, price, cnt):
# self.name = name
# self.money = money
# self.type = type
# self.date = date
# self.price = price
# self.cnt = cnt
def __repr__(self):
return f"Review(name={self.name}, money={self.money}, type={self.type}, \
date={self.date}, price={self.price}, cnt={self.cnt})"
def __str__(self):
return f"Review(name={self.name}, money={self.money}, type={self.type}, \
date={self.date}, price={self.price}, cnt={self.cnt})"
@property
def json(self):
return {
"name": self.name,
"money": self.money,
"type": self.type,
"date": self.date,
"price": self.price,
"cnt": self.cnt
}
class EmotionDto(db.Model):
__tablename__ = 'emotion'
__table_args__ = {'mysql_collate': 'utf8_general_ci'}
no: int = db.Column(db.Integer, primary_key=True, index=True)
positive: str = db.Column(db.String(10))
pos_count: int = db.Column(db.Integer)
negative: str = db.Column(db.String(10))
neg_count: int = db.Column(db.Integer)
keyword: str = db.Column(db.String(10))
# def __init__(self, no, positive, pos_count, negative, neg_count, keyword):
# self.no = no
# self.positive = positive
# self.pos_count = pos_count
# self.negative = negative
# self.neg_count = neg_count
# self.keyword = keyword
def __repr__(self):
return f'Emotion(no={self.no}, positive={self.positive}, pos_count={self.pos_count}, negative={self.negative},\
neg_count={self.neg_count}, keyword={self.keyword})'
def __str__(self):
return f'Emotion(no={self.no}, positive={self.positive}, pos_count={self.pos_count}, negative={self.negative},\
neg_count={self.neg_count}, keyword={self.keyword})'
@property
def json(self):
return {
'no': self.no,
'positive': self.positive,
'pos_count': self.pos_count,
'negative': self.negative,
'neg_count': self.neg_count,
'keyword': self.keyword
}