編集履歴

質問編集履歴

コードが冗長であったため、いったん非表示にしました

2021/11/21 08:11

投稿

blueyellow

スコア4

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -28,620 +28,10 @@
-いったい自分のコードのどこに原因があったのでしょうか。
-お教えいただけますと幸いです。よろしくお願いいたします。
-### SqliteDatabase.cs
-```C#
-public class SqliteDatabase
-{
-    [DllImport("sqlite3", EntryPoint = "sqlite3_exec")]
-    private static extern int sqlite3_exec(IntPtr db, string sql, IntPtr callback, IntPtr args, out IntPtr errorMessage);
-    [DllImport("sqlite3", EntryPoint = "sqlite3_open")]
-	private static extern int sqlite3_open (string filename, out IntPtr db);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_close")]
-	private static extern int sqlite3_close (IntPtr db);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_prepare_v2")]
-	private static extern int sqlite3_prepare_v2 (IntPtr db, string zSql, int nByte, out IntPtr ppStmpt, IntPtr pzTail);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_step")]
-	private static extern int sqlite3_step (IntPtr stmHandle);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_finalize")]
-	private static extern int sqlite3_finalize (IntPtr stmHandle);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_errmsg")]
-	private static extern IntPtr sqlite3_errmsg (IntPtr db);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_column_count")]
-	private static extern int sqlite3_column_count (IntPtr stmHandle);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_column_name")]
-	private static extern IntPtr sqlite3_column_name (IntPtr stmHandle, int iCol);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_column_type")]
-	private static extern int sqlite3_column_type (IntPtr stmHandle, int iCol);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_column_int")]
-	private static extern int sqlite3_column_int (IntPtr stmHandle, int iCol);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_column_text")]
-	private static extern IntPtr sqlite3_column_text (IntPtr stmHandle, int iCol);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_column_double")]
-	private static extern double sqlite3_column_double (IntPtr stmHandle, int iCol);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_column_blob")]
-	private static extern IntPtr sqlite3_column_blob (IntPtr stmHandle, int iCol);
-	[DllImport("sqlite3", EntryPoint = "sqlite3_column_bytes")]
-	private static extern int sqlite3_column_bytes (IntPtr stmHandle, int iCol);
-	private IntPtr _connection;
-	private bool IsConnectionOpen { get; set; }
-	private string pathDB;
-    #region Public Methods
-    public SqliteDatabase(string dbName)
-    {
-        pathDB = System.IO.Path.Combine(Application.persistentDataPath, dbName);
-        string sourcePath = System.IO.Path.Combine(Application.streamingAssetsPath, dbName);
-        if (!System.IO.File.Exists(pathDB) )
-        {
-            if (sourcePath.Contains("://"))
-            {
-                WWW www = new WWW(sourcePath);
-                while (!www.isDone) {; }
-                if (String.IsNullOrEmpty(www.error))
-                {
-                    System.IO.File.WriteAllBytes(pathDB, www.bytes);
-                }
-                else
-                {
-                    CanExQuery = false;
-                }
-            }
-            else
-            {
-                if (System.IO.File.Exists(sourcePath))
-                {
-                    System.IO.File.Copy(sourcePath, pathDB, true);
-                }
-                else
-                {
-                    CanExQuery = false;
-                    Debug.Log("ERROR: the file DB named " + dbName + " doesn't exist in the StreamingAssets Folder, please copy it there.");
-                }
-            }
-        }
-    }
-    private void Open()
-    {
-        this.Open(pathDB);
-    }
-    private void Open(string path)
-    {
-        if (IsConnectionOpen)
-        {
-            throw new SqliteException("There is already an open connection");
-        }
-        if (sqlite3_open(path, out _connection) != SQLITE_OK)
-        {
-            throw new SqliteException("Could not open database file: " + path);
-        }
-        IsConnectionOpen = true;
-    }
-    private void Close()
-    {
-        if (IsConnectionOpen)
-        {
-            sqlite3_close(_connection);
-        }
-        IsConnectionOpen = false;
-    }
-    public void ExecuteNonQuery(string query)
-    {
-        if (!CanExQuery)
-        {
-            Debug.Log("ERROR: Can't execute the query, verify DB origin file");
-            return;
-        }
-        if (!IsTransaction)
-        {
-            Open();
-        }
-        if (!IsConnectionOpen)
-        {
-            throw new SqliteException("SQLite database is not open.");
-        }
-        IntPtr stmHandle = Prepare(query);
-        if (sqlite3_step(stmHandle) != SQLITE_DONE)
-        {
-            throw new SqliteException("Could not execute SQL statement.");
-        }
-        Finalize(stmHandle);
-        if (!IsTransaction)
-        {
-            Close();
-        }
-    }
-    public DataTable ExecuteQuery(string query)
-    {
-        if (!CanExQuery)
-        {
-            Debug.Log("ERROR: Can't execute the query, verify DB origin file");
-            return null;
-        }
-        this.Open();
-        if (!IsConnectionOpen)
-        {
-            throw new SqliteException("SQLite database is not open.");
-        }
-        IntPtr stmHandle = Prepare(query);
-        int columnCount = sqlite3_column_count(stmHandle);
-        var dataTable = new DataTable();
-        for (int i = 0; i < columnCount; i++)
-        {
-            string columnName = Marshal.PtrToStringAnsi(sqlite3_column_name(stmHandle, i));
-            dataTable.Columns.Add(columnName);
-        }
-        while (sqlite3_step(stmHandle) == SQLITE_ROW)
-        {
-            object[] row = new object[columnCount];
-            for (int i = 0; i < columnCount; i++)
-            {
-                switch (sqlite3_column_type(stmHandle, i))
-                {
-                    case SQLITE_INTEGER:
-                        row[i] = sqlite3_column_int(stmHandle, i);
-                        break;
-                    case SQLITE_TEXT:
-                        IntPtr text = sqlite3_column_text(stmHandle, i);
-                        row[i] = Marshal.PtrToStringAnsi(text);
-                        break;
-                    case SQLITE_FLOAT:
-                        row[i] = sqlite3_column_double(stmHandle, i);
-                        break;
-                    case SQLITE_BLOB:
-                        IntPtr blob = sqlite3_column_blob(stmHandle, i);
-                        int size = sqlite3_column_bytes(stmHandle, i);
-                        byte[] data = new byte[size];
-                        Marshal.Copy(blob, data, 0, size);
-                        row[i] = data;
-                        break;
-                    case SQLITE_NULL:
-                        row[i] = null;
-                        break;
-                }
-            }
-            dataTable.AddRow(row);
-        }
-        Finalize(stmHandle);
-        this.Close();
-        return dataTable;
-    }
-    public void ExecuteScript(string script)
-    {
-        string[] statements = script.Split(';');
-        foreach (string statement in statements)
-        {
-            if (!string.IsNullOrEmpty(statement.Trim()))
-            {
-                ExecuteNonQuery(statement);
-            }
-        }
-    }
-    public void TransactionStart()
-    {
-        Open();
-        IsTransaction = true;
-        ExecuteQueryExec("BEGIN");
-    }
-　public void TransactionCommit()
-    {
-        ExecuteQueryExec("COMMIT");
-        IsTransaction = false;
-        Close();
-    }
-    public void TransactionRollBack()
-    {
-        ExecuteQueryExec("ROLLBACK");
-        Close();
-    }
-    #endregion
-    #region Private Methods
-    private IntPtr Prepare(string query)
-    {
-        IntPtr stmHandle;
-        int byteCount = System.Text.Encoding.UTF8.GetByteCount(query);
-        if (sqlite3_prepare_v2(_connection, query, byteCount, out stmHandle, IntPtr.Zero) != SQLITE_OK)
-        {
-            IntPtr errorMsg = sqlite3_errmsg(_connection);
-            throw new SqliteException(Marshal.PtrToStringAnsi(errorMsg));
-        }
-        return stmHandle;
-    }
-    private void Finalize(IntPtr stmHandle)
-    {
-        if (sqlite3_finalize(stmHandle) != SQLITE_OK)
-        {
-            throw new SqliteException("Could not finalize SQL statement.");
-        }
-    }
-    private bool IsTransaction = false;
-    private void ExecuteQueryExec(string query)
-    {
-        IntPtr stmHandle;
-        if (!CanExQuery)
-        {
-            Debug.Log("ERROR: Can't execute the query, verify DB origin file");
-            return;
-        }
-        if (!IsTransaction)
-        {
-            Debug.Log("ERROR: Haven't started a transaction.");
-            return;
-        }
-        if (sqlite3_exec(_connection, query, IntPtr.Zero, IntPtr.Zero, out stmHandle) != SQLITE_OK)
-        {
-            throw new SqliteException("Could not execute SQL statement.");
-        }
-    }
-    #endregion
-}
-```
 ### 試したこと
-SQLiteUnityKitに同封されているSqliteDatabase.csを上記のように書き換えましたが、書き換える前と変化はありませんでした。
+SQLiteUnityKitに同封されているSqliteDatabase.csを書き換えましたが、変化はありませんでした。
-### 補足情報（FW/ツールのバージョンなど）
-Unity 2020.3.18f1
-Windows 10