def remove_achievement(achievementID): #Firstly, get videoIDs videoID = sql.run_sql(("""SElECT VideoID FROM Video WHERE InstanceRunID = (SELECT InstanceRunID From Achievement WHERE AchievementID = "%s") """ %(achievementID))) #If video exist for this achievement if videoID: videoID = videoID[0][0] #Get all the viewerOrders for the video viewerOrders = sql.run_sql(("""SELECT ViewerOrderID FROM ViewerOrderLine WHERE VideoID = "%s" """% (videoID))) #Remove all ViewerOrderLine data with the VideoID sql.run_remove(("""DELETE FROM ViewerOrderLine WHERE VideoID = "%s" """ % (videoID))) #Remove all ViewerOrders for i in viewerOrders: sql.run_remove(("""DELETE FROM ViewerOrder WHERE ViewerOrderID = "%s" """ % (i[0]))) #finall,y remove Video sql.run_remove(("""DELETE FROM Video WHERE VideoID = "%s" """ % (videoID))) #Remove Achievement sql.run_remove(("""DELETE FROM Achievement WHERE AchievementID = "%s" """ % (achievementID))) #Remove InstanceRun to keep the logic we have decided sql.run_remove(("""DELETE FROM InstanceRun WHERE InstanceRunID = (SELECT InstanceRunID FROM Achievement WHERE AchievementID = "%s") """ % (achievementID))) return
def cancelSubscription(): sql.run_update("""UPDATE Viewer SET ViewerType = "N" WHERE ViewerID = "%s" """%(viewerID)) sql.run_remove("""DELETE FROM PremiumViewer WHERE ViewerID = "%s" """%(viewerID)) return
def remove_instance(instanceRunID): #Get related achievements sql.run_update(("""UPDATE Achievement SET InstanceRunID = NULL, WhenAchieved = NULL WHERE InstanceRunID = "%s" """ % (instanceRunID))) #Get related Videos videoID = sql.run_sql(("""SELECT VideoID FROM Video WHERE InstanceRunID = "%s" """ % (instanceRunID))) if videoID: videoID = videoID[0][0] #Remove all viewerOrders for that video viewerOrders = sql.run_sql(("""SELECT ViewerOrderID FROM ViewerOrderLine WHERE VideoID = "%s" """% (videoID))) sql.run_remove(("""DELETE FROM ViewerOrderLine WHERE VideoID = "%s" """ % (videoID))) for i in viewerOrders: sql.run_remove(("""DELETE FROM ViewerOrder WHERE ViewerOrderID = "%s" """ % (i[0]))) #Delete Video sql.run_remove(("""DELETE FROM Video WHERE VideoID = "%s" """ % (videoID))) #Delete instaceRun sql.run_remove(("""DELETE FROM InstanceRun WHERE InstanceRunID= "%s" """ % (instanceRunID))) return
def delete_video(videoID): viewerOrders = sql.run_sql(("""SELECT ViewerOrderID FROM ViewerOrderLine WHERE VideoID = "%s" """ % (videoID))) sql.run_remove(("""DELETE FROM ViewerOrderLine WHERE VideoID = "%s" """ % (videoID))) for i in viewerOrders: sql.run_remove(("""DELETE FROM ViewerOrder WHERE ViewerOrderID = "%s" """ % (i[0]))) sql.run_remove(("""DELETE FROM Achievement WHERE InstanceRunID = (SELECT InstanceRunID FROM Video WHERE VideoID = "%s") """ % (videoID))) sql.run_remove(("""DELETE FROM Video WHERE VideoID = "%s" """ % (videoID))) sql.run_remove(("""DELETE FROM InstanceRun WHERE InstanceRunID = (SELECT InstanceRunID FROM Video WHERE VideoID = "%s") """ % (videoID))) return
def remove_viewer(viewerID): sql.run_remove(("""DELETE FROM CrowdFundingViewer WHERE ViewerID = "%s" """% (viewerID))) sql.run_remove(("""DELETE FROM PremiumViewer WHERE ViewerID = "%s" """% (viewerID))) addressIDs = sql.run_sql(("""SELECT AddressID FROM ViewerAddress WHERE ViewerID = "%s" AND AddressID NOT IN (SELECT AddressID FROM ViewerAddress WHERE ViewerID != "%s") AND AddressID NOT IN (SELECT DISTINCT(AddressID) FROM PlayerAddress) """ %(viewerID,viewerID))) sql.run_remove(("""DELETE FROM ViewerAddress WHERE ViewerID = "%s" """ % (viewerID))) for i in addressIDs: sql.run_remove(("""DELETE FROM Address WHERE AddressID = "%s" """ % (i[0]))) orderIDs = sql.run_sql(("""SELECT ViewerOrderID FROM ViewerOrder WHERE ViewerID = "%s" """ % (viewerID))) for i in orderIDs: sql.run_remove(("""DELETE FROM ViewerOrderLine WHERE ViewerOrderID = "%s" """ % (i[0]))) sql.run_remove(("""DELETE FROM ViewerOrder WHERE ViewerID = "%s" """ % (viewerID))) sql.run_remove(("""DELETE FROM ViewerLogin WHERE ViewerID = "%s" """ % (viewerID))) sql.run_remove(("""DELETE FROM Viewer WHERE ViewerID = "%s" """ % (viewerID))) return
def delete_game(gameID): videoID = sql.run_sql("""SELECT VideoID FROM Video WHERE GameID = %s"""%gameID) if videoID: delete_video(videoID[0][0]) sql.run_remove(("""DELETE FROM Game WHERE GameID = "%s" """%gameID)) return