Skip to content

Instantly share code, notes, and snippets.

@koush
Created November 13, 2010 01:06
Show Gist options
  • Save koush/674985 to your computer and use it in GitHub Desktop.
Save koush/674985 to your computer and use it in GitHub Desktop.
diff -r 78fcda0bf780 Community.CsharpSqlite.WindowsPhone7/Community.CsharpSqlite.WindowsPhone7.csproj
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/Community.CsharpSqlite.WindowsPhone7/Community.CsharpSqlite.WindowsPhone7.csproj Fri Nov 12 17:05:42 2010 -0800
@@ -0,0 +1,319 @@
+<?xml version="1.0" encoding="utf-8"?>
+<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+ <PropertyGroup>
+ <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
+ <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
+ <ProductVersion>10.0.20506</ProductVersion>
+ <SchemaVersion>2.0</SchemaVersion>
+ <ProjectGuid>{D677FBFD-23C4-43BD-977A-0444AF237B5F}</ProjectGuid>
+ <ProjectTypeGuids>{C089C8C0-30E0-4E22-80C0-CE093F111A43};{fae04ec0-301f-11d3-bf4b-00c04f79efbc}</ProjectTypeGuids>
+ <OutputType>Library</OutputType>
+ <AppDesignerFolder>Properties</AppDesignerFolder>
+ <RootNamespace>Community.CsharpSqlite.WindowsPhone7</RootNamespace>
+ <AssemblyName>Community.CsharpSqlite.WindowsPhone7</AssemblyName>
+ <TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
+ <SilverlightVersion>$(TargetFrameworkVersion)</SilverlightVersion>
+ <TargetFrameworkProfile>WindowsPhone</TargetFrameworkProfile>
+ <TargetFrameworkIdentifier>Silverlight</TargetFrameworkIdentifier>
+ <SilverlightApplication>false</SilverlightApplication>
+ <ValidateXaml>true</ValidateXaml>
+ <ThrowErrorsInValidation>true</ThrowErrorsInValidation>
+ </PropertyGroup>
+ <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
+ <DebugSymbols>true</DebugSymbols>
+ <DebugType>full</DebugType>
+ <Optimize>false</Optimize>
+ <OutputPath>Bin\Debug</OutputPath>
+ <DefineConstants>TRACE;DEBUG;SQLITE_SILVERLIGHT TRUE WIN32 _MSC_VER NDEBUG NO_TCL SQLITE_ASCII SQLITE_DISABLE_LFS SQLITE_MEM_POOL SQLITE_MUTEX_OMIT SQLITE_OMIT_AUTHORIZATION SQLITE_OMIT_DEPRECATED SQLITE_OMIT_GET_TABLE SQLITE_OMIT_INCRBLOB SQLITE_OMIT_LOOKASIDE SQLITE_OMIT_SHARED_CACHE SQLITE_OMIT_UTF16 SQLITE_OMIT_VIRTUALTABLE SQLITE_OS_WIN SQLITE_SYSTEM_MALLOC VDBE_PROFILE_OFF WINDOWS_PHONE</DefineConstants>
+ <NoStdLib>true</NoStdLib>
+ <NoConfig>true</NoConfig>
+ <ErrorReport>prompt</ErrorReport>
+ <WarningLevel>4</WarningLevel>
+ </PropertyGroup>
+ <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
+ <DebugType>pdbonly</DebugType>
+ <Optimize>true</Optimize>
+ <OutputPath>Bin\Release</OutputPath>
+ <DefineConstants>TRACE;SQLITE_SILVERLIGHT TRUE WIN32 _MSC_VER NDEBUG NO_TCL SQLITE_ASCII SQLITE_DISABLE_LFS SQLITE_MEM_POOL SQLITE_MUTEX_OMIT SQLITE_OMIT_AUTHORIZATION SQLITE_OMIT_DEPRECATED SQLITE_OMIT_GET_TABLE SQLITE_OMIT_INCRBLOB SQLITE_OMIT_LOOKASIDE SQLITE_OMIT_SHARED_CACHE SQLITE_OMIT_UTF16 SQLITE_OMIT_VIRTUALTABLE SQLITE_OS_WIN SQLITE_SYSTEM_MALLOC VDBE_PROFILE_OFF WINDOWS_PHONE</DefineConstants>
+ <NoStdLib>true</NoStdLib>
+ <NoConfig>true</NoConfig>
+ <ErrorReport>prompt</ErrorReport>
+ <WarningLevel>4</WarningLevel>
+ </PropertyGroup>
+ <ItemGroup>
+ <Reference Include="System.Windows" />
+ <Reference Include="system" />
+ <Reference Include="System.Core" />
+ <Reference Include="System.Xml" />
+ <Reference Include="System.Net" />
+ </ItemGroup>
+ <ItemGroup>
+ <Compile Include="..\Community.CsharpSqlite\src\alter_c.cs">
+ <Link>src\alter_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\analyze_c.cs">
+ <Link>src\analyze_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\attach_c.cs">
+ <Link>src\attach_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\auth_c.cs">
+ <Link>src\auth_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\backup_c.cs">
+ <Link>src\backup_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\bitvec_c.cs">
+ <Link>src\bitvec_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\btmutex_c.cs">
+ <Link>src\btmutex_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\BtreeInt_h.cs">
+ <Link>src\BtreeInt_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\btree_c.cs">
+ <Link>src\btree_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\Btree_h.cs">
+ <Link>src\Btree_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\build_c.cs">
+ <Link>src\build_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\callback_c.cs">
+ <Link>src\callback_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\complete_c.cs">
+ <Link>src\complete_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\crypto.cs">
+ <Link>src\crypto.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\ctime_cs.cs">
+ <Link>src\ctime_cs.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\date_c.cs">
+ <Link>src\date_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\Delegates.cs">
+ <Link>src\Delegates.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\delete_c.cs">
+ <Link>src\delete_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\expr_c.cs">
+ <Link>src\expr_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\fault_c.cs">
+ <Link>src\fault_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\fkey_c.cs">
+ <Link>src\fkey_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\func_c.cs">
+ <Link>src\func_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\global_c.cs">
+ <Link>src\global_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\hash_c.cs">
+ <Link>src\hash_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\Hash_h.cs">
+ <Link>src\Hash_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\hwtime_c.cs">
+ <Link>src\hwtime_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\insert_c.cs">
+ <Link>src\insert_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\journal_c.cs">
+ <Link>src\journal_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\keywordhash_h.cs">
+ <Link>src\keywordhash_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\legacy_c.cs">
+ <Link>src\legacy_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\loadext_c.cs">
+ <Link>src\loadext_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\main_c.cs">
+ <Link>src\main_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\malloc_c.cs">
+ <Link>src\malloc_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\memjournal_c.cs">
+ <Link>src\memjournal_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\mem_Pool.cs">
+ <Link>src\mem_Pool.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\mutex_c.cs">
+ <Link>src\mutex_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\mutex_h.cs">
+ <Link>src\mutex_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\mutex_noop_c.cs">
+ <Link>src\mutex_noop_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\mutex_w32.cs">
+ <Link>src\mutex_w32.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\notify_c.cs">
+ <Link>src\notify_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\opcodes_c.cs">
+ <Link>src\opcodes_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\opcodes_h.cs">
+ <Link>src\opcodes_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\os_c.cs">
+ <Link>src\os_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\os_common_h.cs">
+ <Link>src\os_common_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\os_h.cs">
+ <Link>src\os_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\os_win_c.cs">
+ <Link>src\os_win_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\pager_c.cs">
+ <Link>src\pager_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\pager_h.cs">
+ <Link>src\pager_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\parse_c.cs">
+ <Link>src\parse_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\parse_h.cs">
+ <Link>src\parse_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\pcache1_c.cs">
+ <Link>src\pcache1_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\pcache_c.cs">
+ <Link>src\pcache_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\pcache_h.cs">
+ <Link>src\pcache_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\pragma_c.cs">
+ <Link>src\pragma_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\prepare_c.cs">
+ <Link>src\prepare_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\printf_c.cs">
+ <Link>src\printf_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\random_c.cs">
+ <Link>src\random_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\resolve_c.cs">
+ <Link>src\resolve_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\rowset_c.cs">
+ <Link>src\rowset_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\select_c.cs">
+ <Link>src\select_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\sqlite3ext_h.cs">
+ <Link>src\sqlite3ext_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\sqlite3_h.cs">
+ <Link>src\sqlite3_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\sqliteicu_h.cs">
+ <Link>src\sqliteicu_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\sqliteInt_h.cs">
+ <Link>src\sqliteInt_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\sqliteLimit_h.cs">
+ <Link>src\sqliteLimit_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\status_c.cs">
+ <Link>src\status_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\table_c.cs">
+ <Link>src\table_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\tokenize_c.cs">
+ <Link>src\tokenize_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\trigger_c.cs">
+ <Link>src\trigger_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\update_c.cs">
+ <Link>src\update_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\utf_c.cs">
+ <Link>src\utf_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\util_c.cs">
+ <Link>src\util_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\vacuum_c.cs">
+ <Link>src\vacuum_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\vdbeapi_c.cs">
+ <Link>src\vdbeapi_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\vdbeaux_c.cs">
+ <Link>src\vdbeaux_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\vdbeblob_c.cs">
+ <Link>src\vdbeblob_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\VdbeInt_h.cs">
+ <Link>src\VdbeInt_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\vdbemem_c.cs">
+ <Link>src\vdbemem_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\vdbetrace_c.cs">
+ <Link>src\vdbetrace_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\vdbe_c.cs">
+ <Link>src\vdbe_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\Vdbe_h.cs">
+ <Link>src\Vdbe_h.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\vtab_c.cs">
+ <Link>src\vtab_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\walker_c.cs">
+ <Link>src\walker_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\where_c.cs">
+ <Link>src\where_c.cs</Link>
+ </Compile>
+ <Compile Include="..\Community.CsharpSqlite\src\_Custom.cs">
+ <Link>src\_Custom.cs</Link>
+ </Compile>
+ <Compile Include="MissingMethods.cs" />
+ <Compile Include="Properties\AssemblyInfo.cs" />
+ </ItemGroup>
+ <Import Project="$(MSBuildExtensionsPath)\Microsoft\Silverlight for Phone\$(TargetFrameworkVersion)\Microsoft.Silverlight.$(TargetFrameworkProfile).Overrides.targets" />
+ <Import Project="$(MSBuildExtensionsPath)\Microsoft\Silverlight for Phone\$(TargetFrameworkVersion)\Microsoft.Silverlight.CSharp.targets" />
+ <ProjectExtensions />
+ <!-- To modify your build process, add your task inside one of the targets below and uncomment it.
+ Other similar extension points exist, see Microsoft.Common.targets.
+ <Target Name="BeforeBuild">
+ </Target>
+ <Target Name="AfterBuild">
+ </Target>
+ -->
+</Project>
\ No newline at end of file
diff -r 78fcda0bf780 Community.CsharpSqlite.WindowsPhone7/Community.CsharpSqlite.WindowsPhone7.sln
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/Community.CsharpSqlite.WindowsPhone7/Community.CsharpSqlite.WindowsPhone7.sln Fri Nov 12 17:05:42 2010 -0800
@@ -0,0 +1,20 @@
+
+Microsoft Visual Studio Solution File, Format Version 11.00
+# Visual Studio 2010
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Community.CsharpSqlite.WindowsPhone7", "Community.CsharpSqlite.WindowsPhone7.csproj", "{D677FBFD-23C4-43BD-977A-0444AF237B5F}"
+EndProject
+Global
+ GlobalSection(SolutionConfigurationPlatforms) = preSolution
+ Debug|Any CPU = Debug|Any CPU
+ Release|Any CPU = Release|Any CPU
+ EndGlobalSection
+ GlobalSection(ProjectConfigurationPlatforms) = postSolution
+ {D677FBFD-23C4-43BD-977A-0444AF237B5F}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+ {D677FBFD-23C4-43BD-977A-0444AF237B5F}.Debug|Any CPU.Build.0 = Debug|Any CPU
+ {D677FBFD-23C4-43BD-977A-0444AF237B5F}.Release|Any CPU.ActiveCfg = Release|Any CPU
+ {D677FBFD-23C4-43BD-977A-0444AF237B5F}.Release|Any CPU.Build.0 = Release|Any CPU
+ EndGlobalSection
+ GlobalSection(SolutionProperties) = preSolution
+ HideSolutionNode = FALSE
+ EndGlobalSection
+EndGlobal
diff -r 78fcda0bf780 Community.CsharpSqlite.WindowsPhone7/MissingMethods.cs
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/Community.CsharpSqlite.WindowsPhone7/MissingMethods.cs Fri Nov 12 17:05:42 2010 -0800
@@ -0,0 +1,18 @@
+using System;
+
+
+namespace Community.CsharpSqlite.WindowsPhone7
+{
+ public static class MissingMethods
+ {
+ public static long DoubleToInt64Bits(double value)
+ {
+ return BitConverter.ToInt64(BitConverter.GetBytes(value), 0);
+ }
+
+ public static double Int64BitsToDouble(long value)
+ {
+ return BitConverter.ToDouble(BitConverter.GetBytes(value), 0);
+ }
+ }
+}
diff -r 78fcda0bf780 Community.CsharpSqlite.WindowsPhone7/Properties/AssemblyInfo.cs
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/Community.CsharpSqlite.WindowsPhone7/Properties/AssemblyInfo.cs Fri Nov 12 17:05:42 2010 -0800
@@ -0,0 +1,33 @@
+using System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+// General Information about an assembly is controlled through the following
+// set of attributes. Change these attribute values to modify the information
+// associated with an assembly.
+[assembly: AssemblyTitle("C#-SQLite 3")]
+[assembly: AssemblyDescription("C#-SQLite is an independent reimplementation of the SQLite software library")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("Pioneer Software Consulting")]
+[assembly: AssemblyProduct("C#-SQLite3 shell")]
+[assembly: AssemblyCopyright("Copyright © 2009")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// Setting ComVisible to false makes the types in this assembly not visible
+// to COM components. If you need to access a type in this assembly from
+// COM, set the ComVisible attribute to true on that type.
+[assembly: ComVisible(false)]
+
+// The following GUID is for the ID of the typelib if this project is exposed to COM
+[assembly: Guid("2133c634-4139-466e-8983-9a23ec99e01b")]
+
+// Version information for an assembly consists of the following four values:
+//
+// Major Version
+// Minor Version
+// Build Number
+// Revision
+//
+[assembly: AssemblyVersion("3.6.23.2")]
+[assembly: AssemblyFileVersion("1.0.0.0")]
diff -r 78fcda0bf780 Community.CsharpSqlite/src/btree_c.cs
--- a/Community.CsharpSqlite/src/btree_c.cs Fri Jul 30 06:29:20 2010 -0700
+++ b/Community.CsharpSqlite/src/btree_c.cs Fri Nov 12 17:05:42 2010 -0800
@@ -6037,7 +6037,9 @@
if ( pRC != 0 ) return;
Debug.Assert( idx >= 0 && idx < pPage.nCell );
+#if !WINDOWS_PHONE
Debug.Assert( sz == cellSize( pPage, idx ) );
+#endif
Debug.Assert( sqlite3PagerIswriteable( pPage.pDbPage ) );
Debug.Assert( sqlite3_mutex_held( pPage.pBt.mutex ) );
data = pPage.aData;
diff -r 78fcda0bf780 Community.CsharpSqlite/src/os_win_c.cs
--- a/Community.CsharpSqlite/src/os_win_c.cs Fri Jul 30 06:29:20 2010 -0700
+++ b/Community.CsharpSqlite/src/os_win_c.cs Fri Nov 12 17:05:42 2010 -0800
@@ -1716,8 +1716,10 @@
while ( ( fs == null ) && ( retries > 0 ) )
try
{
- retries--;
-#if !SQLITE_SILVERLIGHT
+ retries--;
+#if WINDOWS_PHONE
+ fs = new System.IO.IsolatedStorage.IsolatedStorageFileStream(zConverted, dwCreationDisposition, dwDesiredAccess, dwShareMode, System.IO.IsolatedStorage.IsolatedStorageFile.GetUserStoreForApplication());
+#elif !SQLITE_SILVERLIGHT
fs = new FileStream( zConverted, dwCreationDisposition, dwDesiredAccess, dwShareMode, 4096, dwFlagsAndAttributes );
#else
fs = new FileStream(zConverted, dwCreationDisposition, dwDesiredAccess, dwShareMode, 4096);
@@ -1849,14 +1851,22 @@
// && (++cnt < MX_DELETION_ATTEMPTS)
// && (Sleep(100), 1) );
{
+#if WINDOWS_PHONE
+ if ( !System.IO.IsolatedStorage.IsolatedStorageFile.GetUserStoreForApplication().FileExists( zFilename ) )
+#else
if ( !File.Exists( zFilename ) )
+#endif
{
rc = SQLITE_IOERR;
break;
}
try
{
+#if WINDOWS_PHONE
+ System.IO.IsolatedStorage.IsolatedStorageFile.GetUserStoreForApplication().DeleteFile(zFilename);
+#else
File.Delete( zConverted );
+#endif
rc = SQLITE_OK;
}
catch ( IOException e )
@@ -1930,14 +1940,22 @@
// Do a quick test to prevent the try/catch block
if ( flags == SQLITE_ACCESS_EXISTS )
{
+#if WINDOWS_PHONE
+ pResOut = System.IO.IsolatedStorage.IsolatedStorageFile.GetUserStoreForApplication().FileExists( zFilename ) ? 1 : 0;
+#else
pResOut = File.Exists( zFilename ) ? 1 : 0;
+#endif
return SQLITE_OK;
}
//
try
{
+#if WINDOWS_PHONE
+ if (new DirectoryInfo(zFilename).Exists)
+#else
attr = File.GetAttributes( zFilename );// GetFileAttributesW( (WCHAR*)zConverted );
if ( attr == FileAttributes.Directory )
+#endif
{
try
{
@@ -2026,8 +2044,12 @@
//zTemp = GetFullPathNameW(zConverted, nByte, zTemp, 0);
// will happen on exit; was free(zConverted);
try
- {
- zOut = Path.GetFullPath( zRelative ); // was unicodeToUtf8(zTemp);
+ {
+#if WINDOWS_PHONE
+ zOut = zRelative;
+#else
+ zOut = Path.GetFullPath(zRelative); // was unicodeToUtf8(zTemp);
+#endif
}
catch ( IOException e )
{ zOut = zRelative; }
diff -r 78fcda0bf780 Community.CsharpSqlite/src/vdbeaux_c.cs
--- a/Community.CsharpSqlite/src/vdbeaux_c.cs Fri Jul 30 06:29:20 2010 -0700
+++ b/Community.CsharpSqlite/src/vdbeaux_c.cs Fri Nov 12 17:05:42 2010 -0800
@@ -3246,7 +3246,11 @@
if ( serial_type == 7 )
{
//Debug.Assert( sizeof( v) == sizeof(pMem.r));
+#if WINDOWS_PHONE
+ v = (ulong)Community.CsharpSqlite.WindowsPhone7.MissingMethods.DoubleToInt64Bits(pMem.r);
+#else
v = (ulong)BitConverter.DoubleToInt64Bits( pMem.r );// memcpy( &v, pMem.r, v ).Length;
+#endif
#if SQLITE_MIXED_ENDIAN_64BIT_FLOAT
swapMixedEndianFloat( v );
#endif
@@ -3384,7 +3388,11 @@
#if SQLITE_MIXED_ENDIAN_64BIT_FLOAT
swapMixedEndianFloat(x);
#endif
+#if WINDOWS_PHONE
+ pMem.r = Community.CsharpSqlite.WindowsPhone7.MissingMethods.Int64BitsToDouble((long)x);
+#else
pMem.r = BitConverter.Int64BitsToDouble( (long)x );// memcpy(pMem.r, x, sizeof(x))
+#endif
pMem.flags = (u16)( sqlite3IsNaN( pMem.r ) ? MEM_Null : MEM_Real );
}
return 8;
@@ -3503,7 +3511,11 @@
#if SQLITE_MIXED_ENDIAN_64BIT_FLOAT
swapMixedEndianFloat(x);
#endif
+#if WINDOWS_PHONE
+ pMem.r = Community.CsharpSqlite.WindowsPhone7.MissingMethods.Int64BitsToDouble((long)x);
+#else
pMem.r = BitConverter.Int64BitsToDouble( (long)x );// memcpy(pMem.r, x, sizeof(x))
+#endif
pMem.flags = MEM_Real;
}
return 8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment