def insertDataset():
try:
if session['loginRole'] == 'admin':
datasetVO = DatasetVO()
datasetDAO = DatasetDAO()
UPLOAD_FOLDER = 'C:/project/admin/project/static/adminResources/dataset'
app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER
file = request.files['datasetFile']
filename = secure_filename(file.filename)
filepath = os.path.join(app.config['UPLOAD_FOLDER'])
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
datasetVO.datasetFilename = filename
datasetVO.datasetFilepath = filepath
datasetVO.datasetDescription = request.form['datasetDescription']
datasetVO.datasetActiveStatus = 'active'
datasetDAO.insertDataset(datasetVO)
return render_template('admin/addDataset.html')
else:
return render_template('admin/login.html')
except:
return render_template('admin/login.html')
def adminInsertDataset():
try:
if adminLoginSession() == 'admin':
UPLOAD_FOLDER = 'project/static/adminResources/dataset/' # setting path of storage data
app.config[
'UPLOAD_FOLDER'] = UPLOAD_FOLDER # update config path of folder
datasetVO = DatasetVO()
datasetDAO = DatasetDAO()
file = request.files['file'] # getting filename from addDataset
datasetFilename = secure_filename(file.filename)
datasetFilepath = os.path.join(
app.config['UPLOAD_FOLDER']) # setting value in variable
file.save(os.path.join(datasetFilepath, datasetFilename)
) # saving file in dataset folder with filename
datasetVO.datasetFilename = datasetFilename # saving filename in database
todayDate = date.today()
datasetVO.uploadDate = todayDate # saving current date in database
nowTime = datetime.now()
datasetVO.uploadTime = nowTime.strftime(
"%H:%M:%S") # saving current date in database
filepath = datasetFilepath.replace("project", "..")
datasetVO.datasetFilePath = str(
filepath) # saving filepath in database
datasetDAO.insertDataset(datasetVO)
return redirect(url_for('adminViewDataset'))
else:
adminLogoutSession()
except Exception as ex:
print(ex)
def userInsertDataset(file):
try:
if adminLoginSession() == 'user':
datasetVO = DatasetVO()
datasetDAO = DatasetDAO()
file = file # getting filename from addDataset
datasetFilename = secure_filename(file.filename)
datasetFilepath = os.path.join(
app.config['UPLOAD_FOLDER']) # setting value in variable
file.save(os.path.join(datasetFilepath, datasetFilename))
datasetVO.datasetFilename = datasetFilename # saving filename in database
todayDate = date.today()
datasetVO.uploadDate = todayDate # saving current date in database
nowTime = datetime.now()
datasetVO.uploadTime = nowTime.strftime(
"%H:%M:%S") # saving current date in database
filepath = datasetFilepath.replace("project", "..")
datasetVO.datasetFilePath = str(
filepath) # saving filepath in database
filepath = str(filepath)
datasetDAO.insertDataset(datasetVO)
return datasetFilename, filepath
else:
adminLogoutSession()
except Exception as ex:
print(ex)
def adminInsertDataset():
try:
if adminLoginSession() == 'admin':
datasetVO = DatasetVO()
datasetDAO = DatasetDAO()
file = request.files['file']
print(file)
datasetFilename = secure_filename(file.filename)
print(datasetFilename)
now = datetime.now()
print("now=", now)
datasetUploadDate = now.strftime("%Y/%m/%d")
print("date =", datasetUploadDate)
datasetUploadTime = now.strftime("%H:%M:%S")
print("time =", datasetUploadTime)
datasetFilepath = os.path.join(app.config['UPLOAD_FOLDER'])
print(datasetFilepath)
file.save(os.path.join(datasetFilepath, datasetFilename))
datasetVO.datasetFilename = datasetFilename
datasetVO.datasetUploadDate = datasetUploadDate
datasetVO.datasetUploadTime = datasetUploadTime
datasetVO.datasetFilepath = datasetFilepath.replace(
"project", "..")
datasetDAO.insertDataset(datasetVO)
return redirect(url_for('adminViewDataset'))
else:
return adminLogoutSession()
except Exception as ex:
print(ex)