Das deutsche Python-Forum

Code: Alles auswählen

def SELECT_Topic_Tree(self, Root_Id):
        try:
            self._DB_Cursor.execute("""SELECT %s_forum1.titel, %s_forum1.node_id, %s_forum1.author, %s_forum1.datestamp,
                                      IF ( %s_forum1.node_id = %s_forum1.root_id,
                                      round( (%s_forum1.rgt - 2) / 2, 0),
                                      round( ( (%s_forum1.rgt - %s_forum1.lft - 1) / 2), 0)
                                      ) AS children,
                                      COUNT(*) AS level

                                      FROM %s_forum AS %s_forum1,
                                      %s_forum AS %s_forum2
 
                                      WHERE %s_forum1.root_id = %s
                                      AND %s_forum2.root_id = %s

                                      AND %s_forum1.lft BETWEEN %s_forum2.lft AND %s_forum2.rgt

                                      GROUP BY %s_forum1.LFT"""% (self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  Root_Id,
                                                                  self.Forum_Id,
                                                                  Root_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id,
                                                                  self.Forum_Id) )
            Result = self._DB_Cursor.fetchall()
            return  Result
        except Error, Error_Var:
            raise PyForumDBError(Error_Var)

Code: Alles auswählen

>>> a=1
>>> "%i, %i"%((a,)*2)
'1, 1'
"%(id)i, %(id)i"%{"id":a}
'1, 1'