Skip Menu |
 

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 101608
Status: rejected
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: dimytch [...] jvs-service.com.ua
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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>
Download (untitled) / with headers
text/plain 1.6k
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.

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)
Download (untitled) / with headers
text/plain 2.1k
"ДП 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
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>
Download (untitled) / with headers
text/plain 2.6k
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.

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)
Download (untitled) / with headers
text/plain 3.2k
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
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>
Download (untitled) / with headers
text/plain 231b
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.

Glad you got it working. Marking ticket as rejected.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.