def POST(self):
if web.ctx.session.login==True:
f = form.uploadfile_form()
datafile = web.input(datafile={}).datafile
msg = ''
if not f.validates():
msg = ERR_TABLE_NAME
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).Import(form.uploadfile_form(),msg)#这儿必须返回新的form，不然会出错
else:
msg = importdata(models.any2str(f.d.tablename),models.any2str(f.d.filetype),datafile,models.any2str(f.d.sep))
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).Import(form.uploadfile_form(),msg)#这儿也一样
else:
raise web.seeother("/../")
def GET(self,text):
text = any2str(text)
flist,msg = models.get_fields_name(text)
f = DynamicForm()
custom_master(f,flist)
if msg == '' :
msg = models.if_table_exists(text,config.MDM)
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).master_data(f,msg)
def POST(self):
if web.ctx.session.login==True:
f = form.search_form()
alldata=web.input()
if not f.validates():
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).search(f)
else:
if alldata.has_key('ismaster'):
rtdata=models.search_master(models.any2str(f.d.content))
else:
rtdata = models.search_all_tables(models.any2str(f.d.content))
if rtdata==None:
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).search(f,ERR_DB)
elif rtdata=={}:
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).search(f,NO_RESULT)
else:
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).search(f,THIS_RESULT,rtdata)
else:
raise web.seeother('/session/login')
def POST(self,text):
if web.ctx.session.login==True:
num = int(text.split('--')[1])
tablename = text.split('--')[0]
f = DynamicForm()
custom_form(f,num)
if not f.validates():
msg = ERR_COL_EDIT
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).columns(f,msg)
else:
fnames = [models.any2str(f["name" + str(i)].value) for i in range(num)]
fattrs = [models.any2str(f["attr" + str(i)].value) for i in range(num)]
attrs = {models.any2str('PK'):models.any2str(f["primarykey"].value)}
msg = models.create_table(models.any2str(tablename),fnames,fattrs,attrs)
if msg!='':
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).columns(f,msg)
else:
raise web.seeother('/../')
else:
raise web.seeother("/../")
def POST(self,text):
text = any2str(text)
flist,msg = models.get_fields_name(text)
f = DynamicForm()
custom_master(f,flist)
if not f.validates() or msg != '':
msg = ERR_NOTNULL
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).master_data(f,msg)
else :
tbinfo = [text]
fw = web.input()
mflist = [any2str(flist[idx]) for idx in range(len(flist)) if fw.has_key(str(idx))]
tbinfo.append(','.join(mflist))
print tbinfo[1]
msg = models.insert_column(config.MDM,tbinfo,('text','text'))
models.db.commit()
if msg != '':
return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).master_data(f,msg)
else :
raise web.seeother('/../')
