Skip to content

Instantly share code, notes, and snippets.

@jjn1056
Created January 28, 2020 14:02
Show Gist options
  • Save jjn1056/5bf66c393b0eaedd35eb2fb1e98958da to your computer and use it in GitHub Desktop.
Save jjn1056/5bf66c393b0eaedd35eb2fb1e98958da to your computer and use it in GitHub Desktop.
package Liminal::Schema::Result::Person;
use strict;
use warnings;
use base 'Liminal::Schema::Result';
__PACKAGE__->table("person");
__PACKAGE__->load_components(qw/EncodedColumn /);
__PACKAGE__->add_columns(
id => { data_type => 'bigserial', is_nullable => 0, is_auto_increment => 1 },
username => { data_type => 'varchar', is_nullable => 0, size => 48 },
email => { data_type => 'varchar', is_nullable => 0, size => 48 },
password => {
data_type => 'varchar',
is_nullable => 0,
size => 64,
encode_column => 1,
encode_class => 'Digest',
encode_args => { algorithm => 'MD5', format => 'base64' },
},
);
__PACKAGE__->set_primary_key("id");
1;
@jjn1056
Copy link
Author

jjn1056 commented Jan 28, 2020

When running a migration Fia App::DH I get

-- 
-- Created by SQL::Translator::Producer::PostgreSQL
-- Created on Thu Jan 23 13:17:18 2020
-- 
;
--
-- Table: person
--
CREATE TABLE "person" (
  "id" serial NOT NULL,
  "username" character varying(48) NOT NULL,
  "password" character varying(64) NOT NULL,
  PRIMARY KEY ("id")
);

;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment