def OnIdle(self, event = None): '''Idle UI handler''' # Save window settings settings.saveSettings() # Handle comms receive logic self.CommsReceive()
def OnClose(self, event): """Event handler for closing.""" try: # Save any unsaved settings settings.saveSettings(self._controller) except Exception, msg: self._debug("Error during shutdown", msg)
def OnClose(self, event): '''Event handler for closing.''' try: # Save any unsaved settings settings.saveSettings() except Exception, msg: logger.error(msg) logger.error('Error during shutdown')
def guiVarsToSave(): for x in cfg.config["strings"]: cfg.config["strings"][x] = guiVars[x].get() for x in cfg.config["variables"]: cfg.config["variables"][x] = str(guiVars[x].get()) for x in cfg.config["intvars"]: cfg.config["intvars"][x] = str(guiVars[x].get()) cfg.saveSettings() return True
def _finishQuit(self, result=None): debug("In second stage shutdown") if self.window: self.window.destroy() # seems to be a bug, but we need to clean up the threadpool if reactor.threadpool is not None: reactor.threadpool.stop() try: reactor.stop() except twisted.internet.error.ReactorNotRunning: debug("Reactor wasn't running, so couldn't stop it") if self.settings: settings.saveSettings(self.settings) debug("Finished shutdown, goodbye")
def doEnd(self,outcome): bs.playMusic(None) if self._score2 > 500: outcome = 'defeat' self._score2 = 0 self.end(results={'outcome':outcome,'score':self._score2,'playerInfo':self.initialPlayerInfo},delay = 3000) if outcome == 'defeat': self._bots.finalCelebrate() self.fadeToRed() elif outcome == 'victory': tint = bs.getSharedObject('globals').tint bsUtils.animateArray(bs.getSharedObject('globals'),"tint",3,{0:tint,1000:(1.4,1.4,1.4)}) self.cameraFlash() import bsAchievement bsAchievement._awardLocalAchievement('Boss') import settings settings.bolt = True settings.duck = True settings.saveSettings()
sys.exit(0) connectionSettings = settings.getConnection(server) if not connectionSettings: if server == 'main' or server == 'ptr': legacyConfig = settings.getLegacySettings() if legacyConfig: if raw_input("Upgrade settings file to the new format? (y/n) ") != "y": sys.exit(-1) settings.addConnection('main', legacyConfig['screeps_username'], legacyConfig['screeps_password']) config = settings.getSettings() config['smooth_scroll'] = legacyConfig['smooth_scroll'] config['max_scroll'] = legacyConfig['max_scroll'] config['max_history'] = legacyConfig['max_history'] settings.saveSettings(config) connectionSettings = settings.getConnection(server) if not connectionSettings: if server is 'main': host = 'screeps.com' secure = True else: host = raw_input("Host: ") secure = raw_input("Secure (y/n) ") == "y" username = raw_input("Username: "******"Password: ") settings.addConnection(server, username, password, host, secure) ScreepsInteractiveConsole(server)
def saveSettings(self): settings.saveSettings(self.settings, "quester")
def saveSettings(self): settings.saveSettings(self.settings, "grinder")
settings.removeConnection(server) sys.exit(0) connectionSettings = settings.getConnection(server) if not connectionSettings: if server == 'main' or server == 'ptr': legacyConfig = settings.getLegacySettings() if legacyConfig: if input("Upgrade settings file to the new format? (y/n) ") == "y": settings.addConnection('main', legacyConfig['screeps_username'], legacyConfig['screeps_password']) config = settings.getSettings() config['smooth_scroll'] = legacyConfig['smooth_scroll'] config['max_scroll'] = legacyConfig['max_scroll'] config['max_history'] = legacyConfig['max_history'] settings.saveSettings(config) connectionSettings = settings.getConnection(server) if not connectionSettings: if server is 'main': host = 'screeps.com' secure = True else: host = input("Host: ") secure = input("Secure (y/n) ") == "y" username = input("Username: "******"Password: ") settings.addConnection(server, username, password, host, secure) if server == 'main' and 'token' not in connectionSettings: settings.addConnection('main', connectionSettings['username'], connectionSettings['password'])
def on_custom_mindstorms_gadget_control(self, directive): try: payload = json.loads(directive.payload.decode("utf-8")) print("Control payload: {}".format(payload), file=sys.stderr) controlType = payload["type"] if controlType == "print": print("Printing a word.") if not settings.getDialogMode(): p.startPrinting() t.printText(payload["word"]) p.finishPrinting() if controlType == "printList": print("Printing a list.") itemList = json.loads(payload["items"]) if not settings.getDialogMode(): p.startPrinting() for item in itemList: draw.listItem(item) p.finishPrinting() if controlType == "giftTags": print("Printing gift tags.") itemList = json.loads(payload["items"]) sender = payload["sender"] if not settings.getDialogMode(): p.startPrinting() for item in itemList: # print( "Current Y Position: {}".format( p.CurrentPositionY ), file=sys.stderr ) # print( "Gift tag height: {}".format( draw.giftTagHeight() ), file=sys.stderr ) # print( "Page height: {}".format( p.PageHeight ), file=sys.stderr ) if (p.CurrentPositionY - draw.giftTagHeight() < p.PageHeight): p.newSheet() draw.giftTag(item, sender) p.finishPrinting() if controlType == "mindstorms": print("Drawing the EV3 logo.") if not settings.getDialogMode(): p.startPrinting() draw.ev3Logo(800) p.finishPrinting() if controlType == "calibrate": print("Calibrating the printer.") if not settings.getDialogMode(): p.calibrate() if controlType == "setTextSize": print("Setting the text size.") settings.setTextSize(payload["size"] * 8) t.updateMetrics(settings.getTextSize()) settings.saveSettings() if controlType == "getTextSize": print("Getting the text size.") self._send_event("TextSize", {'size': settings.getTextSize() / 8}) if controlType == "dialogMode": enable = payload["enable"] if enable == "on": print("Entering dialog mode.") settings.setDialogMode(True) else: print("Exiting dialog mode.") settings.setDialogMode(False) except KeyError: print("Missing expected parameters: {}".format(directive), file=sys.stderr)
def main(): # Load settings filepath_settings = 'C:/DISCHARGEDB/code/data/settings.json' settings = initSettings() saveSettings(settings, filepath_settings) settings = fillSettingsTags(loadSettings(filepath_settings)) # Downlaod new images from ag mednet discharge = DISCHARGEDB(database=settings['database']) #discharge.download_images(settings) #discharge.update_images(settings) discharge.truncateTable(tablename='dicom') discharge.update_dicom(settings) ### Update agmednet reports ### discharge = DISCHARGEDB(host="127.0.0.1", port='3306', user="******", password="******", database=settings['database']) discharge.update_agmednet_01(settings) discharge.update_agmednet_02(settings) discharge = DISCHARGEDB(host="127.0.0.1", port='3306', user="******", password="******", database=settings['database']) rs = discharge.truncateTable('agmednet_02') discharge.update_agmednet_02(settings) df = discharge.getTable('agmednet_02') df = discharge.getTable('agmednet_01') #### Execute sript ##### discharge = DISCHARGEDB(host="127.0.0.1", port='3306', user="******", password="******", database=settings['database']) table = discharge.getTable('agmednet_01') discharge.truncateTable('agmednet_01') discharge.truncateTable('agmednet_02') discharge.connectSQL() table = discharge.getTable('agmednet_01') table = discharge.getTable('agmednet_01') self = db mysql_path = 'mysql://' + self.user + ':' + self.password + '@' + self.host + '/' + self.database + '?charset=utf8' sqlEngine = create_engine(mysql_path) df = pd.read_sql("SELECT * FROM agmednet_01", sqlEngine) ### Reset autoincrement db = DISCHARGEDB(host="127.0.0.1", port='3306', user="******", password="******", database=settings['database']) db.connectSQL() db.resetAutoIncrement() #db.createDB() db.initDB(settings) db.executeScript( fip_script= 'H:/cloud/cloud_data/Projects/DISCHARGEDB/src/scripts/set_primary_key.sql', replace=('TABLE_VAR', 'v_a06_docu_hosp')) result = db.executeSQL('SELECT * FROM dischargedb3.site;') db.sas7bdatTosql() db.closeSQL() filename = 'v_a01_fu_staff' db = DISCHARGEDB(database=settings['database']) db.connectSQL() db.executeSQL('ALTER TABLE ' + filename + ' ADD PRIMARY KEY index') command = "ALTER TABLE `dischargedb`.`v_a03_ses_staff` CHANGE COLUMN `index` `index` BIGINT NOT NULL ," cursor = db.db.cursor() cursor.execute(command) result = cursor.fetchall() db = DISCHARGEDB(database=settings['database']) db.connectSQL() #command = "ALTER TABLE `dischargedb`.`v_a02_fu_questf_sub01` CHANGE COLUMN `index` `index` BIGINT NULL ,ADD PRIMARY KEY (`index`);;" command = "ALTER TABLE dischargedb.v_a03_ses_staff CHANGE COLUMN index index BIGINT NOT NULL" db.executeSQL(command) ############################## reader = SAS7BDAT( 'H:/cloud/cloud_data/Projects/DISCHARGEDB/data/tmp/ecrf/v_g02_ct_reading_a.sas7bdat', skip_header=False) df1 = reader.to_data_frame() for i in range(len(reader.columns)): f = reader.columns[i].format print('format:', f) c = reader.columns[10] fip = 'H:/cloud/cloud_data/Projects/DISCHARGEDB/data/tmp/ecrf/v_a01_fu_staff.sas7bdat' df = pd.read_sas(fip, format='sas7bdat', encoding='iso-8859-1') df.to_sql(con=con, name='table_name_for_df', if_exists='replace', flavor='mysql') mysql_path = 'mysql://*****:*****@localhost/?charset=utf8' engine = create_engine(mysql_path, encoding="utf-8", echo=False) # with engine.connect() as con: # con.execute("use dischargedb3; drop table if exists " + name + ";") # df = pd.read_excel(path) # df.to_sql(name, engine, index=False) fip = 'H:/cloud/cloud_data/Projects/DISCHARGEDB/data/tables/sas/v_a02_fu_questf_sub01.sas7bdat' df = pd.read_sas(fip, format='sas7bdat', encoding='iso-8859-1') with engine.connect() as con: #con = engine.connect() con.execute("use dischargedb3;") df.to_sql('table6', engine, index=False) df = pd.read_excel( 'H:/cloud/cloud_data/Projects/DISCHARGEDB/data/tables/xlsx/discharge_ecrf_01092020.xlsx', sheet_name='Sheet1', index_col=0)