Yahoo! Sports Fantasy Manager

The "Yahoo! Sports Fantasy Manager" is a swing application designed with flexability and customizability in mind. The tabs on the left of the swing application are all configured by a file named manager.xml (download) . This file contains the format of the panel and any queries needed to CRUD (Create/Replace/Update/Delete) the data displayed.

The code that reads and parses the config file is located in the package com.mlw.fball (download) . The zip file that contains the application and the source can be downloded here: fball.zip.

Below there are five examples of segments of the xml file and the screen it generates.

Team Management
<component class="com.mlw.fball.TeamManagementPanel" > <set name="TabLabel">Team Management</set> <set name="TeamsQuery"> SELECT name, nid FROM teams ORDER BY name </set> <set name="AddPlayerQuery"> INSERT INTO player_x_team (player_id, nid) VALUES(?,?) </set> <set name="RemovePlayerQuery"> DELETE FROM player_x_team WHERE player_id = ? AND nid = ? </set> <set name="AvailablePlayersQuery"> SELECT STATS.first_name, STATS.last_name, STATS.player_id, STATS.position, STATS.team FROM PLAYER_X_TEAM RIGHT JOIN STATS ON PLAYER_X_TEAM.PLAYER_ID = STATS.PLAYER_ID WHERE STATS.first_name LIKE ? AND STATS.last_name LIKE ? AND (((PLAYER_X_TEAM.PLAYER_ID) Is Null)) ORDER BY STATS.last_name, STATS.first_name </set> <set name="TeamPlayersQuery"> SELECT stats.FIRST_NAME, stats.LAST_NAME, stats.PLAYER_ID, stats.POSITION, stats.TEAM FROM stats, PLAYER_X_TEAM WHERE stats.PLAYER_ID = PLAYER_X_TEAM.PLAYER_ID AND PLAYER_X_TEAM.NID = ? ORDER BY stats.LAST_NAME, stats.FIRST_NAME </set> </component>

Figure 1

Team Stats (1)
<component class="com.mlw.fball.JTableDataPanel" > <set name="TabLabel">Team Stats (1)</set>> <set name="StatsQuery"> SELECT teams.name as "Owner", PTS as "Points", TOT_REB as "Reb", ASSISTS as "Asts", STEALS as "Stls", TURNOVERS as "Tnvr", BLOCKS as "Blks", THREE_PTR_MADE as "3-pt", FT_PCT as "FGpt", FG_PCT as "FTpt", (PTS+TOT_REB+ASSISTS+STEALS+ TURNOVERS+BLOCKS+THREE_PTR_MADE+ FT_PCT+FG_PCT)/10 as "Average" FROM rank, teams WHERE rank.NID = teams.NID ORDER BY (PTS+TOT_REB+ ASSISTS+STEALS+ TURNOVERS+BLOCKS+ THREE_PTR_MADE+ FT_PCT+FG_PCT) DESC </set> </component>

Figure 2

Match Up
<component class="com.mlw.fball.MatchUpDataPanel" > <set name="TabLabel">Match Up</set> <set name="TeamsQuery"> SELECT name, nid FROM teams ORDER BY name </set> <set name="MakeStarterQuery"> UPDATE PLAYER_X_TEAM SET starter = ? WHERE PLAYER_ID = ? AND NID = ? </set> <set name="Positions">G,G,G,F,F,F,F,C,%,%</set> <set name="TeamPlayersQuery"> SELECT stats.PLAYER_ID, ${Fantasy Rank}, stats.POSITION, stats.FIRST_NAME, stats.LAST_NAME FROM stats, PLAYER_X_TEAM WHERE stats.GAMES_PLAYED > 0 AND stats.PLAYER_ID = PLAYER_X_TEAM.PLAYER_ID AND PLAYER_X_TEAM.NID = ? ORDER BY ${Fantasy Rank} ASC </set> <set name="PlayersQuery"> SELECT stats.PLAYER_ID, ${Fantasy Rank}, stats.POSITION, stats.FIRST_NAME, stats.LAST_NAME FROM stats WHERE stats.GAMES_PLAYED > 0 ORDER BY ${Fantasy Rank} ASC </set> <set name="AvailablePlayersQuery"> SELECT stats.PLAYER_ID, ${Fantasy Rank}, stats.POSITION, stats.FIRST_NAME, stats.LAST_NAME FROM PLAYER_X_TEAM RIGHT JOIN STATS ON PLAYER_X_TEAM.PLAYER_ID = STATS.PLAYER_ID WHERE stats.GAMES_PLAYED > 0 AND (((PLAYER_X_TEAM.PLAYER_ID) Is Null)) ORDER BY ${Fantasy Rank} ASC </set> </component>

Figure 3

Taken Players
<component class="com.mlw.fball.JTableDataPanel" > <set name="TabLabel">Taken Players</set> <panel location="North"> <input type="select" resource="Owner" width="10" default="%" > <query>SELECT distinct name FROM teams</query> </input> <input type="select" resource="Position" width="10" default="%" > <query>SELECT distinct POSITION FROM stats</query> </input> </panel> <set name="StatsQuery"> SELECT teams.name as "Owner", stats.FIRST_NAME as "First Name", stats.LAST_NAME as "Last Name", stats.POSITION as "Position", stats.TEAM as "Team", stats.GAMES_PLAYED as "Games", ${Fantasy Rank} as "Fantasy Rank" FROM stats, PLAYER_X_TEAM, teams WHERE stats.PLAYER_ID = PLAYER_X_TEAM.PLAYER_ID AND stats.GAMES_PLAYED > 0 AND teams.NID = PLAYER_X_TEAM.NID AND teams.name like ? AND stats.POSITION like ? ORDER BY ${Fantasy Rank} ASC </set> </component>

Figure 4

Available Players
<component class="com.mlw.fball.JTableDataPanel" > <set name="TabLabel">Available Players</set> <panel location="North"> <input type="text" resource="First Name" width="10" default="%" /> <input type="text" resource="Last Name" width="10" default="%" /> <input type="select" resource="Position" width="10" default="%" > <query>SELECT distinct POSITION FROM stats</query> </input> </panel> <set name="StatsQuery"> SELECT stats.FIRST_NAME as "First Name", stats.LAST_NAME as "Last Name", stats.POSITION as "Position", stats.TEAM as "Team", stats.GAMES_PLAYED as "Games", ${Fantasy Rank} as "Fantasy Rank" FROM PLAYER_X_TEAM RIGHT JOIN STATS ON PLAYER_X_TEAM.PLAYER_ID = STATS.PLAYER_ID WHERE stats.GAMES_PLAYED > 0 AND (((PLAYER_X_TEAM.PLAYER_ID) Is Null)) AND stats.FIRST_NAME like ? AND stats.LAST_NAME like ? AND stats.POSITION like ? ORDER BY ${Fantasy Rank} ASC </set> </component>

Figure 5