oarj3=> select column_name,data_type from information_schema.columns where table_name like 'urls';
column_name | data_type
-----------------+-------------------
date_checked | date
http_code | integer
base_uri | text
host_alive | boolean
last_check_good | boolean
count_fails | integer
count_success | integer
pri | boolean
url | text
table_id | integer
tbl | character varying
id | integer
(12 rows)
####
dbicdump -o dump_directory=./lib/perl -o debug=1 EDINA::ORI dbi:Pg:dbname=oarj3;host=[host];port=[port] [username] [password]
####
__PACKAGE__->add_columns(
"id",
{
data_type => "integer",
is_auto_increment => 1,
is_nullable => 0,
sequence => "urls_id_seq",
},
"table",
{ accessor => undef, data_type => "varchar", is_nullable => 0, size => 20 },
"table_id",
{ data_type => "integer", is_nullable => 0 },
"url",
{ data_type => "text", is_nullable => 0 },
"primary",
{ data_type => "boolean", default_value => \"false", is_nullable => 0 },
);
####
EDINA::ORI::Result::Url->table("urls");
Column 'table' in table 'urls' collides with an inherited method.
See "COLUMN ACCESSOR COLLISIONS" in perldoc DBIx::Class::Schema::Loader::Base .
EDINA::ORI::Result::Url->add_columns(
"id",
{
data_type => "integer",
is_auto_increment => 1,
is_nullable => 0,
sequence => "urls_id_seq",
},
"table",
{ accessor => undef, data_type => "varchar", is_nullable => 0, size => 20 },
"table_id",
{ data_type => "integer", is_nullable => 0 },
"url",
{ data_type => "text", is_nullable => 0 },
"primary",
{ data_type => "boolean", default_value => \"false", is_nullable => 0 },
);
DBIx::Class::Schema::Loader::make_schema_at(): urls has no primary key at /usr/local/bin/dbicdump line 178