Sorry for the noob question. Why do I only end up with 2 inserted
rows when doing this?
>>> from sqlalchemy import *
>>> db = create_engine('mysql://login:[EMAIL PROTECTED]/database')
>>> metadata = BoundMetaData(db)
>>> temptable = Table('temptable', metadata,
... Column('col1', Integer),
... Column('col2', String(10)))
>>> temptable.create()
>>> data = [(1, 'blah1'), (2, 'blah2'), (2, 'blah2'), (3, 'blah3'), (3,
>>> 'blah3'), (3, 'blah3')]
>>> temptable.insert(values=data).execute()
<sqlalchemy.engine.base.ResultProxy object at 0x01169C70>
>>> s = temptable.select()
>>> e = s.execute()
>>> e.fetchall()
[(1L, 'blah1'), (2L, 'blah2')]
But if I continue in another table and insert via a loop, it works
fine:
>>> temptable2 = Table('temptable2', metadata,
... Column('col1', Integer),
... Column('col2', String(10)))
>>> temptable2.create()
>>> for i in data:
... temptable2.insert(values=i).execute()
...
<sqlalchemy.engine.base.ResultProxy object at 0x011745B0>
<sqlalchemy.engine.base.ResultProxy object at 0x011747D0>
<sqlalchemy.engine.base.ResultProxy object at 0x01174910>
<sqlalchemy.engine.base.ResultProxy object at 0x01174A50>
<sqlalchemy.engine.base.ResultProxy object at 0x01174B90>
<sqlalchemy.engine.base.ResultProxy object at 0x01174CD0>
>>>
Is there some better way to do bulk inserts that I am missing?
Thanks in advance
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
