Re: SQL Designer Import

[D Harriman Morgan]

Update:

The short of it is that I can only get sqldesigner to save/load server-side when I set it up using Boris Manojlovic's (attached) script file for installing web2py with sqldesigner included as application 'init'. The  file (web2py-designer-patches.zip) includes three files: 'README', which is actually a script file that downloads and installs both web2py and wwwsqldesigner; '01-routes.patch' which creates a routes.py file, and '02-init.patch', which modifies three files within the new 'init' application.

Installation using the script file requires that you be ready to browse to the new application during the process, as the script must wait for you to create an 'init' application via the web2py admin view. In this example, I have subdomain sqldesigner.example.com for http and https.

[ in first terminal]
    copy the README, 01-routes.patch, and 02-init.patch files to directory
from which you'll serve this web2py instance, mine is
'~/webapps/sqldesigner'

    make README executable and run it
        chmod 764 README
        ./README

    script will prompt you to open another terminal to create an 'init' app.

[ in second terminal}
    cd ~/webapps/sqldesigner/web2py
    # NNNN = port number
    python web2py.py -p NNNN
        password of your choice

[open browser to admin for this site]

    create new application, 'init'

    at this point the README installation script resumes, which you'll see
in the first terminal

[ in first terminal]

    script should end by telling you it patched four files and that it
should just work

    while you're there, kill the web2py you started in the second
terminal, according to the instructions provided at startup, 'kill -SIGTERM ##### ' for example

    it may just work; in my case, however (installed as webfaction custom
app) I had to move the contents of sqldesigner/web2py down one level

        try this if it doesn't "just work":
            mv ~/webapps/sqldesigner/web2py/* ~/webapps/sqldesigner/ rmdir ~/webapps/sqldesigner/web2py

    restart web2py
        screen python web2py.py -p NNNN -password='<recycle>'

[ in second terminal}
    screen -d


And you're there. Point your browser to http://sqldesigner.example.com and you have your own facility for visually modeling data in a format that's readily exportable to web2py. As you would hope, the sqldesigner data can be administered via admin over https.

My immediate impression with using SQL-Designer is quite positive. Having a visual representation and being able to save/retrieve/edit the models is allowing me to work far more productively. It has room for improvement (see below), which makes me wonder about doing it all fresh in Pyjamas....

Rooms for improvement: ordering of output by depedency (order is currently chronological(?) which causes errors in web2py model compilation), cannot do things like copy/paste tables or fields, cannot select multiple tables for repositioning/deleting, documentation button opens wwwsqldesigner twice, etc.


Danny

[dhmorgan]

Note: this thread continues from thread of same name:
http://groups.google.com/group/web2py/browse_thread/thread/30eb9ee195b358cb/20f3cf32cfbc876e#20f3cf32cfbc876e

Additionally, I have now posted a how-to on webfaction for setting it
up there:
http://forum.webfaction.com/viewtopic.php?pid=8718#p8718

On Feb 9, 8:57 am, D Harriman Morgan <dharrimanmor...@gmail.com>
wrote:

>  web2py-designer-patches.zip
> 5KViewDownload

[mdipierro]

excellent

On Feb 9, 9:17 am, dhmorgan <dharrimanmor...@gmail.com> wrote:
> Note: this thread continues from thread of same name:

> http://groups.google.com/group/web2py/browse_thread/thread/30eb9ee195...