Bug #101608 for SQL-Translator: Got error parsing a simple dump of an sqlite database

Sun Jan 18 21:58:29 2015 dimytch [...] jvs-service.com.ua - Ticket created

Subject:	Got error parsing a simple dump of an sqlite database
Date:	Mon, 19 Jan 2015 04:58:12 +0200
To:	bug-SQL-Translator [...] rt.cpan.org
From:	ДП <dimytch [...] jvs-service.com.ua>

I'm not sure which exactly email should I use. Sent that already to bug-SQL-Translator-Parser-SQLite@rt.cpan.org ======== Archlinux x64 3.18.2-2-ARCH #1 SMP PREEMPT # sqlite3 --version 3.8.7.4 2014-12-09 01:34:36 f66f7a17b78ba617acde90fc810107f34f1a1f2e # sqlite3 db/development.sqlite3 .dump > db/development.sqlite3.sql # sqlt-graph -d SQLite -t svg -o db/development.sqlite3.svg --natural-join-pk -c --show-constraints db/development.sqlite3 Error: translate: Error with parser 'SQL::Translator::Parser::SQLite': Unable to parse line 1: 'SQLite format 3@ -8b--�' '�8��4/.,%& "' +��p^L:(��tbP>,��xfTB0 �+)20140125205141*)20140104184410))20131005214916()20131004204055')20131003191702&)20130816202119%)20130710203000$)20130709201736#)20130626202544")20130603210837!)20130403142148 )20130303194626)20130303193958)20130303193539)20121101190009)20121026213542)20121026205727)20121010204647)20120921220813)20120921220138)20120906231318)20120810001033)20120810000006)20120809141715)20120809004756)20120803041641)20120803040631)20120802203305)201208021)2012073116522292308 )20120729231628 )20120729231230' ')20120729190513 )20120729185015)20120729182035)20120729174648)20120729164016)20120729163311)20120722003603)20120722001722)20120720221116)20120720220642' '+��|iVC0' ... ==== Database is made by the ruby code in schema.rb //Dimitri

Download development.sqlite3.sql
application/sql 10.5k

Message body not shown because it is not plain text.

Download schema.rb
application/x-ruby 8.2k

Message body not shown because it is not plain text.

Download development.sqlite3
application/octet-stream 56k

Message body not shown because it is not plain text.

Download smime.p7s
application/pkcs7-signature 4.1k

Message body not shown because it is not plain text.

Mon Jan 19 03:35:40 2015 ilmari [...] ilmari.org - Correspondence added

CC:	undisclosed-recipients:;
Subject:	Re: [rt.cpan.org #101608] Got error parsing a simple dump of an sqlite database
Date:	Mon, 19 Jan 2015 09:35:20 +0100
To:	bug-SQL-Translator [...] rt.cpan.org
From:	ilmari [...] ilmari.org (Dagfinn Ilmari Mannsåker)

"ДП via RT" <bug-SQL-Translator@rt.cpan.org> writes: Show quoted text

> # sqlite3 --version > 3.8.7.4 2014-12-09 01:34:36 f66f7a17b78ba617acde90fc810107f34f1a1f2e > > # sqlite3 db/development.sqlite3 .dump > db/development.sqlite3.sql > > # sqlt-graph -d SQLite -t svg -o db/development.sqlite3.svg > --natural-join-pk -c --show-constraints db/development.sqlite3

You are trying to parse the SQLite database file, not the SQL dump file. Does it work if you specify db/development.sqlite3.sql instead? Note that .dump outputs the table content as well (as INSERT statements), which SQL::Translator does not handle. To dump just the schema, use the .schema command instead. Show quoted text

> Error: translate: Error with parser 'SQL::Translator::Parser::SQLite': > Unable to parse line 1: > 'SQLite format 3@ -8b--�' > '�8��4/.,%& "' > +��p^L:(��tbP>,��xfTB0 > > > �+)20140125205141*)20140104184410))20131005214916()20131004204055')20131003191702&)20130816202119%)20130710203000$)20130709201736#)20130626202544")20130603210837!)20130403142148 > )20130303194626)20130303193958)20130303193539)20121101190009)20121026213542)20121026205727)20121010204647)20120921220813)20120921220138)20120906231318)20120810001033)20120810000006)20120809141715)20120809004756)20120803041641)20120803040631)20120802203305)201208021)2012073116522292308 > )20120729231628 > )20120729231230' > ')20120729190513 > )20120729185015)20120729182035)20120729174648)20120729164016)20120729163311)20120722003603)20120722001722)20120720221116)20120720220642' > '+��|iVC0' > ... > > ==== > Database is made by the ruby code in schema.rb > > //Dimitri > > > >

