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

2 files changed, 67 insertions, 0 deletions

diff --git a/lib/ASM/DB/Result/Actionlog.pm b/lib/ASM/DB/Result/Actionlog.pm
new file mode 100644
index 0000000..5385650
--- /dev/null
+++ b/lib/ASM/DB/Result/Actionlog.pm
@@ -0,0 +1,37 @@
+use utf8;
+package ASM::DB::Result::Actionlog;
+
+use strict;
+use warnings;
+
+use parent 'DBIx::Class::Core';
+
+__PACKAGE__->load_components('InflateColumn::DateTime');
+__PACKAGE__->table('actionlog');
+__PACKAGE__->add_columns(
+    index => { data_type => 'bigint', is_auto_increment => 1, is_nullable => 0 },
+    time => {
+        data_type => 'timestamp',
+        datetime_undef_if_invalid => 1,
+        default_value => \'current_timestamp',
+        is_nullable => 0,
+    },
+    action    => { data_type => 'varchar', is_nullable => 0, size => 20 },
+    reason    => { data_type => 'varchar', is_nullable => 1, size => 512 },
+    channel   => { data_type => 'varchar', is_nullable => 1, size => 51 },
+    nick      => { data_type => 'varchar', is_nullable => 0, size => 17 },
+    user      => { data_type => 'varchar', is_nullable => 1, size => 11 },
+    host      => { data_type => 'varchar', is_nullable => 1, size => 64 },
+    ip        => { data_type => 'integer', is_nullable => 1, extra => { unsigned => 1 } },
+    gecos     => { data_type => 'varchar', is_nullable => 1, size => 512 },
+    account   => { data_type => 'varchar', is_nullable => 1, size => 17 },
+    bynick    => { data_type => 'varchar', is_nullable => 1, size => 17 },
+    byuser    => { data_type => 'varchar', is_nullable => 1, size => 11 },
+    byhost    => { data_type => 'varchar', is_nullable => 1, size => 64 },
+    bygecos   => { data_type => 'varchar', is_nullable => 1, size => 512 },
+    byaccount => { data_type => 'varchar', is_nullable => 1, size => 17 },
+);
+
+__PACKAGE__->set_primary_key('index');
+
+1;
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;