NAME

WordPress::DBIC::Schema::Result::WpPost

COMPONENTS LOADED

• DBIx::Class::InflateColumn::DateTime

TABLE: wp_posts

ACCESSORS

id

  data_type: 'bigint'
  extra: {unsigned => 1}
  is_auto_increment: 1
  is_nullable: 0

post_author

  data_type: 'bigint'
  default_value: 0
  extra: {unsigned => 1}
  is_nullable: 0

post_date

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  default_value: '0000-00-00 00:00:00'
  is_nullable: 0

post_date_gmt

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  default_value: '0000-00-00 00:00:00'
  is_nullable: 0

post_content

  data_type: 'longtext'
  is_nullable: 0

post_title

  data_type: 'text'
  is_nullable: 0

post_excerpt

  data_type: 'text'
  is_nullable: 0

post_status

  data_type: 'varchar'
  default_value: 'publish'
  is_nullable: 0
  size: 20

comment_status

  data_type: 'varchar'
  default_value: 'open'
  is_nullable: 0
  size: 20

ping_status

  data_type: 'varchar'
  default_value: 'open'
  is_nullable: 0
  size: 20

post_password

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 255

post_name

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 200

to_ping

  data_type: 'text'
  is_nullable: 0

pinged

  data_type: 'text'
  is_nullable: 0

post_modified

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  default_value: '0000-00-00 00:00:00'
  is_nullable: 0

post_modified_gmt

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  default_value: '0000-00-00 00:00:00'
  is_nullable: 0

post_content_filtered

  data_type: 'longtext'
  is_nullable: 0

post_parent

  data_type: 'bigint'
  default_value: 0
  extra: {unsigned => 1}
  is_nullable: 0

guid

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 255

menu_order

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

post_type

  data_type: 'varchar'
  default_value: 'post'
  is_nullable: 0
  size: 20

post_mime_type

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 100

comment_count

  data_type: 'bigint'
  default_value: 0
  is_nullable: 0

PRIMARY KEY

• "id"

RELATIONSHIPS

wp_term_relationships: has many

taxonomies: many to many using wp_term_relationships as bridge

metas: has many to the wp_postmeta table

METHODS

They should be self-explanatory

• clean_url

• permalink

• html_teaser

• html_body

cpanm WordPress::DBIC::Schema

perl -MCPAN -e shell
install WordPress::DBIC::Schema