349cfbdebfb05d2faf51ae7c82eca81c97ed5c49,deeppavlov/core/data/sqlite_database.py,Sqlite3Database,_search,#Sqlite3Database#Any#Any#Any#,84

Before Change

                self.cursor.execute("SELECT * FROM {}".format(self.tname) +
                                    " ORDER BY {} {}".format(order_by, order))
            else:
                self.cursor.execute("SELECT * FROM {}".format(self.tname))
        else:
            keys = list(kv.keys())
            values = [kv[k] for k in keys]
            where_expr = " AND ".join("{}=?".format(k) for k in keys)
            if order_by is not None:
                self.cursor.execute("SELECT * FROM {}".format(self.tname) +
                                    " WHERE {}".format(where_expr) +
                                    " ORDER BY {} {}".format(order_by, order),
                                    values)
            else:

After Change

        else:
            keys = list(kv.keys())
            values = [kv[k] for k in keys]
            where_expr = " AND ".join(f"{k}=?" for k in keys)
            if order_by is not None:
                self.cursor.execute(f"SELECT * FROM {self.tname}" +
                                    f" WHERE {where_expr}" +
                                    f" ORDER BY {order_by} {order}",

Instances