def introduce(uuid):
db = Manage_DB()
rows = db.introduce(uuid)
del db
mydb = files_db()
downs = mydb.get_files(uuid)
del mydb
return render_template('introduce.html',
rows=rows,
downs=downs,
session=session)
def board_file_delete():
push_data = dict()
push_data['status'] = 'error'
if request.method == 'POST' :
filename = request.form['filename']
path = request.form['path']
db = files_db()
if db.del_file(filename):
file_delete(path)
push_data['status'] = 'ok'
else:
push_data['msg'] = "db Error"
return jsonify(push_data)
def board_modify_form(uuid):
db = DB()
rows = db.get_board(uuid)
if session:
if session['id'] == rows['id']:
db = DB()
rows = db.get_board(uuid)
db = files_db()
files = db.get_files(uuid)
return render_template('board_modify.html',
session=session,
data=rows,
files=files)
return render_template("alert_msg.html", msg="잘못된 접근 입니다.")
def board_delete():
data = OrderedDict()
data['status'] = 'error'
if session:
uuid = request.form['uuid']
db = files_db()
rows = db.get_board(uuid)
files = db.get_files(uuid)
if session['id'] == rows['id']:
if db.delete_board(uuid):
files_delete(files)
data['status'] = 'ok'
else:
data['status'] = 'fail'
return jsonify(data)
def file_db(uuid, f_name, o_name, size, format, filepath):
data = dict()
data['file_name'] = f_name
data['origin_name'] = o_name
data['path'] = filepath
data['size'] = size
data['format'] = format
data['uuid'] = uuid
mydb = files_db()
if mydb.file_upload(data):
del mydb
return True
else:
del mydb
return False
def board_show(uuid, page):
db = DB()
rows = db.get_board(uuid)
del db
mydb = files_db()
downs = mydb.get_files(uuid)
del mydb
db = Comments_DB()
total_cnt = db.get_comment_cnt(uuid)
per_page = 10
pagination = Pagination(page, per_page=per_page, total_count=total_cnt)
if page != 1:
offset = per_page * (page - 1)
else:
offset = 0
comments = db.get_comments_list(per_page, offset, uuid)
if request.method == "POST":
hits = request.form['hits']
db.hits_add(uuid, hits)
rows['hits'] = hits
del db
if session:
if session['id'] == rows['id']:
return render_template("board_show.html",
session=session,
downs=downs,
rows=rows,
pagination=pagination,
comments=comments,
user_check=True)
return render_template("board_show.html",
rows=rows,
pagination=pagination,
downs=downs,
comments=comments)