peewee

peewee - grzebania w ORM.
definicje modelu oraz tworzenie schematu
Pachnie jak django:
Import peewee
Klasa Blog (peewee.Model):
& Nbsp; title = peewee.CharField ()
& Nbsp; def __unicode __ (self):
& Nbsp; return self.title
Klasa wprowadzająca (peewee.Model):
& Nbsp; title = peewee.CharField (max_length = 50)
& Nbsp; content = peewee.TextField ()
& Nbsp; pub_date = peewee.DateTimeField ()
& Nbsp; blog = peewee.ForeignKeyField (Blog)
& Nbsp; def __unicode __ (self):
& Nbsp; return '% s:% s "% (self.blog.title, self.title)
utworzyć kilka tabel:
>>> Blog.create_table ()
>>> Entry.create_table ()
klucze obce pracować jak Django
& Nbsp; >>> b = Blog (title = "peewee Wielka przygoda")
& Nbsp; >>> b.save ()
& Nbsp; >>> e = Wejście (title = "? Greatest film w historii" content = "yes", blog = b)
& Nbsp; >>> e.save ()
& Nbsp; >>> e.blog
& Nbsp;
& Nbsp; >>> dla e w b.entry_set:
& Nbsp; ... druku e.title
& Nbsp; ...
& Nbsp; Greatest film w historii?
zapytań dziwaczne
Zapytania są w 4 smakach (SELECT / aktualizacja / insert / delete):
>>> For i w xrange (50):
... B = Blog (title = "blog-% d '% i)
... B.save ()
... Dla j w xrange (i):
... E = Wejście (title = "entry-% d '% j, blog = b)
... E.save ()
...
>>> [Obj.title do obj w Blog.select (). Gdzie (title__contains = "0")]
[U'blog-0 "u'blog-10 'u'blog-20', u'blog-30 ', u'blog-40']
>>> [Obj.title do obj w Blog.select (). Paginate (3, 10)]
[U'blog-20 ', u'blog-21', u'blog-22 ', u'blog-23', u'blog-24 ',
& Nbsp; u'blog-25 ', 26' u'blog-27, u'blog ", u'blog-28", u'blog-29 ']
>>> [Obj.title do obj w Blog.select (). Join (Wejście) .gdzie (title__contains = "entry-45 ')]
[U'blog-46 ', u'blog-47', u'blog-48 ', u'blog-49']
>>> Blog.select (). Join (Wejście) .gdzie (title__contains = "entry-29") liczy. ()
20

Wymagania :

• Python