Hi all, I'm using Web2py to serve a wxPython thick client via XMLRPC. I'm currently using SQLite (I like the zero db config ;-) and I have a few questions:
1) I have missed how to specify table constraints across several fields (in SQLite). For example, in a table the primary key consists of two fields - how do I specify that these two fields must comprise a UNIQUE value? In other dbs I could use executesql to just give the SQL commands, but SQLite (unless I'm mistaken) only allows table constraints within the CREATE TABLE SQL command. So can this be done in Web2py? 2) I'm confused as to which models get run when a controller is accessed. If I have db.py and uom.py models and I access the uom controller, what happens? From stepping thru the debugger I saw db.py get run first, then uom.py and then uom.py again (weird). I've simplified things down to just one (db.py) file for now, but I'm wondering if the infrastructure's intent is to run all model files upon each and every controller access. Oh, my access of the controller is via XMLRPC function (if that changes anything). Thx in advance, Rb. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
