Python pass arguments in to query error

Question

I have the following code in python. I get this error ->tuple indices must be integers, not str

How can I pass these values into the query? I have other examples where this approach works perfectly, i don't understand why it's failling here.

def request_events_json(uei,interval,conn):

    cur = conn.cursor()

    events_query ="""select e.nodeid,n.nodelabel,e.ipaddr,count(*) as total,min(e.eventcreatetime),max(e.eventcreatetime),(regexp_matches (e.eventlogmsg,E': %(.*)'))[1] as msglog
                     from events e, node n where e.eventuei = (%s)  and e.eventcreatetime > now() - interval (%s) and n.nodeid=e.nodeid
                     group by n.nodelabel,e.nodeid,e.ipaddr,msglog
                     order by e.nodeid, count(*) desc limit 10;"""



    try:
       print('## Requesting events ##')
       cur.execute(events_query,('uei.opennms.org/syslogd/cisco/line','5 min'))
       .......

What postgresql driver are you using?

Marco de Wit
– Marco de Wit

2012-07-04 12:10:43 +00:00
Commented Jul 4, 2012 at 12:10 — Marco de Wit
– Marco de Wit, Commented Jul 4, 2012 at 12:10

Marco de Wit · Accepted Answer · 2012-07-04 19:20:22Z

1

With my version of PostgreSQL the round brackets after interval are forbidden.

Update:

It is the percent-sign in the regexp. Double it.

edited Jul 4, 2012 at 19:20

answered Jul 4, 2012 at 11:33

Marco de Wit

2,8362 gold badges20 silver badges23 bronze badges

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

4 Comments

user1501398 Over a year ago

psycopg2 and the postgres is 8.4.3. If I change the query to events_query ="""select nodeid from events where eventuei=(%s) and eventcreatetime > now() - interval %s limit 10;""" it works...

user1501398 Over a year ago

I took the regex part out and it worked (regexp_matches (e.eventlogmsg,E': %(.*)'))[1] as msglog ...can anyone help me on how to mantain this part and pass the parameters to the query ?

Marco de Wit Over a year ago

Maybe doubling the % helps in your regex. E': %%(.*)'

Marco de Wit Over a year ago

Or maybe replacing that percent sign by \\x25 .

Collectives™ on Stack Overflow

Python pass arguments in to query error

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related