Class: KnjDB_sqlite3_ironruby

Inherits:
Object
  • Object
show all
Defined in:
lib/knj/knjdb/libknjdb_sqlite3_ironruby.rb

Instance Method Summary collapse

Constructor Details

#initialize(knjdb_ob) ⇒ KnjDB_sqlite3_ironruby

Returns a new instance of KnjDB_sqlite3_ironruby.



17
18
19
20
21
 
# File 'lib/knj/knjdb/libknjdb_sqlite3_ironruby.rb', line 17

def initialize(knjdb_ob)
  @knjdb = knjdb_ob
  @conn = Mono::Data::SqliteClient::SqliteConnection.new("URI=file:" + @knjdb.opts[:path] + ",version=3")
  @conn.Open
end

Instance Method Details

#escape(string) ⇒ Object 



30
31
32
33
34
35
36
37
 
# File 'lib/knj/knjdb/libknjdb_sqlite3_ironruby.rb', line 30

def escape(string)
  if (!string)
    return ""
  end
  
    string = string.gsub("'", "\\'")
  return string
end

#escape_col ⇒ Object 



9
10
11
 
# File 'lib/knj/knjdb/libknjdb_sqlite3_ironruby.rb', line 9

def escape_col
  return "`"
end

#escape_table ⇒ Object 



5
6
7
 
# File 'lib/knj/knjdb/libknjdb_sqlite3_ironruby.rb', line 5

def escape_table
  return "`"
end

#escape_val ⇒ Object 



13
14
15
 
# File 'lib/knj/knjdb/libknjdb_sqlite3_ironruby.rb', line 13

def escape_val
  return "'"
end

#lastID ⇒ Object 



39
40
41
 
# File 'lib/knj/knjdb/libknjdb_sqlite3_ironruby.rb', line 39

def lastID
  return @conn.last_insert_row_id
end

#query(string) ⇒ Object 



23
24
25
26
27
28
 
# File 'lib/knj/knjdb/libknjdb_sqlite3_ironruby.rb', line 23

def query(string)
  dbcmd = @conn.CreateCommand
  dbcmd.CommandText = string
  reader = dbcmd.ExecuteReader
  return KnjDB_sqlite3_ironruby_result.new(reader)
end