def index():
"""
example action using the internationalization operator T and flash
rendered by views/default/index.html or views/generic.html
"""
form=FORM(T('Search:'),
INPUT( _name='filesearch', requires=IS_LENGTH(minsize=3)),
INPUT(_type='submit'))
filesearch=None
if form.accepts(request,session):
filesearch=request.vars['filesearch']
if not request.env.web2py_runtime_gae:
rows= db(db.ddl.filename.contains(filesearch.replace("%", "_").replace(" ","%"))).select(orderby=db.ddl.filename, limitby=(0,100))
else:
# query = like_query(filesearch.replace(" ","%"), db.ddl.filename)
# rows = db(query).select()
from google.appengine.ext.db import GqlQuery
query = filesearch
queryEnd = query+"\xEF\xBF\xBD".decode('utf-8')
rows = GqlQuery("SELECT * FROM ddl WHERE filename>=:1 AND filename<=:2 ORDER BY filename DESC", query, queryEnd)
else:
rows= db(db.ddl.id>0).select(orderby=~db.ddl.date_added, limitby=(0,20))
ddlz=[]
for row in rows:
if not request.env.web2py_runtime_gae:
date_added=row['date_added']
else:
date_added=row.date_added
difference = datetime.now()-date_added
weeks, days = divmod(difference.days, 7)
minutes, seconds = divmod(difference.seconds, 60)
hours, minutes = divmod(minutes, 60)
if not request.env.web2py_runtime_gae:
row['timedelta']= getTimeDelta(weeks, days, hours, minutes, seconds)
row['nickname']= row['uploader']['nickname']
else:
row.timedelta= getTimeDelta(weeks, days, hours, minutes, seconds)
if type(row.uploader) is long:
row.nickname = row.uploader
row.id = 0
else:
row.nickname= row.uploader.nickname
ddlz.append(row)
loggedIn = True if auth.is_logged_in() else False
return dict(message=T('Hello World'),ddlz=ddlz, form=form, filesearch=filesearch, loggedIn=loggedIn)
def how_to_upload():
allowed= False
tuto=dict()
if auth.user.is_uploader:
tuto = dict()
tuto['start']= T("Start DDLagoon Uploader.")
tuto['login']= T("Login with your username and password.")
tuto['go_to_profile_pre']= T('Go to your')
tuto['profile']= T('profile')
tuto['go_to_profile_suf']= T('to get your API key.')
tuto['go_to_settings']= T('Go to the settings tab.')
allowed=True
loggedIn = True if auth.is_logged_in() else False
return dict(tuto=tuto, allowed=allowed, loggedIn=loggedIn)
def help():
issuesUrl= "https://bitbucket.org/DDLagoon/ddlagoon/issues"
wikiUrl= "https://bitbucket.org/DDLagoon/ddlagoon/wiki"
loggedIn = True if auth.is_logged_in() else False
return dict(issuesUrl=issuesUrl, wikiUrl=wikiUrl, loggedIn=loggedIn)
def howto():
win32= "http://www.mediafire.com/?hbuvrbrwh12fhbv"
win64= "http://www.mediafire.com/?carxg6ord5v5bfy"
amd64= "http://www.mediafire.com/?p4mzpscyd93uur8"
loggedIn = True if auth.is_logged_in() else False
return dict(win32=win32, win64=win64, amd64=amd64, version=__version__, loggedIn=loggedIn)
