Class: Sqlite3Extension

Inherits:
Object
  • Object
show all
Defined in:
lib/sqlite3_extensions.rb

Class Method Summary collapse

Class Method Details

.regexp ⇒ Object 



8
9
10
11
12
13
14
15
16
17
18
19
20
 
# File 'lib/sqlite3_extensions.rb', line 8

def self.regexp
  @connection.create_function("regexp", 2) do |func, expr, value|
    begin
      if value.to_s && value.to_s.match(Regexp.new(expr.to_s))
        func.result = 1
      else
        func.result = 0
      end
    rescue => e
      puts "error: #{e}"
    end
  end
end

.setup(connection) ⇒ Object 



2
3
4
5
6
 
# File 'lib/sqlite3_extensions.rb', line 2

def self.setup(connection)
  @connection = connection
  regexp
  year
end

.year ⇒ Object 



22
23
24
25
26
27
28
29
30
 
# File 'lib/sqlite3_extensions.rb', line 22

def self.year
  @connection.create_function("year", 1) do |func, date|
    begin
      func.result = Date.parse(date).year
    rescue => e
      puts "error: #{e}"
    end
  end
end