Re: [web2py] Re: Moving away from define_table

[Johann Spies]

On 10 May 2012 22:10, Anthony  wrote:

> You can turn off migrations globally for the entire db connection via DAL(...,
> migrate_enabled=False).
>
> Anthony
>
> p.s., Even people with a programming background find the DAL useful. :-)
>

I agree.  It is useful, but also limiting: e.g.  To work with
SQLFORM.grid/smartgrid/plugin_wiki's jqgrid you depend on DAL.

I very often find that for complex queries I spend a lot of time
experimenting to get the DAL version producing the same results as the raw
SQL and there are cases where you just cannot do in DAL what can be done in
SQL. In such case the use of tools like grid/smartgid is not possible in
this stage.

Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

[web2py] Re: Moving away from define_table

[Anthony]

You can turn off migrations globally for the entire db connection via DAL(..., 
migrate_enabled=False).

Anthony

p.s., Even people with a programming background find the DAL useful. :-)

On Thursday, May 10, 2012 4:01:18 PM UTC-4, simon wrote:
>
> Can't you just set migrate=false?
>
> On Thursday, 10 May 2012 20:55:14 UTC+1, Christopher Baron wrote:
>>
>> Hi,
>>
>> I've been using web2py for a few years now.  What I find most annoying is 
>> the DAL.  I understand that its easy for people who don't have a 
>> programming background, but anytime I want to make changes to columns - I 
>> run into issues large and small.  I'd simply prefer to manage my database 
>> without having web2py altering things.  Please advise.
>>
>

Re: [web2py] Re: Moving away from define_table

[Richard Vézina]

db=DAL('postgres://USER:PWD@127.0.0.1:5432/database', \
*migrate_enabled=False*)

Or as simon wrote :

db.define_table(...,migrate=False)

Richard

On Thu, May 10, 2012 at 4:01 PM, simon  wrote:

> Can't you just set migrate=false?
>
>
> On Thursday, 10 May 2012 20:55:14 UTC+1, Christopher Baron wrote:
>>
>> Hi,
>>
>> I've been using web2py for a few years now.  What I find most annoying is
>> the DAL.  I understand that its easy for people who don't have a
>> programming background, but anytime I want to make changes to columns - I
>> run into issues large and small.  I'd simply prefer to manage my database
>> without having web2py altering things.  Please advise.
>>
>

[web2py] Re: Moving away from define_table

[simon]

Can't you just set migrate=false?

On Thursday, 10 May 2012 20:55:14 UTC+1, Christopher Baron wrote:
>
> Hi,
>
> I've been using web2py for a few years now.  What I find most annoying is 
> the DAL.  I understand that its easy for people who don't have a 
> programming background, but anytime I want to make changes to columns - I 
> run into issues large and small.  I'd simply prefer to manage my database 
> without having web2py altering things.  Please advise.
>