Python not querying database in loop

Question

I currently have a process running that should call a method every 10 seconds. I see that it actually calls the method at that interval, but it seems to not execute something in the code. Weird thing is, is that when I cancel the loop, and start it new it does actually do it the first time. Then when I keep it running it does not do anything.

def main():
    try:
        while True:
            read()
            time.sleep(10)
    except KeyboardInterrupt:
        pass

Above is the loop, and the code here is actually the beginning of the method that is being called, and I found out that it does not actually get results in the results, while the file has changed. In this case it gets data from a .json file

def read():
    message = Query()
    results = DB.search(message.pushed == False)

Am I overlooking something?

How are you sure that read() is being called after KeyboardInterrupt ? Ideally your program will exit upon KeyboardInterrupt(Ctrl+C). Try to put a print statement in read() and check if you see that statement on console. If you wan to run this continuously, you have to run it as a daemon process. — redoc
– redoc, Commented May 2, 2016 at 8:10
I had indeed put a print statement there, so I know it's being called. The file is being run as a service on the server, it keeps calling the method every 10 seconds. It seems to run fine, it's just that it does not get any results from the database — dnsko
– dnsko, Commented May 2, 2016 at 8:19

dnsko · Accepted Answer · 2016-05-02 09:39:24Z

1

Solved. I had the DB declared globally and that did not go so well. It is being fixed by declaring it just before the statement.

answered May 2, 2016 at 9:39

dnsko

1,0575 gold badges18 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Python not querying database in loop

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related