Closed michalskop closed 9 years ago
Can you make a PR with those fixes? It would help a lot!
Unfortunately, I cannot make a pull request. I actually do not know how to make the Does not work stuff to get working, nor the Missing examples (even after several hours of playing with it).
I have tried the _sqlaexample.py from the /examples, but could not replicate some of the examples from the documentation (and similar):
Works:
both return 1 record
returns 4 records
returns 1 record
Does not work:
returns 0 records
returns 0 records
returns code 500 and error message simplejson.scanner.JSONDecodeError: Invalid \X escape sequence '\': line 1 column 29 (char 28) // Werkzeug Debugger
returns code 500 and error message simplejson.scanner.JSONDecodeError: Invalid \X escape sequence '\': line 1 column 29 (char 28) // Werkzeug Debugger
returns code 500 and error message _sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "NULLS": syntax error [SQL: 'SELECT count(*) AS count_1 \nFROM (SELECT people.firstname || ? || people.lastname AS anon_2, people._created AS peoplecreated, people._updated AS people__updated, people._etag AS peopleetag, people.id AS people_id, people.firstname AS people_firstname, people.lastname AS people_lastname \nFROM people ORDER BY people.lastname DESC NULLS LAST) AS anon1'] [parameters: (' ',)] // Werkzeug Debugger
Missing examples It would be great to add examples: