def __init__(self, *args, **kwargs):
self._properties = [
properties.Text(name='reported_from', default=common.current_user(), completion=common.get_commiters(),),
properties.Id(name="issue_id", auto=False),
properties.Date(name="created_on", editable=False, auto_add_now=True),
properties.Description(name="description"),
]
super(Comment, self).__init__(*args, **kwargs)
self._print_order = ['reported_from', 'created_on', 'description']
def run():
#
# all the user preference cgi entry points come here
#
# The common page header:
output.write(common.cgi_header_html)
output.write(common.page_header())
#
form = pandokia.pcgi.form
# find out whose preferences we are handling
user = common.current_user()
if user is None:
output.write(
'This web server does not perform authentication, so pandokia does not know about user names.<br>'
)
output.write(
'Using the user name "nobody" for testing, but do not expect it to be useful.<br>'
)
user = '******'
# dispatch this to the relevant subtype
if 'subtype' in form:
x = form['subtype'].value
else:
x = 'show'
if x == 'show':
show(user)
elif x == 'save':
if ('newuser' in form) and (user in cfg.admin_user_list):
if form['submit'].value == 'newuser':
newuser = form['newuser'].value
save(newuser)
else:
save(user)
else:
save(user)
elif x == 'add_project':
add_project(user)
elif x == 'list':
if user in cfg.admin_user_list:
list_users()
if user in cfg.admin_user_list:
output.write(
'<p><a href=%s?query=prefs&subtype=list>list all</a></p>' %
common.get_cgi_name())
sys_report()
def __init__(self, *args, **kwargs):
self._properties = [
properties.Text(
name='reported_from',
default=common.current_user(),
completion=common.get_commiters(),
),
properties.Id(name="issue_id", auto=False),
properties.Date(name="created_on",
editable=False,
auto_add_now=True),
properties.Description(name="description"),
]
super(Comment, self).__init__(*args, **kwargs)
self._print_order = ['reported_from', 'created_on', 'description']
def hostinfo():
admin = common.current_user() in common.cfg.admin_user_list
print common.cgi_header_html
input_query = pandokia.pcgi.form_to_dict(pandokia.pcgi.form)
for x in input_query['host']:
host, os, description = common.hostinfo(x)
if os is None:
os = ''
if description is None:
description = ''
print '<b>%s</b><br>' % cgi.escape(host)
cols = len(os)
if cols < 40:
cols = 40
if admin:
print "<form action=%s method=POST>" % common.get_cgi_name()
print "<input type=hidden name=query value=set_hostinfo>"
print "<input type=hidden name=host value=%s>" % host
print '<input type=text cols=%d name=os value="%s">' % (
cols, cgi.escape(os, True))
l = [len(s) for s in description.split('\n')]
cols = max(l)
if cols < 40:
cols = 40
rows = len(l)
if rows < 4:
rows = 4
print "<br><textarea name=description rows=%d cols=%d>%s</textarea>" % (
rows, cols, cgi.escape(description))
if admin:
print "<br><input type=submit value='change'>"
print "</form>"
def set_hostinfo():
admin = common.current_user() in common.cfg.admin_user_list
if not admin:
pandokia.pcgi.error_1201()
return
print "content-type: text/plain\n"
input_query = pandokia.pcgi.form_to_dict(pandokia.pcgi.form)
os = input_query['os'][0]
description = input_query['description'][0]
host = input_query['host'][0]
pandokia.cfg.pdk_db.execute("DELETE FROM hostinfo WHERE hostname = :1",
(host, ))
pandokia.cfg.pdk_db.execute(
"INSERT INTO hostinfo ( os, description, hostname ) VALUES ( :1, :2, :3 )",
(os, description, host))
pandokia.cfg.pdk_db.commit()
print(os, description, host)
def __init__(self, *args, **kwargs):
self._properties = [
properties.Text(name='title', allow_empty=False),
properties.Option(name='status',
options={
'new': {
'shortcut': 'n',
'color': common.get_fore_color('YELLOW')
},
'assigned': {
'shortcut': 'a',
'color': common.get_fore_color('GREEN')
},
'invalid': {
'shortcut': 'i',
'color': common.get_fore_color('WHITE')
},
'closed': {
'shortcut': 'c',
'color': common.get_fore_color('WHITE')
}
},
default='new'),
properties.Option(name='type',
options={
'bug': {
'shortcut': 'b',
'color': common.get_fore_color('YELLOW')
},
'feature': {
'shortcut': 'f',
'color': common.get_fore_color('GREEN')
}
},
default='bug'),
properties.Option(name='severity',
options={
'high': {
'shortcut': 'h',
'color': common.get_fore_color('RED')
},
'medium': {
'shortcut': 'm',
'color': common.get_fore_color('YELLOW')
},
'low': {
'shortcut': 'l',
'color': common.get_fore_color('WHITE')
}
},
default='low'),
properties.Text(name='assigned_to',
completion=common.get_commiters()),
properties.Text(name='reported_from',
completion=common.get_commiters(),
default=common.current_user()),
properties.Date(name='created_on',
editable=False,
auto_add_now=True),
properties.Date(name='updated_on', editable=False, auto_now=True),
properties.Description(name='description')
]
self._comments = []
super(Issue, self).__init__(*args, **kwargs)
self._print_order = [
'id', 'title', 'type', 'severity', 'reported_from', 'assigned_to',
'created_on', 'updated_on', 'status', 'description'
]
def __init__(self, *args, **kwargs):
self._properties = [
properties.Text(name='title', allow_empty=False),
properties.Option(name='status',
options={'new':{'shortcut':'n', 'color':common.get_fore_color('YELLOW')},
'assigned':{'shortcut':'a', 'color':common.get_fore_color('GREEN')},
'invalid':{'shortcut':'i', 'color':common.get_fore_color('WHITE')},
'closed':{'shortcut':'c', 'color':common.get_fore_color('WHITE')}
},
default='new'),
properties.Option(name='type',
options={'bug':{'shortcut':'b', 'color':common.get_fore_color('YELLOW')},
'feature':{'shortcut':'f', 'color':common.get_fore_color('GREEN')}
},
default='bug'),
properties.Option(name='severity',
options={'high':{'shortcut':'h', 'color':common.get_fore_color('RED')},
'medium':{'shortcut':'m', 'color':common.get_fore_color('YELLOW')},
'low':{'shortcut':'l', 'color':common.get_fore_color('WHITE')}
},
default='low'),
properties.Text(name='assigned_to', completion=common.get_commiters()),
properties.Text(name='reported_from', completion=common.get_commiters(), default=common.current_user()),
properties.Date(name='created_on', editable=False, auto_add_now=True),
properties.Date(name='updated_on', editable=False, auto_now=True),
properties.Description(name='description')
]
self._comments = []
super(Issue, self).__init__(*args, **kwargs)
self._print_order = ['id', 'title', 'type', 'severity', 'reported_from', 'assigned_to',
'created_on', 'updated_on', 'status', 'description'
]
def run( ) :
#
# take actions based on the button a user slected from the summary page
#
output = sys.stdout
text_present = 0
output.write(common.cgi_header_html)
output.write('...')
output.flush()
# don't issue the redirect for internet explorer
if 'MSIE' in os.environ['HTTP_USER_AGENT'] :
output.write('<p>Internet Explorer fumbles the redirect. Click the link below.</p>')
no_redirect = 1
else :
no_redirect = 0
#
# gather up all the expected parameters
#
form = pandokia.pcgi.form
# lots of cases use qid
if 'qid' in form :
qid = int(form['qid'].value)
else :
qid = None
#
if 'action_remove' in form :
qid = copy_qid(qid)
for key_id in valid_key_ids(form) :
pdk_db.execute('DELETE FROM query WHERE qid = :1 AND key_id = :2 ', (qid, key_id))
pdk_db.commit()
if ( 'action_cattn' in form ) or ( 'action_sattn' in form ) :
if 'action_cattn' in form :
value='N'
else :
value='Y'
for key_id in valid_key_ids(form) :
pdk_db.execute("UPDATE result_scalar SET attn = :1 WHERE key_id = :2 ", (value,key_id))
pdk_db.commit()
elif 'action_keep' in form :
qid = copy_qid(qid)
c = pdk_db.execute('SELECT key_id FROM query WHERE qid = :1 ', (qid,))
for key_id, in c :
if not str(key_id) in form :
pdk_db.execute('DELETE FROM query WHERE qid = :1 AND key_id = :2 ', (qid, key_id))
pdk_db.commit()
elif ( 'action_flagok' in form ) or ( 'action_flagok_rem' in form ) :
qid = copy_qid(qid)
# pick out client IP for logging
# we don't need to validate client because it was done already in the main program
output.write("<h3>flagging tests as ok</h3>\n")
# ip address
client = os.environ["REMOTE_ADDR"]
# user who flagged OK
user = common.current_user()
if user is None :
user = '******'
# OK comment
comment = form["ok_comment"].value
text_present |= pandokia.flagok.ok_transaction(
qid,
client,
valid_key_ids(form),
user,
comment
)
pandokia.flagok.commit()
if 'action_flagok_rem' in form :
# copy of 'remove' above - expedient for the moment
for key_id in valid_key_ids(form) :
pdk_db.execute('DELETE FROM query WHERE qid = :1 AND key_id = :2 ', (qid, key_id))
pdk_db.commit()
elif 'not_expected' in form :
arg1 = form['arg1'].value
for key_id in valid_key_ids(form) :
c = pdk_db.execute("SELECT project, host, test_name, context FROM result_scalar WHERE key_id = :1 ", (key_id,) )
for project, host, test_name, context in c :
pdk_db.execute("DELETE FROM expected WHERE test_run_type LIKE :5 AND project = :1 AND host = :2 AND test_name = :3 AND context = :4 ",(project,host,test_name,context,arg1))
pdk_db.commit()
elif 'claim_qid' in form :
print "CLAIM", common.current_user()
pdk_db.execute("UPDATE query_id SET username = :1 WHERE qid = :2 ",(common.current_user(), qid))
pdk_db.commit()
elif 'valuable_qid' in form :
v = int(form['valuable_qid'].value)
if v :
expire = pandokia.never_expires
if 0 :
s = "SELECT DISTINCT result_scalar.test_run FROM result_scalar, query WHERE query.qid = %d and result_scalar.key_id = query.key_id " % ( qid, )
print "S=%s<br>"%s
c = pdk_db.execute( s )
for x in c :
print x, "<br>"
pdk_db.execute("""UPDATE distinct_test_run SET valuable=1 WHERE test_run IN
( SELECT DISTINCT result_scalar.test_run FROM result_scalar, query WHERE query.qid = %d and result_scalar.key_id = query.key_id )
""" % ( qid, ) )
else :
expire = time.time() + pandokia.cfg.default_qid_expire_days * 86400
pdk_db.execute("UPDATE query_id SET username = :1, expires = :2 WHERE qid = :3",(common.current_user(), expire, qid))
pdk_db.commit()
qid = None
elif 'valuable_run' in form :
text_present = 1
v = int(form['valuable_run'].value)
test_run = str(form['test_run'].value)
pdk_db.execute("UPDATE distinct_test_run SET valuable = :1 WHERE test_run = :2",(v,test_run))
pdk_db.commit()
if v :
v = 'valuable'
else :
v = 'not valuable'
print "Test run",test_run," marked as ",v
elif 'note' in form :
text_present = 1
v = str(form['note'].value)
test_run = str(form['test_run'].value)
pdk_db.execute("UPDATE distinct_test_run SET note = :1 WHERE test_run = :2",(v,test_run))
pdk_db.commit()
print "Note set"
elif 'count_run' in form :
text_present = 1
import pandokia.cleaner as cleaner
print "<pre>"
test_run = str(form['count_run'].value)
cleaner.recount( [ test_run ] )
print "</pre>"
elif 'edit_comment' in form :
text_present = 1
c = pdk_db.execute("SELECT notes FROM query_id WHERE qid = :1",(qid,))
note = c.fetchone()[0]
if note is None :
note = ''
output.write('<form action=%s method=get name=edit_comment>' % pandokia.pcgi.cginame )
output.write('<input type=hidden name=query value=action>')
output.write('<input type=hidden name=qid value=%d>'%qid)
output.write('<input type=hidden name=save_comment value=1>')
output.write('<textarea cols="80" rows="10" name=comment>%s</textarea><br>'%(cgi.escape(note)))
output.write('<input type=submit value="save">')
output.write('</form>')
elif 'save_comment' in form :
notes = form['comment'].value
pdk_db.execute('UPDATE query_id SET notes = :1 WHERE qid = :2', (notes, qid) )
pdk_db.commit()
else :
no_redirect = 1
print form
if qid is not None :
if text_present :
output.write(
"<a href='"
+ pandokia.pcgi.cginame
+ ("?query=summary&qid=%s'>back to qid = " % qid)
+ str(qid)
+ "</a><br>\n"
)
else :
if not no_redirect :
output.write(
'<html><head><meta http-equiv="REFRESH" content="0;'
+ pandokia.pcgi.cginame
+ ( '?query=summary&qid=%s"' % qid )
+ '>\n</head><body>\n'
)
output.write(
"redirecting: <a href='"
+ pandokia.pcgi.cginame
+ ("?query=summary&qid=%s'>qid = " % qid)
+ str(qid)
+ "</a><br>\n"
)
else :
output.write("<br>Hit BACK and RELOAD\n")
