app.py

import os
import xlsxwriter
from flask import Flask,render_template,request,jsonify
from commonutility import CommonUtility


app = Flask(__name__)

@app.route('/program/projecttest.html')
def projectTest():
    return render_template('program/projecttest.html')

@app.route('/program/wordsanimation.html')
def wordsAnimation():
    return render_template('program/wordsanimation.html')

@app.route('/program/flowanimation.html')
def flowAnimation():
    return render_template('program/flowanimation.html')

@app.route('/')
@app.route('/program')
@app.route('/program/stringsorting.html')
def stringSorting():
    return render_template('program/stringsorting.html')

@app.route('/program/populatetable.html')
def populateTable():
    return render_template('program/populatetable.html')

@app.route('/program/sendattachment.html')
def sendAttachment():
    return render_template('program/sendattachment.html')

@app.route('/program/sendattachment.html/sendAttachmentContent',methods=['POST'])
# add two excel sheets
def sendAttachmentContent():
    requestsData=request.json
    excelFileName='test.xlsx'
    sheetNames=['firstSheet','secondSheet']
    heads=['Mark','Name','Age','Degree']
    contents=[]
    for data in requestsData['students']:
        content=[]
        content.append(data['mark'])
        content.append(data['name'])
        content.append(data['age'])
        content.append(data['degree'])
        contents.append(content)
    CommonUtility.createAndWriteToExcel(excelFileName,sheetNames,[heads,heads],[contents,contents],'black','blue')
    bodyText='Please Check the attachment!'
    attachmentName='testAttachment.xlsx'
    CommonUtility.setEmailandSend('Email Test','xiazhai2017@outlook.com',requestsData['emailAddress'],
                                  None,bodyText,excelFileName,attachmentName)
    response={'success':True}
    return jsonify(response)

@app.route('/interview')
@app.route('/interview/pythonquestions.html')
def pythonQuestions():
    return render_template('/interview/pythonquestions.html')

@app.route('/interview/pythonquestions.html/getContent',methods=['POST'])
def getContent():
    fileName='pythonQuestions.txt'
    questions=CommonUtility.readTxtFile(fileName)
    fileName='pythonAnswers.txt'
    answers=CommonUtility.readTxtFile(fileName)
    return jsonify({'success':True, 'data':{'questions':questions,'answers':answers}})

@app.route('/interview/pythonquestions.html/saveContent',methods=['POST'])
def saveContent():
    data=request.json
    if(data['type']=='questions'):
        fileName = 'pythonQuestions.txt'
    else:
        fileName = 'pythonAnswers.txt'
    result=CommonUtility.writeTxtFile(fileName, data['data'])
    return jsonify({'success': result})


@app.route('/interview/pythonquestions.html/deleteContent',methods=['POST'])
def deleteContent():
    data=request.json
    if (data['type'] == 'questions'):
        fileName = 'pythonQuestions.txt'
    else:
        fileName = 'pythonAnswers.txt'
    result=CommonUtility.deleteTxtfile(fileName,data['data'])
    return jsonify({'success':result})

@app.route('/signIn',methods=['GET','POST'])
def signIn():
    return render_template('signIn.html',title='Sign In')

#has been coded
@app.route('/signOn',methods=['GET'])
def signOn():
    return render_template('signOn.html',title='Sign On')



@app.route('/program/functionalprogram.html')
def functionalProgram():
    return render_template('program/functionalprogram.html')


@app.route('/program/functionalprogram.html/request',methods=['GET','POST'])
def requestTest():
    data=request.json
    return jsonify({'success':True, 'data':data})

if __name__ == '__main__':
    app.run()