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