Module: SpaceCadetPostgresqlHack

Included in:
SpaceCadetUuid
Defined in:
lib/space_cadet_postgresql_hack.rb

Instance Method Summary collapse

Instance Method Details

#new_uuid(conn) ⇒ Object

create extension “uuid-ossp”



12
13
14
15
# File 'lib/space_cadet_postgresql_hack.rb', line 12

def new_uuid conn
  conn.execute("select uuid_generate_v4() as u")[0]['u']
  # SecureRandom.uuid
end

#set_auto_increment(conn, table_name, id) ⇒ Object



6
7
8
9
# File 'lib/space_cadet_postgresql_hack.rb', line 6

def set_auto_increment conn, table_name, id
  primary_id_seq = table_name + '_id_seq'
  conn.execute("select setval('#{primary_id_seq}', #{id - 1});")
end