Question

::

counters = Counter.objects.raw("""
            SELECT id, name FROM building_counter c
            INNER JOIN scope_scope_buildings ssb 
                    ON c.building_id = ssb.building_id
                    AND ssb.scope_id = %s
            WHERE  energy_id = %s
            AND parent_id is not NULL
            AND type = "C"
           """, [self.id, energy_id])

The result gave me :

TypeError: not enough arguments for format string 
[2, 1L]

I don t understand what s wrong with it :s

Answer 1

真正的问题是,你把名单转至准点,但随后,你又试图将结果称为repr(我只知道这一点,因为我当时在开始时就遇到了同样的问题)。你们需要做的是:

counters = Counter.objects.raw("""
        SELECT id, name FROM building_counter c
        INNER JOIN scope_scope_buildings ssb 
                ON c.building_id = ssb.building_id
                AND ssb.scope_id = %s
        WHERE  energy_id = %s
        AND parent_id is not NULL
        AND type =  C 
       """, (self.id, energy_id))

或者,你可以将

如果你经常不使用批量进行原始询问,那么你就只能无视这一点,因为jan子的其余部分只处理准武器。

Answer 2

页: 1

counters = Counter.objects.raw("""
        SELECT id, name FROM building_counter c
        INNER JOIN scope_scope_buildings ssb 
                ON c.building_id = ssb.building_id
                AND ssb.scope_id =  %s 
        WHERE  energy_id =  %s 
        AND parent_id is not NULL
        AND type =  C 
       """, [self.id, energy_id])

Answer 3

你们也需要自食其力地为第一任持有人使用 %。补贴将是一种激励,而不是一种强硬。 %d 表明在那个时间段内预计会出现t。

友情链接