示例#1
0
	def __init__(self):
		import cf

		perm_active = []
		if cf.require_activation:
			perm_active = perm.edit

		ent_table.__init__(self, attributes = [
			('party', string(label.party, perm.all + ['delete'], '', 20)),
			('username', string(label.username, perm.all + ['delete'], '', 10)),
			('tourney', string(label.tourney, perm.all + ['delete', 'list'], '', 32)),
			# Editing the team must not be allowed, because the 'active' status
			# would remain unchanged. Also, the user may be leader of the
			# current team, which would not allow him to be a member of a
			# different team. The only legal way is to delete the entry
			# altogether and rejoin the other team.
			('team', string(label.team, perm.submit, '', 32)),
			('active', bool(label.active, perm_active, 0))
			],
			primary_keys = [ 'party', 'username', 'tourney' ],
			relations = [
				relation(
			table =	'gamer',
			keys = {	'party':	'party',
						'username':	'******' },
						# Users can only subscribe themselves.
			cond = {	'submit':	"gamer.username = $userid",
						'delete':	"gamer.username = $userid OR " \
									"$users.rank > 0" } ),
				relation(
			table =	'team',
			keys = {	'party':	'party',
						'tourney':	'tourney',
						'team':		'name' },
						# Only the team leader can change member settings.
						#
						# NB: The 'team.name = team_members.team' condition can
						# not be handled as a join condition because 'team' is
						# not a primary key of 'team_members'.
			cond = {	'edit':		"team.name = team_members.team AND " \
									"team.leader = $userid" } ),
				relation(
			table =	'tourney',
			alias =	'tn',
			keys = {	'party':	'party',
						'tourney':	'name' },
						# Make sure tournament is in preparation phase.
			cond = {	'submit':	"tn.phase = 1",
						'edit':		"tn.phase = 1",
						'delete':	"tn.phase = 1" } ),
				relation(
			table =	'users',
			keys = {	'username':		'******' },
						# Make sure user has paid.
			cond = {	'submit':	"gamer.paid = TRUE OR users.rank > 0" } ),
				relation(
			table =	'team',
			alias =	'lt',
			keys = {	'party':	'party',
						'tourney':	'tourney',
						'username':	'******' },
						# Make sure user is not a leader of another team
						# already.
			cond = {	'submit':	"lt.leader IS NULL OR team.name = lt.name" },
			outer_join =	"LEFT" )
				],
			item_txt = {
				'edit': {
					'en': 'Teammember Settings',
					'de': 'Teammitglieder Einstellungen' },
				'submit': {
					'en': 'Join Team',
					'de': 'Team beitreten' },
				'view': {
					'en': 'Teammembers',
					'de': 'Teammitglieder' },
				'list': {
					'en': 'Teammembers',
					'de': 'Teammitglieder' } } )
示例#2
0
	def __init__(self):
		opt_bracket = [
			{ 'en': 'Winner' },
			{ 'en': 'Loser' } ]

		opt_status = [
			{ 'en': 'pending',
			  'de': 'l"auft' },
			{ 'en': 'Team 1 wins',
			  'de': 'Team 1 gewinnt' },
			{ 'en': 'Team 2 wins',
			  'de': 'Team 2 gewinnt' } ]

		from users import rank_check

		ent_table.__init__(self, attributes = [
			('party', string(label.party, perm.all, '', 20)),
			('tourney', string(label.tourney, perm.all, '', 32)),
			('round', attr_int(label.round, perm.edit)),
			('stage', attr_int(label.stage, perm.edit)),
			('bracket', choice(label.bracket, opt_bracket, perm.edit)),
			('id', attr_int(label.id, perm.edit)),
			('team1', string(label.team1, perm.view, '', 32)),
			('team2', string(label.team2, perm.view, '', 32)),
			('status', choice(label.status, opt_status, perm.edit))
			],
			primary_keys = [ 'party', 'tourney',
				'round', 'stage', 'bracket', 'id' ],
			relations = [
				relation(
			table = 'double_elimination',
			alias = 't1',
			keys = {	'party':	'party',
						'tourney':	'tourney',
						'round':	'round',
						'stage':	'stage',
						'bracket':	'bracket',
						'id':		'id' },
			# TODO: Is there a neater way to do this and can we get rid of the
			# nested SELECT?
			cond = {	'edit':
					"(t1.bracket = 1 AND (2*t1.round + t1.stage) = " \
					"(SELECT MAX(2*t2.round + t2.stage) " \
					"FROM double_elimination AS t2 " \
					"WHERE t1.party = t2.party AND t1.tourney = t2.tourney " \
						"AND t1.bracket = t2.bracket)) OR " \
					"(t1.bracket = 0 AND (2*t1.round + t1.stage) = " \
					"(SELECT MAX(2*t2.round + t2.stage) " \
					"FROM double_elimination AS t2 " \
					"WHERE t1.party = t2.party AND t1.tourney = t2.tourney " \
						"AND t1.bracket = t2.bracket))" } ),
				relation(
			table =	'team',
			alias = 'tm1',
			keys = {	'party':	'party',
						'tourney':	'tourney',
						'team1':	'name' } ),
				relation(
			table =	'team',
			alias = 'tm2',
			keys = {	'party':	'party',
						'tourney':	'tourney',
						'team2':	'name' } ) ],
			perm = {
				'edit':	rank_check(self, 2),
				'view': True },
			item_txt = {
				'edit': {
					'en': 'Enter game results',
					'de': 'Spielergebnisse eintragen' },
				'submit': {
					'en': 'Add game',
					'de': 'Spiel hinzuf"ugen' },
				'list': {
					'en': 'Game results',
					'de': 'Spielergebnisse' } }
				)