Hi. I am having trouble with this code
MODULE NAME: Model.py
--------------------------------
from elixir import *
metadata.bind = "mysql://root:[EMAIL PROTECTED]/prueba"
metadata.bind.echo = True
class Empresa(Entity):
using_options(tablename='empresa')
nombre = Field(Unicode(50))
direccion = Field(Unicode(100))
observaciones = Field(UnicodeText)
sociedad_anonima = ManyToOne('SociedadAnonima')
#def __repr__(self):
# return '<Empresa "%s %s" >' % (self.nombre, self.direccion)
class SociedadAnonima(Entity):
using_options(tablename='sociedadAnonima')
nombre = Field(Unicode(50))
cedula = Field(Unicode(50))
observaciones = Field(UnicodeText)
empresas = OneToMany('Empresa')
#def __repr__(self):
# return '<Sociedad_Anonima "%s %s" >' % (self.cedula,
self.nombre)
MODULE NAME: createData.py
---------------------------------------
from model import *
setup_all()
sa = SociedadAnonima(nombre=u"Optica X",cedula=u"3-101-123456")
session.commit()
Error I get
------------
/usr/bin/python -u "/home/edgar/createData.py"
Traceback (most recent call last):
File "/home/edgar/createData.py", line 7, in <module>
session.commit()
File "/var/lib/python-support/python2.5/sqlalchemy/orm/scoping.py",
line 98, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/session.py",
line 552, in commit
raise exceptions.InvalidRequestError("No transaction is begun.")
sqlalchemy.exceptions.InvalidRequestError: No transaction is begun.
I see that "No transaction is begun" is the problem, but -How do I
begin a transaction?
Thanks a lot in advance for your help!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" 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/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
