[web2py] Re: Using external database join with DAL

[Gallien Labeyrie]

Thanks for answering my question ! :)

-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Using external database join with DAL

[Gallien Labeyrie]

Hi, 

I'm connecting to multiple MySQL databases through Web2Py. So far 
everything works fine! 
But for some dumb reasons, my databases do not follow usual good design 
practices. 
For example some of  the tables foreign keys refer to other database 
primary keys (which is surprisingly possible (!) because MySql seem to 
understand  a database more like a 'schema' )

So I'm wondering, Is it possible to use the DAL functions to query them and 
make JOIN even though they are referring another database?
or will I still have to stick to the old school *db.executesql()* ?

thanks for the help, 
Gallien

-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [web2py] Begginer questions about web2py

[Gallien Labeyrie]

Hello, 

Thanks for your answers and links,everything is fine now, I connect to my 
database  and i'm able to debugg the app :)

-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Begginer questions about web2py

[Gallien Labeyrie]

Hello, 

Coming from a PHP background, I've recently discovered Web2Py framework and 
I am amazed Its embed functionalities.
However I'm wondering If someone among the community could enlighten me :

- What's the easiest way to debbug in web2py ? (= what would be the 
equivalent to dump variable content such as print_r() in php ?)
I tried PDB but I don't find It really convinient...
- How to connect an external MySQL database ?
According to the official docs I tried the script given*
 extract_mysql_models.py *
but It only gives me a one line script like with the string connection. (It 
doesn't generate the model ?)

legacy_db = DAL('mysql://password@somewebsite/dbname')

I put that line in a model file, but It doesn't seems to work. Plus I still 
have to declare all the tables manually which is a bit boring ...

- Except the official website, are there any other useful resources online ?

Thanks for the help, 

Gallien LABEYRIE

-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.