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)



MIME-Version: 1.0
X-Spam-Status: No, score=0.789 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DNS_FROM_AHBL_RHSBL=2.699, T_RP_MATCHES_RCVD=-0.01] autolearn=no
X-Spam-Flag: NO
X-Virus-Checked: Checked
Content-Type: multipart/signed; boundary="------------ms020500070501050602000107"; micalg="sha1"; protocol="application/pkcs7-signature"
Message-ID: <54BC72C4.3000008 [...] jvs-service.com.ua>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: 0.789
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 9C812240220 for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Sun, 18 Jan 2015 21:58:27 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id FoFkvGdTkR-x for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Sun, 18 Jan 2015 21:58:23 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 8E46C2400D8 for <bug-SQL-Translator [...] rt.cpan.org>; Sun, 18 Jan 2015 21:58:22 -0500 (EST)
Received: (qmail 16966 invoked by alias); 19 Jan 2015 02:58:20 -0000
Received: from mail2.jvs-service.com.ua (HELO mail.jvs-service.com.ua) (89.209.126.194) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Sun, 18 Jan 2015 18:58:19 -0800
Received: from avgust.h0 (ppp7-47.tis-dialog.ru [213.149.7.47]) by mail.jvs-service.com.ua (Postfix) with ESMTPSA id 32D5B10D530B9 for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 04:58:14 +0200 (EET)
Delivered-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
Subject: Got error parsing a simple dump of an sqlite database
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0
Return-Path: <dimytch [...] jvs-service.com.ua>
X-RT-Mail-Extension: sql-translator
X-Original-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Date: Mon, 19 Jan 2015 04:58:12 +0200
X-Spam-Level:
To: bug-SQL-Translator [...] rt.cpan.org
From: ДП <dimytch [...] jvs-service.com.ua>
X-RT-Interface: Email
Content-Length: 0
Content-Type: multipart/mixed; boundary="------------070603070500030101030007"
Content-Length: 0
content-type: text/plain; charset="utf-8"; format="flowed"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 1695
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
Content-Type: application/sql; name="development.sqlite3.sql"
Content-Disposition: attachment; filename="development.sqlite3.sql"
Content-Transfer-Encoding: base64
Content-Length: 10839
Download development.sqlite3.sql
application/sql 10.5k

Message body not shown because it is not plain text.

Content-Type: application/x-ruby; name="schema.rb"
Content-Disposition: attachment; filename="schema.rb"
Content-Transfer-Encoding: base64
Content-Length: 8461
Download schema.rb
application/x-ruby 8.2k

Message body not shown because it is not plain text.

Content-Type: application/octet-stream; name="development.sqlite3"
Content-Disposition: attachment; filename="development.sqlite3"
Content-Transfer-Encoding: base64
Content-Length: 57344
Download development.sqlite3
application/octet-stream 56k

Message body not shown because it is not plain text.

Content-Description: Криптографическая подпись S/MIME
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Disposition: attachment; filename="smime.p7s"
Content-Transfer-Encoding: base64
Content-Length: 4270
Download smime.p7s
application/pkcs7-signature 4.1k

Message body not shown because it is not plain text.

