[sqlalchemy] Syntax Checking

2015-07-24 Thread Rich Shepard
Because this is my first SQLAlchemy project and the schema file has 657 lines I would like to check for syntax errors before proceeding with the next step in application development. I find no index in the SA manual and cannot find the string 'syntax check' in the PDF file. Web search turns up

Re: [sqlalchemy] Syntax Checking

2015-07-24 Thread Mike Bayer
On 7/24/15 1:49 PM, Rich Shepard wrote: Because this is my first SQLAlchemy project and the schema file has 657 lines I would like to check for syntax errors before proceeding with the next step in application development. I find no index in the SA manual and cannot find the string 'syntax

Re: [sqlalchemy] Syntax Checking

2015-07-24 Thread Rich Shepard
On Fri, 24 Jul 2015, Mike Bayer wrote: Python syntax or SQL syntax? Mike, The former. Typically in Python we rely on linters and runtime checks for this, same idea with SQL. Have not used a lint before with Python, but will run it on my SQLAlchemy code. I know that SQLite and

Re: [sqlalchemy] Syntax Checking

2015-07-24 Thread Jonathan Vanasco
flake8 is super simple - it checks your code for mistakes (undeclared vars, non-runnable code, etc) and pushes you to write pep8 style code. the only things you need to do really are: * write a .cfg for various projects, so you can turn off some warnings * get in the habit of running it before

Re: [sqlalchemy] Syntax Checking

2015-07-24 Thread Jonathan Vanasco
In terms of linters, `flake8` (https://pypi.python.org/pypi/flake8) catches most mistakes I've made with SqlAlchemy. It's also useful to start writing Unit Tests that will interact with your SqlAlchemy models in predicted ways -- in addition to continually checking core functionality. -- You

Re: [sqlalchemy] Syntax Checking

2015-07-24 Thread Rich Shepard
On Fri, 24 Jul 2015, Jonathan Vanasco wrote: In terms of linters, `flake8` (https://pypi.python.org/pypi/flake8) catches most mistakes I've made with SqlAlchemy. It's also useful to start writing Unit Tests that will interact with your SqlAlchemy models in predicted ways -- in addition to