-- - Twitter seems more influential [than blogs] in the 'gets reported in the mainstream press' sense at least. - Matt McLeod - That'd be because the content of a tweet is easier to condense down to a mainstream media article. - Calle Dybedahl

Mon Jan 19 03:35:40 2015 The RT System itself - Status changed from 'new' to 'open'

Mon Jan 19 04:40:12 2015 dimytch [...] jvs-service.com.ua - Correspondence added

Subject:	Re: [rt.cpan.org #101608] Got error parsing a simple dump of an sqlite database
Date:	Mon, 19 Jan 2015 11:39:50 +0200
To:	bug-SQL-Translator [...] rt.cpan.org
From:	ДП <dimytch [...] jvs-service.com.ua>

Oh sorry, mea culpa. But parsing sql also does not work. # sqlt-graph -d SQLite -t svg -o db/development.sqlite3.svg --natural-join-pk -c --show-constraints db/development.sqlite3.sql Error: translate: Error with parser 'SQL::Translator::Parser::SQLite': Unable to parse line 1: 'PRAGMA foreign_keys=OFF;' 'BEGIN TRANSACTION;' 'CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL);' 'INSERT INTO "schema_migrations" VALUES('20120720220642');' 'INSERT INTO "schema_migrations" VALUES('20120720221116');' ... code 255 //DP 19.01.2015 10:35, (Dagfinn Ilmari Mannsåker) via RT пишет: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=101608 > > > "ДП via RT" <bug-SQL-Translator@rt.cpan.org> writes: >

>> # sqlite3 --version >> 3.8.7.4 2014-12-09 01:34:36 f66f7a17b78ba617acde90fc810107f34f1a1f2e >> >> # sqlite3 db/development.sqlite3 .dump > db/development.sqlite3.sql >> >> # sqlt-graph -d SQLite -t svg -o db/development.sqlite3.svg >> --natural-join-pk -c --show-constraints db/development.sqlite3

> > You are trying to parse the SQLite database file, not the SQL dump > file. Does it work if you specify db/development.sqlite3.sql instead? > > Note that .dump outputs the table content as well (as INSERT > statements), which SQL::Translator does not handle. To dump just the > schema, use the .schema command instead. >

>> Error: translate: Error with parser 'SQL::Translator::Parser::SQLite': >> Unable to parse line 1: >> 'SQLite format 3@ -8b--�' >> '�8��4/.,%& "' >> +��p^L:(��tbP>,��xfTB0 >> >> >> �+)20140125205141*)20140104184410))20131005214916()20131004204055')20131003191702&)20130816202119%)20130710203000$)20130709201736#)20130626202544")20130603210837!)20130403142148 >> )20130303194626)20130303193958)20130303193539)20121101190009)20121026213542)20121026205727)20121010204647)20120921220813)20120921220138)20120906231318)20120810001033)20120810000006)20120809141715)20120809004756)20120803041641)20120803040631)20120802203305)201208021)2012073116522292308 >> )20120729231628 >> )20120729231230' >> ')20120729190513 >> )20120729185015)20120729182035)20120729174648)20120729164016)20120729163311)20120722003603)20120722001722)20120720221116)20120720220642' >> '+��|iVC0' >> ... >> >> ==== >> Database is made by the ruby code in schema.rb >> >> //Dimitri >> >> >> >>

>

Download smime.p7s
application/pkcs7-signature 4.1k

Message body not shown because it is not plain text.

Mon Jan 19 06:03:23 2015 ilmari [...] ilmari.org - Correspondence added

