<!-- markdown css tag --><div class="pinggu_markdown">
<div class="pinggu_markdown__html"><p>没人回贴，我把我的想法po出来，大家帮忙看看吧。</p>
<pre class=" language-python"><code class="prism  language-python"><span class="token keyword">from</span> peewee <span class="token keyword">import</span> <span class="token operator">*</span>
<span class="token keyword">from</span> datetime <span class="token keyword">import</span> datetime


<span class="token triple-quoted-string string">'''
Sheet：表格的属性包括
    name - 对应企业的名字
    catagory - ‘资产负债表’、‘利润表’、‘现金流量表’、‘财务指标表’
Item：科目
    name - 科目名字，比如‘总资产’
    sheet - 外键，属于那个表，后面利于汇总计算
    belong - 科目所属的，比如应收账款属于总资产
    year3 - 前3年的年度数据
    year2 - 前2年的年度数据
    year1 - 前1年的年度数据
    month - 最近1期的月度数据
    delta - 差值
    ratio - 变化率
    summa - 和值
    avera - 平均值
'''</span>

db <span class="token operator">=</span> SqliteDatabase<span class="token punctuation">(</span>‘<span class="token punctuation">:</span>memory<span class="token punctuation">:</span>’<span class="token punctuation">)</span>

<span class="token keyword">class</span> <span class="token class-name">BaseModel</span><span class="token punctuation">(</span>Model<span class="token punctuation">)</span><span class="token punctuation">:</span>
    <span class="token keyword">class</span> <span class="token class-name">me ta</span><span class="token punctuation">:</span>
        Datebase <span class="token operator">=</span> db


<span class="token keyword">class</span> <span class="token class-name">Sheet</span><span class="token punctuation">(</span>BaseModel<span class="token punctuation">)</span><span class="token punctuation">:</span>
    name <span class="token operator">=</span> CharField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    form <span class="token operator">=</span> CharField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    create_date <span class="token operator">=</span> DateTimeField<span class="token punctuation">(</span>default <span class="token operator">=</span> datetime<span class="token punctuation">.</span>now<span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span>
   
   
<span class="token keyword">class</span> <span class="token class-name">Item</span><span class="token punctuation">(</span>BaseModel<span class="token punctuation">)</span><span class="token punctuation">:</span>
    name <span class="token operator">=</span> CharField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    sheet <span class="token operator">=</span> ForeignKeyField<span class="token punctuation">(</span>Sheet<span class="token punctuation">,</span> backref<span class="token operator">=</span><span class="token string">'items'</span><span class="token punctuation">)</span>
    belong <span class="token operator">=</span> CharField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    year3 <span class="token operator">=</span> FloatField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    year2 <span class="token operator">=</span> FloatField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    year1 <span class="token operator">=</span> FloatField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    month <span class="token operator">=</span> FloatField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    delta <span class="token operator">=</span> FloatField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    ratio <span class="token operator">=</span> FloatField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    sigma <span class="token operator">=</span> FloatField<span class="token punctuation">(</span><span class="token punctuation">)</span>
    avera <span class="token operator">=</span> FloatField<span class="token punctuation">(</span><span class="token punctuation">)</span>
</code></pre>
</div>
</div>

markdown显示不出来。再贴一遍吧