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 from http://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 -~----------~----~----~----~------~----~------~--~---
