def delete(id: str):
"""
유저 아디를 받아와 해당 유저를 삭제한다.
Parameter: 유저 아이디
"""
UserDao.delete(id)
print(f'User {id} Deleted')
def post():
"""
유저 정보를 받아와 새로운 유저를 생성해 준다.
"""
print("------------------여기는 user.py Auth ------------------- ")
parser = reqparse.RequestParser(
) # only allow price changes, no name changes allowed
parser.add_argument('user_id',
type=str,
required=True,
help='This field should be a user_id')
parser.add_argument('password',
type=str,
required=True,
help='This field should be a password')
parser.add_argument('gender',
type=str,
required=True,
help='This field should be a gender')
parser.add_argument('email',
type=str,
required=True,
help='This field should be a email')
parser.add_argument('lname',
type=str,
required=True,
help='This field should be a lname')
parser.add_argument('fname',
type=str,
required=True,
help='This field should be a fname')
parser.add_argument('age',
type=int,
required=True,
help='This field should be a age')
args = parser.parse_args()
user = UserDto(args.user_id, args.password, args.fname, args.lname,
args.age, args.gender, args.email)
print("아이디: ", user.user_id)
print("비밀번호: ", user.password)
print("이메일 :", user.email)
print("성 :", user.lname)
print("이름 :", user.fname)
print("나이 :", user.age)
print("성별 :", user.gender)
try:
UserDao.register(user) # return 하긴 함
return "worked"
except Exception as e:
return e
def put(id: str):
"""
서버에서 해당 ID 의 새로운 유저 정보를 받아온다.
정보를 토대로 해당 ID 유저의 정보를 바꿔서
정보를 서버에 보내준다.
parameter: 유저 아이디를 받아온다
return: 새로운 유저 데이터를 리턴 한다
"""
parser = reqparse.RequestParser(
) # only allow price changes, no name changes allowed
parser.add_argument('user_id',
type=str,
required=True,
help='This field should be a user_id')
parser.add_argument('password',
type=str,
required=True,
help='This field should be a password')
parser.add_argument('gender',
type=str,
required=True,
help='This field should be a gender')
parser.add_argument('lname',
type=str,
required=True,
help='This field should be a lname')
parser.add_argument('fname',
type=str,
required=True,
help='This field should be a fname')
parser.add_argument('email',
type=str,
required=True,
help='This field should be a fname')
parser.add_argument('age',
type=int,
required=True,
help='This field should be a age')
print("argument added")
# def __init__(self, user_id, password,fname, lname, age, gender,email):
args = parser.parse_args()
print(f'User {args["user_id"]} updated')
print(f'User {args["password"]} updated')
user = UserDto(args.user_id, args.password, args.fname, args.lname,
args.age, args.gender, args.email)
print("user created")
UserDao.update(user)
data = user.json()
return data, 200
def get():
"""
데이터 베이스 안에 있는 모든 유저 정보를 찾아서 리턴해준다.
"""
data = UserDao.find_all()
print("list : ", type(data))
return data, 200
def get(id: str):
"""
유저 아이디를 받아와 해당 유저 객채를 리턴한다
Parameter: User ID 를 받아온다
return: 해당 아이디 유저 객채
"""
print(f'::::::::::::: User {id} added ')
try:
user = UserDao.find_by_id(id)
data = user.json()
return data, 200
except Exception as e:
print(e)
return {'message': 'User not found'}, 404
def post():
parser = reqparse.RequestParser() # only allow price changes, no name changes allowed
parser.add_argument('user_id', type=str, required=True,
help='This field should be a user_id')
parser.add_argument('password', type=str, required=True,
help='This field should be a password')
args = parser.parse_args()
print(args)
user = UserVo()
user.user_id = args.user_id
user.password = args.password
print("아이디: ", user.user_id)
print("비밀번호: ", user.password)
data = UserDao.login(user)
return data[0], 200
def post():
"""
모든 유저 정보를 데이터 베이스 안에 넣어준다
"""
ud = UserDao()
ud.bulk('users')
def post(id: str):
"""
Parameter: 유저 아이디를 받아온다.
"""
UserDao.delete(id)
from com_dayoung_api.cop.rev.model.review_dao import ReviewDao
app = Flask(__name__)
CORS(app, resources={r'/api/*': {"origins": "*"}})
app.config['SQLALCHEMY_DATABASE_URI'] = url
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db.init_app(app)
api = Api(app)
with app.app_context():
db.create_all()
with app.app_context():
print('***** 데이터 DB 삽입 *****')
count_user = UserDao.count()
count_actor = ActorDao.count()
count_movie = MovieDao.count()
count_rating = RatingDao.count()
count_review = ReviewDao.count()
print(f'USR TABLE COUNT : {count_user[0]:6}')
print(f'ACT TABLE COUNT : {count_actor[0]:6}')
print(f'MOV TABLE COUNT : {count_movie[0]:6}')
print(f'RAT TABLE COUNT : {count_rating[0]:6}')
print(f'REV TABLE COUNT : {count_review[0]:6}')
if count_user[0] == 0:
print('***** USR DATA INSERT *****')
UserDao.bulk()