def __dbdel__(self, kwdb): if kwdb.db_type == 'sqlite3': tag_ids_script = read_db_script(['tweets', 'get-tagids-of-tweet.sql']) decrement_tag_script = read_db_script(['tweets', 'decrement-tag-byid.sql']) delete_tweet_script = read_db_script(['delete', 'delete-tweet.sql']) self.tweet_id = int(self.tweet_id) tag_ids = kwdb.cursor().execute(tag_ids_script, (self.tweet_id,)).fetchall() tag_ids = [tag_id[0] for tag_id in tag_ids] for tag_id in tag_ids: kwdb.cursor().execute(decrement_tag_script.replace('?', str(tag_id))) kwdb.cursor().executescript(delete_tweet_script.replace('?', str(self.tweet_id))) else: raise UnsupportedDBTypeException(kwdb.db_type)
def add_user_auto(kwdb, user): if kwdb.db_type == 'sqlite3': add_user_auto_sqlite3(kwdb, user) else: raise UnsupportedDBTypeException(kwdb.db_type)
def sanity_check(self, kwdb): if kwdb.db_type == 'sqlite3': return kwdb.cursor().execute( self.sanity_check_script).fetchall() == [] else: raise UnsupportedDBTypeException(kwdb.db_type)
def get_all_followees_of_user_by_username(kwdb, username): if kwdb.db_type == 'sqlite3': return get_all_followees_of_user_by_username_sqlite3(kwdb=kwdb, username=username) else: raise UnsupportedDBTypeException(kwdb.db_type)
def get_all_followees_of_user(kwdb, user): if kwdb.db_type == 'sqlite3': return get_all_followees_of_user_sqlite3(kwdb, user) else: raise UnsupportedDBTypeException(kwdb.db_type)
def get_all_followersrelations(kwdb): if kwdb.db_type == 'sqlite3': return get_all_followerrelations_sqlite3(kwdb) else: raise UnsupportedDBTypeException(kwdb.db_type)
def get_all_tags(kwdb): if kwdb.db_type == 'sqlite3': return get_all_tags_sqlite3(kwdb) else: raise UnsupportedDBTypeException(kwdb.db_type)