Method: Ayadn::Databases.pagination_insert

Defined in:

lib/ayadn/databases.rb

.pagination_insert(name, val) ⇒ Object

# File 'lib/ayadn/databases.rb', line 941

def self.pagination_insert(name, val)
  crashes = 0
  begin
    @sql.execute("DELETE FROM Pagination WHERE name=(?)", [name])
    @sql.execute("INSERT INTO Pagination(name, post_id) VALUES(?, ?);", [name, val.to_i])
  rescue Amalgalite::SQLite3::Error => e
    if crashes < 2
      crashes += 1
      sleep(0.01)
      retry
    else
      puts "ERROR in Databases"
      puts caller
      puts e
      puts ['pagination_insert', name, val].inspect
      exit
    end
  end
end