Class: SimpleMySQLPartitioning::Range

Inherits:
BasePartitioning show all
Defined in:
lib/simple_mysql_partitioning/range.rb

Instance Attribute Summary

Attributes inherited from BasePartitioning

#klass, #table_name

Instance Method Summary collapse

Methods inherited from BasePartitioning

#drop, #exists?, #initialize

Constructor Details

This class inherits a constructor from SimpleMySQLPartitioning::BasePartitioning

Instance Method Details

#add(pairs_name_with_value) ⇒ Object 



17
18
19
20
21
22
 
# File 'lib/simple_mysql_partitioning/range.rb', line 17

def add(pairs_name_with_value)
  pairs_name_with_value.map do |pair|
    add_partition_sql = SQL.add_sql(table_name, pair.first, pair.last)
    klass.connection.execute(add_partition_sql)
  end
end

#create(pairs_name_with_value) ⇒ Object 



7
8
9
10
11
12
13
14
15
 
# File 'lib/simple_mysql_partitioning/range.rb', line 7

def create(pairs_name_with_value)
  sql = SQL.create_sql(
    table_name,
    klass.partition_config[:column],
    pairs_name_with_value, true
  )

  klass.connection.execute(sql)
end

#reorganize(pairs_name_with_value, reorganize_partition_name, reorganize_partition_value = 'MAXVALUE') ⇒ Object 



24
25
26
27
28
29
30
31
32
33
34
35
 
# File 'lib/simple_mysql_partitioning/range.rb', line 24

def reorganize(pairs_name_with_value, reorganize_partition_name, reorganize_partition_value = 'MAXVALUE')
  pairs_name_with_value.map do |pair|
    klass.connection.execute(
      SQL.reorganize_sql(
        table_name,
        pair.first, pair.last,
        reorganize_partition_name,
        reorganize_partition_value
      )
    )
  end
end