StatementRow
sqlite3 :: StatementEntry :: defaultinit
sqlite3 :: StatementEntry :: statement=
Statement linked toself
sqlite3 :: StatementEntry :: value
Get the value of this entry according to its Sqlite typesqlite3 $ StatementEntry :: SELF
Type of this instance, automatically specialized in every classcore :: Object :: class_factory
Implementation used byget_class
to create the specific class.
sqlite3 :: StatementEntry :: defaultinit
core :: Object :: defaultinit
core :: Object :: is_same_instance
Return true ifself
and other
are the same instance (i.e. same identity).
core :: Object :: is_same_serialized
Isself
the same as other
in a serialization context?
core :: Object :: is_same_type
Return true ifself
and other
have the same dynamic type.
core :: Object :: output_class_name
Display class name on stdout (debug only).sqlite3 :: StatementEntry :: statement=
Statement linked toself
sqlite3 :: StatementEntry :: value
Get the value of this entry according to its Sqlite type
# An entry on a `StatementRow`
class StatementEntry
# Statement linked to `self`
var statement: Statement
private var index: Int
# Name of the column
#
# require: `self.statement.is_open`
var name: String is lazy do
assert statement_closed: statement.is_open
var cname = statement.native_statement.column_name(index)
assert not cname.address_is_null
return cname.to_s
end
# Get the value of this entry according to its Sqlite type
#
# require: `self.statement.is_open`
fun value: nullable Sqlite3Data
do
assert statement_closed: statement.is_open
var data_type = statement.native_statement.column_type(index)
if data_type.is_integer then return to_i
if data_type.is_float then return to_f
if data_type.is_blob then return to_blob
if data_type.is_null then return null
if data_type.is_text then return to_s
abort
end
# Get this entry as `Int`
#
# If the Sqlite type of this entry is not an integer, it will be `CAST` to
# integer. If `null`, returns 0.
#
# require: `self.statement.is_open`
fun to_i: Int
do
assert statement_closed: statement.is_open
return statement.native_statement.column_int(index)
end
# Get this entry as `Float`
#
# If the Sqlite type of this entry is not a floating point, it will be `CAST`
# to float. If `null`, returns 0.0.
#
# require: `self.statement.is_open`
fun to_f: Float
do
assert statement_closed: statement.is_open
return statement.native_statement.column_double(index)
end
# Get this entry as `String`
#
# If the Sqlite type of this entry is not text, it will be `CAST` to text.
# If null, returns an empty string.
#
# require: `self.statement.is_open`
redef fun to_s
do
assert statement_closed: statement.is_open
var c_string = statement.native_statement.column_text(index)
if c_string.address_is_null then return ""
return c_string.to_s
end
# Get this entry as `Blob`
#
# If the Sqlite type of this entry is not a blob, it will be `CAST` to text.
# If null, returns a NULL pointer.
#
# require: `self.statement.is_open`
fun to_blob: Blob
do
assert statement_closed: statement.is_open
# By spec, we must get the pointer before the byte count
var pointer = statement.native_statement.column_blob(index)
var length = statement.native_statement.column_bytes(index)
return new Blob(pointer, length)
end
end
lib/sqlite3/sqlite3.nit:183,1--274,3