Source Code for Module buildbot.util.sautils

 1  # This file is part of Buildbot.  Buildbot is free software: you can 
 2  # redistribute it and/or modify it under the terms of the GNU General Public 
 3  # License as published by the Free Software Foundation, version 2. 
 4  # 
 5  # This program is distributed in the hope that it will be useful, but WITHOUT 
 6  # ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS 
 7  # FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more 
 8  # details. 
 9  # 
10  # You should have received a copy of the GNU General Public License along with 
11  # this program; if not, write to the Free Software Foundation, Inc., 51 
12  # Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. 
13  # 
14  # Copyright Buildbot Team Members 
15   
16  # from http://www.sqlalchemy.org/docs/core/compiler.html#compiling-sub-elements-of-a-custom-expression-construct 
17   
18  from sqlalchemy.ext import compiler 
19  from sqlalchemy.sql.expression import Executable, ClauseElement 
20   
21 -class InsertFromSelect(Executable, ClauseElement): 
22      """ 
23      An L{Executable} that can insert into C{table} the values from C{select} 
24      """ 
25 -    def __init__(self, table, select): 
26          self.table = table 
27          self.select = select 
28   
29  @compiler.compiles(InsertFromSelect) 
30 -def _visit_insert_from_select(element, compiler, **kw): 
31      return "INSERT INTO %s %s" % ( 
32          compiler.process(element.table, asfrom=True), 
33          compiler.process(element.select) 
34      ) 
35