Another thing: the wizard does not ask for, or create, certain settings 
that are required by the code in models/db.py. so one cannot simply load 
those settings and bind all values below:

if not request.env.web2py_runtime_gae:
    # ---------------------------------------------------------------------
    # if NOT running on Google App Engine use SQLite or other DB
    # ---------------------------------------------------------------------
    db = DAL(myconf.get('db.uri'),
             pool_size=myconf.get('db.pool_size'),
             migrate_enabled=myconf.get('db.migrate'),
             check_reserved=['all'])

(pool_size and migrate) are not configured by the wizard, but they need to 
be set somewhere for auto-created and manually created apps to be congruent.


On Tuesday, July 11, 2017 at 2:41:15 PM UTC-4, Terrence Brannon wrote:
>
> I am using the stable source code version of web2py. I created an 
> application via the wizard and specified a MySQL database URI at that time. 
>
> Now, 2 days later, I went looking for my data and realized it is in 
> storage.sqlite... why? Because the automatically-created models/db.py 
> attempts to connect to the database via AppConfig().get('db.uri')
>
> However models/0.py binds settings.database_uri to another value, which 
> was set during the wizard dialogue.
>
> As a result, all of my data is in a SQLite database (because of the
> default setting of AppConfig().get('db.uri')) instead of being in the
> MySQL database I configured via the wizard dialogue.
>
> Has this been addressed in the bleeding edge versions of web2py?
>

-- 
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.

Reply via email to