def execute(self):
if self.old_var.text().strip():
old_column = Column.get_by_name(self.old_var.text().strip())
new_column = None
if self.same.isChecked():
new_column = Column.get_by_name(self.new_var.text().strip())
recode = Recode(old_column, new_column)
recode.execute()
def execute(self):
query = Query(select=self.input.toPlainText())
query.execute()
if query.error == Query.NoError:
var_name = self.target.text().strip()
column = None
new_column = False
if var_name:
logger.debug("var_name={}".format(var_name))
column = Column.get_by_name(var_name)
if not column:
column = Column(Column.count(), name=var_name)
new_column = True
logger.debug("new_column={}".format(new_column))
for row, data in query.result.items():
if new_column:
Cell(row, column.id, data=data)
else:
cell = Cell.get(row, column.id)
cell.data = data
