SQLiteAPI.py 文件源码

def DataSetAnalytes(self, data_set, TableProcessingToReturn='Both_PeakFinding_TargetAnalyteFinding'):
        # Query all foreign key columns in Sample table and return a list of all analyts that are
        # found in a given data set.
        column_string = self.createQueryColumnsStr(TableProcessingToReturn)

        # Build SQL statement & Query sample table for all foreign key columns of a given data set
        sql_statement = "SELECT %s FROM Sample WHERE Sample.DataSetName = '%s';" % (column_string, data_set)        
        df = pd.read_sql_query(sql_statement, self.conn)

        return self.GetFoundAnalytesLst(df)