Produits Entr'ouvert » w.c.s.

def test_api_global_geojson(pub, local_user):

    Role.wipe()

    role = Role(name='test')

    role.store()

    FormDef.wipe()

    formdef = FormDef()

    formdef.name = 'test'

    formdef.workflow_roles = {'_receiver': role.id}

    formdef.fields = []

    formdef.store()

    data_class = formdef.data_class()

    data_class.wipe()

    formdef.geolocations = {'base': 'Location'}

    formdef.store()

    for i in range(30):

        formdata = data_class()

        date = time.strptime('2014-01-20', '%Y-%m-%d')

        formdata.geolocations = {'base': {'lat': 48, 'lon': 2}}

        formdata.user_id = local_user.id

        formdata.just_created()

        if i%3 == 0:

            formdata.jump_status('new')

        else:

            formdata.jump_status('finished')

        formdata.store()

    if not pub.is_using_postgresql():

        resp = get_app(pub).get(sign_uri('/api/forms/geojson', user=local_user), status=404)

        pytest.skip('this requires SQL')

        return

    # check empty content if user doesn't have the appropriate role

    resp = get_app(pub).get(sign_uri('/api/forms/geojson', user=local_user))

    assert 'features' in resp.json

    assert len(resp.json['features']) == 0

    # add proper role to user

    local_user.roles = [role.id]

    local_user.store()

    # check it gets the data

    resp = get_app(pub).get(sign_uri('/api/forms/geojson', user=local_user))

    assert 'features' in resp.json

    assert len(resp.json['features']) == 10

    # check with a filter

    resp = get_app(pub).get(sign_uri('/api/forms/geojson?status=done', user=local_user))

    assert 'features' in resp.json

    assert len(resp.json['features']) == 20

def test_api_global_listing(pub, local_user):

    Role.wipe()

    role = Role(name='test')

    role.store()

    FormDef.wipe()

    formdef = FormDef()

    formdef.name = 'test'

    formdef.workflow_roles = {'_receiver': role.id}

    formdef.fields = [

        fields.StringField(id='0', label='foobar', varname='foobar'),

        ]

    formdef.store()

    data_class = formdef.data_class()

    data_class.wipe()

    formdef.store()

    for i in range(30):

        formdata = data_class()

        date = time.strptime('2014-01-20', '%Y-%m-%d')

        formdata.data = {'0': 'FOO BAR'}

        formdata.user_id = local_user.id

        formdata.just_created()

        if i%3 == 0:

            formdata.jump_status('new')

        else:

            formdata.jump_status('finished')

        formdata.store()

    if not pub.is_using_postgresql():

        resp = get_app(pub).get(sign_uri('/api/forms/geojson', user=local_user), status=404)

        pytest.skip('this requires SQL')

        return

    # check empty content if user doesn't have the appropriate role

    resp = get_app(pub).get(sign_uri('/api/forms/', user=local_user))

    assert len(resp.json['data']) == 0

    # add proper role to user

    local_user.roles = [role.id]

    local_user.store()

    # check it gets the data

    resp = get_app(pub).get(sign_uri('/api/forms/', user=local_user))

    assert len(resp.json['data']) == 10

    # check with a filter

    resp = get_app(pub).get(sign_uri('/api/forms/?status=done', user=local_user))

    assert len(resp.json['data']) == 20

from quixote.directory import Directory, AccessControlled

from backoffice.management import ManagementDirectory

def get_formdata_dict(formdata, user, consider_status_visibility=True):

    if consider_status_visibility:

        status = formdata.get_visible_status(user=user)

        if not status:

            # skip hidden forms

            return None

    else:

        status = formdata.get_status()

    title = _('%(name)s #%(id)s (%(status)s)') % {

            'name': formdata.formdef.name,

            'id': formdata.get_display_id(),

            'status': status.name,

    }

    d = {'title': title,

        'name': formdata.formdef.name,

        'url': formdata.get_url(),

        'datetime': misc.strftime.strftime('%Y-%m-%d %H:%M:%S', formdata.receipt_time),

        'status': status.name,

        'status_css_class': status.extra_css_class,

        'keywords': formdata.formdef.keywords_list,

    }

    d.update(formdata.get_substitution_variables(minimal=True))

    if get_request().form.get('full') == 'on':

        d.update(formdata.get_json_export_dict(include_files=False))

    return d

class ApiFormsDirectory(AccessControlled, Directory):

    _q_exports = ['', 'geojson']

    def _q_access(self):

    def _q_index(self):

        if not get_publisher().is_using_postgresql():

            raise TraversalError()

        get_request().user = get_user_from_api_query_string() or get_request().user

        from wcs import sql

        management_directory = ManagementDirectory()

        criterias = management_directory.get_global_listing_criterias()

        limit = int(get_request().form.get('limit',

            get_publisher().get_site_option('default-page-size') or 20))

        offset = int(get_request().form.get('offset', 0))

        order_by = get_request().form.get('order_by',

            get_publisher().get_site_option('default-sort-order') or '-receipt_time')

        output = [get_formdata_dict(x, user=get_request().user, consider_status_visibility=False)

                  for x in sql.AnyFormData.select(

                      criterias, order_by=order_by, limit=limit, offset=offset)]

        get_response().set_content_type('application/json')

        return json.dumps({'data': output},

                cls=misc.JSONEncoder,

                encoding=get_publisher().site_charset)

    def geojson(self):

        if not get_publisher().is_using_postgresql():

            raise TraversalError()

        get_request().user = get_user_from_api_query_string() or get_request().user

        return ManagementDirectory().geojson()

    def _q_lookup(self, component):

            formdata_dict = get_formdata_dict(form, user)

            if not formdata_dict:

                # skip hidden forms

            forms.append(formdata_dict)

        user_roles = [logged_users_role().id] + (

                get_request().user.roles if get_request().user else [])

from qommon.evalutils import make_datetime

                d['form_receipt_datetime'] = make_datetime(self.receipt_time)