Ejemplo n.º 1
0
    def test_create_table_that_does_not_extend_base(self):
        print"8"
        class Test2():
            """Represent test table in db.

            Inherit declarative base class from base.py
            """
            __tablename__ = 'test2'
            id = Column(Integer, primary_key=True)
            a = Column(String, nullable=False)
            b = Column(String, nullable=False)
            c = Column(String, nullable=False)

        HoneypotBase.create_tables()
        self.assertFalse(HoneypotBase.engine.dialect.has_table(HoneypotBase.engine.connect(), "test2"))
Ejemplo n.º 2
0
    def test_create_valid_table(self):
        print"7"
        class Test1(Base):
            """Represent test table in db.

            Inherit declarative base class from base.py
            """
            __tablename__ = 'test1'
            id = Column(Integer, primary_key=True)
            a = Column(String, nullable=False)
            b = Column(String, nullable=False)
            c = Column(String, nullable=False)

        HoneypotBase.create_tables()
        self.assertTrue(HoneypotBase.engine.dialect.has_table(HoneypotBase.engine.connect(), "test1"))
Ejemplo n.º 3
0
    def test_create_table_that_does_not_extend_base(self):
        print "8"

        class Test2():
            """Represent test table in db.

            Inherit declarative base class from base.py
            """
            __tablename__ = 'test2'
            id = Column(Integer, primary_key=True)
            a = Column(String, nullable=False)
            b = Column(String, nullable=False)
            c = Column(String, nullable=False)

        HoneypotBase.create_tables()
        self.assertFalse(
            HoneypotBase.engine.dialect.has_table(
                HoneypotBase.engine.connect(), "test2"))
Ejemplo n.º 4
0
    def test_create_valid_table(self):
        print "7"

        class Test1(Base):
            """Represent test table in db.

            Inherit declarative base class from base.py
            """
            __tablename__ = 'test1'
            id = Column(Integer, primary_key=True)
            a = Column(String, nullable=False)
            b = Column(String, nullable=False)
            c = Column(String, nullable=False)

        HoneypotBase.create_tables()
        self.assertTrue(
            HoneypotBase.engine.dialect.has_table(
                HoneypotBase.engine.connect(), "test1"))
Ejemplo n.º 5
0
    def test_create_table_without_columns(self):
        print"10"

        class Test4(Base):
            """Represent test table in db.

            Inherit declarative base class from base.py
            """
            __tablename__ = 'test4'
            a = Column(String, nullable=False)
            b = Column(String, nullable=False)
            c = Column(String, nullable=False)
        self.assertRaises(InvalidRequestError, lambda: HoneypotBase.create_tables(), Test4)
Ejemplo n.º 6
0
    def test_create_table_that_does_not_define_tablename(self):
        print"9"

        class Test3(Base):
            """Represent test table in db.

            Inherit declarative base class from base.py
            """
            id = Column(Integer, primary_key=True)
            a = Column(String, nullable=False)
            b = Column(String, nullable=False)
            c = Column(String, nullable=False)
        self.assertRaises(InvalidRequestError, lambda: HoneypotBase.create_tables(), Test3)
Ejemplo n.º 7
0
    def test_create_table_without_columns(self):
        print "10"

        class Test4(Base):
            """Represent test table in db.

            Inherit declarative base class from base.py
            """
            __tablename__ = 'test4'
            a = Column(String, nullable=False)
            b = Column(String, nullable=False)
            c = Column(String, nullable=False)

        self.assertRaises(InvalidRequestError,
                          lambda: HoneypotBase.create_tables(), Test4)
Ejemplo n.º 8
0
    def test_create_table_that_does_not_define_tablename(self):
        print "9"

        class Test3(Base):
            """Represent test table in db.

            Inherit declarative base class from base.py
            """
            id = Column(Integer, primary_key=True)
            a = Column(String, nullable=False)
            b = Column(String, nullable=False)
            c = Column(String, nullable=False)

        self.assertRaises(InvalidRequestError,
                          lambda: HoneypotBase.create_tables(), Test3)