Class: SolidObjects::DatabaseAdapters::Sqlite

Inherits:
SolidObjects::DatabaseAdapter show all
Defined in:
lib/solid_objects/database_adapters/sqlite.rb,
sig/generated/lib/solid_objects/database_adapters/sqlite.rbs

Constant Summary collapse

LOCK_RETRY_INTERVAL =

Returns:

  • (::Float) 
0.001

Instance Attribute Summary

Attributes inherited from SolidObjects::DatabaseAdapter

#connection_pool, #fixed_connection

Instance Method Summary collapse

Methods inherited from SolidObjects::DatabaseAdapter

#claim_lock, #configure_transaction_deadline, #database_now, for, #initialize, #lock_candidates, #supports_skip_locked?, #with_connection

Constructor Details

This class inherits a constructor from SolidObjects::DatabaseAdapter

Instance Method Details

#current_time_expression ⇒ String

RBS:

  • () -> String

Returns:

  • (String) 


9
10
11
 
# File 'lib/solid_objects/database_adapters/sqlite.rb', line 9

def current_time_expression
  "STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')"
end

#deadline_error?(error) ⇒ Boolean

RBS:

  • (Exception) -> bool

Parameters:

  • (Exception)

Returns:

  • (Boolean) 


39
40
41
42
43
44
45
46
47
48
49
 
# File 'lib/solid_objects/database_adapters/sqlite.rb', line 39

def deadline_error?(error)
  return false unless SyncDeadline.active?

  cause = error
  while cause
    return true if cause.class.name.match?(/BusyException|BusyError/)

    cause = cause.cause
  end
  false
end

#transaction { ... } ⇒ Object

RBS:

  • () { () -> untyped } -> untyped

Yields:

Yield Returns:

  • (Object)

Returns:

  • (Object) 


14
15
16
17
18
19
20
21
22
23
 
# File 'lib/solid_objects/database_adapters/sqlite.rb', line 14

def transaction(&block)
  return super unless SyncDeadline.active?

  super
rescue DatabaseDeadlineExceeded
  raise if SyncDeadline.expired?

  sleep [ LOCK_RETRY_INTERVAL, SyncDeadline.remaining ].min
  retry
end

#with_transaction_deadline(connection) { ... } ⇒ Object

RBS:

  • (untyped) { () -> untyped } -> untyped

Parameters:

  • (Object)

Yields:

Yield Returns:

  • (Object)

Returns:

  • (Object) 


28
29
30
31
32
33
34
35
36
 
# File 'lib/solid_objects/database_adapters/sqlite.rb', line 28

def with_transaction_deadline(connection)
  return yield unless SyncDeadline.active?

  previous_timeout = connection.select_value("PRAGMA busy_timeout").to_i
  connection.execute("PRAGMA busy_timeout = 0")
  yield
ensure
  connection.execute("PRAGMA busy_timeout = #{previous_timeout}") if previous_timeout
end