misc/cmp_schema.py
author Sylvain Thénault <sylvain.thenault@logilab.fr>
Fri, 01 Apr 2011 15:04:47 +0200
changeset 7166 dde161937d3e
parent 5372 b74eed7e8b37
permissions -rw-r--r--
[time zone] support for TZDatetime and TZTime data type Should be usable and cause no crash, though some stuff may still be refined (test value generation, display in views/forms...) Proprify some data structures dealing with yams base types along the way and adding warning when some were missing (eg Interval usually).

"""This module compare the Schema on the file system to the one in the database"""

from cStringIO import StringIO
from cubicweb.web.schemaviewer import SchemaViewer
from logilab.common.ureports import TextWriter
import difflib

viewer = SchemaViewer()
layout_db = viewer.visit_schema(schema, display_relations=True)
layout_fs = viewer.visit_schema(fsschema, display_relations=True)
writer = TextWriter()
stream_db = StringIO()
stream_fs = StringIO()
writer.format(layout_db, stream=stream_db)
writer.format(layout_fs, stream=stream_fs)

stream_db.seek(0)
stream_fs.seek(0)
db = stream_db.getvalue().splitlines()
fs = stream_fs.getvalue().splitlines()
open('db_schema.txt', 'w').write(stream_db.getvalue())
open('fs_schema.txt', 'w').write(stream_fs.getvalue())
#for diff in difflib.ndiff(fs, db):
#    print diff