X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FParser%2FDBI%2FSQLite.pm;h=49c4cb1dbf01963a555f430f9487ead30c2b4b06;hb=49eb21a3a6910bf8f7109fbfb06f7bb20c4eff33;hp=cb6fb7fecf01109cf612f1d1ab33df17eee3782f;hpb=4f4fd192801c55deb75aa8e4bc440b220e24c396;p=dbsrgits%2FSQL-Translator-2.0-ish.git

diff --git a/lib/SQL/Translator/Parser/DBI/SQLite.pm b/lib/SQL/Translator/Parser/DBI/SQLite.pm
index cb6fb7f..49c4cb1 100644
--- a/lib/SQL/Translator/Parser/DBI/SQLite.pm
+++ b/lib/SQL/Translator/Parser/DBI/SQLite.pm
@@ -1,3 +1,25 @@
 use MooseX::Declare;
 role SQL::Translator::Parser::DBI::SQLite {
+    use MooseX::Types::Moose qw(HashRef);
+    use SQL::Translator::Constants qw(:sqlt_types);
+
+    my %data_type_mapping = (
+        'text' => SQL_LONGVARCHAR(),
+        'timestamp' => SQL_TIMESTAMP(),
+        'timestamp without time zone' => SQL_TYPE_TIMESTAMP(),
+        'timestamp' => SQL_TYPE_TIMESTAMP_WITH_TIMEZONE(),
+        'integer' => SQL_INTEGER(),
+        'character' => SQL_CHAR(),
+        'varchar' => SQL_VARCHAR(),
+        'bigint' => SQL_BIGINT(),
+    );
+
+    method _column_data_type(HashRef $column_info) {
+        print $column_info->{TYPE_NAME} . "\n";
+        my $data_type = defined $data_type_mapping{$column_info->{TYPE_NAME}} ?
+                        $data_type_mapping{$column_info->{TYPE_NAME}} :
+                        -1;
+        return $data_type;
+    }
+
 }