balance_deduction_log:
    scheme: "mysql"
    user: "root"
    password: ""
    host: "localhost"
    database: "triple_seven"

def db_settings(table_name):
    x = open('db_settings.yml')
    settings = yaml.load(f)
    return settings[table_name]


def triple_seven_hits_within(date_range):
    begin, end = date_range
    settings = db_settings('balance_deduction_log')
    database = create_database("%://%:%@%/%" % (settings['scheme'],
                                                settings['user'],
                                                settings['password']
                                                settings['host'],
                                                settings['database']))
    store = Store(database)
    hits = store.find(BalanceDeductionLog, "time between '%s' and '%s'" % (begin, end))
    return hits.count()