X-Amavis-Alert: BAD HEADER SECTION, Improper folded header field made up entirely of whitespace (char 20 hex): X-Exiscan-Spam-Report: ...ping.uio.no\n Score Rule\n \n * -5.0 PING_U[...]
CC: undisclosed-recipients:;
MIME-Version: 1.0
X-Spam-Status: No, score=-3.757 tagged_above=-99.9 required=10 tests=[AWL=-0.556, BAYES_00=-1.9, DNS_FROM_AHBL_RHSBL=2.699, FROM_OUR_RT=-4, RCVD_IN_DNSWL_NONE=-0.0001] autolearn=ham
In-Reply-To: <rt-4.0.18-29674-1421636309-98.101608-4-0 [...] rt.cpan.org> ("ДП via RT"'s message of "Sun, 18 Jan 2015 21:58:35 -0500")
X-Exiscan-Spam-Score: -1.3 (-)
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-101608 [...] rt.cpan.org> <54BC72C4.3000008 [...] jvs-service.com.ua> <rt-4.0.18-29674-1421636309-98.101608-4-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <d8jegqr5fsn.fsf [...] dalvik.ping.uio.no>
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -3.757
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id DF789240590 for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 19 Jan 2015 03:35:38 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id qtDsr0UAqrJK for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 19 Jan 2015 03:35:32 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 009AD2400D8 for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 03:35:31 -0500 (EST)
Received: (qmail 12382 invoked by alias); 19 Jan 2015 08:35:31 -0000
Received: from pike.ping.uio.no (HELO ping.uio.no) (193.157.115.208) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 19 Jan 2015 00:35:29 -0800
Received: from [2001:700:100:570::211] (helo=dalvik.ping.uio.no ident=Debian-exim) by ping.uio.no with esmtp (Exim 4.72 #1 (Debian)) id 1YD7nY-0007AF-9S for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 09:35:02 +0100
Received: from ilmari by dalvik.ping.uio.no with local (Exim 4.72) (envelope-from <ilmari [...] ilmari.org>) id 1YD7nt-0008QU-8M for bug-SQL-Translator [...] rt.cpan.org; Mon, 19 Jan 2015 09:35:21 +0100
Delivered-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
X-Exiscan-Spam-Report: SpamAssassin 3.3.1 (2010-03-16) on pike.ping.uio.no Score Rule * -5.0 PING_UIO_MAIL_IS_INTERNAL Message has never been outside * 129.240.0.0/16 or 193.157.115.0/24 * 2.4 DNS_FROM_AHBL_RHSBL RBL: Envelope sender listed in dnsbl.ahbl.org * 1.3 RDNS_NONE Delivered to internal network by a host with no rDNS
Subject: Re: [rt.cpan.org #101608] Got error parsing a simple dump of an sqlite database
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux)
Return-Path: <ilmari [...] ilmari.org>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
X-RT-Mail-Extension: sql-translator
Date: Mon, 19 Jan 2015 09:35:20 +0100
X-Spam-Level:
X-Quarantine-ID: <qtDsr0UAqrJK>
To: bug-SQL-Translator [...] rt.cpan.org
Content-Transfer-Encoding: 8bit
From: ilmari [...] ilmari.org (Dagfinn Ilmari Mannsåker)
RT-Message-ID: <rt-4.0.18-10937-1421656540-1684.101608-0-0 [...] rt.cpan.org>
Content-Length: 2235
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
MIME-Version: 1.0
X-Spam-Status: No, score=-1.211 tagged_above=-99.9 required=10 tests=[AWL=2.000, BAYES_00=-1.9, DNS_FROM_AHBL_RHSBL=2.699, FROM_OUR_RT=-4, T_RP_MATCHES_RCVD=-0.01] autolearn=ham
In-Reply-To: <rt-4.0.18-10937-1421656540-1479.101608-6-0 [...] rt.cpan.org>
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-101608 [...] rt.cpan.org> <54BC72C4.3000008 [...] jvs-service.com.ua> <rt-4.0.18-29674-1421636309-98.101608-4-0 [...] rt.cpan.org> <d8jegqr5fsn.fsf [...] dalvik.ping.uio.no> <rt-4.0.18-10937-1421656540-1479.101608-6-0 [...] rt.cpan.org>
X-Virus-Checked: Checked
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <54BCD0E6.2010801 [...] jvs-service.com.ua>
Content-Type: multipart/signed; boundary="------------ms040508090101040002050502"; micalg="sha1"; protocol="application/pkcs7-signature"
X-Spam-Score: -1.211
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 9C3FD24071B for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 19 Jan 2015 04:40:11 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 75uySrCbjpp7 for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 19 Jan 2015 04:40:06 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 3780E240590 for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 04:40:05 -0500 (EST)
Received: (qmail 16741 invoked by alias); 19 Jan 2015 09:40:00 -0000
Received: from mail2.jvs-service.com.ua (HELO mail.jvs-service.com.ua) (89.209.126.194) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 19 Jan 2015 01:39:58 -0800
Received: from avgust.h0 (ppp7-47.tis-dialog.ru [213.149.7.47]) by mail.jvs-service.com.ua (Postfix) with ESMTPSA id 7772610D522FE for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 11:39:53 +0200 (EET)
Delivered-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0
Subject: Re: [rt.cpan.org #101608] Got error parsing a simple dump of an sqlite database
Return-Path: <dimytch [...] jvs-service.com.ua>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
X-RT-Mail-Extension: sql-translator
Date: Mon, 19 Jan 2015 11:39:50 +0200
X-Spam-Level:
To: bug-SQL-Translator [...] rt.cpan.org
From: ДП <dimytch [...] jvs-service.com.ua>
RT-Message-ID: <rt-4.0.18-10936-1421660412-830.101608-0-0 [...] rt.cpan.org>
Content-Length: 0
content-type: text/plain; charset="utf-8"; format="flowed"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 2666
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 >> >> >> >>
>
Content-Description: Криптографическая подпись S/MIME
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Disposition: attachment; filename="smime.p7s"
Content-Transfer-Encoding: base64
Content-Length: 4270
Download smime.p7s
application/pkcs7-signature 4.1k

Message body not shown because it is not plain text.

X-Amavis-Alert: BAD HEADER SECTION, Improper folded header field made up entirely of whitespace (char 20 hex): X-Exiscan-Spam-Report: ...ping.uio.no\n Score Rule\n \n * 2.4 DNS_FR[...]
CC: undisclosed-recipients:;
MIME-Version: 1.0
X-Spam-Status: No, score=-3.732 tagged_above=-99.9 required=10 tests=[AWL=-0.531, BAYES_00=-1.9, DNS_FROM_AHBL_RHSBL=2.699, FROM_OUR_RT=-4, RCVD_IN_DNSWL_NONE=-0.0001] autolearn=ham
In-Reply-To: <rt-4.0.18-10936-1421660412-292.101608-5-0 [...] rt.cpan.org> ("ДП via RT"'s message of "Mon, 19 Jan 2015 04:40:13 -0500")
X-Exiscan-Spam-Score: -1.3 (-)
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-101608 [...] rt.cpan.org> <54BC72C4.3000008 [...] jvs-service.com.ua> <rt-4.0.18-29674-1421636309-98.101608-4-0 [...] rt.cpan.org> <d8jegqr5fsn.fsf [...] dalvik.ping.uio.no> <rt-4.0.18-10937-1421656540-1479.101608-6-0 [...] rt.cpan.org> <54BCD0E6.2010801 [...] jvs-service.com.ua> <rt-4.0.18-10936-1421660412-292.101608-5-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <d8ja91f58yl.fsf [...] dalvik.ping.uio.no>
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -3.732
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id AFF80240733 for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 19 Jan 2015 06:03:22 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id R+K4XY6k1ucY for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 19 Jan 2015 06:03:18 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 77CA22404AD for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 06:03:11 -0500 (EST)
Received: (qmail 22187 invoked by alias); 19 Jan 2015 11:03:10 -0000
Received: from pike.ping.uio.no (HELO ping.uio.no) (193.157.115.208) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 19 Jan 2015 03:03:06 -0800
Received: from [2001:700:100:570::211] (helo=dalvik.ping.uio.no ident=Debian-exim) by ping.uio.no with esmtp (Exim 4.72 #1 (Debian)) id 1YDA6P-0002ji-KU for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 12:02:39 +0100
Received: from ilmari by dalvik.ping.uio.no with local (Exim 4.72) (envelope-from <ilmari [...] ilmari.org>) id 1YDA6k-0001s1-Km for bug-SQL-Translator [...] rt.cpan.org; Mon, 19 Jan 2015 12:02:58 +0100
Delivered-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
X-Exiscan-Spam-Report: SpamAssassin 3.3.1 (2010-03-16) on pike.ping.uio.no Score Rule * 2.4 DNS_FROM_AHBL_RHSBL RBL: Envelope sender listed in dnsbl.ahbl.org * -5.0 PING_UIO_MAIL_IS_INTERNAL Message has never been outside * 129.240.0.0/16 or 193.157.115.0/24 * 1.3 RDNS_NONE Delivered to internal network by a host with no rDNS
Subject: Re: [rt.cpan.org #101608] Got error parsing a simple dump of an sqlite database
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux)
Return-Path: <ilmari [...] ilmari.org>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
X-RT-Mail-Extension: sql-translator
Date: Mon, 19 Jan 2015 12:02:58 +0100
X-Spam-Level:
X-Quarantine-ID: <R+K4XY6k1ucY>
To: bug-SQL-Translator [...] rt.cpan.org
Content-Transfer-Encoding: 8bit
From: ilmari [...] ilmari.org (Dagfinn Ilmari Mannsåker)
RT-Message-ID: <rt-4.0.18-6950-1421665403-583.101608-0-0 [...] rt.cpan.org>
Content-Length: 3373
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
MIME-Version: 1.0
X-Spam-Status: No, score=-1.878 tagged_above=-99.9 required=10 tests=[AWL=1.333, BAYES_00=-1.9, DNS_FROM_AHBL_RHSBL=2.699, FROM_OUR_RT=-4, T_RP_MATCHES_RCVD=-0.01] autolearn=ham
In-Reply-To: <rt-4.0.18-6950-1421665404-1818.101608-6-0 [...] rt.cpan.org>
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-101608 [...] rt.cpan.org> <54BC72C4.3000008 [...] jvs-service.com.ua> <rt-4.0.18-29674-1421636309-98.101608-4-0 [...] rt.cpan.org> <d8jegqr5fsn.fsf [...] dalvik.ping.uio.no> <rt-4.0.18-10937-1421656540-1479.101608-6-0 [...] rt.cpan.org> <54BCD0E6.2010801 [...] jvs-service.com.ua> <rt-4.0.18-10936-1421660412-292.101608-5-0 [...] rt.cpan.org> <d8ja91f58yl.fsf [...] dalvik.ping.uio.no> <rt-4.0.18-6950-1421665404-1818.101608-6-0 [...] rt.cpan.org>
X-Virus-Checked: Checked
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <54BCF6FD.20201 [...] jvs-service.com.ua>
Content-Type: multipart/signed; boundary="------------ms000106070301060408030407"; micalg="sha1"; protocol="application/pkcs7-signature"
X-Spam-Score: -1.878
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 2E72D2403BE for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 19 Jan 2015 07:22:38 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uhhxc6jinje0 for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 19 Jan 2015 07:22:33 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 0A5B82403AA for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 07:22:32 -0500 (EST)
Received: (qmail 29887 invoked by alias); 19 Jan 2015 12:22:32 -0000
Received: from mail2.jvs-service.com.ua (HELO mail.jvs-service.com.ua) (89.209.126.194) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 19 Jan 2015 04:22:30 -0800
Received: from avgust.h0 (ppp7-47.tis-dialog.ru [213.149.7.47]) by mail.jvs-service.com.ua (Postfix) with ESMTPSA id 25F0110CFFAD8 for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 19 Jan 2015 14:22:25 +0200 (EET)
Delivered-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0
Subject: Re: [rt.cpan.org #101608] Got error parsing a simple dump of an sqlite database
Return-Path: <dimytch [...] jvs-service.com.ua>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
X-RT-Mail-Extension: sql-translator
Date: Mon, 19 Jan 2015 14:22:21 +0200
X-Spam-Level:
To: bug-SQL-Translator [...] rt.cpan.org
From: ДП <dimytch [...] jvs-service.com.ua>
RT-Message-ID: <rt-4.0.18-649-1421670159-1601.101608-0-0 [...] rt.cpan.org>
Content-Length: 0
content-type: text/plain; charset="utf-8"; format="flowed"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 231
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
Content-Description: Криптографическая подпись S/MIME
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Disposition: attachment; filename="smime.p7s"
Content-Transfer-Encoding: base64
Content-Length: 4270
Download smime.p7s
application/pkcs7-signature 4.1k

Message body not shown because it is not plain text.

MIME-Version: 1.0
In-Reply-To: <54BC72C4.3000008 [...] jvs-service.com.ua>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <54BC72C4.3000008 [...] jvs-service.com.ua>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-2733-1421671452-1316.101608-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 52
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.