Navigation

Changeset 2524

Timestamp:

07/24/07 16:39:39 (1 year ago)

Author:

eclip5e

Message:

ManualTestingPlugin:

Files:

r2523	r2524
30	30	return None
31	31
	32	def add_suite(self,cursor,new_user,new_title,new_component,new_description,new_time):
	33	sql = "INSERT INTO mtp_suites (title,component,description,deleted,user) VALUES ('%s','%s','%s',%s,'%s')" % (new_title,new_component,new_description,0,new_user)
	34	self.log.debug(sql)
	35	# ToDo: values in SQL statement must be escaped.
	36	cursor.execute(sql)
	37
32	38	def get_plans(self, req, cursor, suite_id):
33	39	rows = []
…	…
47	53	# ToDo: values in SQL statement must be escaped.
48	54	cursor.execute(sql)
	55
	56	def get_tracComponents(self, cursor):
	57	rows = []
	58	columns = ('name','owner','default')
	59	sql = "SELECT * FROM component"
	60	self.log.debug(sql)
	61	cursor.execute(sql)
	62	for row in cursor:
	63	row = dict(zip(columns, row))
	64	rows.append(row)
	65	return rows
	66
	67	def get_tracVersions(self, cursor):
	68	rows = []
	69	columns = ('name','time','default')
	70	sql = "SELECT * FROM version"
	71	self.log.debug(sql)
	72	cursor.execute(sql)
	73	for row in cursor:
	74	row = dict(zip(columns, row))
	75	rows.append(row)
	76	return rows

r2523	r2524
26	26	<th><a href="#" title="">Report</a></th>
27	27	<th><a href="#" title="">Title</a></th>
	28	<th><a href="#" title="">Component</a></th>
28	29	<th><a href="#" title="">Description</a></th>
29	30	</tr>
…	…
49	50	</a>
50	51	</td>
	52	<td class="Component">
	53	<?cs var:row.component ?>
	54	</td>
51	55	<td class="description">
52	56	<?cs var:row.description ?>
…	…
66	70	</form>
67	71	</div>
	72	<div class="buttons">
	73	<form method="post" action="<?cs var:manualtesting.href ?>">
	74	<input type="submit" name="addsuite" value="Add Test Suite" />
	75	<input type="hidden" name="manualtesting_action" value="add" />
	76	</form>
	77	</div>
68	78	</div>
69	79

r2523	r2524
67	67	return ['suite-view']
68	68	else:
69		return ['main']
	69	if action == 'add':
	70	return ['suite-add-form']
	71	elif action == 'suite-add':
	72	return ['suite-add-submit', 'main']
	73	else:
	74	return ['main']
70	75
71	76	def performAction(self, req, cursor, modes, suite_id, plan_id):
…	…
76	81	suites = self.dbUtils.get_suites(cursor)
77	82	req.hdf['manualtesting.suites'] = suites
78		return '~~suites~~.cs'
	83	return 'main.cs'
79	84
80	85	elif mode == 'plan-add-form':
…	…
113	118	req.hdf['manualtesting.plans'] = plans
114	119	return 'suite.cs'
	120
	121	elif mode == 'suite-add-form':
	122	components = self.dbUtils.get_tracComponents(cursor)
	123	req.hdf['manualtesting.trac.components'] = components
	124	# Return template
	125	return 'suite-add.cs'
	126
	127	elif mode == 'suite-add-submit':
	128	# Get form values.
	129	new_user = req.args.get('user')
	130	new_title = req.args.get('title')
	131	new_component = req.args.get('component')
	132	new_description = req.args.get('description')
	133	new_time = int( time.time() )
	134	# Add plan.
	135	self.log.debug(new_description)
	136	self.dbUtils.add_suite(cursor,new_user,new_title,new_component,new_description,new_time)