def open_connection(self):
print("Opening Database")
path = QFileDialog.getOpenFileName()
self.connection = SQLConnection(path)
ok = self.connection.open_database()
print(ok)
def performanceMeasurement():
root = tk.Tk()
figure1 = plt.Figure(figsize=(6, 5), dpi=100)
ax1 = figure1.add_subplot(111)
bar1 = FigureCanvasTkAgg(figure1, root)
bar1.get_tk_widget().pack(side=tk.LEFT, fill=tk.BOTH)
SQL = SQLConnection.SQLConnection()
numbers = SQL.getWorkEfficiency()
# print(data.OutreachDetailsDate)
SQL.closeConnection()
# performanceMeasurement(data['OutreachDetailsDate'], data['name'].values.tolist())
df1 = numbers[['name', 'Count_OutreachDetailsPatientId']]
df1.plot.bar(x='name',
y='Count_OutreachDetailsPatientId',
rot=0,
fontsize=8,
color=(0.2, 0.4, 0.6, 0.6),
ax=ax1)
# ax1.set_title(str(numbers['name'].values[0]) + ' work progress')
toolbar = NavigationToolbar2Tk(bar1, root)
toolbar.update()
bar1._tkcanvas.pack(side=TOP, fill=BOTH, expand=True)
root.mainloop()
def main(): # Main loop of ICA
window = Tk()
window.resizable(0, 0)
window.title()
currentSCREEN = Login_Screen.loginScreen(window, None)
sql = SQLConnection.SQLConnection()
#currentUser = Users.User([0, "Jason", "Van Bladel", "Admin", 1], 1, sql)
#currentUser.setPermissions(Users.Permissions(["Hi", "decr", 1,1,1,1,1,1,1,1,1,1,1,1,1,1, 7, 10]))
#currentSCREEN = Main_Menu.mainMenu(window, currentUser)
#currentSCREEN = mainMenu(window, ["Jason Van Bladel"])
#currentUser = User([0, "Jason", "Van Bladel", "Admin"], 1)
#currentSCREEN = mainMenu(window, currentUser)
#test patient information for med info screen since DB is down
testPatientData = [
20, 10, "Test", "Account", "L", "4/31/2000", "F", "No", "4/21/2020", 0,
"Insert Race", "Insert ethnicity", 20
]
testPatient = Patient(testPatientData)
#currentSCREEN = Med_Info_Screen.med_INFO_SCREEN(window,testPatient)
window.mainloop()
def fuzzySearch(field, input_str, input_type):
if not Type_Check.checkType(input_str, input_type):
return
SQLConn = SQLConnection.SQLConnection()
query = query_generator.fuzzySearch_sql(field, input_str, input_type)
df = pd.read_sql(query, SQLConn.conn)
print(len(df.index))
if len(df.index) == 0:
SQLConn.closeConnection()
return
plist = []
data = df.values.tolist()
for p in data:
plist.append(Patients.Patient(p))
SQLConn.closeConnection()
return plist
def individualGroupByDate(userID):
SQL = SQLConnection.SQLConnection()
data = SQL.getIndWorkEfficiency(userID)
# print(data.OutreachDetailsDate)
SQL.closeConnection()
# performanceMeasurement(data['OutreachDetailsDate'], data['name'].values.tolist())
plt.bar(x=range(0, len(data['OutreachDetailsDate'])),
height=data['Count_OutreachDetailsPatientId'])
# print(data['name'].values[0])
plt.title(str(data['name'].values[0]) + ' work progress')
dateTime = data['OutreachDetailsDate'].values.tolist()
date = []
for d in dateTime:
date.append(d[:10])
# print(date)
plt.xticks(range(0, len(date)), date, rotation=20, fontsize=7)
plt.ylim(0, dailyGoal)
for index, value in enumerate(data['Count_OutreachDetailsPatientId']):
plt.text(index, value, str(value))
plt.show()
def clockConnection(self):
if not self.SQL == None:
self.SQL.closeConnection()
self.SQL = SQLConnection.SQLConnection()
self.clockConnectionVar = self.root.after(15 * 60 * 1000,
self.clockConnection)
def main():
# Create logging environment
logging_ini_path = Path(__file__).resolve().parent / 'logging.ini'
logging.config.fileConfig(logging_ini_path)
mainLogger = logging.getLogger('root')
# Create header in log file
mainLogger.info("____________________")
mainLogger.info("Entering Application")
mainLogger.info("--------------------")
# Get configs
configsListPath = input("Path to your config file: ")
if configsListPath == "":
configsListPath = "C:\data\configs.json"
try:
assert os.path.exists(
configsListPath), "File does not exist at " + str(configsListPath)
except AssertionError:
subLogger.warning(f"Failed to find csv file at {configsListPath}")
try:
with open(configsListPath) as json_config_file:
cfg = json.load(json_config_file)
except KeyError:
print("KeyError")
data = ""
exit_sentinel = False
currentEnvironment = {}
# Initiate Menu Loop
while exit_sentinel == False:
# Print CLI pointer with environment if applicable
try:
envName = currentEnvironment["name"]
except:
envName = "null"
command = input(f"env: {envName}>")
# Check given command
if command == "env":
print("Available Environments:")
for env in cfg:
print(f" {env}")
valid_environment = False
while valid_environment == False:
selectedEnvironment = input("select an environment: ")
try:
currentEnvironment = cfg[selectedEnvironment]
valid_environment = True
except KeyError:
print(f"'{selectedEnvironment}'' is not a valid choice")
valid_environment = False
elif command == "connect":
if currentEnvironment:
sql = SQLConnection.SQLConnection(currentEnvironment)
sql.name = currentEnvironment["name"]
sql.host = currentEnvironment["host"]
sql.user = currentEnvironment["user"]
sql.password = currentEnvironment["password"]
sql.database = currentEnvironment["database"]
sql.menu()
else:
print("Please use 'env' to select an environment first")
elif command == "exit" or command == "quit":
exit_sentinel = True
else:
main_menu_selection = "none"
