sqlalchemy-datatables
sqlalchemy-datatables copied to clipboard
SQLAlchemy integration of jQuery DataTables >= 1.10.x (Pyramid and Flask examples)
Hi, thanks for the work done. I am using fastapi and have integrated your project, everything works except if the order of the front end is different from the backend,...
I noticed that it is possible to do custom rendering for column with `ColumnDT("" + User.id + "")`. How can I differ how the data is rendered according to a...
``` @app.route("/data", methods=['GET']) def data(): columns = [ ColumnDT(Customer.id), ColumnDT(Customer.Email), ] query = db.session.query(Customer) params = request.args.to_dict() rowTable = DataTables(params, query, columns) print(query , file=sys.stdout) return jsonify(rowTable.output_result()) ``` and i...
FYI, the link to the Flask example is broken in the center page text. The link on the left nav works fine though
Ability to escape data before output, to prevent JS/HTML injections.
I am getting the following error when I try to perform a global search while using an oracle database. I'm not sure if this is an issue with sqlalchemy-datatables, sqlalchemy,...
Hi, I'm listing the following table in my datatable (simplified version): ``` class MainTerm(db.Model): __tablename__ = 'main_term' id = db.Column(db.Integer, primary_key=True) text = db.Column(db.String) ``` Further I have gazetteers that...
**Regarding this [issue](https://github.com/Pegase745/sqlalchemy-datatables/issues/131), I have come up with a ```_map_columns_with_params ``` private method in DataTables class in datatables.py module.** This method compares columns data with the parameters data and map...
I'm having trouble lining up the self.columns index with the index which comes from datatables(js) in the search item. My indexes don't match sometimes because I have to post process...