If you host this I will redirect to your copy. Or do you want me to host it?
What is the license? Massimo On Sep 14, 1:56 pm, Boris Manojlovic <[email protected]> wrote: > Hello community, > > after few months I'm happy to announce that new version of SQL WWW > Developer is possible to integrate into web2py without need to patch web2py > nor www sql designer code. > Attached files in web2py-backend.tar.gz should replace default files in > wwwsqldesigner-2.3.3.zip<http://wwwsqldesigner.googlecode.com/files/wwwsqldesigner-2.3.3.zip> > in folder <unpacked_wwwsqldesigner>/db/web2py. > Process of integration into web2py is following: > > 1. Download web2py <http://web2py.com/examples/static/web2py_src.zip> and > unpack (doh) > 2. create application named designer for example (no hard-coding of names > needed anymore) > 3. change dir to <application_name>/static/ > 4. Download and unpack wwwsqldesigner-2.3.3.zip and rename folder to > designer ( that is needed if you don't want to change default.py code) > 5. cd designer/db/web2py and unpack web2py-backend.tar.gz file from this > email. > 6. cd designer/js/ and edit it so it looks like this snipper bellow > --------------------------------------------------------------------------------------------------------- > var CONFIG = { > AVAILABLE_DBS:["mysql","sqlite","web2py","mssql","postgresql"], > DEFAULT_DB:"*web2py*", > > AVAILABLE_LOCALES:["en","fr","de","cs","pl","pt_BR","es", "ru","eo"], > DEFAULT_LOCALE:"en", > > AVAILABLE_BACKENDS:["php-mysql","php-blank","php-file","php-sqlite","* > web2py*"], > DEFAULT_BACKEND:["*web2py*"], > > RELATION_THICKNESS:2, > RELATION_SPACING:15, > > STATIC_PATH: "", > XHR_PATH: "*../../default/*"} > > --------------------------------------------------------------------------------------------------------- > > 7. edit ( from web gui or from console ) *models/db.py* and add table > definition: > --------------------------------------------------------------------------------------------------------- > db.define_table("tbldata", > Field("tblname", "string", default="tabela"), > Field("changed", "datetime", default=request.now), > Field("xmldata", "blob")) > --------------------------------------------------------------------------------------------------------- > 8. replace *controllers/default.py* with code attached ( default.py) - > adding backend for web2py and redirection to static/designer/index.html > 9a. Go to http://<YOUR_IP>/<appname>/ and enjoy creating tables visually > 9b. Buy beer or some cocktail to me when in Belgrade, Serbia :) (and to > Ondrej as he created this great tool) > > FIXES: > data types fixes (removal of timestamp), > many XSL fixes; > - relations are working now as they should - no need to remove > anything from "relations" line if you are lazy it should just work :), > - tables without relation will be first on list of created tables as > needed by web2py - when this is not a case web2py will error out. > - password fields will not be mapped to select box by design!! > - some defaults are mapped correctly - still watch out for single > quotes! > > Boris Manojlovic > > -- > "Only two things are infinite, the universe and human stupidity, and I'm not > sure about the former."-Albert Einstein > > web2py-backend.tar.gz > 3KViewDownload > > default.py > 4KViewDownload --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
