def robotsrulesetOfDomain(self, domain):
		'''检查domain是否在数据库中,
			否 --> (False, None)
			是 --> (True, 数据库中存储的robots.txt内容)
		'''
		exist = False
		cur = self.conn.cursor()
		# 是否存在
		cur.execute("SELECT 1 FROM Domains WHERE domain=?", (domain,))
		if cur.fetchone() :
			exist = True
		# 存在的话,结果是什么
		cur.execute("SELECT rules FROM Domains,Rulesets "
			"WHERE domain=? AND Domains.did=Rulesets.did"
			,(domain,) )
		ruleset = cur.fetchone()
		return (exist, ruleset)
def test_to_dict_returns_correct_dict(self):
        self.voiceover_application.accept(self.reviewer_id)
        expected_dict = {
            'voiceover_application_id': 'application_id',
            'target_type': 'exploration',
            'target_id': 'exp_id',
            'status': 'accepted',
            'author_name': 'author',
            'final_reviewer_name': 'reviewer',
            'language_code': 'en',
            'content': '<p>Content</p>',
            'filename': 'audio_file.mp3',
            'rejection_message': None
        }
        self.assertEqual(
            self.voiceover_application.to_dict(), expected_dict)