http://code.activestate.com/recipes/tags/dot/views/2011-06-12T03:29:01-07:00ActiveState Code Recipes2011-06-12T03:29:01-07:00Raymond Hettingerhttp://code.activestate.com/recipes/users/178123/http://code.activestate.com/recipes/577749-experiment-with-kaprekars-routine/

<p style="color: grey"> Python recipe 577749 by <a href="/recipes/users/178123/">Raymond Hettinger</a> (<a href="/recipes/tags/6174/">6174</a>, <a href="/recipes/tags/dot/">dot</a>, <a href="/recipes/tags/graph/">graph</a>, <a href="/recipes/tags/kaprekar/">kaprekar</a>). Revision 2. </p> <p>Explore the story behind the mysterious number 6174. Generate all possible chains leading to 6174, show their length and their patterns of convergence.</p>

2010-07-10T08:14:09-07:00Noufal Ibrahimhttp://code.activestate.com/recipes/users/4173873/http://code.activestate.com/recipes/577298-plot-database-table-dependecies-for-a-mysql-databa/

<p style="color: grey"> Python recipe 577298 by <a href="/recipes/users/4173873/">Noufal Ibrahim</a> (<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/dot/">dot</a>, <a href="/recipes/tags/graphs/">graphs</a>, <a href="/recipes/tags/graphviz/">graphviz</a>, <a href="/recipes/tags/mysql/">mysql</a>). </p> <p>The following snippet will output a spec suitable for the graphviz dot program. It will go through the database specified and for all the tables that start with any of the names in <code>table_prefixes</code>, it will create a dependency graph. A dependency in this context is when a field of one table has a foreign key reference to another. The edges are labelled with the actual field names. </p> <p>It can be used like this</p> <pre class="prettyprint"><code>python deps.py | dot -Tpng | display </code></pre> <p>This requires the InnoDB engine (i.e. something that honours foreign keys. MyISAM doesn't do so).</p>