1 package SQL::Translator::Generator::DDL::SQLite;
3 # AUTHOR: Arthur Axel fREW Schmidt
4 # Copyright: Same as Perl 5
8 has quote_chars => (is=>'ro', default=>sub { +[qw(" ")] } );
10 with 'SQL::Translator::Generator::Role::Quote';
11 with 'SQL::Translator::Generator::Role::DDL';
22 sub _build_sizeless_types {
28 sub _build_numeric_types {
36 'unsigned big int' => 1,
44 'double precision' => 1,
49 sub _build_unquoted_defaults {
53 CURRENT_TIMESTAMP => 1,
60 my ($self, $field) = @_;
62 my $pk = $field->table->primary_key;
63 my @pk_fields = $pk ? $pk->fields : ();
65 $field->is_primary_key && scalar @pk_fields == 1 &&
66 ( $field->data_type =~ /int(eger)?$/i
68 ( $field->data_type =~ /^number?$/i && $field->size !~ /,/ ) )
72 my ($self, $field) = @_;
76 $self->field_comments($field),
77 $self->field_name($field),
79 ? ( 'INTEGER PRIMARY KEY' )
80 : ( $self->field_type($field) )
82 $self->field_nullable($field),
83 $self->field_default($field, {
86 'CURRENT_TIMESTAMP' => 1,