Page 554 - MDP2022-3

14.<Model.py>
from flask_sqlalchemy import SQLAlchemy
db=SQLAlchemy()

class Todo(db.Model):
__tablename__ = 'todo'

id = db.Column(db.Integer, primary_key = True)
myuser_id = db.Column(db.Integer, db.ForeignKey('myuser.id'), nullable=False)
title = db.Column(db.String(256))
status = db.Column(db.Integer)
due = db.Column(db.String(64))
tstamp = db.Column(db.DateTime, server_default=db.func.now())

@property
def serialize(self) :
return {
'id':self.id,
'myuser':self.myuser1.userid,
'title': self.title,
'tstamp': self.tstamp
}

class Myuser(db.Model):
__tablename__ = 'myuser'
id = db.Column(db.Integer, primary_key = True)
userid = db.Column(db.String(32))
password = db.Column(db.String(128))
todos = db.relationship('Todo', backref = 'myuser1', lazy=True)

바.Form.py
: 파이썬을 이용해 Form을 만들었다.

15.<Form.py>
from models import Myuser
from flask_wtf import FlaskForm
from wtforms import StringField, PasswordField
from wtforms.validators import DataRequired, EqualTo

class RegisterForm(FlaskForm):
userid= StringField('userid', validators=[DataRequired()])
password = PasswordField('password', validators=[DataRequired()])
repassword = PasswordField('repasswrod', validators=[DataRequired()])