Schedule error in Python

Question

I am extracting info from XYZ website and save it to sqlite. I want this process repeat every 15 minutes. So my code:

import numpy as np
import pandas as pd
import datetime
import urllib
from bokeh.models import HoverTool
from collections import OrderedDict
import sqlite3
from sqlalchemy import create_engine
from apscheduler.schedulers.background import BackgroundScheduler

def get_data():
    query = ("WEBSITE_ADDRESSCOM/XYZ.json")
    raw_data = pd.read_json(query)
    conn = sqlite3.connect('X.db')
    c = conn.cursor()
    disk_engine = create_engine('sqlite:///X.db')
    raw_data.to_sql('table', disk_engine, if_exists='append')
    print("I downloaded", pd.read_sql_query('SELECT * FROM 
    table',disk_engine).shape[0],"cases")
    conn.close()

scheduler = BackgroundScheduler()
scheduler.add_job(get_data, 'interval', minutes=15)
scheduler.start()

But it gives me this error.

LookupError: No trigger by the name "interval" was found

This code works on Windows. I am trying on Mac now (with Python 3) but it gives above error although I followed recommendations on this link No trigger by the name "interval" was found.

So... what line did this error occur on?

LTClipp
– LTClipp

2017-12-11 17:35:18 +00:00
Commented Dec 11, 2017 at 17:35 — LTClipp
– LTClipp, Commented Dec 11, 2017 at 17:35
I think scheduler.add_job(get_data, 'interval', minutes=15)

worthy
– worthy

2017-12-11 17:36:27 +00:00
Commented Dec 11, 2017 at 17:36 — worthy
– worthy, Commented Dec 11, 2017 at 17:36

worthy · Accepted Answer · 2017-12-11 20:14:54Z

1

Here is what I did and it worked on Mac too.

I updated setuptools as outlined here: No trigger by the name "interval" was found

Then I run below code.

sudo -H pip  install --ignore-installed apscheduler

I am not sure if that is relevant but I restarted the kernel after this procedure and now it works.

answered Dec 11, 2017 at 20:14

worthy

651 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

Schedule error in Python

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