'Test inserting default cgsnapshot group type.'

def _check_086(self, engine, data):

    self.assertTrue(engine.dialect.has_table(engine.connect(), 'group_types'))
    group_types = db_utils.get_table(engine, 'group_types')
    t1 = group_types.select((group_types.c.name == volume_group_types.DEFAULT_CGSNAPSHOT_TYPE)).execute().first()
    self.assertIsNotNone(t1)
    group_specs = db_utils.get_table(engine, 'group_type_specs')
    specs = group_specs.select(((group_specs.c.group_type_id == t1.id) and (group_specs.c.key == 'consistent_group_snapshot_enabled'))).execute().first()
    self.assertIsNotNone(specs)
    self.assertEqual('<is>    True', specs.value)
