[web2py:13398] Joins in DAL

2008-12-11 Thread michal niklas
How can I do in DAL query such as: select persons.person, a.name, b.name from votes join persons on(votes.person=persons.id) join gifts as a on (a.id = gift1) join gifts as b on (b.id = gift2) There are 3 tables: persons (person varchar) gifts (name varchar) votes (person_id, gift1_id, gift2_id

[web2py:13297] Re: Problem with ticket (long)

2008-12-10 Thread michal niklas
On 6 Gru, 22:28, mdipierro <[EMAIL PROTECTED]> wrote: > I got it but I do not have postgresql here with me. Will check next > week. I have found why it not worked: Files in databases dir that store serialized tables definition are created using hash of connection string. Unfortunately ours connec

[web2py:13025] Re: Problem with ticket (long)

2008-12-06 Thread michal niklas
On Dec 6, 1:32 am, mdipierro <[EMAIL PROTECTED]> wrote: > I am still unsure on what specifically caused the problem but I see > one issure right away. In your model you have migrate=True (which > means web2py should create the tables) but you your pg_dump you have > "CREATE TABLE" statements. This

[web2py:12957] Re: Problem with ticket (long)

2008-12-05 Thread michal niklas
On 5 Gru, 23:56, mdipierro <[EMAIL PROTECTED]> wrote: > Whatever you have this should not happening. RestrictedError is an > internal web2py error that means an error has been caught. Web2py > should catch RestrictedError and display the traceback therein. > > Would you, confidentially, send me yo

[web2py:12953] Problem with ticket (long)

2008-12-05 Thread michal niklas
Hello, While trying web2py I imported app done by other developer. We use PostgreSQL so I pg_dumped whole database and imported it on my machine, then I zipped whole app directory (web2py\applications\Archiwum) and restored it on my machine. I restarted web2py. Now from admin interface I can edit

[web2py:12852] Error in FAQ

2008-12-02 Thread michal niklas
Hello, I think that there is error in FAQ 'Form navigation': http://mdp.cti.depaul.edu/AlterEgo/default/show/33 There is: if form.accepts(session.vars,session): I thought that first arg for form.accepts() is request.vars. Am I right? Should this be changed to: if form.accepts(request.vars

[web2py:11035] Validators in db schema mapping to db model

2008-11-03 Thread michal niklas
Hello, I started writing tool to create model from existing PostgreSQL database. At first I created cookbook db via web2py and now I translate it back from PostgreSQL schema to web2py model. I have mapped tables and columns and even foreign keys if they point to 'id' column of other table. But a

[web2py:10921] Re: Import db model from existing database

2008-11-01 Thread michal niklas
On 31 Paź, 22:57, yarko <[EMAIL PROTECTED]> wrote: > Looking forward to your tool(s)... > > Perhaps we could include them in web2py admin ? OK. As soon as I create them (PostgreSQL first) they will be available. Regards, Michal --~--~-~--~~~---~--~~ You received

[web2py:10905] Re: Import db model from existing database

2008-10-31 Thread michal niklas
tml It will warn if there is no 'id' column in table. Regards, Michal Niklas --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web

[web2py:10861] Error in 'admin' application

2008-10-30 Thread michal niklas
If you click on 'cleanup' in 'admin' app then internal error occurs. Meybe there is problem with deleting session which is currently in use. My browser shows 'ticked issued' but there is no ticket in errors dir. If I click on the ticket link it shows another ticket and after another click I can vi

[web2py:10853] Import db model from existing database

2008-10-30 Thread michal niklas
from my old apps. Are there any tools to create db.py model from existing PostgreSQL database? Regards, Michal Niklas --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to