Hello,
I have some problems with SQL Fairy when I try to work with a SQLite
database. After some investigations, the problem seem to be that the SQLite
grammar has evolved.
By example, if you create a simple database like that :
# sqlite3 test.db
Loading resources from /Users/manu/.sqliterc
SQLite version 3.3.13
Enter ".help" for instructions
sqlite> create table test (
...> test integer not null primary key autoincrement);
sqlite> .exit
# sqlt -f DBI --dsn "dbi:SQLite:dbname=./test.db" -t XML
"my" variable $v masks earlier declaration in same scope at
/Library/Perl/5.8.6/SQL/Translator/Parser/DBI/DB2.pm line 274.
ERROR (line 1): Invalid statement: Was expecting begin transaction,
or
commit, or drop, or comment, or create
<?xml version="1.0" encoding="UTF-8"?>
<!--
Created by SQL::Translator::Producer::XML::SQLFairy
Created on Sun Aug 12 11:41:56 2007
-->
<schema name="" database="" xmlns="
http://sqlfairy.sourceforge.net/sqlfairy.xml";>
<extra />
<tables></tables>
<views></views>
<triggers></triggers>
<procedures></procedures>
</schema>
I've tried to update the SQL::Translator::Parser::SQLite module,
unfortunately, the learning curve is quite high for me.
Is there anybody who can help me ?
Thanks in advance,
Emmanuel Di Pretoro
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
--
sqlfairy-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
