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)