will bulk insertion of data is auto committed for each row insertion ????

[kampy]

Hi all ,

I am trying bulk data into mysql database through sqlalchemy. In the table there may be primary key values before. If we get the same primary key values we get Integrity Error so I am using transaction management here. But while inserting bulk data the rows inserted before this error werent get rolled back only the row where error is got is rolled back. Can anyone please help me out in gettin gout this issue.

Thanks in advance

[Michael Bayer]

sounds like you aren't using InnoDB and therefore there's really no transaction in place at all.  The (often default) MyISAM engine of MySQL doesn't support transactions.

--
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/mxq1e7yJoOQJ.
To post to this group, send email to sqlal...@googlegroups.com.
To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.

[kampy]

HI Michael Bayer,
I am using InnoDB only.

users_table = Table(XXXXXX',metadata,
    Column('id1, Integer, primary_key=True,
                         autoincrement=False),
    Column('id2', String(255), primary_key=True),
    Column('d3', String(255), primary_key=True),
    Column('t_id',String(255)),
    Column('ie_name',String(255)),
    Column('n_name',String(255)),
    Column('in_status',String(255)),
    Column('ud_at',DateTime),
    Column('c_at',DateTime),
    Column('d_at',DateTime),
    mysql_engine='InnoDB'
)

[Michael Bayer]

if rows that were inserted in the transaction are not removed when the transaction rolls back, then that's the only possibility here.   are you sure you emitted a CREATE TABLE statement for the "users_table" definition which included InnoDB ?

To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/6vP2FZqsZEYJ.

[kampy]

i created table manually  not in the code .

[Michael Bayer]

this would need to include "engine='InnoDB'" in the CREATE TABLE statement.

To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/PCyh3Gh31MwJ.