def METHOD_NAME(self):
    group = self.create_random_name(prefix='group', length=24)
    server = self.create_random_name(prefix='server', length=24)
    output = self.cmd('sql up -g {} -s {}'.format(group, server)).get_output_in_json()
    user, server_name = output['username'].split('@')
    password, database = output['password'], 'sampledb'
    self.assertEqual(server, server_name)
    # test followup iterations of up
    self.cmd('sql up', checks=[JMESPathCheck('password', '*****')])
    self.cmd('sql up -p {}'.format(password), checks=[JMESPathCheck('password', password)])
    # check that db and server exist
    self.cmd('sql db show -n {} -g {} -s {}'.format(database, group, server))
    # remove all resources used by up
    self.cmd('sql down -y --delete-group')
    # check group no longer exists
    with self.assertRaises(SystemExit) as ex:
        self.cmd('group show -n {}'.format(group))
    self.assertEqual(ex.exception.code, 3)