parse sql queries in python

Question

I want to be able to take a string like below and pull out the first parameter (id) and then use that to print it out. I have been looking into split for python, but I usually have to split 2 or 3 times before getting something usable.

Here is an example of the strings I am trying to parse:

EntryError(u"(sqlite3.IntegrityError) UNIQUE constraint failed:
role.name, role.domain_id [SQL: u'INSERT INTO table1 (id, name, 
domain_id, extra) VALUES (?, ?, ?, ?)'] [parameters: ('id', 
'fake1name', '<<null>>', '{}')]",)

I have tries things like:

e = e.split("\'")
e = e.split(",")

But this gives me weird strings that have to further be parsed. Is there an easier way to always pull the id from "[parameters: ('id', 'fake1name', '<<null>>', '{}')]"?

Here's the code I have:

except exception.EntryError as e:   

    query = str(e)
    # example of me using split to try and reduce the string
    parsedstr = query.split("[")
    parsedstr = parsedstr.split("\'")

    # This will give me id like I want but it doesn't seem efficient
    # prints: id
    print parsedstr[1]

Could you show the rest of your code - do you actually have access to the cursor or the exception instance itself? Thanks. — alecxe
– alecxe, Commented Nov 30, 2016 at 21:17
What string are you trying to parse? Are you actually trying to parse the message in the EntryError object above? — aquil.abdullah
– aquil.abdullah, Commented Nov 30, 2016 at 21:25

Stacktrace · Accepted Answer · 2016-11-30 22:25:05Z

1

You can use regular expressions.

import re

...

except exception.EntryError as e:
    print re.search("\[parameters: \('([^']+)", str(e)).group(1)

This would search the exception string for the first occurrence of [parameters: (' and start matching from that point until it hits a '.

answered Nov 30, 2016 at 22:25

Stacktrace

1124 bronze badges

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

Collectives™ on Stack Overflow

parse sql queries in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related