def METHOD_NAME(self, provider):
    res = self.environment[
        oenginecons.EngineDBEnv.STATEMENT
    ].execute(
        statement='SELECT auth_url ' +
                  'FROM providers ' +
                  'WHERE id = %(id)s',
        args=dict(
            id=provider.id,
        ),
        ownConnection=True,
    )
    if len(res) > 0:
        return res[0]['auth_url']