Produits Entr'ouvert » w.c.s.

            sql_type = SQL_TYPE_MAPPING.get(field.key, 'varchar')

            if sql_type is None:

                continue

            value = row[i]

            if value is not None:

                value = str_encode(value)

                if field.key == 'ranked-items':

                    d = {}

                    for data, rank in value:

                        try:

                            d[data] = int(rank)

                        except ValueError:

                            d[data] = rank

                    value = d

                elif field.key == 'password':

                    d = {}

                    for fmt, val in value:

                        d[fmt] = force_str(val)

                    value = d

                elif field.key == 'computed':

                    if isinstance(value, dict) and value.get('@type') == 'computed-data':

                        value = value.get('data')

                if sql_type == 'date':

                    value = value.timetuple()

                elif sql_type == 'bytea':

                    value = pickle_loads(value)

                elif sql_type == 'jsonb' and isinstance(value, dict) and value.get('schema'):

                    # block field, adapt date/field values

                    for field_id, field_type in value.get('schema').items():

                        if field_type not in ('date', 'file'):

                            continue

                        for entry in value.get('data') or []:

                            subvalue = entry.get(field_id)

                            if subvalue and field_type == 'date':

                                entry[field_id] = time.strptime(subvalue, '%Y-%m-%d')

                            elif subvalue and field_type == 'file':

                                entry[field_id] = PicklableUpload.__new__(PicklableUpload)

                                entry[field_id].__setstate__(subvalue)

            obdata[field.id] = value

            i += 1

            if field.store_display_value:

                value = str_encode(row[i])

                obdata['%s_display' % field.id] = value

                i += 1

            if field.store_structured_value:

                value = row[i]

                if value is not None:

                    obdata['%s_structured' % field.id] = pickle_loads(value)

                    if obdata['%s_structured' % field.id] is None:

                        del obdata['%s_structured' % field.id]

                i += 1

-