CC:	undisclosed-recipients:;
Subject:	Re: [rt.cpan.org #101608] Got error parsing a simple dump of an sqlite database
Date:	Mon, 19 Jan 2015 12:02:58 +0100
To:	bug-SQL-Translator [...] rt.cpan.org
From:	ilmari [...] ilmari.org (Dagfinn Ilmari Mannsåker)

As I mentionned in my second paragraph, you need to use .schema to dump just the table structure. The .dump commmand dumps all the data as well, which SQL::Translator does not handle. "ДП via RT" <bug-SQL-Translator@rt.cpan.org> writes: Show quoted text

> Queue: SQL-Translator > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=101608 > > > Oh sorry, mea culpa. > But parsing sql also does not work. > > # sqlt-graph -d SQLite -t svg -o db/development.sqlite3.svg > --natural-join-pk -c --show-constraints db/development.sqlite3.sql > Error: translate: Error with parser 'SQL::Translator::Parser::SQLite': > Unable to parse line 1: > 'PRAGMA foreign_keys=OFF;' > 'BEGIN TRANSACTION;' > 'CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL);' > 'INSERT INTO "schema_migrations" VALUES('20120720220642');' > 'INSERT INTO "schema_migrations" VALUES('20120720221116');' > ... > code 255 > > //DP > > 19.01.2015 10:35, (Dagfinn Ilmari Mannsåker) via RT пишет:

>> <URL: https://rt.cpan.org/Ticket/Display.html?id=101608 > >> >> "ДП via RT" <bug-SQL-Translator@rt.cpan.org> writes: >>

>>> # sqlite3 --version >>> 3.8.7.4 2014-12-09 01:34:36 f66f7a17b78ba617acde90fc810107f34f1a1f2e >>> >>> # sqlite3 db/development.sqlite3 .dump > db/development.sqlite3.sql >>> >>> # sqlt-graph -d SQLite -t svg -o db/development.sqlite3.svg >>> --natural-join-pk -c --show-constraints db/development.sqlite3

>> >> You are trying to parse the SQLite database file, not the SQL dump >> file. Does it work if you specify db/development.sqlite3.sql instead? >> >> Note that .dump outputs the table content as well (as INSERT >> statements), which SQL::Translator does not handle. To dump just the >> schema, use the .schema command instead. >>

>>> Error: translate: Error with parser 'SQL::Translator::Parser::SQLite': >>> Unable to parse line 1: >>> 'SQLite format 3@ -8b--�' >>> '�8��4/.,%& "' >>> +��p^L:(��tbP>,��xfTB0 >>> >>> >>> �+)20140125205141*)20140104184410))20131005214916()20131004204055')20131003191702&)20130816202119%)20130710203000$)20130709201736#)20130626202544")20130603210837!)20130403142148 >>> )20130303194626)20130303193958)20130303193539)20121101190009)20121026213542)20121026205727)20121010204647)20120921220813)20120921220138)20120906231318)20120810001033)20120810000006)20120809141715)20120809004756)20120803041641)20120803040631)20120802203305)201208021)2012073116522292308 >>> )20120729231628 >>> )20120729231230' >>> ')20120729190513 >>> )20120729185015)20120729182035)20120729174648)20120729164016)20120729163311)20120722003603)20120722001722)20120720221116)20120720220642' >>> '+��|iVC0' >>> ... >>> >>> ==== >>> Database is made by the ruby code in schema.rb >>> >>> //Dimitri >>> >>> >>> >>>

>>

> >

-- - Twitter seems more influential [than blogs] in the 'gets reported in the mainstream press' sense at least. - Matt McLeod - That'd be because the content of a tweet is easier to condense down to a mainstream media article. - Calle Dybedahl

Mon Jan 19 07:22:39 2015 dimytch [...] jvs-service.com.ua - Correspondence added

Subject:	Re: [rt.cpan.org #101608] Got error parsing a simple dump of an sqlite database
Date:	Mon, 19 Jan 2015 14:22:21 +0200
To:	bug-SQL-Translator [...] rt.cpan.org
From:	ДП <dimytch [...] jvs-service.com.ua>

I'm sorry for stupidity. All is working. Result is unreadable, but my ticket is wrong. //Dimitri 19.01.2015 13:03, (Dagfinn Ilmari Mannsåker) via RT пишет: Show quoted text

> As I mentionned in my second paragraph, you need to use .schema

Download smime.p7s
application/pkcs7-signature 4.1k

Message body not shown because it is not plain text.

Mon Jan 19 07:44:12 2015 ilmari+cpan [...] ilmari.org - Correspondence added

Glad you got it working. Marking ticket as rejected.

Mon Jan 19 07:44:25 2015 ilmari+cpan [...] ilmari.org - Status changed from 'open' to 'rejected'