Use DBIx::Class

For now this is a relatively quick-and-dirty transition, but this
enables us to reuse ASM::DB from the website. Yay

1 files changed, 30 insertions, 0 deletions

diff --git a/lib/ASM/DB/Result/Alertlog.pm b/lib/ASM/DB/Result/Alertlog.pm
new file mode 100644
index 0000000..8ce22ff
--- /dev/null
+++ b/lib/ASM/DB/Result/Alertlog.pm
@@ -0,0 +1,30 @@
+use utf8;
+package ASM::DB::Result::Alertlog;
+
+use strict;
+use warnings;
+
+use parent 'DBIx::Class::Core';
+
+__PACKAGE__->load_components('InflateColumn::DateTime');
+__PACKAGE__->table('alertlog');
+__PACKAGE__->add_columns(
+    time => {
+        data_type => 'timestamp',
+        datetime_undef_if_invalid => 1,
+        default_value => \'current_timestamp',
+        is_nullable => 0,
+    },
+    channel => { data_type => 'text',     is_nullable => 0 },
+    nick    => { data_type => 'text',     is_nullable => 0 },
+    user    => { data_type => 'text',     is_nullable => 0 },
+    host    => { data_type => 'text',     is_nullable => 0 },
+    gecos   => { data_type => 'text',     is_nullable => 0 },
+    level   => { data_type => 'tinytext', is_nullable => 0 },
+    id      => { data_type => 'tinytext', is_nullable => 0 },
+    reason  => { data_type => 'text',     is_nullable => 0 },
+);
+
+__PACKAGE__->set_primary_key('id');
+
+1;