schema_dumper and function calls as default values

[fnando]

I'm using the schema_dumper extension and noticed that it doesn't apply default values when using function calls. For instance, this is my migration definition:

Sequel.migration do
  change do
    create_table :users do
      String :id, null: false,
                  default: Sequel.function(:shortid, "U"),
                  primary_key: true
      String :display_name, null: false
      File :encrypted_email, null: false
      Integer :keyring_id, null: false
      String :email_digest, text: true, null: false
      Time :created_at, null: false
      Time :updated_at, null: false

      index :email_digest, unique: true
      foreign_key :space_id, :spaces, null: true, type: String
    end
  end
end

After calling connection.dump_schema_migration, this is the generated dump:

# frozen_string_literal: true

Sequel.migration do
  change do
    create_table(:schema_migrations) do
      String :filename, size: 255, null: false

      primary_key [:filename]
    end

    create_table(:users, ignore_index_errors: true) do
      String :id, size: 255, null: false
      String :display_name, size: 255, null: false
      File :encrypted_email, null: false
      Integer :keyring_id, null: false
      String :email_digest, text: true, null: false
      DateTime :created_at, null: false
      DateTime :updated_at, null: false
      foreign_key :space_id, :spaces, type: String

      primary_key [:id]

      index [:email_digest], unique: true
    end
  end
end

Inspecting the schema on SQLite, this is what's being emitted:

sqlite> .schema users
CREATE TABLE `users` (`id` varchar(255) DEFAULT (shortid('U')) NOT NULL PRIMARY KEY, `display_name` varchar(255) NOT NULL, `encrypted_email` blob NOT NULL, `keyring_id` integer NOT NULL, `email_digest` text NOT NULL, `created_at` timestamp NOT NULL, `updated_at` timestamp NOT NULL, `space_id` varchar(255) NULL REFERENCES `spaces`);
CREATE UNIQUE INDEX `users_email_digest_index` ON `users` (`email_digest`);

Is there a way to include function calls? It seems this is quite trivial (at least the common cases) to be inferred from the column's default value.

[jeremyevans]

If you are dumping to the same database type, you can pass the same_db: true option when dumping the schema, and it will include the default value. Here's what the dumped schema looks like in that case:

create_table(:users) do
  column :id, "varchar(255)", default: Sequel::LiteralString.new("shortid('U')"), null: false
  column :display_name, "varchar(255)", null: false
  column :encrypted_email, "BLOB", null: false
  column :keyring_id, "INTEGER", null: false
  column :email_digest, "TEXT", null: false
  column :created_at, "timestamp", null: false
  column :updated_at, "timestamp", null: false
  foreign_key :space_id, :spaces, type: "varchar(255)"
  
  primary_key [:id]
  
  index [:email_digest], unique: true
end