def save(self): # Create the Password Manager password_manager = PasswordManager() # Create the DBConnection database = DBConnection() # Create the SQL if self.id is None: sql = "INSERT INTO connections (name, host, port, user, passwd, use_key, key_path)" \ " VALUES ('{}', '{}', {}, '{}', '{}', {}, '{}');" else: sql = "UPDATE connections SET name = '{}', host = '{}', port = {}, user = '******', passwd = '{}'," \ " use_key = {}, key_path = '{}' where id_connection = {}" # Bind the values sql = sql.format(self.name, self.host, self.port, self.user, password_manager.encrypt_password(self.password), 1 if self.use_key else 0, self.key_path, self.id) # Execute the SQL if database.execute_query(sql) > 0: # Get the last row inserted if self.id is None: self.id = database.cursor.lastrowid # Return true telling it's OK return True else: # Return False for fail return False
def save(self): # Instance the database database = DBConnection() # Remove the settings from database database.execute_query("DELETE FROM settings") # Create the list of params params = [(Settings.X11_FORWARD, self.x11_forward), (Settings.REQUEST_COMPRESSION, self.request_compression), (Settings.FORCE_IPV4, self.force_ipv4), (Settings.FORCE_IPV6, self.force_ipv6)] # Save the settings affected_rows = database.execute_query_many( "INSERT INTO settings (property, value) VALUES (?, ?)", params) if affected_rows == 4: # Saved all settings return True else: # Something is wrong, try again return False
def save(self): # Instance the database database = DBConnection() # Remove the settings from database database.execute_query("DELETE FROM settings") # Create the list of params params = [(Settings.X11_FORWARD, self.x11_forward), (Settings.REQUEST_COMPRESSION, self.request_compression), (Settings.FORCE_IPV4, self.force_ipv4), (Settings.FORCE_IPV6, self.force_ipv6)] # Save the settings affected_rows = database.execute_query_many( "INSERT INTO settings (property, value) VALUES (?, ?)", params ) if affected_rows == 4: # Saved all settings return True else: # Something is wrong, try again return False
def delete(self): # Check if have the connection ID if self.id is not None: # Create the DBConnection database = DBConnection() # Create the SQL sql = "DELETE FROM connections WHERE id_connection = {}" # Bind the value sql = sql.format(self.id) # Execute the query if database.execute_query(sql) > 0: # Return true telling it's OK return True else: # Return False return False
def save(self): # Create the Password Manager password_manager = PasswordManager() # Create the DBConnection database = DBConnection() # Create the SQL if self.id is None: sql = "INSERT INTO connections (name, host, port, user, passwd, use_key, key_path)" \ " VALUES ('{}', '{}', {}, '{}', '{}', {}, '{}');" else: sql = "UPDATE connections SET name = '{}', host = '{}', port = {}, user = '******', passwd = '{}'," \ " use_key = {}, key_path = '{}' where id_connection = {}" # Bind the values sql = sql.format( self.name, self.host, self.port, self.user, password_manager.encrypt_password(self.password), 1 if self.use_key else 0, self.key_path, self.id ) # Execute the SQL if database.execute_query(sql) > 0: # Get the last row inserted if self.id is None: self.id = database.cursor.lastrowid # Return true telling it's OK return True else: # Return False for fail return False