private static void InitDatabase() { sqlite3Operate = SQLite3Factory.OpenOrCreate(SQLite3Utility.GetBytesMD5(Encoding.UTF8.GetBytes("SQLite3Prefs.db"))); if (!sqlite3Operate.TableExists(tableName)) { sqlite3Operate.Exec(sql); } }
public static SQLite3Operate OpenToReadOnly(string InDbName, bool InIsNeedCheck, string InMd5 = null) { string persistentDbPath = Path.Combine(Application.persistentDataPath, InDbName); #if !UNITY_EDITOR && UNITY_ANDROID string streamDbPath = Path.Combine("jar:file://" + Application.dataPath + "!/assets/", InDbName); #elif UNITY_IOS string streamDbPath = Path.Combine(Application.dataPath + "/Raw/", InDbName); #else string streamDbPath = Path.Combine(Application.streamingAssetsPath, InDbName); #endif bool isNeedOverride = false; byte[] dbBytes = null; if (File.Exists(persistentDbPath)) { if (InIsNeedCheck) { if (string.IsNullOrEmpty(InMd5)) { #if !UNITY_EDITOR && UNITY_ANDROID using (WWW www = new WWW(streamDbPath)) { while (!www.isDone) { } if (string.IsNullOrEmpty(www.error)) { dbBytes = www.bytes; isNeedOverride = !GetFileMD5ByByte(dbBytes).Equals(GetFileMD5(persistentDbPath)); } else { isNeedOverride = true; } } #else dbBytes = File.ReadAllBytes(streamDbPath); isNeedOverride = !SQLite3Utility.GetBytesMD5(dbBytes).Equals(SQLite3Utility.GetFileMD5(persistentDbPath)); #endif } else { isNeedOverride = !InMd5.Equals(persistentDbPath); } } } else { isNeedOverride = true; } if (isNeedOverride) { if (null == dbBytes) { #if !UNITY_EDITOR && UNITY_ANDROID using (WWW www = new WWW(streamDbPath)) { while (!www.isDone) { } if (string.IsNullOrEmpty(www.error)) { dbBytes = www.bytes; } else { Debug.LogError("Copy database from streamingAssetsPath to persistentDataPath error. " + www.error); } } #else dbBytes = File.ReadAllBytes(streamDbPath); #endif } File.WriteAllBytes(persistentDbPath, dbBytes); } return(new SQLite3Operate(persistentDbPath, SQLite3OpenFlags.ReadOnly)); }