gistfile1.txt

from seo.models import jobListing
from directseo.serializers import XMLExtraSerializer


def get_data_from_xmlextraserializer():

    host = 'find.ibm.jobs'
    jobs = jobListing.objects.filter(buid__id=2432,country_short='MEX')

    s = XMLExtraSerializer([{'name':'url', 'type':'CharField'}])
    data = s.serialize(
        jobs.extra(
           select={"url":'concat("http://", "%s",id,"/job?utm_source=xml&utm_medium=feed")' %host}
    ),
    fields(
       'title',
       'url',
       'country',
       'country_short',
       'state',
       'state_short', 
       'city',
       'location',
       'date_new',
       'description',
       'reqid')
    )

    return data