smartgrid: currency format and text-align

controllers/default.py
def admin():
    products = SQLFORM.grid(db.Product,deletable=False, paginate=10)
    return dict(products = products)

models/db.py
db.define_table('Product',
    Field('Part_Number'),
    Field('List_Price', 'decimal(13,2)'))

views/default.py

{{extend 'layout.html'}}
<h2>Product Table</h2>
{{=products}}

By default, all text is aligned to left. You can align it right for decimal fields by adding the following in db.py:

db.Product.List_Price.represent = lambda value, row: XML(DIV(value,_style='text-align: right;')) 

or currency format:

db.Product.List_Price.represent = lambda value, row: '$ %.2f' % (0.0 if value == None else value)

or both:

db.Product.List_Price.represent = lambda value, row: DIV('$ %.2f' % (0.0
if value == None else value), _style='text-align: right;')

Ref: https://groups.google.com/group/web2py/browse_thread/thread/97a3e861957e758b/21bdc438c387abd3#21bdc438c387abd3

Cascading Drop Down Lists with Ajax

I posted my first slice.
http://www.web2pyslices.com/slices/take_slice/144

Have a slice !

web2py: Input field alignment for decimal and integer

By default, all the fileds are aligned to left.

If you want to align to right such decimal and integer, you can simply add the following to your base.css.

input.decimal, input.integer, input.double { 

    text-align: right; 

} 

Then it will be like this,

You can also use "Tight input widget" developed by Kenji san at S-Cubism.

Tight input widget

http://dev.s-cubism.com/plugin_tight_input_widget

A simple password generator with wxPython

This is a simple password generator.

• Providing First and Last Name, then click Get Password! to generate the password
• Line3, 4: you can change the combination here
• Line20 - line25: Use 4 digits of last name to generat the numbers in password
• Line27 - line28: Get the digits for the given alphabet 
• Line57: Use lambda to pass multiple parameters

1. import wx
3. ALP = "HIJKLMNOPQRSTUVWXYZABCDEFG "
4. NBR = "456789012345678901234567897"
5. KEY = dict(zip(ALP, NBR))
7. def getpass(event, firstname, lastname):
8.     password = ''
9.    
10.     # Input both name are required
11.     if firstname == '' or lastname == '':
12.         passText.SetValue('Input both first and last name !')
13.     else:    
14.         firstname = firstname.upper()
15.         lastname = lastname.upper()
16.        
17.         length = len(lastname)
19.         # Fill in blank for the short last name
20.         if length < 4:
21.             lasttemp = lastname + '   '
22.         else:
23.             lasttemp = lastname
25.         last4 = lasttemp[0:4]
26.      
27.         for i in last4:
28.             password += KEY[i]
30.         passText.SetValue('Password: ' + firstname + password)
32. if __name__ == '__main__':
33.     app = wx.App()
34.     win = wx.Frame(None, title='Password Generator',
35.             size = (300, 200), style=wx.SYSTEM_MENU|wx.CAPTION|wx.CLOSE_BOX)
36.     bkg = wx.Panel(win)
38.     font = wx.Font(11, wx.FONTFAMILY_DEFAULT, wx.FONTSTYLE_NORMAL, wx.FONTWEIGHT_NORMAL)
39.     bkg.SetFont(font)
41.     firstTexts = wx.StaticText(bkg, -1, 'First Name: ', size=(90, 22))
42.     firstTextc = wx.TextCtrl(bkg, -1, size=(200, 22))
43.    
44.     hboxf = wx.BoxSizer()
45.     hboxf.Add(firstTexts, proportion=0, flag=wx.ALL, border=0)
46.     hboxf.Add(firstTextc, proportion=0, flag=wx.ALL, border=0)
47.    
48.     lastTexts = wx.StaticText(bkg, -1, 'Last Name: ', size=(90, 22))
49.     lastTextc = wx.TextCtrl(bkg, -1, size=(200, 22))
50.    
51.     hboxl = wx.BoxSizer()
52.     hboxl.Add(lastTexts, proportion=0, flag=wx.ALL, border=0)
53.     hboxl.Add(lastTextc, proportion=0, flag=wx.ALL, border=0)
54.    
55.     submitButton = wx.Button(bkg, label='Get Password!', size=(290, 22))
56.     submitButton.Bind(wx.EVT_BUTTON,
57.             lambda event: getpass(event, firstTextc.GetValue(), lastTextc.GetValue()))
59.     passText = wx.TextCtrl(bkg, -1, '', style=wx.TE_READONLY|wx.BORDER_NONE, size=(290, 22))
61.     hboxp = wx.BoxSizer()
62.     hboxp.Add(passText, proportion=0, flag=wx.ALL, border=0)
64.     vbox = wx.BoxSizer(wx.VERTICAL)
65.     vbox.Add(hboxf, proportion=0, flag=wx.EXPAND|wx.ALL, border=5)
66.     vbox.Add(hboxl, proportion=0, flag=wx.EXPAND|wx.ALL, border=5)
67.     vbox.Add(submitButton,  proportion=0, flag=wx.ALL, border=5)
68.     vbox.Add(hboxp, proportion=0, flag=wx.EXPAND|wx.ALL, border=5)
70.     bkg.SetSizer(vbox)
71.     win.Show()
73.     app.MainLoop()

