def uploadFile(files) : if 'userToken' in session : userIdx = model.getAccountByToken(session['userToken'])[0][0] folder = os.path.join(UPLOAD_FOLDER, str(userIdx)) if not os.access(folder, os.F_OK) : os.mkdir(folder) fileExt = files.filename.rsplit('.', 1)[1].lower() if fileExt in MUSIC_EXT : fileExt = 'music' elif fileExt in MOVIE_EXT : fileExt = 'movie' elif fileExt in IMAGE_EXT : fileExt = 'image' else : fileExt = 'file' fileName = secure_filename(files.filename) filePath = os.path.join(folder, str(int(time.time())) + fileName) dbFilePath = filePath.split("/", 1)[1] files.save(filePath) nTime = datetime.datetime.fromtimestamp(time.time()) sql = "SELECT folder_idx FROM folder WHERE user_idx = %s order by folder_idx asc" % (userIdx) result = model.query(sql) if not result : sql = "INSERT INTO folder(user_idx, folder_name, folder_init_date) " sql += "VALUES (%s, 'index', '%s')" % (userIdx, nTime) model.query(sql) sql = "SELECT folder_idx FROM folder WHERE user_idx = %s order by folder_idx asc" % (userIdx) result = model.query(sql) sql = "INSERT INTO files(user_idx, folder_idx, file_origin_name, file_path, file_type, file_is_shared, folder_init_date)" sql += "VALUES (%s, %s, '%s', '%s', '%s', %s, '%s')" % (userIdx, result[0][0], fileName, dbFilePath, fileExt, 0, nTime) result = model.query(sql) return json.dumps({"result" : 1}) return json.dumps({"result" : -1})
def get(self): if self.answerID in models.query(models.Answers.id): a = models.query(models.Answers, str(self.answerID)) self.questionID = a.get_questionID() self.answer = a.get_answer() return True return False
def get(self): if self.questionID in models.query(models.Questions.id): q = models.query(models.Questions, str(self.questionID)) self.questionType = q.get_questionType() self.question = q.get_question() self.choices = q.get_choices() self.order = q.get_order() return True return False
def get(self): if self.formID in models.query(models.Forms.id): f = models.query(models.Forms, str(self.formID)) self.isOwner = self.userID == f.get_ownerID() self.questions = f.get_questions() self.userAnswers = f.get_userAnswers() if self.isTest: self.correctAnswers = f.get_correctAnswers() else: self.correctAnswers = [] return True return False
def downloadFile(fileIdx) : if 'userToken' in session : userIdx = model.getAccountByToken(session['userToken'])[0][0] sql = "SELECT file_origin_name, file_path FROM files WHERE user_idx = %s and file_idx = %s" % (userIdx, fileIdx) result = model.query(sql) if result : return send_file(result[0][1], as_attachment = True, attachment_filename = result[0][0]), 200 return "<script> alert('No Data'); history.back(-1); </script>", 404 return "<script> alert('Permission Denied'); history.back(-1); </script>", 401
def put(self): session = models.Session() if self.userID in models.query(models.Users.id): query = session.query(models.Users).filter(models.Users.id == str(self.userID)).first() query.forms = str(self.forms) else: session.add(models.Users(id=self.userID, forms=str(self.forms))) session.commit() session.close() return True
def put(self): session = models.Session() if self.answerID in models.query(models.Answers.id): query = session.query(models.Answers).filter( models.Answers.id == str(self.answerID)).first() query.questionID = str(self.questionID) query.answer = str(self.answer) else: session.add( models.Answers(id=self.answerID, questionID=self.questionID, answer=str(self.answer))) session.commit() session.close() return True
def put(self): session = models.Session() if self.formID in models.query(models.Forms.id): query = session.query(models.Forms).filter( models.Forms.id == str(self.formID)).first() query.questions = str(self.questions) query.userAnswers = str(self.userAnswers) query.correctAnswers = str(self.correctAnswers) else: session.add( models.Forms(id=models.generateUUID(self.formID[:1]), ownerID=self.ownerID, questions=str(self.questions), userAnswers=str(self.userAnswers), correctAnswers=str(self.correctAnswers))) session.commit() session.close() return True
def getFileList() : if 'userToken' in session : entries = list() userIdx = model.getAccountByToken(session['userToken'])[0][0] sql = "SELECT file_idx, folder_idx, file_origin_name, file_type, folder_init_date, file_path " sql += "FROM files where user_idx = %s" % (userIdx) result = model.query(sql) if result : for i in result : entry = dict() entry['fileIdx'] = i[0] entry['folderIdx'] = i[1] entry['fileOriginName'] = i[2] entry['fileType'] = i[3] entry['fileInitDate'] = i[4].strftime("%Y/%m/%d %H시 %M분") entry['filePath'] = i[5].split("/", 1)[1] entries.append(entry) return entries return None
def put(self): session = models.Session() if self.questionID in models.query(models.Questions.id): query = session.query(models.Questions).filter( models.Questions.id == str(self.questionID)).first() query.questionType = str(self.questionType) query.question = str(self.question) query.choices = str(self.choices) query.order = str(self.order) else: session.add( models.Questions(id=self.questionID, questionType=self.questionType, question=self.question, choices=str(self.choices), order=str(self.order))) session.commit() session.close() return True
def attribute_edit(): kwargs = {} kwargs['title'] = 'Edit Attribute' kwargs['startup_function'] = 'attributeEditPage' if request.method == 'GET': return render_template('blank.html') # otherwise, we are saving a new or updated attribute_edit # return str(request.get_json()) valid, output = models.attribute_form_process(request.get_json()) if not valid: return output, 400 try: if 'id' in output: models.attribute_insert(output) else: models.attribute_insert(output) return "success" except mysql.connector.Error as e: return str(e) + " " + models.query(), 500 except Exception as e: return str(e), 500
def bookstore_book(book_id): book = models.query(book_id) return render_template('book.html', book=book)
def bookstore_books(): books = models.query()['results'] return render_template('books.html', books=books)
def get(self, book_id): # GET http://[hostname]/api/books/[book_id] 取得書本資料 return models.query(book_id)
def get(self): # GET http://[hostname]/api/books 取得書本清單 return models.query()
def get(self): if self.userID in models.query(models.Users.id): self.forms = models.query(models.Users, str(self.userID)).get_forms() return True return False
answer = tuple(r) order = tuple(shuffle(r)) else: done = True if(not done): qID = f.addQuestion(questionTypes[qChoice-1], question, choice, order) if(f.isTest): f.addAnswer(qID, answer, order) display(userID, f.formID) if __name__ == "__main__": logged_in = False while(True): if(not logged_in): users = models.query(models.Users) print("Select an existing user or create a new user: "******". "+str(users[i-1].get_id())) print(str(len(users)+1)+". NEW USER") uChoice = int(input()) if(uChoice in range(1, len(users)+1)): u = user(users[uChoice-1].get_id()) u.forms = users[uChoice-1].get_forms() else: u = user() u.forms = [] logged_in = True sChoice = '0' if(logged_in): while(sChoice not in {'1','2', '3', 'LOGOUT'}):