Re: dbicdump not importing the full table (Postgres)

in reply to dbicdump not importing the full table (Postgres)

Environment - Perl: Ububtu 12.04; Perl 5.14.2; all packages installed via .debs. Database: postgres database on a Sun server. ... I am using dbicdump to create a pile of DBIx::Class ...

Upgrade to latest dbicdump version ?

perl -MDevel::Modlist -S dbicdump ...

Or dump schema using pg_dump -n schema ... so that others (me) can try sqlt on the output :)

Or try http://search.cpan.org/perldoc/Catalyst::Helper::Model::DBIC::Schema#TYPICAL_EXAMPLES to see if you get something different

Comment on Re: dbicdump not importing the full table (Postgres)

Replies are listed 'Best First'.
Re^2: dbicdump not importing the full table (Postgres) by kiz (Monk) on May 09, 2012 at 12:05 UTC
Hmmmm... the plot thickens! W did some testing with a colleague, who had got good results when he demonstrated the advantage of Catalyst to me. He's running Perl 5.12, I'm on 5.14 We are running the same version of catalyst He's running DBIx::Class::Schema::Loader 0.07017, I went from 0.07020 to 0.07023 I have rolled back to ::::Loader 0.07017, and I'm no longer getting errors. I would class this as a bug, and will report it back. Thankee for your time, and attention. -- Ian Stuart A man depriving some poor village, somewhere, of a first-class idiot.	[reply]
Re^2: dbicdump not importing the full table (Postgres) by Anonymous Monk on May 08, 2012 at 12:18 UTC
the sqlt test suite is good :) Create table schema manually from description Read more... (2 kB) and sqlt doesn't appear to miss anything either output from `sqlt -f PostgreSQL -t DBIx::Class::File --prefix=EDINA::ORI < in > out` Read more... (4 kB) Is this a bug in dbicdump ? I can't tell :)	[reply] [d/l] [select]
Re^2: dbicdump not importing the full table (Postgres) by kiz (Monk) on May 08, 2012 at 15:57 UTC
dbicdump: Hmmm - Ubuntu has packaged 0.07010, and CPAN has 0.07023... I'll have a look at the changes file! pg_dump: I've removed a pile of PostGIS stuff from this (I think I got it all....) Read more... (47 kB)	[reply] [d/l]
Re^3: dbicdump not importing the full table (Postgres) by Anonymous Monk on May 08, 2012 at 16:30 UTC
FWIW, sqlt SQL::Translator v0.11010 chokes on `COMMENT ON TABLE xml IS 'Full XML records, to test for changes. We don''t need to know the repo or anything: if the XML we have to pro +cess matches a record, then we can skip to the next record.';` [download] and `ALTER SEQUENCE "Sources_id_seq" OWNED BY networks.id;` [download] but otherwise merrily generates a gigantic module with no missing fields, same as it did your original snippet at Re^2: dbicdump not importing the full table (Postgres) I did not try the latest dev version RIBASUSHI/SQL-Translator-0.11010_06.tar.gz	[reply] [d/l] [select]

In Section Seekers of Perl Wisdom