def index(req):
""" Lists all the SQL connections.
"""
items = []
create_form = CreateForm()
edit_form = EditForm(prefix='edit')
change_password_form = ChangePasswordForm()
if req.zato.cluster_id and req.method == 'GET':
zato_message, soap_response = invoke_admin_service(req.zato.cluster, 'zato:outgoing.sql.get-list', {'cluster_id': req.zato.cluster_id})
if zato_path('response.item_list.item').get_from(zato_message) is not None:
for msg_item in zato_message.response.item_list.item:
id = msg_item.id.text
name = msg_item.name.text
is_active = is_boolean(msg_item.is_active.text)
engine = msg_item.engine.text if msg_item.engine else ''
host = msg_item.host.text if msg_item.host else ''
port = msg_item.port.text if msg_item.port else ''
db_name = msg_item.db_name.text if msg_item.db_name else ''
username = msg_item.username.text if msg_item.username else ''
pool_size = msg_item.pool_size.text if msg_item.pool_size else ''
extra = msg_item.extra.text if msg_item.extra else ''
item = SQLConnectionPool()
item.id = id
item.name = name
item.is_active = is_active
item.engine = engine
item.engine_text = odb_engine_friendly_name[engine]
item.host = host
item.port = port
item.db_name = db_name
item.username = username
item.pool_size = pool_size
item.extra = extra
items.append(item)
return_data = {'zato_clusters':req.zato.clusters,
'cluster_id':req.zato.cluster_id,
'choose_cluster_form':req.zato.choose_cluster_form,
'items':items,
'create_form':create_form,
'edit_form':edit_form,
'change_password_form': change_password_form
}
return TemplateResponse(req, 'zato/outgoing/sql.html', return_data)
