def add(self) -> None: s = database.newSession() try: s.add(self) s.commit() except FailedToAddToDatabase as e: print(f"Failed to add '{self.message}' to 'Logs'. {e}") finally: s.close()
def remove(self) -> None: s = database.newSession() try: for d in s.query(Icons).filter(Icons.site == self.site): s.delete(d) s.commit() except Exception as e: print(f"{e}") finally: s.close()
def add(self) -> None: s = database.newSession() try: s.add(self) s.commit() except FailedToAddToDatabase as e: print(f"Failed to add {self.site} to Icons table! {e}") finally: s.close()
def clearTable(self) -> None: s = database.newSession() try: for d in s.query(Icons): s.delete(d) s.commit() except Exception as e: print(f"{e}") finally: s.close()
def findAllByName(self) -> List: s = database.newSession() l = list() try: for res in s.query(Icons).filter(Icons.site.contains(self.site)): l.append(res) except Exception as e: pass finally: s.close() return l
def remove(self) -> None: s = database.newSession() try: for d in s.query(DiscordQueue).filter( DiscordQueue.link == self.link): s.delete(d) s.commit() except Exception as e: print(f"{e}") finally: s.close()
def add(self) -> bool: s = database.newSession() res: bool = True try: s.add(self) s.commit() except FailedToAddToDatabase as e: print(f"Failed to add {self.title} to DiscorQueue table! {e}") res = False finally: s.close() return res
def __len__(self) -> int: s = database.newSession() l = list() try: for res in s.query(DiscordWebHooks): l.append(res) except Exception as e: pass finally: s.close() return len(l)
def findAllByName(self) -> List: s = database.newSession() hooks = list() try: for res in s.query(DiscordWebHooks).filter( DiscordWebHooks.name.contains(self.name)): hooks.append(res) except Exception as e: pass finally: s.close() return hooks
def getQueue(self) -> List: s = database.newSession() queue = list() dq = DiscordQueue() try: for res in s.query(DiscordQueue): queue.append(res) except Exception as e: pass finally: s.close() return queue
def add(self) -> None: """ Adds a single object to the table. Returns: None """ s = database.newSession() try: s.add(self) s.commit() except FailedToAddToDatabase as e: print(f"Failed to add {self.key} to 'settings'. {e}") finally: s.close()
def add(self) -> None: s = database.newSession() h = DiscordWebHooks() h.key = self.key h.name = self.name h.enabled = self.enabled try: s.add(self) s.commit() # print(f"'{self.name}' was added to the Discord queue") except FailedToAddToDatabase as e: print(f"Failed to add {self.name} to DiscordWebHook table! {e}") finally: s.close()
def clearTable(self) -> None: """ Removes all the objects found in the Settings Table. Returns: None """ s = database.newSession() try: for d in s.query(Settings): s.delete(d) s.commit() except Exception as e: print(f"{e}") finally: s.close()
def remove(self) -> None: """ Removes single object based on its ID value. Returns: None """ s = database.newSession() try: for d in s.query(Settings).filter(Settings.id == self.id): s.delete(d) s.commit() except Exception as e: Logger().error( f"Failed to remove {self.key} from Settings table. {e}") finally: s.close()
def clearSingle(self) -> bool: """ This will remove a single entry from the table by its ID value. """ s = database.newSession() result: bool = False try: for i in s.query(Sources).filter(Sources.id == self.id): s.delete(i) s.commit() result = True except Exception as e: print(e) finally: s.close() return result
def __len__(self) -> int: """ Returns the number of rows based off the SiteName value provieded. """ s = database.newSession() l = list() try: for res in s.query(Articles).filter( Articles.siteName == self.siteName): l.append(res) except Exception as e: pass finally: s.close() return len(l)
def __len__(self) -> int: """ Returns the number of rows based off the Key value provided. Returns: Int """ s = database.newSession() l = list() try: for res in s.query(Settings).filter(Settings.key == self.key): l.append(res) except Exception as e: pass finally: s.close() return len(l)
def findSingleByKey(self) -> None: """ Searches the database for objects that contain the Key value. Returns: Settings """ s = database.newSession() d = Settings() try: for d in s.query(Settings).filter(Settings.key.contains(self.key)): pass except Exception as e: pass finally: s.close() return d
def findAllByKey(self) -> List: """ Searches the database for objects that contain the Key value. Returns: List[Settings] """ s = database.newSession() l = list() try: for res in s.query(Settings).filter(Settings.key.contains( self.key)): l.append(res) except Exception as e: pass finally: s.close() return l
def exists(self) -> bool: """ Check to see if the current record exists. """ s = database.newSession() a = Articles() try: for res in s.query(Articles).filter(Articles.url == self.url): a = res except Exception as e: pass finally: s.close() if self.url == a.url: return True else: return False
def add(self) -> None: s = database.newSession() a = Articles(siteName=self.siteName, tags=self.tags, title=self.title, url=self.url, pubDate=self.pubDate, video=self.video, videoWidth=self.videoWidth, videoHeight=self.videoHeight, thumbnail=self.thumbnail, description=self.description, authorImage=self.authorImage, authorName=self.authorName) try: s.add(a) s.commit() except FailedToAddToDatabase as e: print(f"Failed to add {self.title} to the database! {e}") finally: s.close()