internal void ReadpVm(IntPtr pVm, int version, SqliteCommand cmd)
{
int pN;
IntPtr pazValue;
IntPtr pazColName;
bool first = true;
int[] declmode = null;
while (true)
{
bool hasdata = cmd.ExecuteStatement(pVm, out pN, out pazValue, out pazColName);
// For the first row, get the column information
if (first)
{
first = false;
if (version == 3)
{
// A decltype might be null if the type is unknown to sqlite.
decltypes = new string[pN];
declmode = new int[pN]; // 1 == integer, 2 == datetime
for (int i = 0; i < pN; i++)
{
IntPtr decl = Sqlite.sqlite3_column_decltype16(pVm, i);
if (decl != IntPtr.Zero)
{
decltypes[i] = Marshal.PtrToStringUni(decl).ToLower(System.Globalization.CultureInfo.InvariantCulture);
if (decltypes[i] == "int" || decltypes[i] == "integer")
{
declmode[i] = 1;
}
else if (decltypes[i] == "date" || decltypes[i] == "datetime")
{
declmode[i] = 2;
}
}
}
}
columns = new string[pN];
for (int i = 0; i < pN; i++)
{
string colName;
if (version == 2)
{
IntPtr fieldPtr = Marshal.ReadIntPtr(pazColName, i * IntPtr.Size);
colName = Sqlite.HeapToString(fieldPtr, ((SqliteConnection)cmd.Connection).Encoding);
}
else
{
colName = Marshal.PtrToStringUni(Sqlite.sqlite3_column_name16(pVm, i));
}
columns[i] = colName;
column_names_sens [colName] = i;
column_names_insens [colName] = i;
}
}
if (!hasdata)
{
break;
}
object[] data_row = new object [pN];
for (int i = 0; i < pN; i++)
{
if (version == 2)
{
IntPtr fieldPtr = Marshal.ReadIntPtr(pazValue, i * IntPtr.Size);
data_row[i] = Sqlite.HeapToString(fieldPtr, ((SqliteConnection)cmd.Connection).Encoding);
}
else
{
switch (Sqlite.sqlite3_column_type(pVm, i))
{
case 1:
long val = Sqlite.sqlite3_column_int64(pVm, i);
// If the column was declared as an 'int' or 'integer', let's play
// nice and return an int (version 3 only).
if (declmode[i] == 1 && val >= int.MinValue && val <= int.MaxValue)
{
data_row[i] = (int)val;
}
// Or if it was declared a date or datetime, do the reverse of what we
// do for DateTime parameters.
else if (declmode[i] == 2)
{
data_row[i] = DateTime.FromFileTime(val);
}
else
{
data_row[i] = val;
}
break;
case 2:
data_row[i] = Sqlite.sqlite3_column_double(pVm, i);
break;
case 3:
data_row[i] = Marshal.PtrToStringUni(Sqlite.sqlite3_column_text16(pVm, i));
// If the column was declared as a 'date' or 'datetime', let's play
// nice and return a DateTime (version 3 only).
if (declmode[i] == 2)
{
data_row[i] = DateTime.Parse((string)data_row[i]);
}
break;
case 4:
int blobbytes = Sqlite.sqlite3_column_bytes16(pVm, i);
IntPtr blobptr = Sqlite.sqlite3_column_blob(pVm, i);
byte[] blob = new byte[blobbytes];
Marshal.Copy(blobptr, blob, 0, blobbytes);
data_row[i] = blob;
break;
case 5:
data_row[i] = null;
break;
default:
throw new ApplicationException("FATAL: Unknown sqlite3_column_type");
}
}
}
rows.Add(data_row);
}
}
private void BindParameters3(IntPtr pStmt)
{
if (sql_params == null)
{
return;
}
if (sql_params.Count == 0)
{
return;
}
int pcount = Sqlite.sqlite3_bind_parameter_count(pStmt);
for (int i = 1; i <= pcount; i++)
{
String name = Sqlite.HeapToString(Sqlite.sqlite3_bind_parameter_name(pStmt, i), Encoding.UTF8);
SqliteParameter param = null;
if (name != null)
{
param = sql_params[name] as SqliteParameter;
}
else
{
param = sql_params[i - 1] as SqliteParameter;
}
if (param.Value == null)
{
Sqlite.sqlite3_bind_null(pStmt, i);
continue;
}
Type ptype = param.Value.GetType();
if (ptype.IsEnum)
{
ptype = Enum.GetUnderlyingType(ptype);
}
SqliteError err;
if (ptype.Equals(typeof(String)))
{
String s = (String)param.Value;
err = Sqlite.sqlite3_bind_text16(pStmt, i, s, -1, (IntPtr)(-1));
}
else if (ptype.Equals(typeof(DBNull)))
{
err = Sqlite.sqlite3_bind_null(pStmt, i);
}
else if (ptype.Equals(typeof(Boolean)))
{
bool b = (bool)param.Value;
err = Sqlite.sqlite3_bind_int(pStmt, i, b ? 1 : 0);
}
else if (ptype.Equals(typeof(Byte)))
{
err = Sqlite.sqlite3_bind_int(pStmt, i, (Byte)param.Value);
}
else if (ptype.Equals(typeof(Char)))
{
err = Sqlite.sqlite3_bind_int(pStmt, i, (Char)param.Value);
}
else if (ptype.IsEnum)
{
err = Sqlite.sqlite3_bind_int(pStmt, i, (Int32)param.Value);
}
else if (ptype.Equals(typeof(Int16)))
{
err = Sqlite.sqlite3_bind_int(pStmt, i, (Int16)param.Value);
}
else if (ptype.Equals(typeof(Int32)))
{
err = Sqlite.sqlite3_bind_int(pStmt, i, (Int32)param.Value);
}
else if (ptype.Equals(typeof(SByte)))
{
err = Sqlite.sqlite3_bind_int(pStmt, i, (SByte)param.Value);
}
else if (ptype.Equals(typeof(UInt16)))
{
err = Sqlite.sqlite3_bind_int(pStmt, i, (UInt16)param.Value);
}
else if (ptype.Equals(typeof(DateTime)))
{
DateTime dt = (DateTime)param.Value;
err = Sqlite.sqlite3_bind_int64(pStmt, i, dt.ToFileTime());
}
else if (ptype.Equals(typeof(Double)))
{
err = Sqlite.sqlite3_bind_double(pStmt, i, (Double)param.Value);
}
else if (ptype.Equals(typeof(Single)))
{
err = Sqlite.sqlite3_bind_double(pStmt, i, (Single)param.Value);
}
else if (ptype.Equals(typeof(UInt32)))
{
err = Sqlite.sqlite3_bind_int64(pStmt, i, (UInt32)param.Value);
}
else if (ptype.Equals(typeof(Int64)))
{
err = Sqlite.sqlite3_bind_int64(pStmt, i, (Int64)param.Value);
}
else if (ptype.Equals(typeof(Byte[])))
{
err = Sqlite.sqlite3_bind_blob(pStmt, i, (Byte[])param.Value, ((Byte[])param.Value).Length, (IntPtr)(-1));
}
else
{
throw new ApplicationException("Unkown Parameter Type");
}
if (err != SqliteError.OK)
{
throw new ApplicationException("Sqlite error in bind " + err);
}
}
}
