def execQuery(self, query, praxis_logger_obj: praxis_logging. praxis_logger = praxis_logging.praxis_logger()): try: self.selfAutoStart() #praxis_logger_obj.log("query:") #praxis_logger_obj.log(query) print("query:") print(query) results = None try: results = self.dbConnection.execute(query) for r in results: #praxis_logger_obj.log("query results:") #praxis_logger_obj.log(r) results = r except: results = None print("execQuery results:") print(results) #praxis_logger_obj.log("execQuery results:") #praxis_logger_obj.log(results) self.closeConnection() return results except Exception as e: print("[Praxis_DB_Connection] query error") print(e) return e
from commands import loader as command_loader from commands import loader_functions as function_loader from commands.command_base import AbstractCommand from commands.command_functions import AbstractCommandFunction, Abstract_Function_Helpers from json import loads from urllib.parse import urlencode import requests import base64 import os import bot_functions.praxis_logging as praxis_logging praxis_logger_obj = praxis_logging.praxis_logger() praxis_logger_obj.init(os.path.basename(__file__)) praxis_logger_obj.log("\n -Starting Logs: " + os.path.basename(__file__)) api = flask.Flask(__name__) # enable/disable this to get web pages of crashes returned api.config["DEBUG"] = False loadedCommands = {} def init(): # todo load entire command library and cache it here load_commands()
def get_Command_returnString(self, command, praxis_logger_obj:praxis_logging.praxis_logger = praxis_logging.praxis_logger()): try: db_obj = db_utility.Praxis_DB_Connection(autoConnect=True) returns = None #praxis_logger_obj.log("Getting Command ReturnString") query = "SELECT * FROM command_responses_v0 WHERE command = \'%s\';" % (command) #praxis_logger_obj.log(query) dbResults = db_obj.execQuery(query, praxis_logger_obj) #praxis_logger_obj.log("dbResults:") #praxis_logger_obj.log(str(dbResults)) returns = dbResults[2] return returns except: print("UNABLE TO FIND RESPONSE") return None