Posted By

jcastell on 03/27/11

Tagged

Versions (?)

Last Edited at 03/27/11 09:49am

Statistics

Viewed 497 times

Favorited by 0 user(s)

Related snippets

Ajax database app

/ Published in: Python

A simple Ajax database app built with the Karrigell web framework for Python; PyDbLite, a non-SQL Python database engine; and JQuery in the browser

Highlighted TextExpand

## HTML and JQuery source: ##

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html;charset=ISO-8859-1" />
 <script src="http://code.jquery.com/jquery-1.4.4.js"></script><script type="text/javascript">

$(document).ready(function(){
	
  $('#country').change(function(){
	   $country = ($(this).val());

$.get('mydata.py', { value : $country },
   function(data){
      $('#txtHint').html(data);
   });

});

</script>

</head>
<body>

<form action=""> 
<select name="customer" id="country">
<option value="" id="select">Select a customer by country:</option>

<option value="Argentina" class="list">Argentina</option>
<option value="Canada" class="list">Canada</option>
<option value="France" class="list">France</option>
<option value="Germany" class="list">Germany</option>
<option value="Mexico" class="list">Mexico</option>
<option value="Sweden" class="list">Sweden</option>
</select>
</form>

<div id="txtHint">Customer info will be listed here...</div>

</body>
</html>

## CSS for table: ##

.customers
{
border-collapse:collapse;
border:2px solid #B7AFA3;
width:39%;
border-bottom: 4px solid #6D929B;
border-top: 3px solid #6D929B;
margin-left:10px;
margin-right:auto;
margin-bottom:auto;
font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;

}

td.row_even  th

{
background:#fff;
padding-left:5px;
}

tr.row_odd, td.row_odd 
{
color:#000000;
background-color:#DCF0F7;
}

## Python script: ##

#mydata.py

#Import the PyDbLite and HTMLTags modules

from PyDbLite import Base

from HTMLTags import *

#Store the value of the query string (the value sent via GET from the dropdown menu)

q = QUERY['value']

#Create a database and insert database records.

db = Base('address.pdl')

db.create('Customer ID','Company Name','Address','City','Postal Code','Country','Phone','Fax',mode="override")

db.open()

db.insert('ALFKI','Alfreds Futterkiste','Obere Str. 57','Berlin',12209,'Germany','030-0074321','030-0076545')
db.insert('ANATR','Ana Trujillo Emparedados y helados','Avda. de la Constituci&#243;n 2222','M&#233;xico D.F.',5021,'Mexico','(5) 555-4729','030-0076545')
db.insert('ANTON','Antonio Moreno TaquerÃƒï¿½Ã¯Â¿Â½ÃƒÂ¯Ã‚Â¿Ã‚Â½Ãƒï¿½Ã‚Â¯Ãƒï¿½Ã‚Â¿Ãƒï¿½Ã‚Â½Ãƒï¿½Ã¯Â¿Â½ÃƒÂ¯Ã‚Â¿Ã‚Â½Ãƒï¿½Ã¯Â¿Â½Ãƒï¿½Ã‚Âa','Mataderos 2312','M&#233;xico D.F.',5023,'M&#233;xico','(5) 555-3932','030-0076471')
db.insert('AROUT','Around the Horn','120 Hanover Sq.','London','WA1 1DP','UK','(171) 555-7788','(171) 555-6750')
db.insert('BERGS','Berglunds snabbk&#246;p','Berguvsv&#228;gen 8','Lule&#229;','S-958 22','Sweden','0921-12 34 65','0921-12 34 67')
db.insert('BLAUS','Blauer See Delikatessen','Forsterstr. 57','Mannheim',68306,'Germany','0621-08460','0621-08924')
db.insert('BLONP','Blondesddsl p&#232;re et fils','24, place Kl&#233;ber','Strasbourg',67000,'France','88.60.15.31','88.60.15.32')
db.insert('BONAP','12, rue des Bouchers','Marseille',13008,'France','91.24.45.40','91.24.45.41')
db.insert('BOTTM','Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','T2F 8M4','Canada','(604) 555-4729','(604) 555-3745')
db.insert('BSBEV','B\'s Beverages','Fauntleroy Circus','London','EC2 5NT','UK','(171) 555-1212','(171) 555-1214')
db.insert('CACTU','Cactus Comidas para llevar','Cerrito 333','Buenos Aires',1010,'Argentina','(1) 135-5555','(1) 135-4892')
db.insert('CENTC','Centro comercial Moctezuma','Sierras de Granada 9993','M&#233;xico D.F.',5022,'Mexico','(5) 555-3392','(5) 555-7293')

db.commit()

#Use Karrigell's HTMLTags module to build an HTML table for the data

head = HEAD()

head <= TITLE('Customer Records')
head <= LINK(rel="Stylesheet",href="css/style.css")
body = BODY()
table = TABLE(Class="customers")

#Iterate on the database records; return those where the query string (q) matches the records stored in Country

recs = [ r for r in db if q == r['Country']]

for record in recs:
	for f in db.fields:
			table <= TR(TD(f)+TD(record[f]))

#This tricky-looking bit of code is entirely optional. I took it off of the HTMLTags page of the Karrigell Reference Manual. It, along with the css style sheet for this app, creates the striped effect on the table.

classes = ['row_odd','row_even']
lines = table.get_by_tag('TR')
for i,line in enumerate(lines):
    cells = line.get_by_tag('TD')
    for cell in cells:
        cell.attrs['Class'] = classes[i%2]

#Append the table to the body of the HTML page, and then print the table.
body <= table
print HTML(head+body)

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.