Hi all,
I need to serialize in XML, through django.core.serializers class, the
result of the function bellow. Is it possible? If not, how can I execute the
query bellow through Django´s API?
*MY FUNCTION:*
def select_site_sql():
cursor = connection.cursor()
cursor.execute("""select site.nm_site, site.vr_site, site.us_site,
site.ps_site, site.dt_deploy_site, serv.nm_servico
from sitemanager_site site,
sitemanager_site_servico site_serv, sitemanager_servico serv
where site.cd_site = site_serv.site_id
and site_serv.servico_id =
serv.cd_servico;
""")
return cursor.fetchall()
*MODELS:*
class Operadora(models.Model):
cd_operadora = models.AutoField(primary_key=True)
nm_operadora = models.CharField('operadora',max_length=200)
def __unicode__(self):
return self.nm_operadora
class Servico(models.Model):
cd_servico = models.AutoField(primary_key=True)
nm_servico = models.CharField('serviço',max_length=50)
vr_servico = models.CharField('versão',max_length=15)
st_servico = models.CharField('status',max_length=15,blank=True)
def __unicode__(self):
return '%s %s %s' % (self.nm_servico, self.vr_servico,
self.st_servico)
class Site(models.Model):
cd_site = models.AutoField(primary_key=True)
nm_site = models.CharField('nome',max_length=50)
vr_site = models.CharField('versão',max_length=15,blank=True)
us_site = models.CharField('usuário',max_length=100)
ps_site = models.CharField('senha',max_length=100)
dt_deploy_site = models.DateTimeField(blank=True,auto_now=True)
operadora = models.ForeignKey(Operadora,db_column='cd_operadora')
servico = models.ManyToManyField(Servico,db_column='cd_servico')
def __unicode__(self):
return '%s %s' % (self.nm_site, self.operadora)
--
Att.
Bruno Galindro da Costa
[email protected]
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
