def setUp(self): datastore = schemaless.DataStore(mysql_shards=['localhost:3306'], user='******', password='******', database='test') self.clear_tables(datastore) tags_db = { 'User': 1, 'ToDo': 2, 'Business': 3} self.session = orm.Session(datastore) self.base_class = orm.make_base(self.session, tags_db=tags_db)
import tornado.ioloop import tornado.httpserver import schemaless from schemaless import c from schemaless import orm dirname = os.path.dirname(__file__) ############## # ORM Things ############## datastore = schemaless.DataStore(mysql_shards=['localhost:3306'], user='******', password='******', database='test') session = orm.Session(datastore) Base = orm.make_base(session, tags_file=os.path.join(dirname, 'tags.yaml')) class Post(Base): _columns = [ orm.String('title', 255, required=True), orm.Text('content', required=True), orm.DateTime('time_created', default=datetime.datetime.now) ] _indexes = [['time_created']] @classmethod def new_post(cls, title, content): return cls(post_id=schemaless.guid(), title=title, content=content).save() @property
import tornado.ioloop import tornado.httpserver import schemaless from schemaless import c from schemaless import orm dirname = os.path.dirname(__file__) ############## # ORM Things ############## datastore = schemaless.DataStore(mysql_shards=["localhost:3306"], user="******", password="******", database="test") session = orm.Session(datastore) Base = orm.make_base(session, tags_file=os.path.join(dirname, "tags.yaml")) class Post(Base): _columns = [ orm.String("title", 255, required=True), orm.Text("content", required=True), orm.DateTime("time_created", default=datetime.datetime.now), ] _indexes = [["time_created"]] @classmethod def new_post(cls, title, content): return cls(post_id=schemaless.guid(), title=title, content=content).save()
import os import datetime import schemaless from schemaless import c from schemaless import orm from blog import base_path, config datastore = schemaless.DataStore(**config['datastore']) session = orm.Session(datastore) Base = orm.make_base(session, tags_file=os.path.join(base_path, 'tags.yaml')) class Post(Base): _columns = [ orm.String('title', 255, required=True), orm.Text('content', required=True), orm.DateTime('time_created'), orm.DateTime('time_updated'), orm.Boolean('active', default=False) ] _indexes = [['time_created'], ['active', 'time_created']] @classmethod def new_post(cls, title, content, active=False): now = datetime.datetime.now() return cls(post_id=schemaless.guid(), title=title, content=content, time_created=now, time_updated=now, active=active).save() @classmethod