--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/createerm.py	Thu Sep 27 17:15:46 2012 +0200
@@ -0,0 +1,71 @@
+# Copyright (c) 2012 netzguerilla.net <iro@netzguerilla.net>
+# 
+# This file is part of Iro.
+# 
+# Permission is hereby granted, free of charge, to any person obtaining a copy of
+# this software and associated documentation files (the "Software"), to deal in
+# the Software without restriction, including without limitation the rights to use,
+# copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the
+# #Software, and to permit persons to whom the Software is furnished to do so,
+# subject to the following conditions:
+# 
+# The above copyright notice and this permission notice shall be included in
+# all copies or substantial portions of the Software.
+# 
+# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED,
+# INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A
+# PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
+# HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
+# OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE
+# SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+
+from iro.model import schema
+
+tables = schema.Base.metadata.sorted_tables
+
+tables_cls={}
+for i in dir(schema):
+    if i.startswith("__") or i == "Base":
+        continue
+    try:
+        a = getattr(schema,i)
+        tables_cls[a.__tablename__] = a
+    except AttributeError:
+        pass
+
+
+#schema plot
+def createSchemaPlot(fname):
+    from sqlalchemy_schemadisplay3 import create_schema_graph
+    graph = create_schema_graph(metadata=schema.Base.metadata,
+        show_datatypes=True, # The image too large if datatypes shown
+        show_indexes=True, # ditto for indexes
+        rankdir='LR', # From left to right (instead of top to bottom)
+        concentrate=True, # Don't try to join the relation lines together
+    )
+
+    graph.set_size('6.5,10')
+    #graph.set_ratio("fill")
+    graph.write_svg(fname)
+
+#umlplot
+def createUMLPlot(fname):
+    from sqlalchemy_schemadisplay3 import create_uml_graph
+    from sqlalchemy.orm import class_mapper
+    mappers = []
+    for attr in dir(schema.model):
+        if attr[0] == '_': continue
+        try:
+            cls = getattr(schema.model, attr)
+            mappers.append(class_mapper(cls))
+        except:
+            pass
+    #pass them to the function and set some formatting options
+    graph = create_uml_graph(mappers,
+        show_operations=False, # not necessary in this case
+        show_multiplicity_one=True, # some people like to see the ones
+        show_attributes=True,
+    )
+    graph.set_size('6,5')
+    graph.set_ratio("fill")
+    graph.write_png('test.png')