npc-drops/data.py

import database


db = database.db
cursor = db.cursor()
query = """SELECT DISTINCT timestamp FROM stocks ORDER BY stocks.timestamp DESC LIMIT 1 OFFSET 1;"""
cursor.execute(query)
one_before_latest_entry_datetime = cursor.fetchone()
query = """SELECT DISTINCT timestamp FROM stocks ORDER BY stocks.timestamp DESC LIMIT 1;"""
cursor.execute(query)
latest_entry_datetime = cursor.fetchone(query)

cursor.close()
db.close()