20
20
<FONT color="green">017</FONT> <a name="line.17"></a>
21
21
<FONT color="green">018</FONT> import org.apache.cayenne.ObjectContext;<a name="line.18"></a>
22
22
<FONT color="green">019</FONT> import org.apache.cayenne.query.NamedQuery;<a name="line.19"></a>
23
<FONT color="green">020</FONT> <a name="line.20"></a>
24
<FONT color="green">021</FONT> import net.codescore.dbo.School;<a name="line.21"></a>
25
<FONT color="green">022</FONT> import net.codescore.dbo.Team;<a name="line.22"></a>
26
<FONT color="green">023</FONT> <a name="line.23"></a>
27
<FONT color="green">024</FONT> public class TeamManager {<a name="line.24"></a>
28
<FONT color="green">025</FONT> public static School getSchoolByName(ObjectContext c, String name) {<a name="line.25"></a>
29
<FONT color="green">026</FONT> HashMap<String, Object> params = new HashMap<String, Object>();<a name="line.26"></a>
30
<FONT color="green">027</FONT> params.put("n", name);<a name="line.27"></a>
31
<FONT color="green">028</FONT> NamedQuery schoolByName = new NamedQuery("school_by_name", params);<a name="line.28"></a>
32
<FONT color="green">029</FONT> List l = c.performQuery(schoolByName);<a name="line.29"></a>
33
<FONT color="green">030</FONT> if (l.size() < 1)<a name="line.30"></a>
34
<FONT color="green">031</FONT> throw new RuntimeException("Couldn't find school " + name);<a name="line.31"></a>
35
<FONT color="green">032</FONT> else if (l.size() > 1)<a name="line.32"></a>
36
<FONT color="green">033</FONT> throw new RuntimeException("Multiple choices");<a name="line.33"></a>
37
<FONT color="green">034</FONT> return (School) l.get(0);<a name="line.34"></a>
38
<FONT color="green">035</FONT> }<a name="line.35"></a>
39
<FONT color="green">036</FONT> <a name="line.36"></a>
40
<FONT color="green">037</FONT> public static Team getTeamByName(ObjectContext c, String name, String school) {<a name="line.37"></a>
41
<FONT color="green">038</FONT> HashMap<String, Object> params = new HashMap<String, Object>();<a name="line.38"></a>
42
<FONT color="green">039</FONT> params.put("n", name);<a name="line.39"></a>
43
<FONT color="green">040</FONT> params.put("s", getSchoolByName(c, school));<a name="line.40"></a>
44
<FONT color="green">041</FONT> NamedQuery teamByName = new NamedQuery("team_by_name", params);<a name="line.41"></a>
45
<FONT color="green">042</FONT> List l = c.performQuery(teamByName);<a name="line.42"></a>
46
<FONT color="green">043</FONT> if (l.size() < 1)<a name="line.43"></a>
47
<FONT color="green">044</FONT> throw new RuntimeException("Couldn't find team " + name);<a name="line.44"></a>
48
<FONT color="green">045</FONT> else if (l.size() > 1)<a name="line.45"></a>
49
<FONT color="green">046</FONT> throw new RuntimeException("Multiple choices");<a name="line.46"></a>
50
<FONT color="green">047</FONT> return (Team) l.get(0);<a name="line.47"></a>
51
<FONT color="green">048</FONT> }<a name="line.48"></a>
52
<FONT color="green">049</FONT> <a name="line.49"></a>
53
<FONT color="green">050</FONT> }<a name="line.50"></a>
23
<FONT color="green">020</FONT> import org.apache.commons.logging.Log;<a name="line.20"></a>
24
<FONT color="green">021</FONT> import org.apache.commons.logging.LogFactory;<a name="line.21"></a>
25
<FONT color="green">022</FONT> <a name="line.22"></a>
26
<FONT color="green">023</FONT> import net.codescore.dbo.School;<a name="line.23"></a>
27
<FONT color="green">024</FONT> import net.codescore.dbo.Team;<a name="line.24"></a>
28
<FONT color="green">025</FONT> <a name="line.25"></a>
29
<FONT color="green">026</FONT> public class TeamManager {<a name="line.26"></a>
30
<FONT color="green">027</FONT> public static School getSchoolByName(ObjectContext c, String name) {<a name="line.27"></a>
31
<FONT color="green">028</FONT> HashMap<String, Object> params = new HashMap<String, Object>();<a name="line.28"></a>
32
<FONT color="green">029</FONT> params.put("name", name);<a name="line.29"></a>
33
<FONT color="green">030</FONT> log.debug(params);<a name="line.30"></a>
34
<FONT color="green">031</FONT> log.debug(c);<a name="line.31"></a>
35
<FONT color="green">032</FONT> NamedQuery schoolByName = new NamedQuery("school_by_name", params);<a name="line.32"></a>
36
<FONT color="green">033</FONT> log.debug(schoolByName);<a name="line.33"></a>
37
<FONT color="green">034</FONT> List l = c.performQuery(schoolByName);<a name="line.34"></a>
38
<FONT color="green">035</FONT> if (l.size() < 1)<a name="line.35"></a>
39
<FONT color="green">036</FONT> throw new RuntimeException("Couldn't find school " + name);<a name="line.36"></a>
40
<FONT color="green">037</FONT> else if (l.size() > 1)<a name="line.37"></a>
41
<FONT color="green">038</FONT> throw new RuntimeException("Multiple choices");<a name="line.38"></a>
42
<FONT color="green">039</FONT> return (School) l.get(0);<a name="line.39"></a>
43
<FONT color="green">040</FONT> }<a name="line.40"></a>
44
<FONT color="green">041</FONT> <a name="line.41"></a>
45
<FONT color="green">042</FONT> private static Log log = LogFactory.getLog(TeamManager.class);<a name="line.42"></a>
46
<FONT color="green">043</FONT> <a name="line.43"></a>
47
<FONT color="green">044</FONT> public static Team getTeamByName(ObjectContext c, String name, String school) {<a name="line.44"></a>
48
<FONT color="green">045</FONT> HashMap<String, Object> params = new HashMap<String, Object>();<a name="line.45"></a>
49
<FONT color="green">046</FONT> params.put("n", name);<a name="line.46"></a>
50
<FONT color="green">047</FONT> params.put("s", getSchoolByName(c, school));<a name="line.47"></a>
51
<FONT color="green">048</FONT> log.debug(params);<a name="line.48"></a>
52
<FONT color="green">049</FONT> NamedQuery teamByName = new NamedQuery("team_by_name", params);<a name="line.49"></a>
53
<FONT color="green">050</FONT> log.debug(c);<a name="line.50"></a>
54
<FONT color="green">051</FONT> log.debug(teamByName);<a name="line.51"></a>
55
<FONT color="green">052</FONT> List l = c.performQuery(teamByName);<a name="line.52"></a>
56
<FONT color="green">053</FONT> if (l.size() < 1)<a name="line.53"></a>
57
<FONT color="green">054</FONT> throw new RuntimeException("Couldn't find team " + name);<a name="line.54"></a>
58
<FONT color="green">055</FONT> else if (l.size() > 1)<a name="line.55"></a>
59
<FONT color="green">056</FONT> throw new RuntimeException("Multiple choices");<a name="line.56"></a>
60
<FONT color="green">057</FONT> return (Team) l.get(0);<a name="line.57"></a>
61
<FONT color="green">058</FONT> }<a name="line.58"></a>
62
<FONT color="green">059</FONT> <a name="line.59"></a>
63
<FONT color="green">060</FONT> }<a name="line.60"></a>