Contents

class KnjDB_java_sqlite3
	def escape_table
		return "`"
	end
	
	def escape_col
		return "`"
	end
	
	def escape_val
		return "'"
	end
	
	def initialize(knjdb_ob)
		@knjdb = knjdb_ob
		
		if @knjdb.opts[:sqlite_driver]
			require @knjdb.opts[:sqlite_driver]
		else
			require File.dirname(__FILE__) + "/sqlitejdbc-v056.jar"
		end
		
		require "java"
		import "org.sqlite.JDBC"
		@conn = java.sql.DriverManager::getConnection("jdbc:sqlite:" + @knjdb.opts[:path])
		@stat = @conn.createStatement
	end
	
	def query(string)
		begin
			return KnjDB_java_sqlite3_result.new(@stat.executeQuery(string))
		rescue java.sql.SQLException => e
			if e.message == "java.sql.SQLException: query does not return ResultSet"
				#ignore it.
			else
				raise e
			end
		end
	end
	
	def fetch(result)
		return result.fetch
	end
	
	def escape(string)
		if (!string)
			return ""
		end
		
    	string = string.gsub("'", "\\'")
		return string
	end
	
	def lastID
		return @conn.last_insert_row_id
	end
end

class KnjDB_java_sqlite3_result
	def initialize(rs)
		@rs = rs
		@index = 0
		
		if rs
			@metadata = rs.getMetaData
			@columns_count = @metadata.getColumnCount
		end
	end
	
	def fetch
		if !@rs.next
			return false
		end
		
		tha_return = {}
		for i in (1..@columns_count)
			col_name = @metadata.getColumnName(i)
			tha_return.store(col_name, @rs.getString(i))
		end
		
		return tha_return
	end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
knjrbfw-0.0.8	lib/knj/knjdb/libknjdb_java_sqlite3.rb
knjrbfw-0.0.7	lib/knj/knjdb/libknjdb_java_sqlite3.rb
knjrbfw-0.0.4	lib/knj/knjdb/libknjdb_java_sqlite3.rb
knjrbfw-0.0.3	lib/knj/knjdb/libknjdb_java_sqlite3.rb