Python Model.fetchAllRows примеры использования

Пример #1

Файл: sentence.py Проект: hekevintran/Rpg

	def loadByCharacterIdAndTriggerWord(idCharacter, triggerWord):
		query = "\
			SELECT\
				ta.id_talk_answer,\
				trigger_word,\
				sentence,\
				condition\
			FROM\
				talk_answer ta\
				INNER JOIN character_answer ca\
					ON ca.id_talk_answer = ta.id_talk_answer\
			WHERE\
				trigger_word = ?\
				AND id_character = ?\
			ORDER BY RANDOM()\
			"

		return Model.fetchAllRows(query, (triggerWord, idCharacter))