How do I check SQLite3 syntax?

Posted by Benjamin Oakes on Stack Overflow See other posts from Stack Overflow or by Benjamin Oakes
Published on 2010-05-27T18:32:26Z Indexed on 2010/05/27 18:41 UTC
Read the original article Hit count: 263

Filed under:

sqlite3

|

syntax-checking

Is there a way to check the syntax of a SQLite3 script without running it?

Basically, I'm looking for the SQLite3 equivalent of ruby -c script.rb, perl -c script.pl, php --syntax-check script.php, etc.

I've thought of using explain, but most of the scripts I'd like to check are kept around for reference purposes (and don't necessarily have an associated database). Using explain would also make it hard to use with something like Syntastic. (That is, I'm only wanting to check syntax, not semantics.)

© Stack Overflow or respective owner

Related posts about sqlite3

ruby1.9.1 - sqlite3 problem on ubuntu 9.10 x64 (no such file to load -- sqlite3)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have problem with sqlite3, because it is not working. irb(main):001:0> require 'sqlite3' LoadError: no such file to load -- sqlite3 from (irb):1:in `require' from (irb):1 from /usr/bin/irb:12:in `<main>' I have installed following packages: sudo apt-get install ruby1… >>> More
python sqlite3 won't execute a join, but sqlite3 alone will

as seen on Stack Overflow - Search for 'Stack Overflow'
Using the sqlite3 standard library in python 2.6.4, the following query works fine on sqlite3 command line: select segmentid, node_t, start, number,title from ((segments inner join position using (segmentid)) left outer join titles using (legid, segmentid)) left outer join numbers… >>> More
Snow Leopard upgrade -> reinstalling sqlite3-ruby gem problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I got ruby 1.8.7 (native compiled), rails 2.3.4, OSX 10.6.2 and also sqlite3-ruby. The error I'm getting when accessing the rails app is NameError: uninitialized constant SQLite3::Driver::Native::Driver::API History: I upgraded to snow leopard by migrating my apps with a FW-cable from… >>> More
Compile PHP Error with freetype

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey Guys, I configured PHP myself, included all of the libraries I needed... but then realized I forgot the freetype library. So I went back to my php-5.3.2 directory and ran ./configure '--with-free-type=/usr/local/lib' PHP did the configure fine, no errors. But when I run make: collect2: ld… >>> More
how to enable sqlite3 for php?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to install sqlite3 for php in ubuntu. I install apt-get php5-sqlite3 and edited php.ini to include sqlite3 extension. When I run phpinfo(); I get SQLITE3 SQLite3 support enabled sqlite3 library version 3.4.2 as shown above, sqlite3 is enabled. However, I get "Class SQLite3… >>> More

Related posts about syntax-checking

Ruby syntax checking in vim

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I use vim with various plugins for editing ruby code. I have proper syntax highlighting set up but I was wondering if anyone knew of a way to get ruby syntax checking, similar to what you might see in an IDE such as visual studio, radrails, etc? Something that would simply turn stuff… >>> More
How to write a linter?

as seen on Stack Overflow - Search for 'Stack Overflow'
In my day job I, and others on my team write a lot of hardware models in Verilog-AMS, a language supported primarily by commercial vendors and a few opensource simulator projects. One thing that would make supporting each others code more helpful would be a LINTER that would check our code for common… >>> More
math syntax checker written in python

as seen on Stack Overflow - Search for 'Stack Overflow'
All I need is to check, using python, if a string is a valid math expression or not. For simplicity let's say I just need + - * / operators (+ - as unary too) with numbers and nested parenthesis. I add also simple variable names for completeness. So I can test this way: test("-3 * (2 + 1)") #valid test("-3… >>> More
How do I check SQLite3 syntax?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to check the syntax of a SQLite3 script without running it? Basically, I'm looking for the SQLite3 equivalent of ruby -c script.rb, perl -c script.pl, php --syntax-check script.php, etc. I've thought of using explain, but most of the scripts I'd like to check are kept around for reference… >>> More
Does anyone know of a syntax checker for classic ASP ?

as seen on Stack Overflow - Search for 'Stack Overflow'
As part of my my web development system I have written a text editor witch (among other formats like CSS and HTML) has got ASP syntax highlighting. Does anyone know of an ASP syntax checker program of (preferably) DLL that I could call from within this editor, so that I could present my users with… >>> More