Module TryExcept body ImportFrom alias handlers ExceptHandler type NameLoad body Pass Import alias Import alias Import alias ImportFrom alias ImportFrom alias ImportFrom alias Import alias identifier ImportFrom alias Import alias TryExcept body Import alias Assign NameStore NameLoad handlers ExceptHandler type NameLoad body Assign NameStore NameLoad TryExcept body Import alias Assign NameStore NameLoad handlers ExceptHandler type NameLoad body Assign NameStore NameLoad ClassDef bases NameLoad body FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Str Assign AttributeStore NameLoad attr Call NameLoad BinOpAdd Str AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call NameLoad AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr Assign NameStore ListLoad Str Str Str Str Str Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr Assign NameStore ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr Assign NameStore ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr Assign NameStore ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Num Assign NameStore Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Return decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr NameLoad With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore ListLoad Str Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad SubscriptLoad NameLoad Index Str Num Expr Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword NameLoad keyword NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad SubscriptLoad NameLoad Index Str Num decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Assign NameStore Str Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword Num keyword Num Expr Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword Str keyword NameLoad Expr Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str keyword Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Num Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str keyword Num Expr Call AttributeLoad NameLoad attr NameLoad Num Expr Call AttributeLoad NameLoad attr NameLoad Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Num Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str keyword Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str keyword Str keyword ListLoad Str Str Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Str Str Str ListLoad Str Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Str Str Str ListLoad Str Str Str decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam defaults body Assign NameStore Call NameLoad ListComp Call AttributeLoad NameLoad attr comprehension NameStore NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad SubscriptLoad NameLoad Index Str NameLoad Expr Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str NameLoad Expr Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str NameLoad Expr Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Assign NameStore Num For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad BinOpMod Str NameLoad BinOpMod Str NameLoad Str ListLoad Str AugAssignSub NameStore Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Assign NameStore Num For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad BinOpMod Str NameLoad BinOpMod Str NameLoad Str ListLoad Str AugAssignAdd NameStore Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Num keyword Num keyword NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Assign NameStore Num For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad BinOpMod Str NameLoad BinOpMod Str NameLoad Str ListLoad Str AugAssignAdd NameStore Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Assign NameStore Num For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad BinOpMod Str NameLoad BinOpMod Str NameLoad Str ListLoad Str AugAssignAdd NameStore Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Assign NameStore Num For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad BinOpMod Str NameLoad BinOpMod Str NameLoad Str ListLoad Str AugAssignAdd NameStore Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Assign NameStore Num For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad BinOpMod Str NameLoad BinOpMod Str NameLoad Str ListLoad Str AugAssignSub NameStore Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Num Assign NameStore Num For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad BinOpMod Str NameLoad BinOpMod Str NameLoad Str ListLoad Str AugAssignSub NameStore Num Return decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr NameLoad Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr NameLoad Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr NameLoad Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr NameLoad Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str Expr Call AttributeLoad NameLoad attr NameLoad Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword Str keyword Str Expr Call AttributeLoad NameLoad attr NameLoad Num decorator_list FunctionDef arguments args NameParam defaults body For NameStore Call NameLoad Num body Assign NameStore IfExp CompareLt NameLoad Num ListLoad Str ListLoad Str Assign NameStore IfExp CompareLt NameLoad Num Str Str Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword BinOpMod Str NameLoad keyword BinOpMod Str NameLoad keyword NameLoad keyword NameLoad Expr Call AttributeLoad NameLoad attr Num decorator_list decorator_list ClassDef bases NameLoad body FunctionDef arguments args NameParam defaults body Assign AttributeStore NameLoad attr Call NameLoad Str Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call NameLoad AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr decorator_list decorator_list Call AttributeLoad NameLoad attr NameLoad Str ClassDef bases NameLoad body FunctionDef arguments args NameParam defaults body Assign AttributeStore NameLoad attr Call NameLoad Str Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call NameLoad AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr decorator_list decorator_list Call AttributeLoad NameLoad attr NameLoad Str ClassDef bases NameLoad body FunctionDef arguments args NameParam NameParam defaults body Return BinOpAdd Str NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Str Assign NameStore Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign SubscriptStore AttributeLoad AttributeLoad NameLoad attr attr Index Str Dict Str NameLoad Assign AttributeStore NameLoad attr Call NameLoad AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call NameLoad keyword AttributeLoad NameLoad attr keyword Str Assign AttributeStore NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr keyword Str Assign AttributeStore NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr keyword ListLoad Str decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr Assign NameStore ListLoad Str Str Str Str Str Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr Assign NameStore ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr Assign NameStore ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str With Call AttributeLoad AttributeLoad NameLoad attr attr NameStore body Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad NameLoad attr Assign NameStore ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list decorator_list ClassDef bases NameLoad body FunctionDef arguments args NameParam NameParam defaults body Return Str decorator_list FunctionDef arguments args NameParam defaults body Pass decorator_list decorator_list Call AttributeLoad NameLoad attr NameLoad Str ClassDef bases NameLoad body FunctionDef arguments args NameParam NameParam defaults body Return Str decorator_list FunctionDef arguments args NameParam defaults body Pass decorator_list decorator_list Call AttributeLoad NameLoad attr NameLoad Str
N/A N/A N/A builtins range N/A N/A N/A ImportError N/A N/A N/A unittest N/A tempfile N/A os flask_blogging.sqlastorage SQLAStorage sqlalchemy create_engine test FlaskBloggingTestCase N/A sqlalchemy sqla flask.ext.sqlalchemy SQLAlchemy N/A time N/A N/A N/A _mysql N/A HAS_MYSQL True N/A N/A N/A ImportError N/A N/A HAS_MYSQL False N/A N/A N/A psycopg2 N/A HAS_POSTGRES True N/A N/A N/A ImportError N/A N/A HAS_POSTGRES False TestSQLiteStorage N/A FlaskBloggingTestCase N/A _create_storage N/A N/A self N/A N/A N/A temp_dir N/A N/A tempfile gettempdir N/A N/A self _dbfile N/A N/A N/A os path join temp_dir temp.db N/A N/A self _engine N/A create_engine N/A sqlite:/// N/A self _dbfile N/A N/A self _meta N/A N/A sqla MetaData N/A N/A self storage N/A SQLAStorage N/A self _engine metadata N/A self _meta N/A N/A N/A N/A self _meta create_all bind N/A self _engine N/A setUp N/A N/A self N/A N/A N/A N/A N/A FlaskBloggingTestCase setUp self N/A N/A N/A self _create_storage N/A tearDown N/A N/A self N/A N/A N/A N/A N/A os remove N/A self _dbfile N/A test_post_table_exists N/A N/A self N/A N/A N/A table_name post N/A N/A N/A N/A self _engine begin conn N/A N/A N/A N/A self assertTrue N/A N/A N/A conn dialect has_table conn table_name N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A columns N/A N/A t name N/A t N/A table columns N/A expected_columns N/A id title text post_date last_modified_date draft N/A N/A N/A self assertListEqual columns expected_columns N/A test_tag_table_exists N/A N/A self N/A N/A N/A table_name tag N/A N/A N/A N/A self _engine begin conn N/A N/A N/A N/A self assertTrue N/A N/A N/A conn dialect has_table conn table_name N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A columns N/A N/A t name N/A t N/A table columns N/A expected_columns N/A id text N/A N/A N/A self assertListEqual columns expected_columns N/A test_tag_post_table_exists N/A N/A self N/A N/A N/A table_name tag_posts N/A N/A N/A N/A self _engine begin conn N/A N/A N/A N/A self assertTrue N/A N/A N/A conn dialect has_table conn table_name N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A columns N/A N/A t name N/A t N/A table columns N/A expected_columns N/A tag_id post_id N/A N/A N/A self assertListEqual columns expected_columns N/A test_user_post_table_exists N/A N/A self N/A N/A N/A table_name user_posts N/A N/A N/A N/A self _engine begin conn N/A N/A N/A N/A self assertTrue N/A N/A N/A conn dialect has_table conn table_name N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A columns N/A N/A t name N/A t N/A table columns N/A expected_columns N/A user_id post_id N/A N/A N/A self assertListEqual columns expected_columns N/A test_user_post_table_consistency N/A N/A self N/A N/A N/A user_id 1 N/A post_id 5 N/A pid N/A N/A N/A self storage save_post title Title text Sample Text user_id user tags N/A hello world N/A posts N/A N/A N/A self storage get_posts N/A N/A N/A self assertEqual N/A len posts 1 N/A N/A N/A N/A self storage save_post title Title text Sample Text user_id newuser tags N/A hello world post_id pid N/A N/A N/A self assertEqual N/A len posts 1 N/A N/A test_tags_uniqueness N/A N/A self N/A N/A N/A table_name tag N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A N/A N/A N/A self _engine begin conn N/A N/A statement N/A N/A N/A N/A table insert values text test_tag N/A N/A N/A conn execute statement N/A N/A N/A N/A self _engine begin conn N/A N/A statement N/A N/A N/A N/A table insert values text test_tag N/A N/A N/A self assertRaises N/A N/A sqla exc IntegrityError N/A conn execute statement N/A test_tags_consistency N/A N/A self N/A N/A N/A tags N/A hello world N/A pid N/A N/A N/A self storage save_post title Title text Sample Text user_id user tags tags N/A post N/A N/A N/A self storage get_post_by_id pid N/A N/A N/A self assertEqual N/A len N/A post N/A tags 2 N/A N/A N/A tags pop N/A pid N/A N/A N/A self storage save_post title Title text Sample Text user_id user tags tags post_id pid N/A post N/A N/A N/A self storage get_post_by_id pid N/A N/A N/A self assertEqual N/A len N/A post N/A tags 1 N/A test_tag_post_uniqueness N/A N/A self N/A N/A N/A N/A N/A N/A self storage save_post title Title text Sample Text user_id user tags N/A tags N/A table_name tag_posts N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A N/A N/A N/A self _engine begin conn N/A N/A statement N/A N/A N/A N/A table insert values tag_id 1 post_id 1 N/A N/A N/A self assertRaises N/A N/A sqla exc IntegrityError N/A conn execute statement N/A test_user_post_uniqueness N/A N/A self N/A N/A N/A pid N/A N/A N/A self storage save_post title Title1 text Sample Text user_id testuser tags N/A hello world N/A table_name user_posts N/A metadata N/A N/A sqla MetaData N/A N/A N/A metadata reflect bind N/A self _engine N/A table N/A N/A metadata tables N/A table_name N/A N/A N/A N/A self _engine begin conn N/A N/A statement N/A N/A N/A N/A table insert values user_id testuser post_id pid N/A N/A N/A self assertRaises N/A N/A sqla exc IntegrityError N/A conn execute statement N/A test_bind_database N/A N/A self N/A N/A N/A N/A N/A self test_post_table_exists N/A N/A N/A self test_tag_table_exists N/A N/A N/A self test_tag_post_table_exists N/A N/A N/A self test_user_post_table_exists N/A test_save_post N/A N/A self N/A N/A N/A pid N/A N/A N/A self storage save_post title Title1 text Sample Text user_id testuser tags N/A hello world N/A pid N/A N/A N/A self storage save_post title Title1 text Sample Text user_id testuser tags N/A hello world post_id 1 N/A p N/A N/A N/A self storage get_post_by_id 2 N/A N/A N/A self assertIsNone p N/A pid N/A N/A N/A self storage save_post title Title1 text Sample Text user_id testuser tags N/A hello world post_id 5 N/A N/A N/A self assertNotEqual pid 5 N/A N/A N/A self assertEqual pid 2 N/A p N/A N/A N/A self storage get_post_by_id 2 N/A N/A N/A self assertIsNotNone p N/A test_delete_post N/A N/A self N/A N/A N/A pid N/A N/A N/A self storage save_post title Title1 text Sample Text user_id testuser tags N/A hello world N/A p N/A N/A N/A self storage get_post_by_id pid N/A N/A N/A self assertIsNotNone p N/A N/A N/A N/A self storage delete_post pid N/A p N/A N/A N/A self storage get_post_by_id pid N/A N/A N/A self assertIsNone p N/A pid N/A N/A N/A self storage save_post title Title1 text Sample Text user_id testuser tags N/A hello world post_id 1 N/A p N/A N/A N/A self storage get_post_by_id pid N/A N/A N/A self assertIsNotNone p N/A test_get_post_by_id N/A N/A self N/A N/A N/A pid1 N/A N/A N/A self storage save_post title Title1 text Sample Text1 user_id testuser tags N/A hello world N/A pid2 N/A N/A N/A self storage save_post title Title2 text Sample Text2 user_id testuser tags N/A hello my world N/A post N/A N/A N/A self storage get_post_by_id pid1 N/A N/A N/A self _assert_post post Title1 Sample Text1 testuser N/A HELLO WORLD N/A post N/A N/A N/A self storage get_post_by_id pid2 N/A N/A N/A self _assert_post post Title2 Sample Text2 testuser N/A HELLO MY WORLD N/A _assert_post N/A N/A self post title text user_id tags N/A N/A N/A tags N/A set N/A N/A N/A t upper N/A t tags N/A N/A N/A self assertSetEqual N/A set N/A post N/A tags tags N/A N/A N/A self assertEqual N/A post N/A title title N/A N/A N/A self assertEqual N/A post N/A text text N/A N/A N/A self assertEqual N/A post N/A user_id user_id N/A test_get_posts N/A N/A self N/A N/A N/A N/A N/A self _create_dummy_data N/A posts N/A N/A N/A self storage get_posts N/A N/A N/A self assertEqual N/A len posts 10 N/A ctr 19 N/A post posts N/A N/A N/A N/A self _assert_post post N/A Title%d ctr N/A Sample Text%d ctr newuser N/A world N/A ctr 1 N/A posts N/A N/A N/A self storage get_posts recent False N/A N/A N/A self assertEqual N/A len posts 10 N/A ctr 0 N/A post posts N/A N/A N/A N/A self _assert_post post N/A Title%d ctr N/A Sample Text%d ctr testuser N/A hello N/A ctr 1 N/A posts N/A N/A N/A self storage get_posts count 5 offset 5 recent False N/A N/A N/A self assertEqual N/A len posts 5 N/A ctr 5 N/A post posts N/A N/A N/A N/A self _assert_post post N/A Title%d ctr N/A Sample Text%d ctr testuser N/A hello N/A ctr 1 N/A posts N/A N/A N/A self storage get_posts tag hello recent False N/A N/A N/A self assertEqual N/A len posts 10 N/A ctr 0 N/A post posts N/A N/A N/A N/A self _assert_post post N/A Title%d ctr N/A Sample Text%d ctr testuser N/A hello N/A ctr 1 N/A posts N/A N/A N/A self storage get_posts tag world recent False N/A N/A N/A self assertEqual N/A len posts 10 N/A ctr 10 N/A post posts N/A N/A N/A N/A self _assert_post post N/A Title%d ctr N/A Sample Text%d ctr newuser N/A world N/A ctr 1 N/A posts N/A N/A N/A self storage get_posts user_id newuser recent True N/A N/A N/A self assertEqual N/A len posts 10 N/A ctr 19 N/A post posts N/A N/A N/A N/A self _assert_post post N/A Title%d ctr N/A Sample Text%d ctr newuser N/A world N/A ctr 1 N/A posts N/A N/A N/A self storage get_posts user_id testuser recent True N/A N/A N/A self assertEqual N/A len posts 10 N/A ctr 9 N/A post posts N/A N/A N/A N/A self _assert_post post N/A Title%d ctr N/A Sample Text%d ctr testuser N/A hello N/A ctr 1 N/A N/A test_count_posts N/A N/A self N/A N/A N/A N/A N/A self _create_dummy_data N/A count N/A N/A N/A self storage count_posts N/A N/A N/A self assertEqual count 20 N/A count N/A N/A N/A self storage count_posts user_id testuser N/A N/A N/A self assertEqual count 10 N/A count N/A N/A N/A self storage count_posts user_id newuser N/A N/A N/A self assertEqual count 10 N/A count N/A N/A N/A self storage count_posts user_id testuser N/A N/A N/A self assertEqual count 10 N/A count N/A N/A N/A self storage count_posts tag hello N/A N/A N/A self assertEqual count 10 N/A count N/A N/A N/A self storage count_posts tag world N/A N/A N/A self assertEqual count 10 N/A count N/A N/A N/A self storage count_posts user_id testuser tag world N/A N/A N/A self assertEqual count 0 N/A _create_dummy_data N/A N/A self N/A N/A N/A i N/A range 20 N/A N/A tags N/A N/A i 10 N/A hello N/A world N/A user N/A N/A i 10 testuser newuser N/A N/A N/A N/A self storage save_post title N/A Title%d i text N/A Sample Text%d i user_id user tags tags N/A N/A N/A time sleep 1 N/A N/A TestMySQLStorage N/A TestSQLiteStorage N/A _create_storage N/A N/A self N/A N/A N/A N/A self _engine N/A create_engine mysql+mysqldb://root:@localhost/flask_blogging N/A N/A self _meta N/A N/A sqla MetaData N/A N/A self storage N/A SQLAStorage N/A self _engine metadata N/A self _meta N/A N/A N/A N/A self _meta create_all bind N/A self _engine N/A tearDown N/A N/A self N/A N/A N/A metadata N/A N/A sqla MetaData N/A N/A N/A metadata reflect bind N/A self _engine N/A N/A N/A metadata drop_all bind N/A self _engine N/A N/A N/A N/A unittest skipUnless HAS_MYSQL Package mysql-python needs to be install to run this test. TestPostgresStorage N/A TestSQLiteStorage N/A _create_storage N/A N/A self N/A N/A N/A N/A self _engine N/A create_engine postgresql+psycopg2://postgres:@localhost/flask_blogging N/A N/A self _meta N/A N/A sqla MetaData N/A N/A self storage N/A SQLAStorage N/A self _engine metadata N/A self _meta N/A N/A N/A N/A self _meta create_all bind N/A self _engine N/A tearDown N/A N/A self N/A N/A N/A metadata N/A N/A sqla MetaData N/A N/A N/A metadata reflect bind N/A self _engine N/A N/A N/A metadata drop_all bind N/A self _engine N/A N/A N/A N/A unittest skipUnless HAS_POSTGRES Requires psycopg2 Postgres package TestSQLiteBinds N/A FlaskBloggingTestCase N/A _conn_string N/A N/A self dbfile N/A N/A N/A N/A sqlite:/// dbfile N/A setUp N/A N/A self N/A N/A N/A N/A N/A FlaskBloggingTestCase setUp self N/A temp_dir N/A N/A tempfile gettempdir N/A N/A self _dbfile N/A N/A N/A os path join temp_dir temp.db N/A conn_string N/A N/A self _conn_string N/A self _dbfile N/A N/A N/A N/A self app config N/A SQLALCHEMY_BINDS N/A blog conn_string N/A N/A self _db N/A SQLAlchemy N/A self app N/A N/A self storage N/A SQLAStorage db N/A self _db bind blog N/A N/A self _engine N/A N/A N/A self _db get_engine N/A self app bind blog N/A N/A self _meta N/A N/A self _db metadata N/A N/A N/A N/A self _db create_all bind N/A blog N/A tearDown N/A N/A self N/A N/A N/A N/A N/A os remove N/A self _dbfile N/A test_post_table_exists N/A N/A self N/A N/A N/A table_name post N/A N/A N/A N/A self _engine begin conn N/A N/A N/A N/A self assertTrue N/A N/A N/A conn dialect has_table conn table_name N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A columns N/A N/A t name N/A t N/A table columns N/A expected_columns N/A id title text post_date last_modified_date draft N/A N/A N/A self assertListEqual columns expected_columns N/A test_tag_table_exists N/A N/A self N/A N/A N/A table_name tag N/A N/A N/A N/A self _engine begin conn N/A N/A N/A N/A self assertTrue N/A N/A N/A conn dialect has_table conn table_name N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A columns N/A N/A t name N/A t N/A table columns N/A expected_columns N/A id text N/A N/A N/A self assertListEqual columns expected_columns N/A test_tag_post_table_exists N/A N/A self N/A N/A N/A table_name tag_posts N/A N/A N/A N/A self _engine begin conn N/A N/A N/A N/A self assertTrue N/A N/A N/A conn dialect has_table conn table_name N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A columns N/A N/A t name N/A t N/A table columns N/A expected_columns N/A tag_id post_id N/A N/A N/A self assertListEqual columns expected_columns N/A test_user_post_table_exists N/A N/A self N/A N/A N/A table_name user_posts N/A N/A N/A N/A self _engine begin conn N/A N/A N/A N/A self assertTrue N/A N/A N/A conn dialect has_table conn table_name N/A metadata N/A self _meta N/A table N/A N/A metadata tables N/A table_name N/A columns N/A N/A t name N/A t N/A table columns N/A expected_columns N/A user_id post_id N/A N/A N/A self assertListEqual columns expected_columns N/A N/A TestMySQLBinds N/A TestSQLiteBinds N/A _conn_string N/A N/A self dbfile N/A N/A N/A mysql+mysqldb://root:@localhost/flask_blogging N/A tearDown N/A N/A self N/A N/A N/A N/A N/A N/A N/A unittest skipUnless HAS_MYSQL Package mysql-python needs to be install to run this test. TestPostgresBinds N/A TestSQLiteBinds N/A _conn_string N/A N/A self dbfile N/A N/A N/A postgresql+psycopg2://postgres:@localhost/flask_blogging N/A tearDown N/A N/A self N/A N/A N/A N/A N/A N/A N/A unittest skipUnless HAS_POSTGRES Requires psycopg2 Postgres package