from flask import Flask, render_template, request
from pymysql import *
from datetime import datetime

app = Flask(__name__)

@app.route('/board_main')
def main():
	conn = connect(host='localhost', user='root', password='********',db='test', charset='utf')
	curs = conn.cursor(pymysql.cursors.DictCursor)
	sql = "select * from board"
	currs.execute(sql)
	rows = curs.fetchall()
	conn.close()

	return render_template('main.html',result = rows)

@app.route('/board_write')
def board_write():
	return render_template('write.html')

@app.route('/write_process',methods = ['POST','GET'])
def write_process():
	if request.method == "POST":
		result = request.form
		conn = connect(host='localhost', user='root', password='********',db='test', charset='utf')
        	curs = conn.cursor()
         	sql = """insert into board(title,name,description,created)
			values (%s,%s,%s,%s)"""

		now = datetime.now()
		datenow = now.year+now.month+now.day

		curs.excute(sql,(result['title'],result['name'],result['description'],int(datenow))

		conn.commit()
		conn.close()

if __name__ == '__main__':
   app.run(debug = True, host='0.0.0.0')