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:
> 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 tohttp://sqldesigner.example.comand
> 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
>
> web2py-designer-patches.zip
> 5KViewDownload
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
