old_contents: # -*- coding: utf-8 -*-
  from auth import create_service_sql
  from dicttoxml import dicttoxml
  from lxml import objectify
  from totvserprm.utils import normalize_xml
  
  
  class ConsultSQL(object):
      def __init__(self, server, username, password):
          self.service = create_service_sql(server, username, password)
  
      def get(self, codcoligada, codsistema, codsentenca, parameters):
          parameters = u";".join(["=".join([key, str(val)]) for key, val in parameters.items()])
          return_from_api = self.service.RealizarConsultaSQL(
              codColigada=codcoligada, codSistema=codsistema, codSentenca=codsentenca, parameters=parameters)
          return_from_api = normalize_xml(return_from_api)
          return_from_api = objectify.fromstring(return_from_api)
          return return_from_api.resultado if hasattr(return_from_api, 'resultado') else []
  
new_contents: # -*- coding: utf-8 -*-
  from dicttoxml import dicttoxml
  from lxml import objectify
  from totvserprm.auth import create_service_sql
  from totvserprm.utils import normalize_xml
  
  
  class ConsultSQL(object):
      def __init__(self, server, username, password):
          self.service = create_service_sql(server, username, password)
  
      def get(self, codcoligada, codsistema, codsentenca, parameters):
          parameters = u";".join(["=".join([key, str(val)]) for key, val in parameters.items()])
          return_from_api = self.service.RealizarConsultaSQL(
              codColigada=codcoligada, codSistema=codsistema, codSentenca=codsentenca, parameters=parameters)
          return_from_api = normalize_xml(return_from_api)
          return_from_api = objectify.fromstring(return_from_api)
          return return_from_api.resultado if hasattr(return_from_api, 'resultado') else []
  
subject: fix python3