module AR::Sequence::Adapter
Public Instance Methods
check_sequences()
click to toggle source
# File lib/ar/sequence/adapter.rb, line 6 def check_sequences select_all("SELECT * FROM information_schema.sequences ORDER BY sequence_name").to_a end
create_sequence(name, options = {})
click to toggle source
# File lib/ar/sequence/adapter.rb, line 10 def create_sequence(name, options = {}) increment = options[:increment] || options[:step] name = quote_column_name(name) sql = ["CREATE SEQUENCE IF NOT EXISTS #{name}"] sql << "INCREMENT BY #{increment}" if increment sql << "START WITH #{options[:start]}" if options[:start] execute(sql.join("\n")) end
drop_sequence(name)
click to toggle source
Drop a sequence by its name.
drop_sequence :user_position
# File lib/ar/sequence/adapter.rb, line 25 def drop_sequence(name) name = quote_column_name(name) sql = "DROP SEQUENCE #{name}" execute(sql) end