def _randquote(): quotecount = db_helper.fetchall( 'SELECT COUNT(*) FROM `quotes`')[0][0] if quotecount == 0: return 'No quotes found' # Get the quote at a specific position quote = Quote.from_db_row( db_helper.fetchall('SELECT * FROM `quotes` LIMIT 1 OFFSET ?', (random.randrange(0, quotecount), ))[0]) return _presentquote(quote)
def db_select_all(): """ Returns: list(Setting): List of all Settings """ result = db_helper.fetchall(SELECT_ALL) return list(map(Setting.from_db_row, result))
def db_select_one(qid): """Select the specified quote by the id""" rawquote = db_helper.fetchall(SELECT_ONE_STATEMENT, (qid, )) if rawquote is None or len(rawquote) == 0: return None else: return Quote.from_db_row(rawquote[0])
def db_select_all(): """Get all quotes in the database""" rawquotes = db_helper.fetchall(SELECT_ALL_STATEMENT) if rawquotes is None: return [] else: return [Quote.from_db_row(row) for row in rawquotes]
def db_select_for_module(module): """ Args: module (str): The module name from the setting to load Returns: list(Setting): List of all matching Settings """ result = db_helper.fetchall(SELECT_FOR_MODULE, (module, )) return list(map(Setting.from_db_row, result))
def db_select_for_module_key(module, key): """ Args: module (str): The module name from the setting to load key (str): The key name from the setting to load Returns: (Setting): The matching setting or None """ result = db_helper.fetchall(SELECT_FOR_MODULE_KEY, (module, key)) if len(result) == 0: return None else: return Setting.from_db_row(result[0])
def db_get_all(): all = db_helper.fetchall(SELECT_ALL_STATEMENT) return list(map(RegexResponse.fromdbtuple, all))
def db_get_all(): return list( map(TimedMessage.from_db_row, db_helper.fetchall(SELECT_ALL_STATEMENT)))
def db_insert(tm): tm.id = db_helper.fetchall( INSERT_STATEMENT, (tm.message, tm.inittime, tm.looptime, 1 if tm.enabled else 0))[0][0]
def db_get(id): result = db_helper.fetchall(SELECT_STATEMENT, (id, )) if len(result) > 0: return TimedMessage.from_db_row(result[0]) else: return None
def db_get_command(name): found = list(map(Command.from_db_tuple,db_helper.fetchall(GET_STATEMENT,(name,)))) if len(found)==0: return None else: return found[0]
def db_get_all_commands(): return map(Command.from_db_tuple,db_helper.fetchall(GET_ALL_STATEMENT))