コード例 #1
0
        internal void ReadpVm(Sqlite3.Vdbe pVm, int version, SQLiteCommand cmd)
        {
            int    pN;
            IntPtr pazValue;
            IntPtr pazColName;
            bool   first = true;

            DeclaredMode[] 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 DeclaredMode[pN]; // 1 == integer, 2 == datetime
                        for (int i = 0; i < pN; i++)
                        {
                            string decl = Sqlite3.sqlite3_column_decltype(pVm, i);
                            if (decl != null)
                            {
                                decltypes[i] = decl.ToLower(System.Globalization.CultureInfo.InvariantCulture);
                                if (decltypes[i] == "int" || decltypes[i] == "integer")
                                {
                                    declmode[i] = DeclaredMode.Integer;
                                }
                                else if (decltypes[i] == "date" || decltypes[i] == "datetime")
                                {
                                    declmode[i] = DeclaredMode.DateTime;
                                }
                                else if (decltypes[i] == "uniqueidentifier" || decltypes[i] == "guid")
                                {
                                    declmode[i] = DeclaredMode.Guid;
                                }
                            }
                        }
                    }

                    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 = Sqlite3.sqlite3_column_name(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++)
                {
                    switch (Sqlite3.sqlite3_column_type(pVm, i))
                    {
                    case 1:
                        long val = Sqlite3.sqlite3_column_int64(pVm, i);

                        // If the column was declared as an 'int' or 'integer' OR the type of column is unknown
                        // let's play nice and return an int (version 3 only).
                        if ((declmode[i] == DeclaredMode.Integer || decltypes[i] == null) && 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] == DeclaredMode.DateTime)
                        {
                            data_row[i] = DateTime.FromFileTime(val);
                        }
                        else
                        {
                            data_row[i] = val;
                        }

                        break;

                    case 2:
                        data_row[i] = Sqlite3.sqlite3_column_double(pVm, i);
                        break;

                    case 3:
                        data_row[i] = Sqlite3.sqlite3_column_text(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] == DeclaredMode.DateTime)
                        {
                            if (data_row[i] == null)
                            {
                                data_row[i] = null;
                            }
                            else
                            {
                                data_row[i] = DateTime.Parse((string)data_row[i], System.Globalization.CultureInfo.InvariantCulture);
                            }
                        }
                        else if (declmode[i] == DeclaredMode.Guid)
                        {
                            Guid g;
                            if (data_row[i] == null)
                            {
                                data_row[i] = null;
                            }
                            else if (Guid.TryParse((string)data_row[i], out g))
                            {
                                data_row[i] = g;
                            }
                        }
                        break;

                    case 4:
                        byte[] blob = Sqlite3.sqlite3_column_blob(pVm, i);
                        data_row[i] = blob;
                        break;

                    case 5:
                        data_row[i] = null;
                        break;

                    default:
                        throw new Exception("FATAL: Unknown sqlite3_column_type");
                    }
                }
                rows.Add(data_row);
            }
        }
コード例 #2
0
ファイル: SQLiteDataReader.cs プロジェクト: jcwmoore/athena
		internal void ReadpVm (Sqlite3.Vdbe pVm, int version, SQLiteCommand cmd)
		{
			int pN;
			IntPtr pazValue;
			IntPtr pazColName;
			bool first = true;
			
			DeclaredMode[] 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 DeclaredMode[pN]; // 1 == integer, 2 == datetime
						for (int i = 0; i < pN; i++) {
							string decl = Sqlite3.sqlite3_column_decltype (pVm, i);
							if (decl != null) {
								decltypes[i] = decl.ToLower(System.Globalization.CultureInfo.InvariantCulture);
								if (decltypes[i] == "int" || decltypes[i] == "integer")
									declmode[i] = DeclaredMode.Integer;
								else if (decltypes[i] == "date" || decltypes[i] == "datetime")
									declmode[i] = DeclaredMode.DateTime;
								else if(decltypes[i] == "uniqueidentifier" || decltypes[i] == "guid")
									declmode[i] = DeclaredMode.Guid;
							}
						}
					}
					
					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 = Sqlite3.sqlite3_column_name (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++) {
				switch (Sqlite3.sqlite3_column_type (pVm, i)) {
					case 1:
						long val = Sqlite3.sqlite3_column_int64 (pVm, i);
					
						// If the column was declared as an 'int' or 'integer' OR the type of column is unknown
						// let's play nice and return an int (version 3 only).
						if ((declmode[i] == DeclaredMode.Integer || decltypes[i] == null) && 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] == DeclaredMode.DateTime)
							data_row[i] = DateTime.FromFileTime(val);								
						else
							data_row[i] = val;
							
						break;
					case 2:
						data_row[i] = Sqlite3.sqlite3_column_double (pVm, i);
						break;
					case 3:
						data_row[i] = Sqlite3.sqlite3_column_text (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] == DeclaredMode.DateTime)
							if (data_row[i] == null) data_row[i] = null;
							else data_row[i] = DateTime.Parse((string)data_row[i], System.Globalization.CultureInfo.InvariantCulture);
						else if (declmode[i] == DeclaredMode.Guid){
							Guid g;
							if (data_row[i] == null) data_row[i] = null;
							else if (Guid.TryParse((string)data_row[i], out g)) data_row[i] = g;
						}
						break;
					case 4:
						byte[] blob = Sqlite3.sqlite3_column_blob(pVm, i);
						data_row[i] = blob;
						break;
					case 5:
						data_row[i] = null;
						break;
					default:
						throw new Exception ("FATAL: Unknown sqlite3_column_type");
					}
				}
				rows.Add (data_row);
			}
		}