def update_details(self):
if self.valid:
self._connection.execute(
GALAXY_DETAIL.update().where(
and_(
GALAXY_DETAIL.c.galaxy_id == self.galaxy_id,
GALAXY_DETAIL.c.table_name == self.table_name
)
).values(
mean=self.mean,
standard_deviation=self.standard_deviation
)
)
def insert_details(self):
if self.valid:
self._connection.execute(
GALAXY_DETAIL.insert().values(
galaxy_id=self.galaxy_id,
table_name=self.table_name,
count=self.count,
min_value=self.min_value,
max_value=self.max_value,
percentile_10=self.percentile_10,
percentile_20=self.percentile_20,
percentile_25=self.percentile_25,
percentile_30=self.percentile_30,
percentile_40=self.percentile_40,
percentile_50=self.percentile_50,
percentile_60=self.percentile_60,
percentile_70=self.percentile_70,
percentile_75=self.percentile_75,
percentile_80=self.percentile_80,
percentile_90=self.percentile_90,
mean=self.mean,
standard_deviation=self.standard_deviation
)
)