class Sequel::Postgres::CreatePartitionOfTableGenerator

Generator used for creating tables that are partitions of other tables.

Constants

MAXVALUE
MINVALUE

Public Class Methods

Source

    # File lib/sequel/adapters/shared/postgres.rb
169 def initialize(&block)
170   instance_exec(&block)
171 end

Public Instance Methods

default ()

Source

    # File lib/sequel/adapters/shared/postgres.rb
214 def default
215   @default = true
216 end

Sets that this is a default partition, where values not in other partitions are stored.

from (*v)

Source

    # File lib/sequel/adapters/shared/postgres.rb
187 def from(*v)
188   @from = v
189 end

Assumes range partitioning, sets the inclusive minimum value of the range for this partition.

hash_values ()

Source

    # File lib/sequel/adapters/shared/postgres.rb
229 def hash_values
230   [@modulus, @remainder]
231 end

The modulus and remainder to use for this partition for a hash partition.

list ()

Source

    # File lib/sequel/adapters/shared/postgres.rb
224 def list
225   @in
226 end

The values to include in this partition for a list partition.

maxvalue ()

Source

    # File lib/sequel/adapters/shared/postgres.rb
181 def maxvalue
182   MAXVALUE
183 end

The minimum value of the data type used in range partitions, useful as an argument to to.

minvalue ()

Source

    # File lib/sequel/adapters/shared/postgres.rb
175 def minvalue
176   MINVALUE
177 end

The minimum value of the data type used in range partitions, useful as an argument to from.

modulus (v)

Source

    # File lib/sequel/adapters/shared/postgres.rb
203 def modulus(v)
204   @modulus = v
205 end

Assumes hash partitioning, sets the modulus for this parition.

partition_type ()

Source

    # File lib/sequel/adapters/shared/postgres.rb
235 def partition_type
236   raise Error, "Unable to determine partition type, multiple different partitioning methods called" if [@from || @to, @list, @modulus || @remainder, @default].compact.length > 1
237 
238   if @from || @to
239     raise Error, "must call both from and to when creating a partition of a table if calling either" unless @from && @to
240     :range
241   elsif @in
242     :list
243   elsif @modulus || @remainder
244     raise Error, "must call both modulus and remainder when creating a partition of a table if calling either" unless @modulus && @remainder
245     :hash
246   elsif @default
247     :default
248   else
249     raise Error, "unable to determine partition type, no partitioning methods called"
250   end
251 end

Determine the appropriate partition type for this partition by which methods were called on it.

range ()

Source

    # File lib/sequel/adapters/shared/postgres.rb
219 def range
220   [@from, @to]
221 end

The from and to values of this partition for a range partition.

remainder (v)

Source

    # File lib/sequel/adapters/shared/postgres.rb
208 def remainder(v)
209   @remainder = v
210 end

Assumes hash partitioning, sets the remainder for this parition.

to (*v)

Source

    # File lib/sequel/adapters/shared/postgres.rb
193 def to(*v)
194   @to = v
195 end

Assumes range partitioning, sets the exclusive maximum value of the range for this partition.

values_in (*v)

Source

    # File lib/sequel/adapters/shared/postgres.rb
198 def values_in(*v)
199   @in = v
200 end

Assumes list partitioning, sets the values to be included in this partition.