Ok thank's.
Il giorno martedì 13 ottobre 2015 21:18:33 UTC+2, Niphlod ha scritto:
>
> a legacy db just needs migrate=False. Nothing else. Just as a production
> db where migrations aren't needed in THAT single request.
>
> tl;dr: The default for every NON "development-mylaptop-etc" environment
> should be migrate=False. Let me reinstate once again: migrate=True is a
> TOTAL WASTE of cpu when models aren't requiring any migration
>
> back to you issue: if you're comfortable with executing queries by hand in
> the database, a DAL line is all you need. If you want to leverage fancy
> syntax over an Abstraction (where the A in DAL comes from), you kinda
> need to define the Abstraction. Which, boiled down, means defining table
> models you want to interact with.
>
>
>
> On Tuesday, October 13, 2015 at 4:16:37 PM UTC+2, Gael Princivalle wrote:
>>
>> Hello all.
>>
>> In a web2py application I would like to insert/update user records in 2
>> db.
>> The first one is the application db, a postgres db:
>> db = DAL('postgres://user:pass@localhost:5432/my_web2py_app_db',
>> check_reserved=['all'], pool_size=1, entity_quoting=True, bigint_id=True,
>> migrate=True)
>>
>>
>> The second one is used by a mailing program called php list. It's a mysql
>> db.
>> db_php_list = DAL('mysql://user:pass@localhost:3306/my_php_list_db',
>> fake_migrate_all=False, migrate=True)
>>
>> I don't see any db_php_list table in database administration.
>>
>> Mysql port is 3306?
>> For an existing db, I've to add 'fake_migrate_all=False, migrate=True',
>> right?
>>
>> Admitting that I can connect to the mysql db, how can I handle the user
>> insert/updates to both db?
>>
>> Thanks, regards.
>>
>>
>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
