first post updated with latest version. Il giorno venerdì 1 febbraio 2013 21:21:28 UTC+1, Massimo Di Pierro ha scritto: > > Can you post a link to the latest? > > On Thursday, 31 January 2013 08:31:53 UTC-6, Paolo Caruccio wrote: >> >> first post updated: replaced following files >> >> db_diagram.html >> corrected CDN links. Now the diagram works on https too >> >> db_diagram.py [please note that you must copy the code within this file >> and paste at the bottom of web2py_app/controllers/appadmin.py] >> deleted a print statement >> >> >> >> Il giorno mercoledì 30 gennaio 2013 17:23:21 UTC+1, Paolo Caruccio ha >> scritto: >>> >>> I was not able to succesfully install pygraphviz on my windows7 64bit >>> enviroment but I liked Jose's idea >>> https://groups.google.com/d/topic/web2py/cFqD1M6rkc8/discussion, so I >>> wrote a simple addendum to appadmin in order to show a graph representation >>> of a database. >>> It's not alternative to or a replacement of Jose's graph layout because >>> there are substantial differences. >>> "db diagram" is interactive (nodes are draggable and clickable) but you >>> cannot save it as an image (anyway it's possible to use a third party >>> application for screenshoots). >>> Moreover it is customizable via css (you will find here attached a css >>> theme for reference) and it's based on jqueryUI framewok. >>> The nodes contain only the table name, so we can draw the layout of a >>> database with (moderately) numerous tables. >>> In order to see table data you have to click on the node. I added some >>> infos like indexed columns (currently available only for sqlite but I think >>> it's not hard to implement for other database engines), the list of other >>> affected tables when we delete a row in cascade mode. >>> The layout (the position of nodes on the screen) is generated trough a >>> force-directed spring algorythm. Therefore the layout is generated >>> dinamically and it will be different each time you refresh the page. >>> For this scope, I adapted and translated to jQuery the original >>> prototype source code freely distributed under the terms of a MIT-style >>> license from >>> http://snipplr.com/view/1950/graph-javascript-framework-version-001/ >>> For a jquery version of this original source code you could visit >>> http://www.graphdracula.net/ >>> The edges are drawn by jsPlumb library ( >>> http://www.jsplumb.org/jquery/demo.html ). All 1.x.x versions of >>> jsPlumb are dual-licensed under both MIT and GPL version 2. >>> Current main limitation: the database must have 'db' key in application >>> databases dictionary. In other words in our model we must have >>> db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) >>> and not, for example, >>> mydb = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) >>> The screen dimensions are important too: the layout will be messed on >>> small screens. >>> The code has been tested on latest versions of Firefox, Chrome, Opera, >>> IE(7,8,9) and on a very limited number of databases. So please check for >>> errors and bugs. >>> >>> Installation: >>> 1) append the code within in the attached db_diagram.py in >>> your_application/controllers/appadmin.py file >>> 2) put attached db_diagram.html in to your_application/views folder >>> 3) create a new folder in your_application/static folder and name it >>> "db_diagram" >>> 4) in to latter put db_diagram.css, db_diagram_print.css, >>> jquery.dbdiagram.js, pencildiagonals.png (an image create by me only for >>> the css theme in bundle) (all these files are here attached) >>> 5) download jsPlumb (jQuery release) from >>> http://code.google.com/p/jsplumb/downloads/list and put >>> jquery.jsPlumb-1.3.16-all-min.js file in your_application/static/db_diagram >>> folder >>> >>> Usage: >>> In your appadmin page you should see a new menu item "diagram" (see >>> image 1), click on it and you should see the layout of your "db". >>> >>> That's all Folks! >>> >>
-- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
