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
