I'm currently trying to implement this. Have followed above instructions and it functions nearly completely. I cannot yet get save/ load to server's database.
Anyone have a handle on this? Danny On Dec 16 2008, 10:42 am, "Yarko Tymciurak" <yark...@gmail.com> wrote: > Sorry... > I may have spoken too soon.... I thought this was working, but still some > things to work out.... (not saving xml to database at the moment) > > 2008/12/16 yarko <yark...@gmail.com> > > > > > I wanted to post an update: > > > I took Boris's adaptation of sqldesigner for web2py, and modified it > > (very slightly) to work as a named app in web2py. > > > The good news: > > > - it seems to work just fine (no routes at all used); > > - to accommodate"name it to whatever you want" I changed ONE line of > > code; > > - I dropped in the latest sqldesigner (to check if this would work as > > needed, w/o any other changes - and yes, it does); > > - I tested saving and restoring work in the "app" database (Boris is > > saving the xml from sessions, so the save/restore is fine); > > - it (continues to) work with latest web2py; > > > The "bad" news (well, this isn't really bad - but does suggest > > something we may need to do w/ web2py): > > - from the static directory, sqldesigner (itself) has a link to it's > > subdirectory for "docs" code; it fails (you have to manually add > > "index.html" to the generated URL); for STATIC references, web2py > > should probably handle doing "what normally happens" (or is this a > > server backend function? anyway, cherrypy doesn't...) > > - the generated DAL is pretty much one-way (at this point): copy / > > paste, and use it once you're done. (This is not really bad news I > > don't think; it's probably not worth the effort to go further); > > > I can post, or you can do what I did: > > > - take Boris's zip, rename applications/init to (for example) > > applications/sqldesigner; zip this up, or copy to your current web2py > > (routes.py not needed); > > - get the latest sqldesigner fromhttp://code.google.com/p/wwwsqldesigner/ > > and drop it in your new app as static/designer > > > Unfortunately, sqldesigner still has not included the changes needed, > > so you need to also update static/designer/js/config.js with Boris's > > change (http://designer.bojanka.net/js/config.js); > > > Alternatively, simply add "web2py-db" to AVAILABLE_BACKENDS and make > > it the DEFAULT_BACKEND string. > > > - in controllers/default.py make the following change: > > > <<< old > > def index(): > > redirect('designer.html') > > > >>> new > > def index(): > > redirect(URL(r=request,c='static',f='designer/index.html')) > > > That's it! > > > Let me know if you find a way to let sqldesigner's "documentation" > > link work. > > > Yarko > > > On Dec 1, 3:25 pm, "Boris Manojlovic" <boris.manojlo...@gmail.com> > > wrote: > > > Hi, > > > as i said it was just a prof of concept :) and i tried to make it > > forward > > > compatible as much as possible. > > > What that means is I did not changed "www sql developer" code (except > > > configuration) on purpose so that files from *applications/init/static/** > > > designer* > > > can be replaced with new version without problems - until Ondřej Žára > > change > > > API code which I hope will not be done hehe :) > > > (Just tried to put newest version of sql developer into my code and it > > > worked on first look) > > > > Boris > > > > P.S. on designer.bojanka.net is still old version of sql developer watch > > out > > > :) > > > > (look here for confighttp://designer.bojanka.net/js/config.js) > > > > On Mon, Dec 1, 2008 at 10:04 PM, mdipierro <mdipie...@cs.depaul.edu> > > wrote: > > > > > perhaps you and jwm can join forces. You have the same interests. > > > > > I am not planning to host this myself since you are doing it, but it > > > > could be used and distributed with T3. > > > > > Massimo > > > > > On Dec 1, 2:57 pm, "Boris Manojlovic" <boris.manojlo...@gmail.com> > > > > wrote: > > > > > it was created as proof of concept, i planed to add more > > functionality > > > > (as > > > > > you can see from database schema) > > > > > >http://www.bojanka.net/w2p-massimo.tar.gz > > > > > > it is opensource as all package is opensource, why to close back end > > :) > > > > > > On Mon, Dec 1, 2008 at 9:53 PM, mdipierro <mdipie...@cs.depaul.edu> > > > > wrote: > > > > > > > Boris, > > > > > > > is it functional? Can I uninstall the old one and link yours? If it > > is > > > > > > open source, is the source posted somewhere? > > > > > > > perhaps the two of you should join forces. > > > > > > > Massimo > > > > > > > On Dec 1, 2:43 pm, jwm <team1...@gmail.com> wrote: > > > > > > > Boris, > > > > > > > Looks like you had the thought before I did, Good Job! > > > > > > > > J > > > > > > > > On Dec 1, 2:39 pm, "Boris Manojlovic" < > > boris.manojlo...@gmail.com> > > > > > > > wrote: > > > > > > > > >http://designer.bojanka.net/ > > > > > > > > and yes it is already on GAE... > > > > > > > > > On Mon, Dec 1, 2008 at 9:30 PM, jwm <team1...@gmail.com> > > wrote: > > > > > > > > > > On a related note I Am in the process of porting SQL Designer > > to > > > > a > > > > > > > > > web2py app on google appengine. > > > > > > > > > >http://gaesql.appspot.com > > > > > > > > > > Right now I have streamlined the export process and am using > > it > > > > as a > > > > > > > > > tool to learn web2py better, I have a basic save backend in > > > > process > > > > > > on > > > > > > > > > my laptop. > > > > > > > > > I'll look into writing a Import function from web2py model to > > the > > > > XML > > > > > > > > > the app uses it uses internally. > > > > > > > > > > Let me know if you guys have any other suggestions, Google > > has > > > > > > > > > featured it onhttp://appgallery.appspot.comandI'mhavingfun > > > > > > > > > learning web2py and welcome some new ideas. > > > > > > > > > > Jason W. Miller > > > > > > > > > > On Dec 1, 1:34 pm, mdipierro <mdipie...@cs.depaul.edu> > > wrote: > > > > > > > > > > No, sorry. > > > > > > > > > > > On Dec 1, 1:25 pm, "Mario Lim" <mlim1...@gmail.com> wrote: > > > > > > > > > > > > Hi all, > > > > > > > > > > > This is my first post... I was playing with the SQL > > > > > > Designer page > > > > > > > > > and > > > > > > > > > > > couldn't click on the "Setting" button to check how to > > > > import. > > > > > > Wanted > > > > > > > > > to > > > > > > > > > > > know if the import functionality is working in cases I > > need > > > > to > > > > > > change > > > > > > > > > the > > > > > > > > > > > schema? > > > > > > > > > -- > > > > > > > > "Only two things are infinite, the universe and human > > stupidity, > > > > and > > > > > > I'm not > > > > > > > > sure about the former."-Albert Einstein > > > > > > -- > > > > > "Only two things are infinite, the universe and human stupidity, and > > I'm > > > > not > > > > > sure about the former."-Albert Einstein > > > > -- > > > "Only two things are infinite, the universe and human stupidity, and I'm > > not > > > sure about the former."-Albert Einstein --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
