How to build a index table (python dict like) in python with sqlite3

Question

Suppose I have one string list may have duplicated items:

A
B
C
A
A
C
D
E
F
F

I want to make a list can assign an unique index for each item, looks like:

now I created sqlite3 database with below SQL statement:

CREATE TABLE aa ( myid INTEGER PRIMARY KEY AUTOINCREMENT,
                  name STRING, 
                  UNIQUE (myid) ON CONFLICT FAIL,
                  UNIQUE (name) ON CONFLICT FAIL);

The plan is insert each row into the database in python.

My question is how to handle the error when conflict do happened when insert in python module sqlite3? For example: the program will printing a warning message which item is conflicted and continue next insert action when inserting in python?

Thanks

xyz-123 · Accepted Answer · 2010-06-18 09:21:13Z

1

Why not try it out and check which Exception is raised? That's not too hard I think, but...

try:
    conn.excecute('...')
except IntegrityError:
    pass

answered Jun 18, 2010 at 9:21

xyz-123

2,2374 gold badges21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

K. C Over a year ago

thanks, I will test it later. Regarding why not test it, with execuse is since I got no python enviroment so far,and to install it is not allowed, with no execuse is many thanks for those company "clever" policies and one can just able to use the keyboard to drive nails ...

xyz-123 · Accepted Answer · 2010-06-18 06:18:46Z

1

You could use a set, to filter double entries in your list and just insert the values:

>>> set(['A', 'B', 'C', 'D', 'A', 'A', 'A', 1, 2, 1, 3, object(), object()])
set(['A', 1, 'C', 'B', 'D', 2, <object object at 0x100274590>, 3, <object object
 at 0x1002746a0>])

or use a try-except clause on each commit to check, whether the value is already in the database.

answered Jun 18, 2010 at 6:18

xyz-123

2,2374 gold badges21 silver badges27 bronze badges

2 Comments

K. C Over a year ago

thanks, set is one approach, but it is not exactly what I want, I want a sample code for the try expect part for this case.

K. C Over a year ago

Collectives™ on Stack Overflow

How to build a index table (python dict like) in python with sqlite3

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related