<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi All,<br>
<br>
I've just released <a
href="http://chide.readthedocs.org/en/latest/">this</a> tiny
library for making sample objects for testing.<br>
<br>
Here's a SQLAlchemy example:<br>
<meta charset="utf-8">
<pre style="box-sizing: border-box; font-family: Consolas, 'Andale Mono WT', 'Andale Mono', 'Lucida Console', 'Lucida Sans Typewriter', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Liberation Mono', 'Nimbus Mono L', Monaco, 'Courier New', Courier, monospace; font-size: 12px; white-space: pre; margin: 0px; padding: 12px; line-height: 1.5; display: block; overflow: auto; color: rgb(64, 64, 64); font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"><span class="k" style="box-sizing: border-box; font-weight: bold;">class</span> <span class="nc" style="box-sizing: border-box; color: rgb(68, 85, 136); font-weight: bold;">Parent</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Base</span><span c
l
ass="p" style="box-sizing: border-box;">):</span>
<span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">__tablename__</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="s1" style="box-sizing: border-box; color: rgb(221, 17, 68);">'parent'</span>
<span class="nb" style="box-sizing: border-box; color: rgb(0, 134, 179);">id</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Column</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Integer</span><span class="p" style="box-sizing: border-box;">,</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">primary_key</span><span class="o" style="box-sizing: border-box; font-weight: bold;">=</span><span class="bp" style="box-sizing: border-box; color: rgb(153, 153, 153);">True</span><span class="p" style="box-sizing: border-box;">)</span>
<span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">child_id</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Column</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Integer</span><span class="p" style="box-sizing: border-box;">,</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">ForeignKey</span><span class="p" style="box-sizing: border-box;">(</span><span class="s1" style="box-sizing: border-box; color: rgb(221, 17, 68);">'child.id'</span><span class="p" style="box-sizing: border-box;">))</span>
<span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">child</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">relationship</span><span class="p" style="box-sizing: border-box;">(</span><span class="s1" style="box-sizing: border-box; color: rgb(221, 17, 68);">'Child'</span><span class="p" style="box-sizing: border-box;">)</span>
<span class="k" style="box-sizing: border-box; font-weight: bold;">class</span> <span class="nc" style="box-sizing: border-box; color: rgb(68, 85, 136); font-weight: bold;">Child</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Base</span><span class="p" style="box-sizing: border-box;">):</span>
<span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">__tablename__</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="s1" style="box-sizing: border-box; color: rgb(221, 17, 68);">'child'</span>
<span class="nb" style="box-sizing: border-box; color: rgb(0, 134, 179);">id</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Column</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Integer</span><span class="p" style="box-sizing: border-box;">,</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">primary_key</span><span class="o" style="box-sizing: border-box; font-weight: bold;">=</span><span class="bp" style="box-sizing: border-box; color: rgb(153, 153, 153);">True</span><span class="p" style="box-sizing: border-box;">)</span>
<span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">value</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Column</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Integer</span><span class="p" style="box-sizing: border-box;">)</span></pre>
Now we can build a source of sample data:<br>
<meta charset="utf-8">
<pre style="box-sizing: border-box; font-family: Consolas, 'Andale Mono WT', 'Andale Mono', 'Lucida Console', 'Lucida Sans Typewriter', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Liberation Mono', 'Nimbus Mono L', Monaco, 'Courier New', Courier, monospace; font-size: 12px; white-space: pre; margin: 0px; padding: 12px; line-height: 1.5; display: block; overflow: auto; color: rgb(64, 64, 64); font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"><span class="kn" style="box-sizing: border-box; font-weight: bold;">from</span> <span class="nn" style="box-sizing: border-box; color: rgb(85, 85, 85);">chide.sqlalchemy</span> <span class="kn" style="box-sizing: border-box; font-weight: bold;">import</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">C
o
llection</span>
<span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">samples</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Collection</span><span class="p" style="box-sizing: border-box;">({</span>
<span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Parent</span><span class="p" style="box-sizing: border-box;">:</span> <span class="p" style="box-sizing: border-box;">{</span><span class="s1" style="box-sizing: border-box; color: rgb(221, 17, 68);">'id'</span><span class="p" style="box-sizing: border-box;">:</span> <span class="mi" style="box-sizing: border-box; color: rgb(0, 153, 153);">1</span><span class="p" style="box-sizing: border-box;">,</span> <span class="s1" style="box-sizing: border-box; color: rgb(221, 17, 68);">'child'</span><span class="p" style="box-sizing: border-box;">:</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Child</span><span class="p" style="box-sizing: border-box;">},</span>
<span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Child</span><span class="p" style="box-sizing: border-box;">:</span> <span class="p" style="box-sizing: border-box;">{</span><span class="s1" style="box-sizing: border-box; color: rgb(221, 17, 68);">'id'</span><span class="p" style="box-sizing: border-box;">:</span> <span class="mi" style="box-sizing: border-box; color: rgb(0, 153, 153);">3</span><span class="p" style="box-sizing: border-box;">,</span> <span class="s1" style="box-sizing: border-box; color: rgb(221, 17, 68);">'value'</span><span class="p" style="box-sizing: border-box;">:</span> <span class="mi" style="box-sizing: border-box; color: rgb(0, 153, 153);">42</span><span class="p" style="box-sizing: border-box;">}</span>
<span class="p" style="box-sizing: border-box;">})</span></pre>
And finally, we can use it:<br>
<meta charset="utf-8">
<pre style="box-sizing: border-box; font-family: Consolas, 'Andale Mono WT', 'Andale Mono', 'Lucida Console', 'Lucida Sans Typewriter', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Liberation Mono', 'Nimbus Mono L', Monaco, 'Courier New', Courier, monospace; font-size: 12px; white-space: pre; margin: 0px; padding: 12px; line-height: 1.5; display: block; overflow: auto; color: rgb(64, 64, 64); font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"><span class="gp" style="box-sizing: border-box; color: rgb(85, 85, 85);">>>> </span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">session</span> <span class="o" style="box-sizing: border-box; font-weight: bold;">=</span> <span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Sess
i
on</span><span class="p" style="box-sizing: border-box;">()</span>
<span class="gp" style="box-sizing: border-box; color: rgb(85, 85, 85);">>>> </span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">session</span><span class="o" style="box-sizing: border-box; font-weight: bold;">.</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">add</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">samples</span><span class="o" style="box-sizing: border-box; font-weight: bold;">.</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">make</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Parent</span><span class="p" style="box-sizing: border-box;">))</span>
<span class="gp" style="box-sizing: border-box; color: rgb(85, 85, 85);">>>> </span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">session</span><span class="o" style="box-sizing: border-box; font-weight: bold;">.</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">commit</span><span class="p" style="box-sizing: border-box;">()
</span><meta charset="utf-8"><span class="gp" style="box-sizing: border-box; color: rgb(85, 85, 85);">>>> </span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">session</span><span class="o" style="box-sizing: border-box; font-weight: bold;">.</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">query</span><span class="p" style="box-sizing: border-box;">(</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">Parent</span><span class="p" style="box-sizing: border-box;">)</span><span class="o" style="box-sizing: border-box; font-weight: bold;">.</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">one</span><span class="p" style="box-sizing: border-box;">()</span>
<span class="go" style="box-sizing: border-box; color: rgb(136, 136, 136);"><Parent ...></span>
<span class="gp" style="box-sizing: border-box; color: rgb(85, 85, 85);">>>> </span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">_</span><span class="o" style="box-sizing: border-box; font-weight: bold;">.</span><span class="n" style="box-sizing: border-box; color: rgb(51, 51, 51);">child</span>
<span class="go" style="box-sizing: border-box; color: rgb(136, 136, 136);"><Child ...></span>
</pre>Hope this helps, if anyone finds bugs or has suggestions, please mail me!
cheers,
Chris
</body></html>