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 setUp(self):
        super(ExplorationVoiceoverApplicationUnitTest, self).setUp()
        self.signup('author@example.com', 'author')
        self.author_id = self.get_user_id_from_email('author@example.com')

        self.signup('reviewer@example.com', 'reviewer')
        self.reviewer_id = self.get_user_id_from_email('reviewer@example.com')

        self.voiceover_application = (
            suggestion_registry.ExplorationVoiceoverApplication(
                'application_id', 'exp_id', suggestion_models.STATUS_IN_REVIEW,
                self.author_id, None, 'en', 'audio_file.mp3', '<p>Content</p>',
                None))