After('@db_cleanup') do|scenario|
client = connect_to_db(@server_database)
result = client.execute("DELETE
FROM [#{@server_database}].[dbo].[Account]
WHERE account LIKE 'test%'
AND email LIKE '%301days.com'")
debug_msg "Rows deleted from [Account]: #{result.do}"
player_tables =["PlayerBelt","PlayerEffects","PlayerFlags","PlayerHeld","PlayerLocker",
"PlayerQuests","PlayerRings","PlayerSack","PlayerSettings","PlayerSkills","PlayerSpells",
"PlayerWearing","Player"]
get_all_test_player_ids().each do|player_to_delete|
debug_msg "Deleting player #{player_to_delete}"
player_tables.each do|table|
result = client.execute("DELETE
FROM [#{@server_database}].[dbo].[#{table}]
WHERE playerID = '#{player_to_delete}'")
debug_msg "Rows deleted from [#{table}]: #{result.do}"endend
result = client.execute("DELETE
FROM [#{@server_database}].[dbo].[Log]")
debug_msg "Rows deleted from [Log]: #{result.do}"end
defdelete_all_test_accounts()
client = connect_to_db(@server_database)
result = client.execute("DELETE
FROM [#{@server_database}].[dbo].[Account]
WHERE account LIKE 'test%'
AND email LIKE '%301days.com'")
debug_msg "Rows deleted from [Account]: #{result.do}"end
defdelete_all_test_players()
client = connect_to_db(@server_database)
player_tables =["PlayerBelt","PlayerEffects","PlayerFlags","PlayerHeld","PlayerLocker",
"PlayerQuests","PlayerRings","PlayerSack","PlayerSettings","PlayerSkills","PlayerSpells",
"PlayerWearing","Player"]
get_all_test_player_ids().each do|player_to_delete|
debug_msg "Deleting player #{player_to_delete}"
player_tables.each do|table|
result = client.execute("DELETE
FROM [#{@server_database}].[dbo].[#{table}]
WHERE playerID = '#{player_to_delete}'")
debug_msg "Rows deleted from [#{table}]: #{result.do}"endendenddefget_all_test_player_ids()
id_list =[]
client = connect_to_db(@server_database)
query ="SELECT [playerID] FROM [#{@server_database}].[dbo].[Player] \
WHERE account LIKE 'test%' \
AND name LIKE 'Dude.%'"
result = client.execute(query)
result.each(:symbolize_keys=>true) do|rowset|
id_list << rowset[:playerID]end
id_list
end
defclear_log()
client = connect_to_db(@server_database)
result = client.execute("DELETE
FROM [#{@server_database}].[dbo].[Log]")
debug_msg "Rows deleted from [Log]: #{result.do}"end