Sha256: b9e898d816c8b467bc8ae270cf5e596b0fabbffc132f688dfdc044560454d82b
Contents?: true
Size: 954 Bytes
Versions: 24
Compression:
Stored size: 954 Bytes
Contents
# -*- coding: utf-8 -*-
#
# 採番
#
module ActiveRecord::Turntable
class Sequencer
class Mysql < Sequencer
def initialize(klass, options = {})
@klass = klass
@options = options
end
def next_sequence_value(sequence_name)
conn = @klass.connection.seq.connection
conn.execute "UPDATE #{@klass.connection.quote_table_name(sequence_name)} SET id=LAST_INSERT_ID(id+1)"
res = conn.execute("SELECT LAST_INSERT_ID()")
new_id = res.first.first.to_i
raise SequenceNotFoundError if new_id.zero?
return new_id
end
def current_sequence_value(sequence_name)
conn = @klass.connection.seq.connection
conn.execute "UPDATE #{@klass.connection.quote_table_name(sequence_name)} SET id=LAST_INSERT_ID(id)"
res = conn.execute("SELECT LAST_INSERT_ID()")
current_id = res.first.first.to_i
return current_id
end
end
end
end
Version data entries
24 entries across 24 versions & 1 rubygems