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': for item in req.zato.client.invoke('zato.outgoing.sql.get-list', {'cluster_id': req.zato.cluster_id}): _item = SQLConnectionPool() for name in('id', 'name', 'is_active', 'engine', 'host', 'port', 'db_name', 'username', 'pool_size'): value = getattr(item, name) setattr(_item, name, value) _item.extra = item.extra or '' _item.engine_text = engine_friendly_name[_item.engine] 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)
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': for item in req.zato.client.invoke( 'zato.outgoing.sql.get-list', {'cluster_id': req.zato.cluster_id}): _item = SQLConnectionPool() for name in ('id', 'name', 'is_active', 'engine', 'host', 'port', 'db_name', 'username', 'pool_size'): value = getattr(item, name) setattr(_item, name, value) _item.extra = item.extra or '' _item.engine_text = engine_friendly_name[_item.engine] 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)
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)
def index(req): """ Lists all the SQL connections. """ items = [] create_form = CreateForm() edit_form = EditForm(prefix='edit') change_password_form = ChangePasswordForm() meta = None if req.zato.cluster_id and req.method == 'GET': request = { 'cluster_id': req.zato.cluster_id, 'paginate': True, 'cur_page': req.GET.get('cur_page', 1) } data, meta = parse_response_data(req.zato.client.invoke('zato.outgoing.sql.get-list', request)) for item in data: _item = SQLConnectionPool() for name in('id', 'name', 'is_active', 'engine', 'host', 'port', 'db_name', 'username', 'pool_size'): value = getattr(item, name) setattr(_item, name, value) _item.extra = item.extra or '' _item.engine_text = engine_friendly_name[_item.engine] items.append(_item) return_data = {'zato_clusters':req.zato.clusters, 'cluster_id':req.zato.cluster_id, 'search_form':req.zato.search_form, 'items':items, 'create_form':create_form, 'edit_form':edit_form, 'change_password_form': change_password_form, 'paginate':True, 'meta': meta, 'req': req, } return TemplateResponse(req, 'zato/outgoing/sql.html', return_data)