SQLiteAPI.py 文件源码

def SensitivityQuery(self, table, data_set):
        # Returns the number of times an analyte is found at each concentration and the
        # number of repetitions in a particular data set.
        sql_statement = "SELECT COUNT(%s.id) AS Count, %s.Concentration_pg AS Conc_pg, \
                            DataSetConcentrations.Repetitions AS Repetitions \
                        FROM \
                            Sample \
                        INNER JOIN %s ON \
                            %s.id = Sample.%s_foreignkey \
                        INNER JOIN DataSetConcentrations ON \
                            DataSetConcentrations.id = Sample.DataSetConcentrations_foreignkey \
                        WHERE \
                            Sample.DataSetName = '%s' \
                        GROUP BY \
                            Conc_pg \
                        ORDER BY \
                            Conc_pg;" % (table, table, table, table, table, data_set)
        return pd.read_sql_query(sql_statement, self.conn)