import ckan.logic as logic
import ckan.plugins as plugins
import ckan.lib.dictization as d
import ckan.lib.navl.dictization_functions
import ckan.lib.plugins as lib_plugins
import urlparse
import ckanext.ecportal.schema as schema
import ckanext.ecportal.helpers as helpers
import ckanext.ecportal.unicode_sort as unicode_sort
_validate = ckan.lib.navl.dictization_functions.validate
def _get_filename_and_extension(resource):
    url = resource.get('url').rstrip('/')
    if '?' in url:
        return '', ''
    if 'URL' in url:
        return '', ''
    url = urlparse.urlparse(url).path
    split = url.split('/')
    last_part = split[-1]
    ending = last_part.split('.')[-1].lower()
    if len(ending) in [2, 3, 4] and len(last_part) > 4 and len(split) > 1:
        return last_part, ending
    return '', ''
# wrapper around group update, *always* adds on packages
def group_update(context, data_dict):
    '''Update a group.
    You must be authorized to edit the group.
    Note: unlike ``group_create()``, the list of packages belonging to the
          group is ignored.  This is a deviation from the standard CKAN API
          specific to ECODP.
    :param id: the name or id of the group to update
    :type id: string
    :param name: the name of the group, a string between 2 and 100 characters
        long, containing only lowercase alphanumeric characters, ``-`` and
    :type name: string
    :param title: the title of the group (optional)
    :type title: string
    :param description: the description of the group (optional)
    :type description: string
    :param image_url: the URL to an image to be displayed on the group's page
    :type image_url: string
    :param type: the type of the group (optional), ``IGroupForm`` plugins
        associate themselves with different group types and provide custom
        group handling behaviour for these types
    :type type: string
    :param state: the current state of the group, e.g. ``'active'`` or
        ``'deleted'``, only active groups show up in search results and
        other lists of groups, this parameter will be ignored if you are not
        authorized to change the state of the group (optional, default:
    :type state: string
    :param approval_status: (optional)
    :type approval_status: string
    :param extras: the group's extras (optional), extras are arbitrary
        (key: value) metadata items that can be added to groups, each extra
        dictionary should have keys ``'key'`` (a string), ``'value'`` (a
        string), and optionally ``'deleted'``
    :type extras: list of dataset extra dictionaries
    :param groups: the groups that belong to the group, a list of dictionaries
        each with key ``'name'`` (string, the id or name of the group) and
        optionally ``'capacity'`` (string, the capacity in which the group is
        a member of the group)
    :type groups: list of dictionaries
    :param users: the users that belong to the group, a list of dictionaries
        each with key ``'name'`` (string, the id or name of the user) and
        optionally ``'capacity'`` (string, the capacity in which the user is
        a member of the group)
    :type users: list of dictionaries
    :returns: the updated group
    :rtype: dictionary
    model = context['model']
    session = context['session']
    id = data_dict.get('id')
    group = model.Group.get(id)
    if group is None:
        raise logic.NotFound('Group was not found.')
    # If the context requires it, then update the packages, as would normally
    # happen with the group_update action.
    if not context.get('ecodp_update_packages', False):
        members = session.query(model.Member.table_id).filter_by(
        packages = []
        for member in members:
            packages.append({'name': member[0]})
        data_dict['packages'] = packages
    # can't save display_name so remove it from data_dict
    data_dict.pop('display_name', None)
    return logic.action.update.group_update(context, data_dict)
# copy of group_dictize form core only change removing package_list dictize
def group_dictize(group, context):
    result_dict = d.table_dictize(group, context)
    result_dict['display_name'] = group.display_name
    result_dict['extras'] = d.model_dictize.extras_dict_dictize(
        group._extras, context)
    context['with_capacity'] = True
    if context.get('ecodp_with_package_list', False):
        result_dict['packages'] = d.obj_list_dictize(
            d.model_dictize._get_members(context, group, 'packages'),
    result_dict['tags'] = d.model_dictize.tag_list_dictize(
        d.model_dictize._get_members(context, group, 'tags'),
    result_dict['groups'] = d.model_dictize.group_list_dictize(
        d.model_dictize._get_members(context, group, 'groups'),
    result_dict['users'] = d.model_dictize.user_list_dictize(
        d.model_dictize._get_members(context, group, 'users'),
    context['with_capacity'] = False
    if context.get('for_view'):
        for item in plugins.PluginImplementations(plugins.IGroupController):
            result_dict = item.before_view(result_dict)
    return result_dict
# copy of core group show only change is using group_dictize above
def group_show(context, data_dict):
    '''Return the details of a group.
    :param id: the id or name of the group
    :type id: string
    :rtype: dictionary
    model = context['model']
    id = data_dict['id']
    group = model.Group.get(id)
    context['group'] = group
    if group is None or group.state == u'deleted':
        raise logic.NotFound
    logic.check_access('group_show', context, data_dict)
    group_dict = group_dictize(group, context)
    for item in plugins.PluginImplementations(plugins.IGroupController):
    group_plugin = lib_plugins.lookup_group_plugin(group_dict['type'])
        group_schema = group_plugin.db_to_form_schema_options({
            'type': 'show',
            'api': 'api_version' in context,
            'context': context
    except AttributeError:
        group_schema = group_plugin.db_to_form_schema()
    if group_schema:
        package_dict, errors = _validate(group_dict, group_schema,
    return group_dict
def sort_group(key):
    if isinstance(key, basestring):
        display_name = key
        display_name = key.get('display_name', '')
    # Strip accents first and if equivilant do next stage comparison.
    # Leaving space and concatenating is to avoid having todo a real
    # 2 level sort.
    return (unicode_sort.strip_accents(display_name) +
            '   ' +
def group_list(context, data_dict):
    '''Return a list of the names of the site's groups.
    :param order_by: the field to sort the list by, must be ``'name'`` or
      ``'packages'`` (optional, default: ``'name'``) Deprecated use sort.
    :type order_by: string
    :param sort: sorting of the search results.  Optional.  Default:
        "name asc" string of field name and sort-order. The allowed fields are
        'name' and 'packages'
    :type sort: string
    :param groups: a list of names of the groups to return, if given only
        groups whose names are in this list will be returned (optional)
    :type groups: list of strings
    :param all_fields: return full group dictionaries instead of  just names
        (optional, default: ``False``)
    :type all_fields: boolean
    :rtype: list of strings
    groups = logic.action.get.group_list(context, data_dict)
    if context.get('for_view', False):
        # in the web UI only list publishers with published datasets
        # depending upon the context, group['packages'] may be either a
        # count of the packages, or the actual list of packages
        if groups and isinstance(groups[0]['packages'], int):
            groups = [g for g in groups if g['packages'] > 0]
            groups = [g for g in groups if len(g['packages']) > 0]
    return sorted(groups, key=sort_group)
def _change_resource_details(resource):
    formats = helpers.resource_mapping().keys()
    resource_format = resource.get('format', '').lower().lstrip('.')
    filename, extension = _get_filename_and_extension(resource)
    if not resource_format:
        resource_format = extension
    if resource_format in formats:
        resource['format'] = helpers.resource_mapping()[resource_format][0]
        if resource.get('name', '') in ['Unnamed resource', '', None]:
            resource['name'] = helpers.resource_mapping()[resource_format][2]
            if filename:
                resource['name'] = resource['name']
    elif resource.get('name', '') in ['Unnamed resource', '', None]:
        if extension and not resource_format:
            if extension in formats:
                resource['format'] = helpers.resource_mapping()[extension][0]
                resource['format'] = extension.upper()
        resource['name'] = 'Web Page'
    if filename and not resource.get('description'):
        resource['description'] = filename
def package_show(context, data_dict):
    '''Return the metadata of a dataset (package) and its resources.
    :param id: the id or name of the dataset
    :type id: string
    :rtype: dictionary
    # Override package_show to sort the resources by name
    result = logic.action.get.package_show(context, data_dict)
    def order_key(resource):
        return resource.get('name', resource.get('description', ''))
    if 'resources' in result:
        for resource in result['resources']:
    return result
def package_search(context, data_dict):
    Searches for packages satisfying a given search criteria.
    This action accepts solr search query parameters (details below), and
    returns a dictionary of results, including dictized datasets that match
    the search criteria, a search count and also facet information.
    **Solr Parameters:**
    For more in depth treatment of each paramter, please read the `Solr
    Documentation <>`_.
    This action accepts a *subset* of solr's search query parameters:
    :param q: the solr query.  Optional.  Default: `"*:*"`
    :type q: string
    :param fq: any filter queries to apply.  Note: `+site_id:{ckan_site_id}`
        is added to this string prior to the query being executed.
    :type fq: string
    :param rows: the number of matching rows to return.
    :type rows: int
    :param sort: sorting of the search results.  Optional.  Default:
        "score desc, name asc".  As per the solr documentation, this is a
        comma-separated string of field names and sort-orderings.
    :type sort: string
    :param start: the offset in the complete result for where the set of
        returned datasets should begin.
    :type start: int
    :param qf: the dismax query fields to search within, including boosts.  See
      the `Solr Dismax Documentation
      for further details.
    :type qf: string
    :param facet: whether to enable faceted results.  Default: "true".
    :type facet: string
    :param facet.mincount: the minimum counts for facet fields should be
        included in the results.
    :type facet.mincount: int
    :param facet.limit: the maximum number of constraint counts that should be
        returned for the facet fields. A negative value means unlimited
    :type facet.limit: int
    :param facet.field: the fields to facet upon.  Default empty.  If empty,
        then the returned facet information is empty.
    :type facet.field: list of strings
    The result of this action is a dict with the following keys:
    :rtype: A dictionary with the following keys
    :param count: the number of results found.  Note, this is the total number
        of results found, not the total number of results returned (which is
        affected by limit and row parameters used in the input).
    :type count: int
    :param results: ordered list of datasets matching the query, where the
        ordering defined by the sort parameter used in the query.
    :type results: list of dictized datasets.
    :param facets: DEPRECATED.  Aggregated information about facet counts.
    :type facets: DEPRECATED dict
    :param search_facets: aggregated information about facet counts.  The outer
        dict is keyed by the facet field name (as used in the search query).
        Each entry of the outer dict is itself a dict, with a "title" key, and
        an "items" key.  The "items" key's value is a list of dicts, each with
        "count", "display_name" and "name" entries.  The display_name is a
        form of the name that can be used in titles.
    :type search_facets: nested dict of dicts.
    An example result: ::
     {'count': 2,
      'results': [ { <snip> }, { <snip> }],
      'search_facets': {u'tags': {'items': [{'count': 1,
                                             'display_name': u'tolstoy',
                                             'name': u'tolstoy'},
                                            {'count': 2,
                                             'display_name': u'russian',
                                             'name': u'russian'}
    The full solr query language is not exposed, including.
        The parameter that controls which fields are returned in the solr
        query cannot be changed.  CKAN always returns the matched datasets as
        dictionary objects.
    # Override package_search to show private datasets to authorized users
    # (sysadmins) when searching in a group.
    if context.get('user') and context.get('group'):
                'package_search_private_datasets', context, data_dict)
            # quite ugly, but these values are set in the group
            # read controller in core for users that are part of a group
            context['ignore_capacity_check'] = True
            data_dict['fq'] = 'groups:"{0}"'.format(context['group'].name)
        except plugins.toolkit.NotAuthorized:
    return logic.action.get.package_search(context, data_dict)
def resource_show(context, data_dict):
    resource = logic.action.get.resource_show(context, data_dict)
    return resource
def purge_publisher_datasets(context, data_dict):
    Purge all deleted datasets belonging to a given publisher.
    :returns: number of revisions purged.
    :rtype: dictionary
    logic.check_access('purge_publisher_datasets', context, data_dict)
    model = context['model']
    engine = model.meta.engine
    publisher_name = logic.get_or_bust(data_dict, 'name')
    group = model.Group.get(publisher_name)
    if not group:
        raise logic.NotFound('Publisher {0} not found'.format(publisher_name))
    deleted_datasets = '''
    SELECT FROM package
    INNER JOIN member ON (member.table_name='package' AND
    INNER JOIN "group" ON ("group".id=member.group_id)
    WHERE "group".name='{publisher_name}' AND package.state='deleted';
        datasets = engine.execute(deleted_datasets)
        num_deleted_datasets = datasets.rowcount
    except Exception, e:
        raise logic.ActionError('Error executing sql: %s' % e)
    for result in datasets:
        dataset = model.Package.get(
    return {'publisher_datasets_deleted': num_deleted_datasets}
def purge_revision_history(context, data_dict):
    Purge a given publisher's unused revision history.
    :param group: the name or id of the publisher
    :type group: string
    :returns: number of resources and revisions purged.
    :rtype: dictionary
    logic.check_access('purge_revision_history', context, data_dict)
    model = context['model']
    engine = model.meta.engine
    group_id = logic.get_or_bust(data_dict, 'group')
    group = model.Group.get(group_id)
    if not group:
        raise logic.NotFound('Publisher {0} not found'.format(group_id))
        SELECT FROM resource
        JOIN resource_group ON resource.resource_group_id =
        JOIN member ON member.table_id = resource_group.package_id
        JOIN "group" ON "group".id = member.group_id
        WHERE "group".name      = %s
          AND "group".type      = 'organization'
          AND member.table_name = 'package'
          AND resource.state    = 'deleted'
        DELETE FROM resource_revision
            WHERE id IN ({sql})
    # Not necessary to use a sub-select, but it allows re-use of sql statement
    # and this isn't performance critical code.
        DELETE FROM resource WHERE id IN ({sql})
        number_revisions_deleted = engine.execute(
        number_resources_deleted = engine.execute(
    except Exception, e:
        raise logic.ActionError('Error executing sql: %s' % e)
    return {'number_revisions_deleted': number_revisions_deleted,
            'number_resources_deleted': number_resources_deleted}
def purge_package_extra_revision(context, data_dict):
    Purge old data from the package_extra_revision table.
    :returns: number of revisions purged.
    :rtype: dictionary
    logic.check_access('purge_package_extra_revision', context, data_dict)
    model = context['model']
    engine = model.meta.engine
    delete_old_extra_revisions = '''
        DELETE FROM package_extra_revision WHERE current=false;
        revision_rows_deleted = engine.execute(
    except Exception, e:
        raise logic.ActionError('Error executing sql: %s' % e)
    return {'revision_rows_deleted': revision_rows_deleted}
def purge_task_data(context, data_dict):
    Purge data from the task_status and kombu_message tables
    (used by CKAN tasks and Celery).
    To just clear the Celery data (and not the task_status table),
    see the 'celery clean' command in CKAN core.
    :returns: number of task_status and Celery (kombu_message) rows deleted.
    :rtype: dictionary
    logic.check_access('purge_task_data', context, data_dict)
    model = context['model']
    engine = model.meta.engine
    purge_task_status = 'DELETE FROM task_status;'
    purge_celery_data = 'DELETE FROM kombu_message;'
        task_status_rows_deleted = engine.execute(purge_task_status).rowcount
        celery_rows_deleted = engine.execute(purge_celery_data).rowcount
    except Exception, e:
        raise logic.ActionError('Error executing sql: %s' % e)
    return {'task_status_rows_deleted': task_status_rows_deleted,
            'celery_rows_deleted': celery_rows_deleted}
def user_create(context, data_dict):
    '''Create a new user.
    You must be authorized to create users.
    Wrapper around core user_create action ensures that the ECODP custom user
    schema are used.
    :param name: the name of the new user, a string between 2 and 100
        characters in length, containing only alphanumeric characters, ``-``
        and ``_``
    :type name: string
    :param email: the email address for the new user (optional)
    :type email: string
    :param password: the password of the new user, a string of at least 4
    :type password: string
    :param id: the id of the new user (optional)
    :type id: string
    :param fullname: the full name of the new user (optional)
    :type fullname: string
    :param about: a description of the new user (optional)
    :type about: string
    :param openid: (optional)
    :type openid: string
    :returns: the newly created user
    :rtype: dictionary
    new_context = context.copy()  # Don't modify caller's context
    user_schema = context.get('schema', logic.schema.default_user_schema())
    new_context['schema'] = schema.default_user_schema(user_schema)
    return logic.action.create.user_create(new_context, data_dict)
def user_update(context, data_dict):
    '''Update a user account.
    Normal users can only update their own user accounts. Sysadmins can update
    any user account.
    For further parameters see ``user_create()``.
    :param id: the name or id of the user to update
    :type id: string
    :returns: the updated user account
    :rtype: dictionary
    new_context = context.copy()  # Don't modify caller's context
    user_schema = context.get('schema',
    new_context['schema'] = schema.default_update_user_schema(user_schema)
    return logic.action.update.user_update(new_context, data_dict)