Popular recipes tagged "schema"http://code.activestate.com/recipes/tags/schema/2014-02-21T09:18:55-08:00ActiveState Code RecipesValidate XML with schemaLocation (Python)
2013-03-28T10:24:55-07:00Mathias Loeschhttp://code.activestate.com/recipes/users/4185910/http://code.activestate.com/recipes/578503-validate-xml-with-schemalocation/
<p style="color: grey">
Python
recipe 578503
by <a href="/recipes/users/4185910/">Mathias Loesch</a>
(<a href="/recipes/tags/schema/">schema</a>, <a href="/recipes/tags/schemalocation/">schemalocation</a>, <a href="/recipes/tags/validation/">validation</a>, <a href="/recipes/tags/xml/">xml</a>).
Revision 3.
</p>
<p>Addresses problems described at:</p>
<p><a href="http://stackoverflow.com/questions/2979824/in-document-schema-declarations-and-lxml" rel="nofollow">http://stackoverflow.com/questions/2979824/in-document-schema-declarations-and-lxml</a>
<a href="https://mailman-mail5.webfaction.com/pipermail/lxml/2011-September/006153.html" rel="nofollow">https://mailman-mail5.webfaction.com/pipermail/lxml/2011-September/006153.html</a></p>
Dump Oracle db schema to text (Python)
2014-02-21T09:18:55-08:00Michal Niklashttp://code.activestate.com/recipes/users/186902/http://code.activestate.com/recipes/576534-dump-oracle-db-schema-to-text/
<p style="color: grey">
Python
recipe 576534
by <a href="/recipes/users/186902/">Michal Niklas</a>
(<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/oracle/">oracle</a>, <a href="/recipes/tags/schema/">schema</a>).
Revision 19.
</p>
<p>Export Oracle schema to text.
Usable to compare databases that should be the same</p>
<p>Oracle schema info:
<a href="http://www.eveandersson.com/writing/data-model-reverse-engineering" rel="nofollow">http://www.eveandersson.com/writing/data-model-reverse-engineering</a></p>
<p>With <code>--separate-files</code> can save table information as <code>CREATE TABLE</code> statements and all view/function art objects are in separate files (sometime it is easier to compare directories with files than compare two big files)</p>
Dump Informix schema to text (Python)
2014-02-21T09:16:15-08:00Michal Niklashttp://code.activestate.com/recipes/users/186902/http://code.activestate.com/recipes/576621-dump-informix-schema-to-text/
<p style="color: grey">
Python
recipe 576621
by <a href="/recipes/users/186902/">Michal Niklas</a>
(<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/informix/">informix</a>, <a href="/recipes/tags/schema/">schema</a>).
Revision 6.
</p>
<p>I needed "normalized" dump of Informix database so I can easily compare two databases.
I have similar tools for other databases:</p>
<p>PostgreSQL: <a href="http://code.activestate.com/recipes/576557/" rel="nofollow">http://code.activestate.com/recipes/576557/</a></p>
<p>Oracle: <a href="http://code.activestate.com/recipes/576534/" rel="nofollow">http://code.activestate.com/recipes/576534/</a></p>
Dump PostgreSQL db schema to text (Python)
2014-02-21T09:17:23-08:00Michal Niklashttp://code.activestate.com/recipes/users/186902/http://code.activestate.com/recipes/576557-dump-postgresql-db-schema-to-text/
<p style="color: grey">
Python
recipe 576557
by <a href="/recipes/users/186902/">Michal Niklas</a>
(<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/postgres/">postgres</a>, <a href="/recipes/tags/postgresql/">postgresql</a>, <a href="/recipes/tags/schema/">schema</a>).
Revision 7.
</p>
<p>With PostgreSQL there is:</p>
<pre class="prettyprint"><code>pg_dump --schema_only
</code></pre>
<p>but I wanted to compare my PostgreSQL and Oracle database schema dumped by:
<a href="http://code.activestate.com/recipes/576534/">http://code.activestate.com/recipes/576534/</a></p>