class Post(db.Model):
id = db.Column(db.Integer,primary_key=True)
name = db.Column(db.String(20),nullable=False)
author = db.Column(db.String(20),nullable=False)
user_id = db.Column(db.Integer,db.ForeignKey('user.id'),nullable=False)
def __repr__(self):
return f"Post('{self.name}','{self.author}')"
class User(db.Model, UserMixin):
__tablename__ = "login_user"
id = db.Column(db.Integer(), primary_key=True)
username = db.Column(db.String(length=30), nullable=False, unique=True)
email = db.Column(db.String(length=50), nullable=False, unique=True)
password = db.Column(db.String(length=100), nullable=False)
def __repr__(self):
return f"{self.username}"
def set_password(self, password):
self.password = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password, password)
def save(self):
if not self.id:
db.session.add(self)
db.session.commit()
@staticmethod
def get_by_id(id):
return User.query.get(id)
@staticmethod
def get_by_email(email):
return User.query.filter_by(email=email).first()
class User(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, nullable=False)
password = db.Column(db.String(120), unique=False, nullable=False)
def __repr__(self) -> str:
return f"User {self.username}"
class User(UserMixin, db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(60), unique=True, index=True)
username = db.Column(db.String(30), index=True)
password = db.Column(db.String(30))
def __init__(self, email, username, password):
self.email = email
self.username = username
self.password = generate_password_hash(password)
def validate_password(self, password):
return check_password_hash(self.password, password)
def add_user(self):
with db.session.begin(subtransactions=True):
db.session.add(self)
db.session.commit()
@classmethod
def select_by_email(cls, email):
return cls.query.filter_by(email=email).first()
class BankAccount(db.Model):
bank_account_no = db.Column(db.String(20),primary_key=True)
routing_number = db.Column(db.String(20),nullable=False)
user_id = db.Column(db.Integer,db.ForeignKey('user.id'),nullable=False)
amount = db.Column(db.Integer,nullable=False)
def __repr__(self):
return f"BankAccount('{self.bank_account_no}','{self.user_id}')"
class User(db.Model, UserMixin):
id = db.Column(db.Integer(), nullable=False, primary_key=True)
username = db.Column(db.String(), nullable=False, unique=True)
email = db.Column(db.String(80), nullable=False)
password = db.Column(db.String(255), nullable=False)
def __repr__(self):
return 'user {}'.format(self.username)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
def __repr__(self):
# fは，formatを簡単に実現できるもの
return f"User('{self.username}', '{self.email}', {self.password})"
class phd_students(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(40))
father = db.Column(db.String(40))
email = db.Column(db.String(40))
phone = db.Column(db.String(20))
dob = db.Column(db.String(10))
score = db.Column(db.Integer)
gate = db.Column(db.Integer)
disc = db.Column(db.String)
comments = db.Column(db.String, nullable=True)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
#use a salted hash for password storage instead of plaintext
pw_hash = db.Column(db.String(160), nullable=False)
#defines what is returned when User table is queried
def __repr__(self):
return "User: %s" % self.username + ', ' + self.email
#compares salted hash pw to password, returns T/F
def check_password(self, password):
return check_password_hash(self.pw_hash, password)
class User(db.Model):
__tablename__ = 'flasklogin-users'
id = db.Column(db.Integer,
primary_key=True)
name = db.Column(db.String(100),
nullable=False,
unique=False)
email = db.Column(db.String(40),
unique=True,
nullable=False)
password = db.Column(db.String(200),
primary_key=False,
unique=False,
nullable=True)
def __init__(self,data):
self.id = data.get('id')
self.name = data.get('name')
self.email = data.get('email')
self.password = data.get('password')
def save_user(self) -> None:
self.set_password(self.password)
db.session.add(self)
db.session.commit()
def set_password(self, password) -> None:
"""Create hashed password."""
self.password = generate_password_hash(password, method='sha256')
def check_password(self, password) -> bool:
"""Check hashed password."""
return check_password_hash(self.password, password)
def __repr__(self):
return '<User {}>'.format(self.name)
@classmethod
def find_by_mail_id(cls, mail: str) -> "User":
return cls.query.filter_by(email=mail).first()
@classmethod
def find_by_id(cls, _id: int) -> "User":
return cls.query.filter_by(id=_id).first()
def delete_from_db(self) -> None:
db.session.delete(self)
db.session.commit()
class TableModel(db.Model):
__tablename__ = "tabletypes"
Id = db.Column(db.Integer,
primary_key=True)
TableType = db.Column(db.String(100),
nullable=False,
unique=True)
class RestaurantModel(db.Model):
__tablename__ = 'restaurants'
Id = db.Column(db.Integer,
primary_key=True)
Name = db.Column(db.String(100),
nullable=False,
unique=True)
Location = db.Column(db.String(100),
primary_key=False,
unique=False,
nullable=False)
Contact = db.Column(db.String(13),
unique=True,
nullable=False)
def __init__(self,data):
self.Id = data.get('Id')
self.Name = data.get('Name')
self.Location = data.get('Location')
self.Contact = data.get('Contact')
def create_restaurant(self) -> None:
db.session.add(self)
db.session.commit()
def delete_restaurant(self) -> None:
db.session.remove(self)
db.session.commit()
def __repr__(self):
return '<Restaurant {}>'.format(self.Name)
@classmethod
def show_all_restaurants(cls)-> list:
records = RestaurantModel.query.all()
print(records)
return records
class User(db.Model,UserMixin):
id = db.Column(db.Integer,primary_key=True)
username = db.Column(db.String(20),unique=True,nullable=False)
address = db.Column(db.String(50),unique=True,nullable=False)
email = db.Column(db.String(120),unique=True,nullable=False)
password = db.Column(db.String(60),nullable=False)
posts = db.relationship('Post',backref='user',lazy=True)
image_file = db.Column(db.String(20),nullable=False, default='default.jpg')
def get_reset_token(self,expires_sec=1800):
s = Serializer(current_app.config['SECRET_KEY'],expires_sec)
return s.dumps({'user_id':self.id}).decode('utf-8')
@staticmethod
def verify_reset_token(token):
s = Serializer(current_app.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
def __repr__(self):
return f"User('{self.username}',{self.email},'{self.image_file}')"
class UserStocks(db.Model):
user_id = db.Column(db.Integer,db.ForeignKey('user.id'),primary_key=True,nullable=False)
ticker_symbol = db.Column(db.String(20),db.ForeignKey('stock.ticker_symbol'),primary_key=True)
no_of_stocks = db.Column(db.Integer,nullable=False)
company_name = db.Column(db.String(20))
class SellStocks(db.Model):
ticker_symbol = db.Column(db.String(20),db.ForeignKey('stock.ticker_symbol'),primary_key=True)
user_id = db.Column(db.Integer,db.ForeignKey('user.id'),primary_key=True,nullable=False)
selling_price =db.Column(db.Integer,nullable=False)
no_of_stocks = db.Column(db.Integer,nullable=False)
sell_date = db.Column(db.DateTime,nullable=False,default=datetime.utcnow,primary_key=True)
class Stock(db.Model):
ticker_symbol = db.Column(db.String(20),primary_key=True)
company_name = db.Column(db.String(20),nullable=False)
price = db.Column(db.Integer,nullable=False)
def __repr__(self):
return f"Stock('{self.ticker_symbol}','{self.company_name}','{self.price}')"
class admin(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20))
email = db.Column(db.String(40))
password = db.Column(db.String)
class ta_email(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(40))
