def create_app(config_filepath = "resource/config.cfg"):
from codeMarble_config import *
try:
dataDir = os.path.join(thisPath, 'codeMarble_Web', 'static', 'problems')
print dataDir
os.mkdir(dataDir)
except Exception as e:
print e
pass
app.config.from_object(codeMarbleConfig)
app.config.from_pyfile(config_filepath, silent=True)
from codeMarble_py3des import TripleDES
TripleDES.init()
from codeMarble_logger import Log
Log.init()
from cache_session import SimpleCacheSessionInterface
app.session_interface = SimpleCacheSessionInterface()
from database import DBManager
DBManager.init(app.config['DB_URL'])
DBManager.init_db()
from controller import *
from codeMarble_blueprint import codeMarble
app.register_blueprint(codeMarble)
return app
def create_app(config_filepath = "resource/config.cfg"):
from codeMarble_config import codeMarbleConfig
app.config.from_object(codeMarbleConfig)
app.config.from_pyfile(config_filepath, silent=True)
from codeMarble_py3des import TripleDES
TripleDES.init()
from codeMarble_logger import Log
Log.init()
from cache_session import SimpleCacheSessionInterface
app.session_interface = SimpleCacheSessionInterface()
from database import DBManager
DBManager.init(app.config['DB_URL'])
DBManager.init_db()
from controller import *
from codeMarble_blueprint import codeMarble
app.register_blueprint(codeMarble)
return app
def index():
return 'procedure test'
@app.route('/procedure/<num1>/<num2>')
def procedure_test(num1, num2):
cursor = DBManager.conn.cursor()
try:
cursor.callproc('multiply', (num1,num2,0))
cursor.execute('select @_multiply_2')
results = list(cursor.fetchone())
return str(results[0])
finally:
cursor.close()
@app.route('/insertbook')
def insertbook():
cursor = DBManager.conn.cursor()
try:
cursor.execute('select books.bookID from books order by bookID * 1 DESC limit 1')
last_idx = int(cursor.fetchone()[0])
last_idx = last_idx+1
cursor.callproc('INSERT_BOOK', (last_idx, 'newbook', 32000, 'novel', 0))
cursor.execute('select @_INSERT_BOOK_0, @_INSERT_BOOK_4')
result = cursor.fetchone()
return "책 insert 결과 : "+str(result)
finally:
cursor.close()
if __name__ == '__main__':
DBManager.init()
app.run(port=2323, debug=True)
