コード例 #1
0
def setup_command_data():
    import os

    if os.path.exists('/tmp/fixture_example.db'):
        os.unlink('/tmp/fixture_example.db')
    if os.path.exists('/tmp/fixture_generate.db'):
        os.unlink('/tmp/fixture_generate.db')

    import sqlalchemy as sa
    from sqlalchemy import orm
    from fixture.examples.db.sqlalchemy_examples import (Author, authors, Book,
                                                         books, metadata)
    metadata.bind = sa.create_engine('sqlite:////tmp/fixture_example.db')
    metadata.create_all()
    orm.mapper(Book, books)
    orm.mapper(Author,
               authors,
               properties={'books': orm.relation(Book, backref='author')})
    Session = orm.sessionmaker(bind=metadata.bind,
                               autoflush=True,
                               transactional=True)
    session = Session()

    frank = Author()
    frank.first_name = "Frank"
    frank.last_name = "Herbert"
    session.save(frank)

    dune = Book()
    dune.title = "Dune"
    dune.author = frank
    session.save(dune)

    session.commit()
コード例 #2
0
ファイル: docs.py プロジェクト: fixture-py/fixture
def setup_command_data():
    import os

    if os.path.exists('/tmp/fixture_example.db'):
        os.unlink('/tmp/fixture_example.db')
    if os.path.exists('/tmp/fixture_generate.db'):
        os.unlink('/tmp/fixture_generate.db')
    
    import sqlalchemy as sa
    from sqlalchemy import orm
    from fixture.examples.db.sqlalchemy_examples import (
                                    Author, authors, Book, books, metadata)
    metadata.bind = sa.create_engine('sqlite:////tmp/fixture_example.db')
    metadata.create_all()
    orm.mapper(Book, books)
    orm.mapper(Author, authors, properties={'books': orm.relation(Book, backref='author')})
    Session = orm.sessionmaker(bind=metadata.bind, autoflush=True, transactional=True)
    session = Session()

    frank = Author()
    frank.first_name = "Frank"
    frank.last_name = "Herbert"
    session.save(frank)

    dune = Book()
    dune.title = "Dune"
    dune.author = frank
    session.save(dune)

    session.commit()
    
    
コード例 #3
0
ファイル: docs.py プロジェクト: w31rd0/fixture
def setup_command_data():
    import os
    from fixture import SQLObjectFixture
    from fixture.examples.db import sqlobject_examples
    from sqlalchemy import (MetaData, create_engine, Table, Integer, String,
                            ForeignKey, Column)
    from sqlalchemy.orm import (scoped_session, sessionmaker, mapper, relation)
    from fixture import DataSet
    from fixture import SQLAlchemyFixture

    if os.path.exists('/tmp/fixture_example.db'):
        os.unlink('/tmp/fixture_example.db')
    if os.path.exists('/tmp/fixture_generate.db'):
        os.unlink('/tmp/fixture_generate.db')

    import sqlalchemy as sa
    from sqlalchemy import orm
    from fixture.examples.db.sqlalchemy_examples import (Author, authors, Book,
                                                         books, metadata)
    metadata.bind = sa.create_engine('sqlite:////tmp/fixture_example.db')
    metadata.create_all()
    orm.mapper(Book, books)
    orm.mapper(Author,
               authors,
               properties={'books': orm.relation(Book, backref='author')})
    Session = orm.sessionmaker(bind=metadata.bind,
                               autoflush=True,
                               transactional=True)
    session = Session()

    frank = Author()
    frank.first_name = "Frank"
    frank.last_name = "Herbert"
    session.save(frank)

    dune = Book()
    dune.title = "Dune"
    dune.author = frank
    session.save(dune)

    session.commit()
コード例 #4
0
 def setUp(self):
     from fixture import SQLAlchemyFixture, NamedDataStyle
     import sqlalchemy
     from sqlalchemy.orm import (
             mapper, relation, clear_mappers, sessionmaker, scoped_session)
     from sqlalchemy import create_engine
     
     metadata.bind = create_engine(conf.LITE_DSN)
     metadata.create_all()
             
     class options:
         dsn = conf.LITE_DSN
         env = ['fixture.examples.db.sqlalchemy_examples']
     self.options = options
     self.generator = DataSetGenerator(self.options, template=StubTemplate())
     
     ScopedSession = scoped_session(sessionmaker(autoflush=False, transactional=True))
     
     ScopedSession.mapper(Category, categories, save_on_init=False)
     ScopedSession.mapper(Product, products, properties={
         'category': relation(Category),
     }, save_on_init=False)
     ScopedSession.mapper(Offer, offers, properties={
         'category': relation(Category, backref='products'),
         'product': relation(Product)
     }, save_on_init=False)
     
     self.fixture = SQLAlchemyFixture(
                         env=sqlalchemy_examples, 
                         style=NamedDataStyle(),
                         engine=metadata.bind)
     self.data = self.fixture.data(self.CategoryData)
     self.data.setup()
     
     self.hnd = self.generator.get_handler(
                         "%s.Category" % (Category.__module__),
                         obj=Category,
                         connection=metadata.bind)
     self.hnd.begin()
コード例 #5
0
ファイル: docs.py プロジェクト: JamesX88/tes
def setup_command_data():
    import os
    from fixture import SQLObjectFixture
    from fixture.examples.db import sqlobject_examples
    from sqlalchemy import (
        MetaData, create_engine, Table, Integer, String, ForeignKey, Column)
    from sqlalchemy.orm import (scoped_session, sessionmaker, mapper, relation)
    from fixture import DataSet
    from fixture import SQLAlchemyFixture
    
    if os.path.exists('/tmp/fixture_example.db'):
        os.unlink('/tmp/fixture_example.db')
    if os.path.exists('/tmp/fixture_generate.db'):
        os.unlink('/tmp/fixture_generate.db')
    
    import sqlalchemy as sa
    from sqlalchemy import orm
    from fixture.examples.db.sqlalchemy_examples import (
                                    Author, authors, Book, books, metadata)
    metadata.bind = sa.create_engine('sqlite:////tmp/fixture_example.db')
    metadata.create_all()
    orm.mapper(Book, books)
    orm.mapper(Author, authors, properties={'books': orm.relation(Book, backref='author')})
    Session = orm.sessionmaker(bind=metadata.bind, autoflush=True, transactional=True)
    session = Session()

    frank = Author()
    frank.first_name = "Frank"
    frank.last_name = "Herbert"
    session.save(frank)

    dune = Book()
    dune.title = "Dune"
    dune.author = frank
    session.save(dune)

    session.commit()