1 package SQL::Translator::Producer;
2 use namespace::autoclean;
4 use MooseX::Types::Moose qw(Str);
5 use SQL::Translator::Types qw(Schema);
15 my $schema = $self->schema;
17 $self->_create_table($_) for values %{$schema->tables};
25 my $add_drop_table = 1;
26 my $sqlite_version = 0;
29 my (@column_defs, @index_defs, @constraint_defs);
31 $create_table .= 'DROP TABLE ' . $table->name . ";\n" if $add_drop_table;
32 $create_table .= 'CREATE TABLE ' . $table->name . " (\n";
34 push @column_defs, $self->_create_column($_) for values %{$table->columns};
35 $create_table .= join(",\n", map { ' ' . $_ } @column_defs ) . "\n)";
36 print $create_table . "\n";
44 $column_def = $column->name . ' ' . $column->data_type;
45 $column_def .= '(' . $column->size . ')' if $column->size;
46 $column_def .= ' NOT NULL' unless $column->is_nullable;
50 __PACKAGE__->meta->make_immutable;