NAME

Interchange6::Schema::Result::User

TABLE: users

ACCESSORS

users_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0
  sequence: 'users_users_id_seq'

username

  data_type: 'varchar'
  is_nullable: 0
  size: 255

The username is automatically converted to lowercase so we make sure that the unique constraint on username works.

nickname

  data_type: 'varchar'
  is_nullable: 1
  size: 255

email

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

password

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 60
  encode_column: 1
  encode_class: 'Crypt::Eksblowfish::Bcrypt'
  encode_args: { key_nul => 1, cost => 14 }
  encode_check_method: 'check_password'

first_name

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

last_name

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

last_login

  data_type: 'datetime'
  is_nullable: 1

fail_count

  data_type: 'integer'
  is_nullable: 0
  default_value: 0

created

  data_type: 'datetime'
  set_on_create: 1
  is_nullable: 0

last_modified

  data_type: 'datetime'
  set_on_create: 1
  set_on_update: 1
  is_nullable: 0

active

  data_type: 'boolean'
  default_value: 1
  is_nullable: 0

PRIMARY KEY

• "users_id"

UNIQUE CONSTRAINTS

users_username

• "username"

users_nickname

• "nickname"

RELATIONS

addresses

Type: has_many

Related object: Interchange6::Schema::Result::Address

carts

Type: has_many

Related object: Interchange6::Schema::Result::Cart

orders

Type: has_many

Related object: Interchange6::Schema::Result::Order

user_attribute

Type: has_many

Related object: Interchange6::Schema::Result::UserAttribute

user_roles

Type: has_many

Related object: Interchange6::Schema::Result::UserRole

roles

Type: many_to_many

Composing rels: "user_roles" -> role

approvals

Type: has_many

Related object: Interchange6::Schema::Result::Message FK approved_by

messages

Type: has_many

Related object: Interchange6::Schema::Result::Message FK author

METHODS

Attribute methods are provided by the Interchange6::Schema::Base::Attribute class.

new

Overloaded method. Die if username is undef, empty string or not lowercase.

update

Overloaded method. Throw exception if username is undef, empty string or not lowercase.

blog_posts

Returns resultset of messages that are blog posts (Message->type eq 'blog_post')

reviews

Returns resultset of messages that are reviews (referenced by ProductReview class).

cpanm Interchange6::Schema

perl -MCPAN -e shell
install Interchange6::Schema