How to connect DB2 with Python pyodbc

There are very few infromation about it and this is how I connect to DB2 from python and web2py.

My environment
-----------------------------------------------------------
OS: Windows 7 x86
iSeries Access: V5R3M0 - SI26600
Python: 2.5
pyodbc: pyodbc-2.1.7.win32-py2.5.exe
web2py: 1.98.2 (Source Code)
-----------------------------------------------------------

Pre-Requirements
IBM iSeries Access is installed on your machine so that you have the iSeries Access ODBC Driver.If you use DB2, it's already installed on you machine, isn't it?

1. Install pyodbc
Download and install from http://code.google.com/p/pyodbc/downloads/list.

2. Create ODBC Data Source

2.1 Go to: Control Panel - System and Security - Administrative Tools - Data Sources (ODBC)
2.2 Click Add and select iSeries Access ODBC Driver

2.3 Type Data source name and System (Your AS400 Name)

2.4 On Server tab, type SQL default library

2.5 Click Advanced button at the bottom 

2.6 Change Commit mode: from (*CHG) to (*NONE)

Very important:  If you don't change, you might get the following error.

Error: ('HY000', '[HY000] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - TEST in MYLIB not valid for operation. (-7008)

Ref: https://www-304.ibm.com/support/docview.wss?uid=nas131821151773d0613862569b200550644

3. Connect from web2py

Now you are ready to connect.

3.1 Restart your web2py if it's already started

3.2 Create new app like AS400

3.3 Edit DB.PY as follows.

# -*- coding: utf-8 -*-
db = DAL('db2://DSN=MYDSN;UID=YourID;PWD=YourPassword')
db.define_table('test',
    Field('name'))

3.4 Save and click "database administration"

3.5 Check on AS400

3.6 Now click on "Insert new test" from web2py, input Name and click submit

3.7 Check on AS400 - Oh my got! It works !!!

* You can create separate DSN to connect different libraries

4 Connect from Python Shell

Notice: I'm using "." instead of "/". If you want,  you can change "Naming Conversion" to *SYS on the Server tab in the data source you created.

4.1 SELECT

>>> import pyodbc
>>> conn = pyodbc.connect('DSN=MYDSN;UID=YourID;PWD=YourPassword')
>>> cursor = conn.cursor()
>>> cursor.execute("SELECT * FROM MYLIB.TEST")
<pyodbc.Cursor object at 0x01E6A598>
>>> for row in cursor:
print row

4.2 INSERT

(1, 'Omi Chiba')
>>> cursor.execute("INSERT INTO MYLIB.TEST VALUES(DEFAULT, 'PYTHON ROLL')")
<pyodbc.Cursor object at 0x01E6A598>

4.3 Check on AS400