def sql(self):
if not self.sql_table:
raise Exception("SQLTable not set")
tab = self.sql_table
tn = tab.tablename
cav = self.get_cols_and_vals()
cols = SQLFormat.columns_join(cav[0])
vals = SQLFormat.values_join(cav[1])
stt = "INSERT INTO %s ( %s ) VALUES ( %s );" % (tn, cols, vals)
return stt
def sql_fed_from(self, table):
if not table:
raise Exception("SQLTable not set")
tn = table.tablename
columns = ["id", "pttsitepump_id", "pttsitetank_id"]
cols = SQLFormat.columns_join(columns)
stt = ""
for tank in self.fed_from:
v = [str(table.get_next_id()), str(self.get_id()), str(tank.get_id())]
vals = SQLFormat.values_join(v)
stt += "INSERT INTO %s ( %s ) VALUES ( %s );\n" % (tn, cols, vals)
if stt == None:
return ""
return stt[:-1]
