Attached is one I made using what it looks like the relationships are
based on your test code. It inserts 3502 rows into a SQLite database
without issue.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
from sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.ext.declarative import declarative_base
engine = create_engine('sqlite://', echo=True)
Base = declarative_base()
class Test(Base):
__tablename__ = 'test'
id = Column(Integer, primary_key=True)
data = Column(String(50))
class Section(Base):
__tablename__ = 'section'
id = Column(Integer, primary_key=True)
data = Column(String(50))
test_id = Column(Integer, ForeignKey('test.id'))
test = relation(Test, backref='sections')
class Question(Base):
__tablename__ = 'question'
id = Column(Integer, primary_key=True)
data = Column(String(50))
section_id = Column(Integer, ForeignKey('section.id'))
section = relation(Section, backref='questions')
class Answer(Base):
__tablename__ = 'answer'
id = Column(Integer, primary_key=True)
data = Column(String(50))
question_id = Column(Integer, ForeignKey('question.id'))
question = relation(Question, backref='answers')
Base.metadata.create_all(bind=engine)
sess = sessionmaker(bind=engine)()
test = Test(data='t1')
section = Section(data='s1')
section.test=test
for i in range(500):
q=Question(data='q%d' % i)
q.section=section
for j in range(6):
a = Answer(data='a %d %d' % (i, j))
a.question = q
sess.save(test)
sess.commit()
On Jun 18, 2008, at 3:37 PM, Marin wrote:
>
>> cant really tell unless you provide a fully functional, as simple as
>> possible test case, preferably against sqlite, which can be run with
>> no dependencies.
>
> I'll try to make one. I tried to fix it doday and got that the next
> code does not produce the error:
> test = Test()
> section = Section()
> section.Test=test
> db_session.save(test)
> for i in range(60):
> q=Question()
> q.Section=section
> for j in range(6)
> a = Answer()
> a.Question = q
>
> db_session.commit()
>
> Is there a max limit on the number of SQL commands that SA can isue
> between a BEGIN-COMMIT?
>
> --~--~---------~--~----~------------~-------~--~----~
> You received this message because you are subscribed to the Google
> Groups "sqlalchemy" 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/sqlalchemy?hl=en
> -~----------~----~----~----~------~----~------~--~---
>
