替换数据库中的句子中的单词（Python/Django）

Question

我有一个这样的字符串句子结构：

从$Duration%开始，$Noun$将是$形容词$

我需要一个视图来检查“$$”中有哪些单词，并将它们替换为从SQL文件导入的数据库中的随机单词。在

以下是模型/sql文件：

from django.db import models
from django.utils import timezone

class Type(models.Model):
    type = models.CharField(max_length=50)
    value = models.CharField(max_length=1)


class Word(models.Model):
    dict = models.CharField(max_length=200)
    kind = models.CharField(max_length=1)

    def randword(self):
        words = self.objects.all()
        number = randrang(0,len(words))
        return words[number]


class Question(models.Model):
    question = models.CharField(max_length=200)

    def randquest(self):
        quests = self.objects.all()
        numbeq = randrang(0, len(quests))
        return quests[numbeq]


class Meta(models.Model):
    question = models.ForeignKey(Question)
    score = models.ForeignKey("Score")
    user = models.CharField(max_length=200)
    time = models.DateTimeField('date published')


class Score(models.Model):
    word = models.ForeignKey(Word)
    score = models.IntegerField()
    question = models.ManyToManyField(Question, through=Meta)

    def __unicode__(self):
        return self.score

SQL文件

^{pr2}$

以及

INSERT INTO quest_word (dict, kind) VALUES ('Coffee Maker', '1');
INSERT INTO quest_word (dict, kind) VALUES ('24 hours', '3');
INSERT INTO quest_word (dict, kind) VALUES ('today', '3');
INSERT INTO quest_word (dict, kind) VALUES ('broken', '2');
INSERT INTO quest_word (dict, kind) VALUES ('Email server', '1');
INSERT INTO quest_word (dict, kind) VALUES ('15 minutes', '3');
INSERT INTO quest_word (dict, kind) VALUES ('tomorrow', '3');
INSERT INTO quest_word (dict, kind) VALUES ('unavailable', '2');


INSERT INTO quest_type (type, value) VALUES ('Noun', '1');
INSERT INTO quest_type (type, value) VALUES ('Adjective', '2');
INSERT INTO quest_type (type, value) VALUES ('Duration', '3');

我开始写视图。需要帮助：

from quest.models import Word, Type, Score, Question, Meta
from django.utils import timezone


def question(request):
    sentence = Question.objects.all()
    find_words = re.findall(r"\w+%0-9a-zA-Z%", sentence.question)

Answer 1

如果您愿意更改符号，您有两种选择：

1. Use Python.

   >>> 'Starting in {Duration}, the {Noun} will be {Adjective}'.format(Duration='24 hours', Noun='Coffee Maker', Adjective='broken')
   'Starting in 24 hours, the Coffee Maker will be broken'
   >>> 'Starting in %(Duration)s, the %(Noun)s will be %(Adjective)s' % dict(Duration='24 hours', Noun='Coffee Maker', Adjective='broken')
   'Starting in 24 hours, the Coffee Maker will be broken'
   

2. Use Django.

   >>> from django.template import Context, Template
   >>> t = Template('Starting in {{Duration}}, the {{Noun}} will be {{Adjective}}') 
   >>> c = Context(dict(Duration='24 hours', Noun='Coffee Maker', Adjective='broken'))
   >>> t.render(c)
   u'Starting in 24 hours, the Coffee Maker will be broken'
   

剩下的部分是从数据库中提取并在random处选择单词，这是最简单的部分。在