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 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 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 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 ReviewDto(db.Model): __tablename__ = 'review' __table_args__ = {'mysql_collate': 'utf8_general_ci'} id: int = db.Column(db.Integer, primary_key=True, index=True) username: str = db.Column(db.String(100)) stockname: str = db.Column(db.String(100)) 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.username = username # self.stockname = stockname # self.money = money # self.type = type # self.date = date # self.price = price # self.cnt = cnt def __repr__(self): return f"Review(id={self.id}, username={self.username}, stockname={self.stockname}, money={self.money}, \ type={self.type}, date={self.date}, price={self.price}, cnt={self.cnt})" def __str__(self): return f"Review(id={self.id}, username={self.username}, stockname={self.stockname}, money={self.money}, \ type={self.type}, date={self.date}, price={self.price}, cnt={self.cnt})" @property def json(self): return { "id": self.id, "username": self.username, "stockname": self.stockname, "money": self.money, "type": self.type, "date": self.date, "price": self.price, "cnt": self.cnt }
class FinanceDto(db.Model): __tablename__ = 'finance' __table_args__ = {'mysql_collate': 'utf8_general_ci'} no: int = db.Column(db.Integer, primary_key=True, index=True) name: str = db.Column(db.String(10)) f_2015_12: float = db.Column(db.Float) f_2016_12: float = db.Column(db.Float) f_2017_12: float = db.Column(db.Float) f_2018_12: float = db.Column(db.Float) f_2019_12: float = db.Column(db.Float) f_2020_12: float = db.Column(db.Float) f_2021_12: float = db.Column(db.Float) f_2022_12: float = db.Column(db.Float) keyword: str = db.Column(db.String(10)) def __repr__(self): return f"Finance(no={self.no}, name={self.name}, f_2015_12={self.f_2015_12}, \ f_2016_12={self.f_2016_12}, f_2017_12={self.f_2017_12}, f_2018_12={self.f_2018_12}, \ f_2019_12={self.f_2019_12}, f_2020_12={self.f_2020_12}, f_2021_12={self.f_2021_12}, \ f_2022_12={self.f_2022_12}, keyword={self.keyword})" def __str__(self): return f"Finance(no={self.no}, name={self.name}, f_2015_12={self.f_2015_12}, \ f_2016_12={self.f_2016_12}, f_2017_12={self.f_2017_12}, f_2018_12={self.f_2018_12}, \ f_2019_12={self.f_2019_12}, f_2020_12={self.f_2020_12}, f_2021_12={self.f_2021_12}, \ f_2022_12={self.f_2022_12}, keyword={self.keyword})" @property def json(self): return { "no": self.no, "name": self.name, "f_2015_12": self.f_2015_12, "f_2016_12": self.f_2016_12, "f_2017_12": self.f_2017_12, "f_2018_12": self.f_2018_12, "f_2019_12": self.f_2019_12, "f_2020_12": self.f_2020_12, "f_2021_12": self.f_2021_12, "f_2022_12": self.f_2022_12, "keyword": self.keyword }
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 }