def index():
    return dict()
def list():
    highways = db().select(db.highways.ALL, orderby=db.highways.lognum)
    return dict(highways = highways)
def show():
    # Retrieve the requested log entry from the database
    #hwy = db.highways(request.args(0, cast=int)) or redirect(URL('index'))
    hwy = db(db.highways.lognum == request.args(0)).select().first()
    return dict(hwy=hwy)
def search():
    #if request.vars.log_number:
    #    session.log_number = request.vars.log_number
    #   redirect(URL('results'))
    #return dict()
    form = FORM(INPUT(_name='log_number', requires=IS_NOT_EMPTY()),
                INPUT(_type='submit'))
    if form.process().accepted:
        session.log_number = form.vars.log_number
        redirect(URL('results'))
    return dict(form=form)
def results():
    hwy = db(db.highways.lognum == session.log_number).select().first()
    #hwy = session.log_number
    return dict(hwy=hwy)
def submit():
    # Don't name this function 'request' because it creates a name conflict with http.request
    form = SQLFORM(db.highways)
    if form.process().accepted:
        response.flash = 'your submission is accepted'
        redirect(URL('list'))
    return dict(form=form)