#!/usr/bin/env python
from datetime import datetime
import os
import json
import sqlite3
import time
import uuid
import redball
from redball import config, logger, upgrade
log = logger.get_logger(logger_name="redball.database",
log_level="DEBUG",
propagate=True)
def get_con(logg=log, dbFile=None):
if not os.path.isdir(redball.DB_PATH):
try:
logg.info(
"The data directory does not exist. Attempting to create it..."
)
os.mkdir(redball.DB_PATH)
except Exception as e:
logg.error("Error creating data directory: {}.".format(e))
raise
try:
logg.debug("Connecting to database {}".format(
dbFile if dbFile else redball.DB_FILE))
#!/usr/bin/env python
from redball import database, logger
import time
log = logger.get_logger(logger_name="redball.upgrade",
log_level="DEBUG",
propagate=True)
def upgrade_database(toVer=None):
# toVer = database version to upgrade to
# returns True if version is satisfactory, False if error
toVer = toVer if toVer else max(upgradeScripts.keys())
fromVer = database.get_database_version(logg=log)
if fromVer == toVer:
log.info("Database is up to date (version: {})!".format(fromVer))
return True
elif fromVer > toVer:
log.warning(
"Current version ({}) is higher than requested version ({}). Someting's wrong but there's nothing to upgrade..."
.format(fromVer, toVer))
return True
else:
log.info("Current database version {}; desired version: {}.".format(
fromVer, toVer))
log.info("Creating a backup of the database...")
database.backup_database(logg=log, manual=False)
con = database.get_con(logg=log)
#!/usr/bin/env python
import json
import praw
import uuid
import redball
from redball import database, logger
log = logger.get_logger(logger_name="redball.config",
log_level="DEBUG",
propagate=True)
def get_sys_config(category=None, key=None, includeChildren=False):
query = "SELECT * FROM rb_config WHERE 1=1"
local_args = tuple()
if category and key:
query += " AND (category=? AND key=?)"
local_args += (category, key)
elif category:
query += " AND category=?"
local_args += (category, )
elif key:
query += " AND key=?"
local_args += (key, )
if includeChildren and key:
query += " OR parent_key=?"
local_args += (key, )
