SQLiteAPI.py 文件源码

def Similarities(self, table, data_sets):
        # This query provides all the data to create the Concentration vs Similarity plot and tables 
        #condition = "DataSet = '" + "' OR DataSet = '".join(data_sets) + "' "
        condition = self.CreateConditionClause_OrSeriesStr(data_sets)

        sql_statement = "SELECT %s.Similarity AS Similarity, %s.Concentration_pg AS Conc_pg, \
                            Sample.Instrument AS SerNo, Sample.DataSetName AS DataSet \
                        FROM \
                            Sample \
                        Inner Join %s ON \
                            %s.id = Sample.%s_foreignkey \
                        WHERE \
                            %s \
                        ORDER BY SerNo, Conc_pg ASC;"  % (table, table, table, table, table, condition)

        return pd.read_sql_query(sql_statement, self.conn)