module ViewData::PG::Controls::Table::CompositePrimaryKey

Public Class Methods

create(drop: nil) click to toggle source
# File lib/view_data/pg/controls/table/composite_primary_key.rb, line 6
          def self.create(drop: nil)
            session = Session.build

            if drop
              session.execute("DROP TABLE IF EXISTS #{name}")
            end

            session.execute(<<~SQL)
              CREATE TABLE #{name} (
                id_1 uuid NOT NULL,
                id_2 uuid NOT NULL,

                some_column text,

                PRIMARY KEY(id_1, id_2)
              )
            SQL

            session.close
          end
name() click to toggle source
# File lib/view_data/pg/controls/table/composite_primary_key.rb, line 27
def self.name
  'test_composite_primary_key'
end