{{extend 'layout.html'}}
<script><!--
$(document).ready(function(){
  $("table.sortable tbody tr").mouseover( function() {
     $(this).addClass("highlight"); }).mouseout( function() { 
     $(this).removeClass("highlight"); });
  $('table.sortable tbody tr:odd').addClass('odd');
  $('table.sortable tbody tr:even').addClass('even');

});
//--></script>

{{if request.function=='index':}}
  <h1>Available databases and tables</h1>
  {{if not databases:}}No databases in this application{{pass}}
  {{for db in sorted(databases):}}
    {{for table in databases[db].tables:}}
      <h2>{{=A("%s.%s"%(db,table),_href=URL(r=request,f='select',args=[db],vars=dict(query='%s.%s.id>0'%(db,table))))}}</h2>
      [ {{=A('insert new '+table,_href=URL(r=request,f='insert',args=[db,table]))}} ]
    <br /><br />
    {{pass}}
  {{pass}}


{{elif request.function=='select':}}
  <h1>database {{=A(request.args[0],_href=URL(r=request,f='index'))}} select
  </h1>
   {{if table:}}
  [ {{=A('insert new %s'%table,_href=URL(r=request,f='insert',args=[request.args[0],table]))}} ]<br/><br/>
    <h2>Rows in table</h2><br/>
   {{else:}}
    <h2>Rows selected</h2><br/>
   {{pass}}
   {{=form}}
   <p>The "query" is a condition like "db.table1.field1=='value'". Something like "db.table1.field1==db.table2.field2" results in a SQL JOIN.<br/>
      Use (...)&amp;(...) for AND, (...)|(...) for OR, and ~(...)  for NOT to build more complex queries.<br/>
      "update" is an optional expression like "field1='newvalue'". You cannot update or delete the results of a JOIN</p>
    <br/><br/>
    <h3>{{=nrows}} selected</h3>
    {{if start>0:}}[ {{=A('previous 100 rows',_href=URL(r=request,f='select',args=request.args[:1],vars=dict(start=start-100)))}} ]{{pass}}
    {{if stop<nrows:}}[ {{=A('next 100 rows',_href=URL(r=request,f='select',args=request.args[:1],vars=dict(start=start+100)))}} ]{{pass}}    
    {{if rows:}}
       <div style="overflow: auto;" width="80%">
       {{linkto=URL(r=request,f='update',args=request.args[:1])}}
       {{upload=URL(r=request,f='download',args=request.args[:1])}}    
       {{=SQLTABLE(rows,linkto,upload,orderby=True,_class='sortable')}}
       </div>
    {{pass}}
    <br/><br/><h2>Import/Export</h2><br/>
    [ <a href="{{=URL(r=request,f='csv',vars=dict(query=query))}}">export as csv file</a> ]
  {{if table:}}
    {{=FORM('or import from csv file ',INPUT(_type='file',_name='csvfile'),INPUT(_type='hidden',_value=table,_name='table'),INPUT(_type='submit',_value='import'))}}
  {{pass}}

{{elif request.function=='insert':}}  
  <h1>database {{=A(request.args[0],_href=URL(r=request,f='index'))}}
    table {{=A(request.args[1],_href=URL(r=request,f='select',args=request.args[:1],vars=dict(query='%s.%s.id>0'%tuple(request.args[:2]))))}}
  </h1>
  <h2>New Record</h2><br/>
  {{=form}}



{{elif request.function=='update':}}
  <h1>database {{=A(request.args[0],_href=URL(r=request,f='index'))}}
    table {{=A(request.args[1],_href=URL(r=request,f='select',args=request.args[:1],vars=dict(query='%s.%s.id>0'%tuple(request.args[:2]))))}}
    record id {{=A(request.args[2],_href=URL(r=request,f='update',args=request.args[:3]))}}
  </h1>
  <h2>Edit current record</h2><br/><br/>{{=form}}



{{elif request.function=='state':}}
  <h1>Internal State</h1>
  <h2>Current request</h2>
  {{=BEAUTIFY(request)}}
  <br/><h2>Current response</h2>
  {{=BEAUTIFY(response)}}
  <br/><h2>Current session</h2>
  {{=BEAUTIFY(session)}}
{{pass}}