def processar():
iderwin = request.args(0)
if not iderwin:
session.flash = 'Nenhum SGDB selecionado'
else:
sgdb = db(db.erwins.id == iderwin).select().first()
if sgdb.status != 5:
session.flash = 'Para processamento, realize a validacao primeiro'
else:
parms = db(db.parametros.id == 1).select().first()
arqui = os.path.join('\\\\', '127.0.0.1', 'c$', parms.web2py,
'applications', parms.soag, 'private',
'sgdb_%s.pickle' % iderwin)
try:
session.pickef = utl.unPic(arqui)
except:
session.pickef = None
loadDb = LoadDB.LoadDB(db,
cAppl=session.aplicacao_id,
iderwin=iderwin)
model = modelo.Sqlalchemy(db, cAppl=None)
model.load(picke=session.pickef)
prc = loadDb.processarSqlalchemy(model)
if prc['retorno']:
db(db.erwins.id == iderwin).update(
status=6,
mensagem='Processamento Efetuado',
usuarioConfirmacao=auth.user.id,
dataConfirmacao=datetime.datetime.today())
session.status_id = 2
session.flash = prc['flash']
session.labelErrors = prc['labelErrors']
session.msgsErrors = prc['msgsErrors']
def processar():
iderwin = request.args(0)
if not iderwin:
session.flash = 'Nenhum SGDB selecionado'
else:
sgdb = db(db.erwins.id == iderwin).select().first()
if sgdb.status != 5:
session.flash = 'Para processamento, realize a validacao primeiro'
else:
parms = db(db.parametros.id == 1).select().first()
arqui = os.path.join( '\\\\'
, '127.0.0.1'
, 'c$'
, parms.web2py
, 'applications'
, parms.soag
, 'private'
, 'sgdb_%s.pickle' % iderwin)
try:
session.pickef = utl.unPic(arqui)
except:
session.pickef = None
loadDb = LoadDB.LoadDB(db, cAppl=session.aplicacao_id, iderwin=iderwin)
model = modelo.Sqlalchemy(db, cAppl=None)
model.load(picke=session.pickef)
prc = loadDb.processarSqlalchemy(model)
if prc['retorno']:
db(db.erwins.id == iderwin).update(status=6,
mensagem='Processamento Efetuado',
usuarioConfirmacao=auth.user.id,
dataConfirmacao=datetime.datetime.today())
session.status_id = 2
session.flash = prc['flash']
session.labelErrors = prc['labelErrors']
session.msgsErrors = prc['msgsErrors']
def index():
iderwin = request.args(0)
if iderwin:
session.iderwin = iderwin
else:
session.iderwin = 0
if request.vars:
idaplicacao = int(request.vars.aplicacao_id or 0)
else:
idaplicacao = int(session.aplicacao_id or 0)
if session.aplicacao_id <> idaplicacao:
session.aplicacao_id = idaplicacao
redirect(URL('index'))
if request.vars:
idstatus = int(request.vars.status_id or 2)
else:
idstatus = session.status_id or 2
if session.status_id <> idstatus:
session.status_id = idstatus
redirect(URL('index'))
if not iderwin:
erwins.nome.requires = IS_IN_DB(db(database.codigoAplicacao==session.aplicacao_id)
,database.nameDB
,'%(nameDB)s', zero='-- Selecione --')
else:
erwins.nome.writable = False
erwins.lookups = {'status': ['statussgdb', ['descricao']], \
'usuarioConfirmacao': ['auth_user', ['first_name','last_name']]}
form = SQLFORM(erwins, iderwin, deletable=True,
hidden=dict(codigoAplicacao=idaplicacao))
if not iderwin:
form.vars.status = request.vars.status = 2
form.vars.mensagem = 'Pendente de Teste de Conexao'
form.vars.usuarioConfirmacao = request.vars.usuarioConfirmacao = auth.user.id
form.vars.dataConfirmacao = datetime.datetime.today()
optionDelete = True if (auth.user) and (auth.has_membership(1, auth.user.id, 'Administrador')) else False
else:
sgdb = db(db.erwins.id==iderwin).select()[0]
if sgdb.status == 6:
optionDelete = False
form = SQLFORM(erwins, iderwin)
else:
erwins.nome.writable = True
form.vars.status = request.vars.status = 2
form.vars.mensagem = 'Pendente de Teste de Conexao'
form.vars.usuarioConfirmacao = request.vars.usuarioConfirmacao = auth.user.id
form.vars.dataConfirmacao = datetime.datetime.today()
optionDelete = True if (auth.user) and (auth.has_membership(1, auth.user.id, 'Administrador')) else False
if form.accepts(request.vars, session):
if request.vars.has_key('delete_this_record') and request.vars.delete_this_record == 'on':
session.flash = 'SGDB Excluido'
redirect(URL('index'))
else:
if iderwin:
session.flash = 'SGDB Alterado'
redirect(URL('index', args=(iderwin)))
else:
response.flash = 'SGDB Incluído'
if session.flash:
response.flash = session.flash
session.flash = None
if session.labelErrors:
form.labelErrors = session.labelErrors
session.labelErrors = None
if session.msgsErrors:
form.errors = session.msgsErrors
session.msgsErrors = None
if idstatus == 1:
query = (db.erwins.id<0) \
if not idaplicacao else \
((db.erwins.codigoAplicacao==idaplicacao) & (db.erwins.arquivo==''))
else:
query = (db.erwins.id<0) \
if not idaplicacao else ((db.erwins.codigoAplicacao==idaplicacao) &
(db.erwins.arquivo=='') &
(db.erwins.status==idstatus))
parms = db(db.parametros.id == 1).select().first()
arqui = os.path.join( '\\\\'
, '127.0.0.1'
, 'c$'
, parms.web2py
, 'applications'
, parms.soag
, 'private'
, 'sgdb_%s.pickle' % iderwin)
try:
session.pickef = utl.unPic(arqui)
except:
session.pickef = None
buttonSelectProguess = []
if iderwin and sgdb.status == 2:
buttonSelectProguess = [['Testar Conexao', URL('testConn', args=(iderwin)),
URL('index', args=(iderwin))]]
if iderwin and sgdb.status == 3:
buttonSelectProguess = [['Importar', URL('importar', args=(iderwin)),
URL('index', args=(iderwin))]]
if iderwin and sgdb.status == 4:
if session.pickef:
buttonSelectProguess = [['Validar', 'validar', '210', '350','300', '600']]
if iderwin and sgdb.status == 5:
if session.pickef:
buttonSelectProguess = [['Processar', URL('processar', args=(iderwin)),
URL('index', args=(iderwin))]]
return dict(listdetail.index(['SGDB',
'<br/>Aplicacao:',
str(utl.Select(db,
name='aplicacao_id',
table='aplicacoes',
fields=['id','descricao'],
filtro='' \
if (auth.user) and \
(auth.has_membership(1, \
auth.user.id, \
'Administrador')) \
else \
db['aplicacoes'].empresa==\
auth.user.empresa,
value=idaplicacao)),
'Status:',
str(utl.Select(db,
name='status_id',
table='statussgdb',
fields=['id','descricao'],
orderby='id',
value=idstatus))],
'erwins', erwins,
query,
form, fields=['id','nome','status'],
noDetail=['codigoAplicacao',
'nomeExterno1',
'arquivo',
'default1',
'nomeExterno2',
'nomeExterno3',
'default3'],
scroll=['5%','60%','35%'],
search=['nome','status'],
optionDelete=optionDelete,
buttonClear=True,
buttonProcess=False,
buttonSelectProguess=buttonSelectProguess,
buttonSubmit=True if idaplicacao and idstatus else False))
def index():
iderwin = request.args(0)
if iderwin:
session.iderwin = iderwin
else:
session.iderwin = 0
if request.vars:
idaplicacao = int(request.vars.aplicacao_id or 0)
else:
idaplicacao = int(session.aplicacao_id or 0)
if session.aplicacao_id <> idaplicacao:
session.aplicacao_id = idaplicacao
redirect(URL('index'))
if request.vars:
idstatus = int(request.vars.status_id or 2)
else:
idstatus = session.status_id or 2
if session.status_id <> idstatus:
session.status_id = idstatus
redirect(URL('index'))
if not iderwin:
erwins.nome.requires = IS_IN_DB(
db(database.codigoAplicacao == session.aplicacao_id),
database.nameDB,
'%(nameDB)s',
zero='-- Selecione --')
else:
erwins.nome.writable = False
erwins.lookups = {'status': ['statussgdb', ['descricao']], \
'usuarioConfirmacao': ['auth_user', ['first_name','last_name']]}
form = SQLFORM(erwins,
iderwin,
deletable=True,
hidden=dict(codigoAplicacao=idaplicacao))
if not iderwin:
form.vars.status = request.vars.status = 2
form.vars.mensagem = 'Pendente de Teste de Conexao'
form.vars.usuarioConfirmacao = request.vars.usuarioConfirmacao = auth.user.id
form.vars.dataConfirmacao = datetime.datetime.today()
optionDelete = True if (auth.user) and (auth.has_membership(
1, auth.user.id, 'Administrador')) else False
else:
sgdb = db(db.erwins.id == iderwin).select()[0]
if sgdb.status == 6:
optionDelete = False
form = SQLFORM(erwins, iderwin)
else:
erwins.nome.writable = True
form.vars.status = request.vars.status = 2
form.vars.mensagem = 'Pendente de Teste de Conexao'
form.vars.usuarioConfirmacao = request.vars.usuarioConfirmacao = auth.user.id
form.vars.dataConfirmacao = datetime.datetime.today()
optionDelete = True if (auth.user) and (auth.has_membership(
1, auth.user.id, 'Administrador')) else False
if form.accepts(request.vars, session):
if request.vars.has_key('delete_this_record'
) and request.vars.delete_this_record == 'on':
session.flash = 'SGDB Excluido'
redirect(URL('index'))
else:
if iderwin:
session.flash = 'SGDB Alterado'
redirect(URL('index', args=(iderwin)))
else:
response.flash = 'SGDB Incluído'
if session.flash:
response.flash = session.flash
session.flash = None
if session.labelErrors:
form.labelErrors = session.labelErrors
session.labelErrors = None
if session.msgsErrors:
form.errors = session.msgsErrors
session.msgsErrors = None
if idstatus == 1:
query = (db.erwins.id<0) \
if not idaplicacao else \
((db.erwins.codigoAplicacao==idaplicacao) & (db.erwins.arquivo==''))
else:
query = (db.erwins.id<0) \
if not idaplicacao else ((db.erwins.codigoAplicacao==idaplicacao) &
(db.erwins.arquivo=='') &
(db.erwins.status==idstatus))
parms = db(db.parametros.id == 1).select().first()
arqui = os.path.join('\\\\', '127.0.0.1', 'c$', parms.web2py,
'applications', parms.soag, 'private',
'sgdb_%s.pickle' % iderwin)
try:
session.pickef = utl.unPic(arqui)
except:
session.pickef = None
buttonSelectProguess = []
if iderwin and sgdb.status == 2:
buttonSelectProguess = [[
'Testar Conexao',
URL('testConn', args=(iderwin)),
URL('index', args=(iderwin))
]]
if iderwin and sgdb.status == 3:
buttonSelectProguess = [[
'Importar',
URL('importar', args=(iderwin)),
URL('index', args=(iderwin))
]]
if iderwin and sgdb.status == 4:
if session.pickef:
buttonSelectProguess = [[
'Validar', 'validar', '210', '350', '300', '600'
]]
if iderwin and sgdb.status == 5:
if session.pickef:
buttonSelectProguess = [[
'Processar',
URL('processar', args=(iderwin)),
URL('index', args=(iderwin))
]]
return dict(listdetail.index(['SGDB',
'<br/>Aplicacao:',
str(utl.Select(db,
name='aplicacao_id',
table='aplicacoes',
fields=['id','descricao'],
filtro='' \
if (auth.user) and \
(auth.has_membership(1, \
auth.user.id, \
'Administrador')) \
else \
db['aplicacoes'].empresa==\
auth.user.empresa,
value=idaplicacao)),
'Status:',
str(utl.Select(db,
name='status_id',
table='statussgdb',
fields=['id','descricao'],
orderby='id',
value=idstatus))],
'erwins', erwins,
query,
form, fields=['id','nome','status'],
noDetail=['codigoAplicacao',
'nomeExterno1',
'arquivo',
'default1',
'nomeExterno2',
'nomeExterno3',
'default3'],
scroll=['5%','60%','35%'],
search=['nome','status'],
optionDelete=optionDelete,
buttonClear=True,
buttonProcess=False,
buttonSelectProguess=buttonSelectProguess,
buttonSubmit=True if idaplicacao and idstatus else False))
