def test_not_null(self):
        stmts = ["CREATE TABLE t1 (c1 INTEGER, c2 INTEGER NULL, "
                 "c3 INTEGER NOT NULL)"]
        dbmap = self.to_map(stmts)
        expmap = {'columns': [{'c1': {'type': 'integer'}},
                              {'c2': {'type': 'integer'}},
                              {'c3': {'type': 'integer', 'not_null': True}}]}

        assert dbmap['schema public']['table t1'] == expmap
Map a table with a NOT NULL column
dataset/ETHPy150Open perseas/Pyrseas/tests/dbobject/test_column.py/ColumnToMapTestCase.test_not_null