do {
my $a = {
all_article_types => bless({
_result_class => "GTH::Archive::Model::DB::ArticleType",
attrs => { alias => "me" },
cond => undef,
pager => undef,
result_source => bless({
_columns => {
id => { data_type => "INTEGER", is_auto_increment => 1 },
last_update => {
_ic_dt_method => "timestamp",
_inflate_info => { deflate => sub { ... }, inflate => sub { ... } },
data_type => "TIMESTAMP",
dynamic_default_on_create => "get_timestamp",
dynamic_default_on_update => "get_timestamp",
timezone => "America/Los_Angeles",
},
name => { data_type => "TEXT" },
},
_columns_info_loaded => 0,
_ordered_columns => ["id", "name", "last_update"],
_primaries => ["id"],
_relationships => {
articles => {
attrs => {
accessor => "multi",
cascade_copy => 1,
cascade_delete => 1,
is_depends_on => 0,
join_type => "LEFT",
},
class => "GTH::Archive::Schema::Result::Article",
cond => { "foreign.type_id" => "self.id" },
source => "GTH::Archive::Schema::Result::Article",
},
},
_unique_constraints => { primary => 'fix' },
name => "article_type",
result_class => "GTH::Archive::Model::DB::ArticleType",
resultset_attributes => {},
resultset_class => "DBIx::Class::ResultSet",
schema => bless({
class_mappings => {
"GTH::Archive::Model::DB::Article" => "Article",
"GTH::Archive::Model::DB::ArticleContent" => "ArticleContent",
"GTH::Archive::Model::DB::ArticleType" => "ArticleType",
"GTH::Archive::Model::DB::Author" => "Author",
"GTH::Archive::Model::DB::Issue" => "Issue",
"GTH::Archive::Model::DB::TeaOfTheMonth" => "TeaOfTheMonth",
"GTH::Archive::Model::DB::TeaTips" => "TeaTips",
"GTH::Archive::Model::DB::TeaWayfarer" => "TeaWayfarer",
"GTH::Archive::Schema::Result::Article" => "Article",
"GTH::Archive::Schema::Result::ArticleContent" => "ArticleContent",
"GTH::Archive::Schema::Result::ArticleType" => "ArticleType",
"GTH::Archive::Schema::Result::Author" => "Author",
"GTH::Archive::Schema::Result::Issue" => "Issue",
"GTH::Archive::Schema::Result::TeaOfTheMonth" => "TeaOfTheMonth",
"GTH::Archive::Schema::Result::TeaTips" => "TeaTips",
"GTH::Archive::Schema::Result::TeaWayfarer" => "TeaWayfarer",
},
source_registrations => {
Article => bless({
_columns => {
author_id => { data_type => "INTEGER" },
file_num => { data_type => "TEXT" },
id => { data_type => "INTEGER", is_auto_increment => 1 },
issue_id => { data_type => "INTEGER" },
last_update => {
_ic_dt_method => "timestamp",
_inflate_info => { deflate => sub { ... }, inflate => sub { ... } },
data_type => "TIMESTAMP",
dynamic_default_on_create => "get_timestamp",
dynamic_default_on_update => "get_timestamp",
timezone => "America/Los_Angeles",
},
month => { data_type => "TEXT" },
page_length => { data_type => "INTEGER", is_nullable => 1 },
start_page => { data_type => "INTEGER" },
tea_of_the_month_id => { data_type => "INTEGER", is_nullable => 1 },
tea_tips_id => { data_type => "INTEGER", is_nullable => 1 },
tea_wayfarer_id => { data_type => "INTEGER", is_nullable => 1 },
title => { data_type => "TEXT" },
type_id => { data_type => "INTEGER" },
year => { data_type => "TEXT" },
},
_columns_info_loaded => 0,
_ordered_columns => [
"id",
"issue_id",
"file_num",
"type_id",
"title",
"author_id",
"year",
"month",
"start_page",
"page_length",
"tea_of_the_month_id",
"tea_wayfarer_id",
"tea_tips_id",
"last_update",
],
_primaries => ["id"],
_relationships => {
article_type => {
attrs => {
accessor => "single",
fk_columns => { type_id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
join_type => "left",
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::ArticleType",
cond => { "foreign.id" => "self.type_id" },
source => "GTH::Archive::Schema::Result::ArticleType",
},
author => {
attrs => {
accessor => "single",
fk_columns => { author_id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
join_type => "left",
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::Author",
cond => { "foreign.id" => "self.author_id" },
source => "GTH::Archive::Schema::Result::Author",
},
issue => {
attrs => {
accessor => "single",
fk_columns => { issue_id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::Issue",
cond => { "foreign.id" => "self.issue_id" },
source => "GTH::Archive::Schema::Result::Issue",
},
tea_of_the_month => {
attrs => {
accessor => "single",
fk_columns => { tea_of_the_month_id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::TeaOfTheMonth",
cond => { "foreign.id" => "self.tea_of_the_month_id" },
source => "GTH::Archive::Schema::Result::TeaOfTheMonth",
},
tea_tips => {
attrs => {
accessor => "single",
fk_columns => { tea_tips_id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::TeaTips",
cond => { "foreign.id" => "self.tea_tips_id" },
source => "GTH::Archive::Schema::Result::TeaTips",
},
tea_wayfarer => {
attrs => {
accessor => "single",
fk_columns => { tea_wayfarer_id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::TeaWayfarer",
cond => { "foreign.id" => "self.tea_wayfarer_id" },
source => "GTH::Archive::Schema::Result::TeaWayfarer",
},
},
_unique_constraints => { primary => 'fix' },
name => "article",
result_class => "GTH::Archive::Model::DB::Article",
resultset_attributes => {},
resultset_class => "DBIx::Class::ResultSet",
schema => 'fix',
source_name => "Article",
}, "DBIx::Class::ResultSource::Table"),
ArticleContent => bless({
_columns => {
article_id => { data_type => "INTEGER" },
content => { data_type => "TEXT" },
},
_columns_info_loaded => 0,
_ordered_columns => ["article_id", "content"],
_relationships => {},
name => "article_content",
result_class => "GTH::Archive::Model::DB::ArticleContent",
resultset_attributes => {},
resultset_class => "DBIx::Class::ResultSet",
schema => 'fix',
source_name => "ArticleContent",
}, "DBIx::Class::ResultSource::Table"),
ArticleType => 'fix',
Author => bless({
_columns => {
alternative_name => { data_type => "TEXT", is_nullable => 1 },
id => { data_type => "INTEGER", is_auto_increment => 1 },
last_update => {
_ic_dt_method => "timestamp",
_inflate_info => { deflate => sub { ... }, inflate => sub { ... } },
data_type => "TIMESTAMP",
dynamic_default_on_create => "get_timestamp",
dynamic_default_on_update => "get_timestamp",
timezone => "America/Los_Angeles",
},
name => { data_type => "TEXT" },
spiritual_name => { data_type => "TEXT", is_nullable => 1 },
spiritual_name_date => { data_type => "TEXT", is_nullable => 1 },
},
_columns_info_loaded => 0,
_ordered_columns => [
"id",
"name",
"spiritual_name",
"spiritual_name_date",
"alternative_name",
"last_update",
],
_primaries => ["id"],
_relationships => {
articles => {
attrs => {
accessor => "multi",
cascade_copy => 1,
cascade_delete => 1,
is_depends_on => 0,
join_type => "LEFT",
},
class => "GTH::Archive::Schema::Result::Article",
cond => { "foreign.author_id" => "self.id" },
source => "GTH::Archive::Schema::Result::Article",
},
},
_unique_constraints => { primary => 'fix' },
name => "author",
result_class => "GTH::Archive::Model::DB::Author",
resultset_attributes => {},
resultset_class => "DBIx::Class::ResultSet",
schema => 'fix',
source_name => "Author",
}, "DBIx::Class::ResultSource::Table"),
Issue => bless({
_columns => {
id => { data_type => "INTEGER", is_auto_increment => 1 },
issue_num => { data_type => "TEXT" },
issue_type => { data_type => "TEXT", is_nullable => 1 },
last_update => {
_ic_dt_method => "timestamp",
_inflate_info => { deflate => sub { ... }, inflate => sub { ... } },
data_type => "TIMESTAMP",
dynamic_default_on_create => "get_timestamp",
dynamic_default_on_update => "get_timestamp",
timezone => "America/Los_Angeles",
},
month => { data_type => "TEXT" },
title => { data_type => "TEXT" },
year => { data_type => "TEXT" },
},
_columns_info_loaded => 0,
_ordered_columns => [
"id",
"issue_num",
"title",
"issue_type",
"year",
"month",
"last_update",
],
_primaries => ["id"],
_relationships => {
articles => {
attrs => {
accessor => "multi",
cascade_copy => 1,
cascade_delete => 1,
is_depends_on => 0,
join_type => "LEFT",
},
class => "GTH::Archive::Schema::Result::Article",
cond => { "foreign.issue_id" => "self.id" },
source => "GTH::Archive::Schema::Result::Article",
},
},
_unique_constraints => { primary => 'fix' },
name => "issue",
result_class => "GTH::Archive::Model::DB::Issue",
resultset_attributes => {},
resultset_class => "DBIx::Class::ResultSet",
schema => 'fix',
source_name => "Issue",
}, "DBIx::Class::ResultSource::Table"),
TeaOfTheMonth => bless({
_columns => {
id => { data_type => "INTEGER", is_auto_increment => 1 },
last_update => {
_ic_dt_method => "timestamp",
_inflate_info => { deflate => sub { ... }, inflate => sub { ... } },
data_type => "TIMESTAMP",
dynamic_default_on_create => "get_timestamp",
dynamic_default_on_update => "get_timestamp",
timezone => "America/Los_Angeles",
},
tea_genre => { data_type => "TEXT", is_nullable => 1 },
tea_location => { data_type => "TEXT", is_nullable => 1 },
tea_name => { data_type => "TEXT", is_nullable => 1 },
tea_season => { data_type => "TEXT", is_nullable => 1 },
tea_year => { data_type => "TEXT", is_nullable => 1 },
title => { data_type => "TEXT" },
},
_columns_info_loaded => 0,
_ordered_columns => [
"id",
"title",
"tea_name",
"tea_genre",
"tea_year",
"tea_season",
"tea_location",
"last_update",
],
_primaries => ["id"],
_relationships => {
article => {
attrs => {
accessor => "single",
fk_columns => { id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::Article",
cond => { "foreign.tea_of_the_month_id" => "self.id" },
source => "GTH::Archive::Schema::Result::Article",
},
},
_unique_constraints => { primary => 'fix' },
name => "tea_of_the_month",
result_class => "GTH::Archive::Model::DB::TeaOfTheMonth",
resultset_attributes => {},
resultset_class => "DBIx::Class::ResultSet",
schema => 'fix',
source_name => "TeaOfTheMonth",
}, "DBIx::Class::ResultSource::Table"),
TeaTips => bless({
_columns => {
id => { data_type => "INTEGER", is_auto_increment => 1 },
last_update => {
_ic_dt_method => "timestamp",
_inflate_info => { deflate => sub { ... }, inflate => sub { ... } },
data_type => "TIMESTAMP",
dynamic_default_on_create => "get_timestamp",
dynamic_default_on_update => "get_timestamp",
timezone => "America/Los_Angeles",
},
topic => { data_type => "TEXT" },
},
_columns_info_loaded => 0,
_ordered_columns => ["id", "topic", "last_update"],
_primaries => ["id"],
_relationships => {
article => {
attrs => {
accessor => "single",
fk_columns => { id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::Article",
cond => { "foreign.tea_tips_id" => "self.id" },
source => "GTH::Archive::Schema::Result::Article",
},
},
_unique_constraints => { primary => 'fix' },
name => "tea_tips",
result_class => "GTH::Archive::Model::DB::TeaTips",
resultset_attributes => {},
resultset_class => "DBIx::Class::ResultSet",
schema => 'fix',
source_name => "TeaTips",
}, "DBIx::Class::ResultSource::Table"),
TeaWayfarer => bless({
_columns => {
id => { data_type => "INTEGER", is_auto_increment => 1 },
last_update => {
_ic_dt_method => "timestamp",
_inflate_info => { deflate => sub { ... }, inflate => sub { ... } },
data_type => "TIMESTAMP",
dynamic_default_on_create => "get_timestamp",
dynamic_default_on_update => "get_timestamp",
timezone => "America/Los_Angeles",
},
location => { data_type => "TEXT" },
name => { data_type => "TEXT" },
},
_columns_info_loaded => 0,
_ordered_columns => ["id", "name", "location", "last_update"],
_primaries => ["id"],
_relationships => {
article => {
attrs => {
accessor => "single",
fk_columns => { id => 1 },
is_depends_on => 1,
is_foreign_key_constraint => 1,
undef_on_null_fk => 1,
},
class => "GTH::Archive::Schema::Result::Article",
cond => { "foreign.tea_wayfarer_id" => "self.id" },
source => "GTH::Archive::Schema::Result::Article",
},
},
_unique_constraints => { primary => 'fix' },
name => "tea_wayfarer",
result_class => "GTH::Archive::Model::DB::TeaWayfarer",
resultset_attributes => {},
resultset_class => "DBIx::Class::ResultSet",
schema => 'fix',
source_name => "TeaWayfarer",
}, "DBIx::Class::ResultSource::Table"),
},
storage => bless({
_conn_pid => 2751,
_connect_info => [
{
dsn => "dbi:SQLite:/opt/sqlite/gth_archive.db",
password => "",
sqlite_unicode => 1,
user => "",
},
],
_dbh => bless({
# tied DBI::db
}, "DBI::db"),
_dbh_autocommit => 1,
_dbh_details => { _datatype_map_cache => { INTEGER => -5, integer => -5 } },
_dbi_connect_info => [
"dbi:SQLite:/opt/sqlite/gth_archive.db",
"",
"",
{
AutoCommit => 1,
PrintError => 0,
RaiseError => 1,
ShowErrorStatement => 1,
sqlite_unicode => 1,
},
],
_dbic_connect_attributes => 'fix',
_driver_determined => 1,
_in_do_block => 0,
_sql_maker => bless({
array_datatypes => 1,
bindtype => "columns",
cmp => "=",
equality_op => qr/^( \= | \= )$/ix,
inequality_op => qr/^( != | <> )$/ix,
injection_guard => qr/
\;
|
^ \s* go \s
/mix,
like_op => qr/^ (is\s+)? r?like $/ix,
limit_dialect => "LimitOffset",
logic => "OR",
name_sep => ".",
not_like_op => qr/^ (is\s+)? not \s+ r?like $/ix,
special_ops => [
{
handler => "_where_field_BETWEEN",
regex => qr/^ (?: not \s )? between $/ix,
},
{
handler => "_where_field_IN",
regex => qr/^ (?: not \s )? in $/ix,
},
{
handler => "_where_op_IDENT",
regex => qr/^ ident $/ix,
},
{
handler => "_where_op_VALUE",
regex => qr/^ value $/ix,
},
{
handler => "_where_field_IS",
regex => qr/^ is (?: \s+ not )? $/ix,
},
],
sqlfalse => "0=1",
sqltrue => "1=1",
unary_ops => [
{
handler => "_where_op_ANDOR",
regex => qr/^ and (?: [_\s]? \d+ )? $/ix,
},
{
handler => "_where_op_ANDOR",
regex => qr/^ or (?: [_\s]? \d+ )? $/ix,
},
{
handler => "_where_op_NEST",
regex => qr/^ nest (?: [_\s]? \d+ )? $/ix,
},
{
handler => "_where_op_BOOL",
regex => qr/^ (?: not \s )? bool $/ix,
},
{
handler => "_where_op_IDENT",
regex => qr/^ ident $/ix,
},
{
handler => "_where_op_VALUE",
regex => qr/^ value $/ix,
},
],
}, "DBIx::Class::SQLMaker::SQLite"),
_sql_maker_opts => {},
savepoints => [],
schema => 'fix',
transaction_depth => 0,
}, "DBIx::Class::Storage::DBI::SQLite"),
}, "GTH::Archive::Schema"),
source_name => "ArticleType",
}, "DBIx::Class::ResultSource::Table"),
}, "DBIx::Class::ResultSet"),
all_authors => bless({
_result_class => "GTH::Archive::Model::DB::Author",
attrs => { alias => "me" },
cond => undef,
pager => undef,
result_source => 'fix',
}, "DBIx::Class::ResultSet"),
all_issues => bless({
_result_class => "GTH::Archive::Model::DB::Issue",
attrs => {
alias => "me",
bind => [],
order_by => { -desc => ["year", "month"] },
where => undef,
},
cond => undef,
pager => undef,
result_source => 'fix',
}, "DBIx::Class::ResultSet"),
article => bless({
_column_data => {
author_id => 24,
file_num => "2020-07-a001",
id => 1057,
issue_id => 102,
last_update => "2021-05-21 05:54:34",
month => "07",
page_length => undef,
start_page => 1,
tea_of_the_month_id => undef,
tea_tips_id => undef,
tea_wayfarer_id => undef,
title => "July 2020",
type_id => 6,
year => 2020,
},
_in_storage => 1,
_inflated_column => {},
_relationship_data => {
issue => bless({
_column_data => {
id => 102,
issue_num => "2020-07",
issue_type => "Sencha",
last_update => "2021-05-21 05:54:34",
month => "07",
title => "July 2020",
year => 2020,
},
_in_storage => 1,
_result_source => 'fix',
}, "GTH::Archive::Model::DB::Issue"),
},
_result_source => 'fix',
related_resultsets => {
issue => bless({
_result_class => "GTH::Archive::Model::DB::Issue",
attrs => {
accessor => "single",
alias => "me",
bind => [],
fk_columns => 'fix',
is_depends_on => 1,
is_foreign_key_constraint => 1,
undef_on_null_fk => 1,
where => { "me.id" => 102 },
},
cond => 'fix',
pager => undef,
result_source => 'fix',
}, "DBIx::Class::ResultSet"),
},
}, "GTH::Archive::Model::DB::Article"),
tag_xref => {
article => "Article",
back_cover => "Back Cover",
bio => "Bio",
classic => "Classic",
contents => "Contents",
cover => "Cover",
humor => "Humor",
news => "News",
photo_contest => "Photo Contest",
preface => "Preface",
review => "Review",
story => "Story",
tea_of_the_month => "Tea of the Month",
tips => "Tips",
wayfarer => "Wayfarer",
},
title => "July 2020 Issue - July 2020",
};
$a->{all_article_types}{result_source}{_unique_constraints}{primary} = $a->{all_article_types}{result_source}{_primaries};
$a->{all_article_types}{result_source}{schema}{source_registrations}{Article}{_unique_constraints}{primary} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Article}{_primaries};
$a->{all_article_types}{result_source}{schema}{source_registrations}{Article}{schema} = $a->{all_article_types}{result_source}{schema};
$a->{all_article_types}{result_source}{schema}{source_registrations}{ArticleContent}{schema} = $a->{all_article_types}{result_source}{schema};
$a->{all_article_types}{result_source}{schema}{source_registrations}{ArticleType} = $a->{all_article_types}{result_source};
$a->{all_article_types}{result_source}{schema}{source_registrations}{Author}{_unique_constraints}{primary} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Author}{_primaries};
$a->{all_article_types}{result_source}{schema}{source_registrations}{Author}{schema} = $a->{all_article_types}{result_source}{schema};
$a->{all_article_types}{result_source}{schema}{source_registrations}{Issue}{_unique_constraints}{primary} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Issue}{_primaries};
$a->{all_article_types}{result_source}{schema}{source_registrations}{Issue}{schema} = $a->{all_article_types}{result_source}{schema};
$a->{all_article_types}{result_source}{schema}{source_registrations}{TeaOfTheMonth}{_unique_constraints}{primary} = $a->{all_article_types}{result_source}{schema}{source_registrations}{TeaOfTheMonth}{_primaries};
$a->{all_article_types}{result_source}{schema}{source_registrations}{TeaOfTheMonth}{schema} = $a->{all_article_types}{result_source}{schema};
$a->{all_article_types}{result_source}{schema}{source_registrations}{TeaTips}{_unique_constraints}{primary} = $a->{all_article_types}{result_source}{schema}{source_registrations}{TeaTips}{_primaries};
$a->{all_article_types}{result_source}{schema}{source_registrations}{TeaTips}{schema} = $a->{all_article_types}{result_source}{schema};
$a->{all_article_types}{result_source}{schema}{source_registrations}{TeaWayfarer}{_unique_constraints}{primary} = $a->{all_article_types}{result_source}{schema}{source_registrations}{TeaWayfarer}{_primaries};
$a->{all_article_types}{result_source}{schema}{source_registrations}{TeaWayfarer}{schema} = $a->{all_article_types}{result_source}{schema};
$a->{all_article_types}{result_source}{schema}{storage}{_dbic_connect_attributes} = $a->{all_article_types}{result_source}{schema}{storage}{_dbi_connect_info}[3];
$a->{all_article_types}{result_source}{schema}{storage}{schema} = $a->{all_article_types}{result_source}{schema};
$a->{all_authors}{result_source} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Author};
$a->{all_issues}{result_source} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Issue};
$a->{article}{_relationship_data}{issue}{_result_source} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Issue};
$a->{article}{_result_source} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Article};
$a->{article}{related_resultsets}{issue}{attrs}{fk_columns} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Article}{_relationships}{issue}{attrs}{fk_columns};
$a->{article}{related_resultsets}{issue}{cond} = $a->{article}{related_resultsets}{issue}{attrs}{where};
$a->{article}{related_resultsets}{issue}{result_source} = $a->{all_article_types}{result_source}{schema}{source_registrations}{Issue};
$a;
}