SQLite adding columns in row in query

Question

I am trying to do a little bit of math in in a sqlite call. I have two columns that I want to add their value then check to see if they are less than a value that I input.

    c = self.db.cursor()
    c.execute("BEGIN EXCLUSIVE TRANSACTION");
    c.execute("SELECT ID as id,task FROM tube WHERE state=0 OR (state=1 & ts+ttr<? ) ORDER BY ID ASC LIMIT 1", (time.time(),))
    task = c.fetchone()
    print task
    if task != None:
        ts = time.time();
        c.execute("UPDATE tube SET state=1,ts=? WHERE ID=?", (ts, task['id']))
        task['ts'] = ts
    else:
        task = None

    self.db.commit()
    return task

From what I can tell its not doing this operation. It still returns a row but not based on the logic I am providing.

do you use Bottle or Flask ? to try to understand what could be returned by c.fetchone() and then if it's possible to modify it on the fly by adding ts to it. — user1593705
– user1593705, Commented Sep 11, 2013 at 12:53
so what's look like the def fetchone() ? as I dont see yet a known ORM that provides this function — user1593705
– user1593705, Commented Sep 11, 2013 at 13:01

Janne Karila · Accepted Answer · 2013-09-11 12:53:53Z

4

You are using the bitwise and operator & where you probably want a logical AND.

The bitwise operators have higher precedence that the comparisons (=, <), while the logical ones have lower. Therefore state=1 & ts+ttr<? is very different from state=1 AND ts+ttr<?

answered Sep 11, 2013 at 12:53

Janne Karila

25.3k6 gold badges59 silver badges97 bronze badges

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

1 Comment

WojonsTech Over a year ago

I think i see what you mean Its been while since i wrote sql

Collectives™ on Stack Overflow

SQLite adding columns in row in query

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related