def show_project(post_id):
reload_init()
if data.lookup_project(post_id)[0] == 0: #kex err code
logger('###Project ' + str(post_id) + ' visited') #sends log message with post id if it exists
return render_template('project_id.html', project = data.lookup_project(post_id)[1]) #renders the requested page
else:
logger('###Nonexistent project visited') #sends err message to the log if nonexistent project
return render_template('project_id.html', error = "Project not found") #err msg to user
def index(id=None):
data.init()
#default template
template = kid.Template(name=os.path.basename(__file__)[:-3],
title=get_text('sitename') + '-' +
get_text(os.path.basename(__file__)[:-3]),
projects=[],
headline=get_text(os.path.basename(__file__)[:-3]),
project_not_found=u'Databasen är inte tillgänglig',
**common_language[DEFAULT_LANGUAGE])
if id == None:
projects = data.retrieve_projects(sort_order='desc')
if projects[0] == 0:
template = kid.Template(name=os.path.basename(__file__)[:-3],
title=get_text('sitename') + '-' +
get_text(os.path.basename(__file__)[:-3]),
projects=projects[1],
headline=get_text(
os.path.basename(__file__)[:-3]),
project_not_found='',
**common_language[DEFAULT_LANGUAGE])
# Find project by id
else:
project = data.lookup_project(id)
# Project not found
if project[0] == 2:
projects = data.retrieve_projects(sort_order='desc')
if projects[0] == 0:
template = kid.Template(
name=os.path.basename(__file__)[:-3],
title=get_text('sitename') + '-' +
get_text('project_not_found'),
projects=projects[1],
headline=get_text(os.path.basename(__file__)[:-3]),
project_not_found=get_text('project_not_found'),
**common_language[DEFAULT_LANGUAGE])
# Show project by id
else:
project = data.retrieve_projects(search=id,
search_fields=['project_no'])
project[1][0]['techniques_used'] = ", ".join(
project[1][0]['techniques_used'])
template = kid.Template(
name='projectsbyid',
title=get_text('sitename') + '-' + get_text('projects') +
": " + project[1][0]['project_name'],
headline=project[1][0]['project_name'],
**dict(project[1][0], **common_language[DEFAULT_LANGUAGE]))
template.cache = False
return template.serialize(output='xhtml-strict')
def page_project(id):
data.init()
_project = data.lookup_project(id)[1]
if _project == None:
_project = ""
data_error = data._error_meaning[data._error_code]
return render_template("project.html", _db_data=_project, data_error=data_error)
def index(id=None):
data.init()
#default template
template = kid.Template(name=os.path.basename(__file__)[:-3],
title=get_text('sitename') + '-' + get_text(os.path.basename(__file__)[:-3]),
projects=[],
headline=get_text(os.path.basename(__file__)[:-3]),
project_not_found=u'Databasen är inte tillgänglig',
**common_language[DEFAULT_LANGUAGE])
if id == None:
projects = data.retrieve_projects(sort_order='desc');
if projects[0] == 0:
template = kid.Template(name=os.path.basename(__file__)[:-3],
title=get_text('sitename') + '-' + get_text(os.path.basename(__file__)[:-3]),
projects=projects[1],
headline=get_text(os.path.basename(__file__)[:-3]),
project_not_found='',
**common_language[DEFAULT_LANGUAGE])
# Find project by id
else:
project = data.lookup_project(id)
# Project not found
if project[0] == 2:
projects = data.retrieve_projects(sort_order='desc');
if projects[0] == 0:
template = kid.Template(name=os.path.basename(__file__)[:-3],
title=get_text('sitename') + '-' + get_text('project_not_found'),
projects=projects[1],
headline=get_text(os.path.basename(__file__)[:-3]),
project_not_found=get_text('project_not_found'),
**common_language[DEFAULT_LANGUAGE])
# Show project by id
else:
project = data.retrieve_projects(search=id,search_fields=['project_no']);
project[1][0]['techniques_used'] = ", ".join(project[1][0]['techniques_used'])
template = kid.Template(name='projectsbyid',
title=get_text('sitename') +
'-' +
get_text('projects') +
": " +
project[1][0]['project_name'],
headline=project[1][0]['project_name'],
**dict(project[1][0],**common_language[DEFAULT_LANGUAGE]))
template.cache = False
return template.serialize(output='xhtml-strict')
def index(id):
try:
id = int(id)
except ValueError:
pass
project = data.lookup_project(id)[1]
if project is not None:
template = kid.Template(file=os.path.dirname(__file__) + os.sep + 'templates' + os.sep + 'project',project_id=project)
else:
template = kid.Template(file=os.path.dirname(__file__) + os.sep + 'templates' + os.sep + 'error',project_id=project)
template.cache = False
site.cache = False
return template.serialize(output='xhtml-strict')
if os.path.exists(data_temp_name):
os.rename(data_temp_name, "data.csv")
errcode, result = data.project_count()
assert errcode != 0
data.init()
os.rename("data.csv", data_temp_name)
errcode, result = data.project_count()
WORKED(errcode)
assert result == 4
errcode, result = data.lookup_project(1)
WORKED(errcode)
assert result[u'course_id'] == u'TDP003'
assert result[u'course_name'] == u'OKÄNT'
assert result[u'techniques_used'] == [u'python']
errcode, result = data.lookup_project(4)
WORKED(errcode)
assert result[u'course_id'] == u' "'
assert result[u'techniques_used'] == []
assert result[u'lulz_had'] == u'over 9000'
errcode, result = data.lookup_project(2)
WORKED(errcode)
assert result[u'project_name'] == u'2007'