擅长:python、mysql、java
<p><a href="https://storm.canonical.com/" rel="noreferrer">Storm</a>可以说是最简单的API:</p>
<pre><code> from storm.locals import *
class Foo:
__storm_table__ = 'foos'
id = Int(primary=True)
class Thing:
__storm_table__ = 'things'
id = Int(primary=True)
name = Unicode()
description = Unicode()
foo_id = Int()
foo = Reference(foo_id, Foo.id)
db = create_database('sqlite:')
store = Store(db)
foo = Foo()
store.add(foo)
thing = Thing()
thing.foo = foo
store.add(thing)
store.commit()
</code></pre>
<p>当您需要执行以下操作时,可以轻松地使用原始SQL:</p>
<pre><code>store.execute('UPDATE bars SET bar_name=? WHERE bar_id like ?', [])
store.commit()
</code></pre>