// Use this for initialization
void Start()
{
Debug.Log (Application.persistentDataPath);
SQLiteDB db = new SQLiteDB (Application.dataPath + "/huhu");
db.Query ("CREATE TABLE test (name VARCHAR(20), score INT)");
db.Query ("CREATE TABLE test2 (label TEXT, position REAL)");
}
public void OpenDB(string p)
{
db = new SQLiteDB();
string filename = Application.persistentDataPath + "/" + p;
Debug.Log("Stablishing connection to: " + filename);
db.Open(filename);
}
public bool getStatus(int id)
{
bool result = false;
int num;
string dbFile = Application.persistentDataPath + "/optionDB_playmaker.db";
SQLiteDB db = new SQLiteDB();
db.Open(dbFile);
SQLiteQuery qr = new SQLiteQuery(db, "SELECT result FROM option_table WHERE id=?");
qr.Bind(id);
qr.Step();
num = qr.GetInteger("result");
switch (num)
{
case 0:
result = false;
break;
case 1:
result = true;
break;
}
qr.Release();
db.Close();
return result;
}
public SQLiteQuery( SQLiteDB sqliteDb, string query )
{
bindIndex = 1;
db = sqliteDb.Connection();
if( Sqlite3.sqlite3_prepare_v2( db, query, query.Length, ref vm, 0 ) != Sqlite3.SQLITE_OK )
{
throw new Exception( "Error with prepare query! error:" + Sqlite3.sqlite3_errmsg(db) );
};
}
void InitDatabase(){
byte[] bytes = null;
db = new SQLiteDB();
string dbfilename = "LOLDatabase.sqlite";
string filename = Application.persistentDataPath + "/" + dbfilename;
/*
if (File.Exists(filename)) {
db.Open(filename);
dbOk = true;
ReadDatabase();
return;
}
*/
#if UNITY_EDITOR || UNITY_STANDALONE_WIN || UNITY_STANDALONE_OSX
string dbpath = "file://" + Application.streamingAssetsPath + "/" + dbfilename;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#elif UNITY_WEBPLAYER
string dbpath = "StreamingAssets/" + dbfilename;
Debug.Log("dbpath:" + dbpath);
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#elif UNITY_IPHONE
string dbpath = Application.dataPath + "/Raw/" + dbfilename;
try{
using ( FileStream fs = new FileStream(dbpath, FileMode.Open, FileAccess.Read, FileShare.Read) ){
bytes = new byte[fs.Length];
fs.Read(bytes,0,(int)fs.Length);
}
} catch (Exception e){
}
#elif UNITY_ANDROID
string dbpath = Application.streamingAssetsPath + "/" + dbfilename;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#endif
if ( bytes != null ) {
try {
using( FileStream fs = new FileStream(filename, FileMode.Create, FileAccess.Write) ) {
fs.Write(bytes,0,bytes.Length);
}
db.Open(filename);
dbOk = true;;
ReadDatabase();
} catch (Exception e){
}
}
}
public void setStatus(int id, int choice)
{
string dbFile = Application.persistentDataPath + "/optionDB_playmaker.db";
SQLiteDB db = new SQLiteDB();
string query = "UPDATE option_table SET Unlocked = " + choice.ToString() + " WHERE id =" + id.ToString();
db.Open(dbFile);
SQLiteQuery qr = new SQLiteQuery(db, query);
qr.Step();
qr.Release();
db.Close();
}
public int getDefense() {
int num = 0;
string dbFile = Application.persistentDataPath + "/playerDB.db";
SQLiteDB db = new SQLiteDB ();
db.Open (dbFile);
SQLiteQuery qr = new SQLiteQuery (db, "SELECT defense FROM player_info WHERE id=1");
qr.Step ();
num = qr.GetInteger ("defense");
qr.Release ();
db.Close ();
return num;
}
public void StoreValue (int id, int a_value)
{
SQLiteQuery qr;
string query = "UPDATE stats_table SET value = " + a_value.ToString() + " WHERE id =" + id.ToString();
SQLiteDB db = new SQLiteDB ();
string filename = Application.persistentDataPath + "/statsDB_playmaker.db";
db.Open (filename);
qr = new SQLiteQuery (db, query);
qr.Step ();
qr.Release();
db.Close ();
}
public int getMoney(int id) {
int num = 0;
string dbFile = Application.persistentDataPath + "/mobDB.db";
SQLiteDB db = new SQLiteDB ();
db.Open (dbFile);
SQLiteQuery qr = new SQLiteQuery (db, "SELECT money FROM mob_info WHERE id=?");
qr.Bind (id);
qr.Step ();
num = qr.GetInteger ("money");
qr.Release ();
db.Close ();
return num;
}
public string getName(int id) {
string name = "";
string dbFile = Application.persistentDataPath + "/achieveDB_playmaker.db";
SQLiteDB db = new SQLiteDB();
db.Open(dbFile);
SQLiteQuery qr = new SQLiteQuery(db, "SELECT Name FROM achieve_table WHERE id=?");
qr.Bind(id);
while (qr.Step()) {
name = qr.GetString("Name");
}
qr.Release();
db.Close();
return name;
}
public int getTarget(int id) {
int num = 0;
string dbFile = Application.persistentDataPath + "/achieveDB_playmaker.db";
SQLiteDB db = new SQLiteDB();
db.Open(dbFile);
SQLiteQuery qr = new SQLiteQuery(db, "SELECT Target FROM achieve_table WHERE id=?");
qr.Bind(id);
qr.Step();
num = qr.GetInteger("Target");
qr.Release();
db.Close();
return num;
}
public string getDesc(int id) {
string description = "";
string dbFile = Application.persistentDataPath + "/achieveDB_playmaker.db";
SQLiteDB db = new SQLiteDB();
db.Open(dbFile);
SQLiteQuery qr = new SQLiteQuery(db, "SELECT Description FROM achieve_table WHERE id=?");
qr.Bind(id);
while (qr.Step()) {
description = qr.GetString("Description");
}
qr.Release();
db.Close();
return description;
}
public TableObject(SQLiteDB db, string table)
{
this.db = db;
workingTable = table;
names = new List<string> ();
types = new List<string> ();
columns = this.db.ColumnInfo (workingTable);
GetRowCount ();
foreach (ColumnObject column in columns) {
names.Add (column.name);
types.Add (column.type);
}
}
public int getValue (string name)
{
int num = 0;
string filename = Application.persistentDataPath + "/statsDB_playmaker.db";
SQLiteDB db = new SQLiteDB ();
SQLiteQuery qr;
string query = "SELECT value FROM stats_table WHERE name =?";
db.Open (filename);
qr = new SQLiteQuery (db, query);
qr.Bind (name);
qr.Step ();
num = qr.GetInteger ("value");
qr.Release ();
db.Close ();
return num;
}
public void ClearFrontAccountByBack()
{
if (Desk.Instance.Players.Sum(p => p.Balance) > 0)
{
return;
}
using (var db = new SQLiteDB())
{
var account = db.FrontAccounts.First(acc => acc.IsClear == false);
if (account == null)
{
return;
}
account.IsClear = true;
account.ClearTime = DateTime.Now;
db.BetScoreRecords.RemoveRange(db.BetScoreRecords);
db.SaveChanges();
}
}
public FrontAccount SelectAccount(int index)
{
try
{
using (var db = new SQLiteDB())
{
var count = db.FrontAccounts.Count();
var account = db.FrontAccounts.OrderByDescending(a => a.CreateTime).Skip(index).FirstOrDefault();
return(account);
}
}
catch (Exception ex)
{
#if DEBUG
MessageBox.Show(ex.Message);
#endif
MessageBox.Show("读取账本失败");
}
return(null);
}
private void PreProcessing(SQLiteDB db, List <string> queries)
{
if (queries == null)
{
return;
}
foreach (string sql in queries)
{
try
{
Logger.LogMessage(db.databaseName + ":EXECUTE:" + sql);
db.Execute(sql);
}
catch (Exception ex)
{
Logger.LogException(ex, Thread.CurrentThread);
}
}
}
public void SQLiteDB_Close_void_ret_void()
{
// Prepara
IDataBase db = new SQLiteDB();
string closed = db.ConnectionState.ToString();
db.Close();
db.ConnectionString = "TestDataBase";
db.Open();
string opened = db.ConnectionState.ToString();
// Ejecuta
db.Close();
// Comprueba
db.Close();
Assert.AreEqual("Closed", closed);
Assert.AreEqual("Open", opened);
Assert.AreEqual("Closed", db.ConnectionState.ToString());
}
public void Update_all_where_idx(
int a_idx,
ST_S_PlayerWeaponRec rec
)
{
if (_db == null)
{
_db = new SQLiteDB();
}
try
{
_db.Open(GetFileName_DB());
SQLiteQuery qr;
string strsql = string.Format(_queryUpdate_all_where_idx, a_idx); //
qr = new SQLiteQuery(_db, strsql);
qr.Bind(rec.slot_no);
qr.Bind(rec.weapon_datacode);
qr.Bind(rec.up_level);
qr.Bind(rec.up_dur);
qr.Bind(rec.up_attack);
qr.Bind(rec.up_critical_ratio);
qr.Bind(rec.upgrade_limit);
qr.Bind(rec.up_attack_speed);
qr.Bind(rec.class_no);
qr.Bind(rec.count);
qr.Step();
qr.Release();
_db.Close();
}
catch (Exception e)
{
if (_db != null)
{
_db.Close();
}
UnityEngine.Debug.LogError(e.ToString());
}
return;
}
/// <summary>
/// 打开SQLITE数据库
/// </summary>
static void OpenSqlite()
{
if (db != null)
{
db.Close();
}
if (string.IsNullOrEmpty(dbfile))
{
Debug.LogError("数据库文件路径为空!!!");
return;
}
db = new SQLiteDB();
db.Open(@dbfile);
if (!string.IsNullOrEmpty(password))
{
db.Key(password); //Set Password
}
PlayerPrefs.SetString("Tool_SqliteFile", dbfile);
PlayerPrefs.SetString("Tool_SqlitePass", password);
Debug.Log("数据库链接打开成功，数据文件:>" + dbfile);
}
private void CloseDatabase(ThreadQueue.TaskControl control, object state)
{
try
{
if (db != null)
{
db.Close();
db = null;
Debug.Log("Database has been closed.");
}
else
{
throw new Exception("Database not ready!");
}
}
catch (Exception ex)
{
Debug.LogError("SQLiteAsync : Exception : " + ex.Message);
}
}
private void InitDataAndLocal(object state)
{
try
{
using (var db = new SQLiteDB())
{
var objectContext = ((IObjectContextAdapter)db).ObjectContext;
var mappingCollection = (StorageMappingItemCollection)objectContext.MetadataWorkspace.GetItemCollection(DataSpace.CSSpace);
mappingCollection.GenerateViews(new List <EdmSchemaError>());
var sessions = db.LocalSessions;
if (sessions != null && sessions.Count() != 0)
{
LocalSessions.Clear();
foreach (var sess in sessions)
{
var mod = JsonConvert.DeserializeObject <Session>(sess.JsonSession);
LocalSessions.Add(mod);
}
}
Game.Instance.LocalSessions = LocalSessions;
//生成新一局路单，可以在点开始按钮之前传送到后台
Game.Instance.NewSession(); //此函数在每局结束时调用，不在洗牌时调用，因此可以在洗牌时将新一局路单传送到后台
}
}
catch (Exception ex)
{
#if DEBUG
MessageBox.Show(ex.Message + ex.StackTrace);
#endif
MessageBox.Show("程序数据库故障，重启游戏或联系工程师");
}
finally
{
ControlBoard.Instance.Dispatcher.Invoke(new Action(() =>
{
ControlBoard.Instance.btnStartGame.IsEnabled = true;
}));
}
}
public int Get_value(string a_data_code)
{
if (_db == null)
{
_db = new SQLiteDB();
}
int rtn = 0;
string filename = GetFileName_DB();
try{
_db.Open(filename);
SQLiteQuery qr;
string strsql = string.Format(_querySelect_value, a_data_code); // _querySelect_exp
qr = new SQLiteQuery(_db, strsql);
while (qr.Step())
{
try
{
rtn = qr.GetInteger("value");
}
catch
{
rtn = 0;
}
}
qr.Release();
_db.Close();
} catch (Exception e) {
if (_db != null)
{
_db.Close();
}
UnityEngine.Debug.LogError(e.ToString());
}
return(rtn);
}
public void Initiliaze(DatabaseType dbType, string connectionString)
{
Configuration = new ConfigurationBuilder().AddJsonFile("appsettings.json", true, true).Build();
ConnectionString = connectionString;
DBType = dbType;
switch (dbType)
{
case DatabaseType.MSSQL:
Connection = new SqlDb(this);
break;
case DatabaseType.SQLite:
Connection = new SQLiteDB(this);
break;
default:
throw new InvalidOperationException("Default case hit :(");
break;
}
}
private void SetBackSessions(object state)
{
var data = state.ToString();
var back_sessions = JsonConvert.DeserializeObject <List <LocalSession> >(data);
//Game.Instance.LocalSessions = back_sessions ?? throw new NullReferenceException();
var cur_session = Game.Instance.CurrentSession;
try
{
using (var db = new SQLiteDB())
{
db.LocalSessions.RemoveRange(db.LocalSessions);
db.LocalSessions.AddRange(back_sessions);
Game.Instance.LocalSessions.Clear();
foreach (var s in back_sessions)
{
var newsession = JsonConvert.DeserializeObject <Session>(s.JsonSession);
Game.Instance.LocalSessions.Add(newsession);
if (s.SessionIndex == cur_session.SessionId)
{
if (Game.Instance.CurrentState == GameState.Shuffling || Game.Instance.CurrentState == GameState.Preparing)
{
Game.Instance.CurrentSession = newsession;
}
}
}
db.SaveChanges();
Game.Instance.WebServer.SendData(
RemoteCommand.ImportBackOK,
Game.Instance.CurrentSession,
SuperServer.appSession);
}
}
catch (Exception ex)
{
}
}
public void SetBackBetRecordData(int id)
{
try
{
using (var db = new SQLiteDB())
{
var records = db.BetScoreRecords.Where(
bs => bs.SessionIndex == id).ToList();
if (records != null)
{
Game.Instance.BetRecordJsonDataToBack = new ObservableCollection <BetScoreRecord>(records);
}
}
}
catch (Exception ex)
{
#if DEBUG
MessageBox.Show(ex.Message + ex.StackTrace);
#endif
MessageBox.Show("程序数据库故障，重启游戏或联系工程师");
}
}
public SHSQLite(string strFileName)
{
if (true == string.IsNullOrEmpty(strFileName))
{
return;
}
// StreamingAssets에서 .db를 byte[]형태로 읽어서
// PersistentDataPath에 저장하고, 그걸 로드하도록 한다.
SaveDBToBytes(GetPersistentPath(strFileName), LoadWWW(GetStreamingPath(strFileName)));
try
{
m_pSQLiteDB = new SQLiteDB();
m_pSQLiteDB.Open(GetPersistentPath(strFileName));
}
catch (System.Exception e)
{
Debug.LogError(string.Format("SQLite Read Fail : {0}", e.ToString()));
}
}
public void SaveSubScoreAccount(int Sub_score, int id)
{
try
{
using (var db = new SQLiteDB())
{
WaitingBox.Show(ControlBoard.Instance, () =>
{
var acc = db.FrontAccounts.First(a => a.IsClear == false);
ObservableCollection <AddSubScoreRecord> record = new ObservableCollection <AddSubScoreRecord>();
if (acc == null)
{
acc = new FrontAccount()
{
CreateTime = DateTime.Now,
IsClear = false,
JsonScoreRecord = ""
};
record = Desk.Instance.CreateNewScoreRecord();
acc.JsonScoreRecord = JsonConvert.SerializeObject(record);
db.FrontAccounts.Add(acc);
}
record = JsonConvert.DeserializeObject <ObservableCollection <AddSubScoreRecord> >(acc.JsonScoreRecord);
var p_record = record.First(a => Convert.ToInt32(a.PlayerId) == id);
p_record.TotalSubScore += Sub_score;
p_record.TotalAccount -= Sub_score;
acc.JsonScoreRecord = JsonConvert.SerializeObject(record);
db.SaveChanges();
}, "数据存储中...");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
MessageBox.Show("数据库出错");
}
}
/// <summary>
/// DBインスタンス取得
/// </summary>
/// <returns>IDatabasインスタンス</returns>
public static IDatabase Create(DatabaseConfigModel config)
{
IDatabase result = null;
// DB種類で作成するインスタンスを変える
switch (config.Type.ToLower())
{
case "sqlite":
result = new SQLiteDB(config.connectionString);
break;
case "postgres":
result = new PostgreSQLDB(config.connectionString);
break;
default:
result = new SQLiteDB(config.connectionString);
break;
}
return(result);
}
public int Get_level(int a_exp, int a_class)
{
if (_db == null)
{
_db = new SQLiteDB();
}
int rtn = 0;
string filename = GetFileName_DB();
try
{
_db.Open(filename);
SQLiteQuery qr;
string strsql = string.Format(_querySelect_level, a_exp, a_class); // _querySelect_exp
qr = new SQLiteQuery(_db, strsql);
while (qr.Step())
{
rtn = qr.GetInteger("level");
}
qr.Release();
_db.Close();
// UnityEngine.Debug.Log("~~~~~~~~~~~~~~~~~~~~~~~ " + strsql + " ~~~>" + rtn);
}
catch (Exception e)
{
if (_db != null)
{
_db.Close();
_db = null;
}
UnityEngine.Debug.LogError(e.ToString());
}
return(rtn);
}
public ST_B_PlayerWeaponRec Get_PlayerWeaponRec(string a_datacode)
{
if (_db == null)
{
_db = new SQLiteDB();
}
ST_B_PlayerWeaponRec rec = new ST_B_PlayerWeaponRec();
string filename = GetFileName_DB();
try{
_db.Open(filename);
SQLiteQuery qr;
string strsql = string.Format(_querySelect_PlayerWeaponRec, a_datacode); // _querySelect_exp
qr = new SQLiteQuery(_db, strsql);
while (qr.Step())
{
rec._datacode = qr.GetString("datacode");
rec._dur = qr.GetInteger("dur");
rec._attack = qr.GetInteger("attack");
rec._level = qr.GetInteger("level");
rec._critical_ratio = (float)qr.GetDouble("critical_ratio");
}
qr.Release();
_db.Close();
} catch (Exception e) {
if (_db != null)
{
_db.Close();
_db = null;
}
UnityEngine.Debug.LogError(e.ToString());
}
return(rec);
}
async Task ExecuteLoadItemsCommand()
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
//empty events collection
Events.Clear();
//get events from database
List <Events> events = new List <Events>();
SQLiteDB db = new SQLiteDB();
events = await db.GetItemAsyncEvents();
//get next events
NextEventService n = new NextEventService();
events = n.GetNextEvents(events).Result;
//add next events to collection
foreach (var e in events)
{
Events.Add(e);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
finally
{
IsBusy = false;
}
}
public async Task <List <ValidationResult> > ValidateNewUser(User user, string confirmPassword)
{
if (user.password.Equals(confirmPassword))
{
ValidationContext ctx = new ValidationContext(user);
var results = new List <ValidationResult>();
if (!Validator.TryValidateObject(user, ctx, results, true))
{
return(results);
}
else
{
IDataBase context = new SQLiteDB();
bool result = await context.AddUser(user);
if (result)
{
return(new List <ValidationResult>());
}
else
{
return(new List <ValidationResult> {
new ValidationResult("Email or Login is already in use", new List <string> {
"login"
})
});
}
}
}
else
{
return(new List <ValidationResult> {
new ValidationResult("Passwords mismatch", new List <string> {
"confirmPassword"
})
});
}
}
internal void ImportBackNextSession(StringRequestInfo requestInfo, AppSession session)
{
var data = requestInfo.Parameters[0];
var back_session = JsonConvert.DeserializeObject <Session>(data) ?? throw new NullReferenceException();
if (Game.Instance.CurrentState == GameState.Preparing || Game.Instance.CurrentState == GameState.Shuffling)
{
back_session.SessionId = Game.Instance.SessionIndex;
Game.Instance.CurrentSession = back_session;
}
else
{
back_session.SessionId = Game.Instance.SessionIndex + 1;
}
var next = Game.Instance.LocalSessions.FirstOrDefault(s => s.SessionId == back_session.SessionId);
if (next != null)
{
Game.Instance.LocalSessions.Remove(next);
}
Game.Instance.LocalSessions.Add(back_session);
using (var db = new SQLiteDB())
{
var ss = db.LocalSessions.FirstOrDefault(s => s.SessionIndex == back_session.SessionId);
if (ss != null)
{
db.LocalSessions.Remove(ss);
}
db.LocalSessions.Add(new LocalSession
{
SessionIndex = back_session.SessionId,
JsonSession = JsonConvert.SerializeObject(back_session)
});
db.SaveChanges();
}
}
public ST_B_stageRec Get_stageData(int a_stage_no, int a_round_no)
{
if (_db == null)
{
_db = new SQLiteDB();
}
string filename = GetFileName_DB();
ST_B_stageRec rec = new ST_B_stageRec();
try
{
_db.Open(filename);
SQLiteQuery qr;
string strsql = string.Format(_querySelect_all_stage_round, a_stage_no, a_round_no); // _querySelect_exp
qr = new SQLiteQuery(_db, strsql);
while (qr.Step())
{
rec.idx = qr.GetInteger("idx");
rec.stage_no = qr.GetInteger("stage_no");
rec.round_no = qr.GetInteger("round_no");
rec.boss_bonus_normal = qr.GetInteger("boss_bonus_normal");
rec.boss_bonus_special = qr.GetInteger("boss_bonus_special");
rec.boss_fail_ratio = (float)qr.GetDouble("boss_fail_ratio");
}
qr.Release();
_db.Close();
}
catch (Exception e)
{
if (_db != null)
{
_db.Close();
}
UnityEngine.Debug.LogError(e.ToString());
}
return(rec);
}
public void SaveNewSession(Session session)
{
if (session == null)
{
return;
}
try
{
using (var db = new SQLiteDB())
{
foreach (var round in session.RoundsOfSession)
{
var record = new BetScoreRecord()
{
CreateTime = DateTime.Now,
SessionIndex = session.SessionId,
RoundIndex = session.RoundsOfSession.IndexOf(round),
DeskBanker = 0,
DeskPlayer = 0,
DeskTie = 0,
Winner = (int)round.Winner.Item1,
JsonPlayerScores = ""
};
var history = db.BetScoreRecords.FirstOrDefault(b => b.SessionIndex == record.SessionIndex && b.RoundIndex == record.RoundIndex);
if (history != null)
{
db.BetScoreRecords.Remove(history);
}
db.BetScoreRecords.Add(record);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace + ex.InnerException.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var db = new SQLiteDB())
{
//SQL発行
var sql = new StringBuilder();
sql.Append("SELECT");
sql.Append(" USER_ID ");
sql.Append(" ,NAME ");
sql.Append(" ,PASSWORD ");
sql.Append("FROM MT_USER ");
var result = db.Fill(sql.ToString());
if (result.Rows.Count > 0)
{
this.dataGridView1.DataSource = result;
}
else
{
this.dataGridView1.DataSource = null;
}
}
}
void PerformanceTest(SQLiteDB db, ref string log)
{
SQLiteQuery qr;
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
qr = new SQLiteQuery(db, "SELECT * FROM en WHERE word like 'a%' LIMIT 1");
qr.Step();
UnityEngine.Debug.Log(qr.GetString("word"));
qr.Release(); log += "\nSelect.";
stopwatch.Stop();
log += stopwatch.ElapsedMilliseconds + " msec";
//
// if we reach that point it's mean we pass the test!
db.Close(); log += "\nDatabase closed!\nTest succeeded!";
}
private void button1_Click(object sender, EventArgs e)
{
string str_addname;
string str_adduser;
string str_addpass;
string str_addq;
string str_adda;
string str_addnotes;
str_addname = txtAdd_name.Text;
str_adduser = txtAdd_user.Text;
str_addpass = txtAdd_pass.Text;
str_addq = txtAdd_q.Text;
str_adda = txtAdd_a.Text;
str_addnotes = txtAdd_notes.Text;
try
{
if (str_addname != "" && str_adduser != "" && str_addpass != "")
{
SQLiteDB.DatabasePath = "credential.db";
SQLiteDB db = SQLiteDB.GetInstance;
db.NonSelectQuery("INSERT INTO credentials (Name, Username, Password, Question, Answer, Notes) VALUES ('" + str_addname + "', '" + str_adduser + "', '" + str_addpass + "', '" + str_addq + "', '" + str_adda + "', '" + str_addnotes + "')");
db.CloseConnection();
}
else
{
throw new ArgumentException();
}
}
catch (Exception)
{
MessageBox.Show("Did not enter in all required fields");
}
}
public BetRecord()
{
InitializeComponent();
using (var db = new SQLiteDB())
{
try
{
//不显示当前局
var last_session_idx = db.BetScoreRecords.Max(mr => mr.SessionIndex);
if (last_session_idx == Game.Instance.SessionIndex)
{
last_session_idx = db.BetScoreRecords.Select(t => t.SessionIndex).Distinct().OrderByDescending(t => t).ElementAt(1);
}
RecordsInSession = db.BetScoreRecords.Where(
r => r.SessionIndex == last_session_idx)
.OrderBy(t => t.RoundIndex).ToList();
if (RecordsInSession == null || RecordsInSession.Count == 0)
{
MessageBox.Show("无记录");
Close();
return;
}
SessionIds = db.BetScoreRecords.Select(b => b.SessionIndex + 1).Distinct().OrderBy(t => t).ToList();
SessionIds.Remove(Game.Instance.SessionIndex + 1);
cmbSessionStrIndex.ItemsSource = SessionIds;
cmbSessionStrIndex.SelectedItem = RecordsInSession[0].SessionIndex + 1;
}
catch (Exception ex)
{
return;
}
}
CurrentRecords = new ObservableCollection <BetScoreRecord>(RecordsInSession.OrderBy(r => r.RoundIndex).ToList());
ShowWaybillAndDetail();
BindCbEvent();
cmbSessionStrIndex.SelectionChanged += cbRoundStrIndex_SelectionChanged;
}
public void Write(string strFileName, Dictionary <string, List <SHTableDataSet> > dicData)
{
if (null == dicData)
{
Debug.LogError(string.Format("SQLite로 저장할 데이터가 없습니다!!"));
return;
}
string strSavePath = string.Format("{0}/{1}.db", SHPath.GetPathToSQLite(), Path.GetFileNameWithoutExtension(strFileName));
File.Delete(strSavePath);
try
{
m_pSQLiteDB = new SQLiteDB();
m_pSQLiteDB.Open(strSavePath);
SHUtils.ForToDic(dicData, (pKey, pValue) =>
{
// 테이블 생성
if (false == CreateTable(pKey, pValue[0]))
{
return;
}
// 생성한 테이블에 데이터 인설트
if (false == InsertData(pKey, pValue))
{
return;
}
});
}
catch (System.Exception e)
{
Debug.LogError(string.Format("SQLite Read Fail : {0}", e.ToString()));
}
}
public int Get_StartLockNumber(int a_stage_no)
{
if (_db == null)
{
_db = new SQLiteDB();
}
int rtn = -1;
string filename = GetFileName_DB();
try
{
_db.Open(filename);
SQLiteQuery qr;
string strsql = string.Format(_querySelect_StartLockNumber, a_stage_no); // _querySelect_exp
qr = new SQLiteQuery(_db, strsql);
while (qr.Step())
{
rtn = qr.GetInteger("round_no");
}
qr.Release();
_db.Close();
}
catch (Exception e)
{
if (_db != null)
{
_db.Close();
}
UnityEngine.Debug.LogError(e.ToString());
}
return(rtn);
}
public int Get_tutorial_play()
{
if (_db == null)
{
_db = new SQLiteDB();
}
int tutorial_play = 0;
string filename = GetFileName_SaveDB();
try
{
_db.Open(filename);
SQLiteQuery qr;
qr = new SQLiteQuery(_db, _querySelect_tutorial_play);
while (qr.Step())
{
tutorial_play = qr.GetInteger("tutorial_play");
}
qr.Release();
_db.Close();
}
catch (Exception e)
{
if (_db != null)
{
_db.Close();
_db = null;
}
UnityEngine.Debug.LogError(e.ToString());
}
return(tutorial_play);
}
public int Get_attack()
{
if (_db == null)
{
_db = new SQLiteDB();
}
int atk = 0;
string filename = GetFileName_SaveDB();
try
{
_db.Open(filename);
SQLiteQuery qr;
qr = new SQLiteQuery(_db, _querySelectAttack);
while (qr.Step())
{
atk = qr.GetInteger("attack");
}
qr.Release();
_db.Close();
}
catch (Exception e)
{
if (_db != null)
{
_db.Close();
_db = null;
}
UnityEngine.Debug.LogError(e.ToString());
}
return(atk);
}
void OnGUI()
{
if (EditorApplication.isPlaying)
{
EditorUtility.DisplayDialog("Error", "Editor is in play mode.", "OK");
return;
}
LoadSettings();
scrollView = GUILayout.BeginScrollView(scrollView);
if( import )
{
if(db == null)
{
string databasePath = Application.streamingAssetsPath +"/"+ settings.Database;
db = new SQLiteDB();
try{
db.Open(databasePath);
Log("Open database: "+databasePath);
}catch(Exception e)
{
Debug.LogError("Fail to Open database: "+databasePath+"\nWith exception:"+e.Message);
EditorUtility.DisplayDialog("Error", "Fail to Open database: "+databasePath+"\nWith exception:"+e.Message, "OK");
import = false;
}
}
if(import)
{
try{
if(www!=null)
{
if(www.error != null)
{
EditorUtility.DisplayDialog("Error", "Can't download spreadsheet from URL: "+www.error, "OK");
import = false;
}
else
if(www.isDone)
{
SQLiteKitEditorSettings.Table table = settings.GetTableAt(tableIndex);
SQLiteQuery qr = null;
try{
List<string> rows = GetCVSLines(www.text);
www = null;
// delete old table
qr = new SQLiteQuery(db,"DROP TABLE IF EXISTS "+table.Name);
qr.Step();
qr.Release();
qr = null;
// read columns
List<Column> columns = new List<Column>();
// import header
List<string> headers = GetCVSLine(rows[0]);
for( int i = 0; i < headers.Count; i++ )
{
string column = headers[i];
if(Column.IsColumnHeader(column))
{
columns.Add(new Column(column,i));
Log (" Column: "+column);
}
}
if(columns.Count>0)
{
// compile create table sql
string createTableSQL = "CREATE TABLE "+table.Name+"( id INTEGER PRIMARY KEY";
foreach( Column column in columns )
{
createTableSQL += ", "+column.Definition;
}
createTableSQL += ");";
qr = new SQLiteQuery(db,createTableSQL);
qr.Step();
qr.Release();
qr = null;
// compile insert sql
string names = "";
string quest = "";
foreach( Column column in columns )
{
if(names.Length == 0){
names = column.Name;
quest = "?";
}
else{
names += ","+column.Name;
quest += ",?";
}
}
string insertSQL = "INSERT INTO "+table.Name+" ("+names+") VALUES("+quest+");";
// import data
for (int i=1; i<rows.Count; i++) {
List<string> row_columns = GetCVSLine(rows[i]);
qr = new SQLiteQuery(db,insertSQL);
foreach( Column column in columns )
{
column.Bind(qr,row_columns[column.Pos]);
}
qr.Step();
qr.Release();
qr = null;
}
}
else
{
import = false;
EditorUtility.DisplayDialog("Error", "Fail to import table '"+table.Name+"' - No columns! Please check source file", "OK");
}
}
catch(Exception e)
{
if(qr!=null)
qr.Release();
EditorUtility.DisplayDialog("Error", "Fail to import table '"+table.Name+"' with Exception: "+e.Message, "OK");
import = false;
}
tableIndex++;
}
}
else
if( tableIndex < settings.TableCount )
{
SQLiteKitEditorSettings.Table table = settings.GetTableAt(tableIndex);
string url = table.Url;
url = url.Trim();
if (!url.Contains("&single="))
url += "&single=true";
if (url.Contains("#gid="))
url = url.Replace("#gid=", "&gid=");
if (!url.Contains("&gid="))
url += "&gid=0";
if (url.Contains("&output=html"))
url = url.Replace("&output=html", "&output=csv");
if (!url.Contains("&output=csv"))
url += "&output=csv";
if (url.Contains("/ccc?"))
url = url.Replace("/ccc?", "/pub?");
table.Url = url;
SaveSettings();
if (!url.Contains(".google.com"))
{
import = false;
EditorUtility.DisplayDialog("Error", "You have entered an incorrect spreadsheet URL. Please read the manuals instructions (See readme.txt)", "OK");
}
else{
Log ("Import table: "+table.Name +" from URL: "+table.Url);
www = new WWW(table.Url);
}
}
else
{
import = false;
EditorUtility.DisplayDialog("Succeed", "All tables was succefully updated!", "OK");
}
}
catch( Exception e )
{
Debug.LogError(e);
EditorUtility.DisplayDialog("Error", "Unexpected exception! Please read log for more information.", "OK");
import = false;
}
}
if (GUILayout.Button("Terminate import"))
{
import = false;
}
GUILayout.Space(25);
GUI.Label(new Rect(0,40,1600,400-40), log);
if(import == false)
{
if(www!=null)
www = null;
if(db!=null)
db.Close();
db = null;
}
}
else
{
GUILayout.Label("Settings", EditorStyles.boldLabel);
settings.Database = EditorGUILayout.TextField("Database", settings.Database);
settings.TableCount = EditorGUILayout.IntField("Table Count", settings.TableCount);
GUILayout.Space(20);
scrollView2 = GUILayout.BeginScrollView(scrollView2);
SQLiteKitEditorSettings.Table table;
for(int pos = 0; pos < settings.TableCount; pos++)
{
GUILayout.Space(10);
table = settings.GetTableAt(pos);
table.Url = EditorGUILayout.TextField("Table #"+pos+" Url:", table.Url);
table.Name = EditorGUILayout.TextField("Table #"+pos+" Name:", table.Name);
}
GUILayout.EndScrollView();
if (GUI.changed)
{
SaveSettings();
}
if (GUILayout.Button("Import database from google spreadsheets"))
{
tableIndex = 0;
import = true;
log = "";
}
if (!string.IsNullOrEmpty(lastError))
{
Rect rec = GUILayoutUtility.GetLastRect();
GUI.color = Color.red;
EditorGUI.DropShadowLabel(new Rect(0, rec.yMin + 15, 200, 20), "Last error: " + lastError);
GUI.color = Color.white;
}
GUILayout.Space(25);
GUILayout.Label("For more information please visit SQLiteKit forum.", EditorStyles.miniLabel);
if (GUILayout.Button("Open forum"))
{
Application.OpenURL("http://forum.unity3d.com/threads/150778-SQLiteKit");
}
GUILayout.Label("Add Example setup.", EditorStyles.miniLabel);
if (GUILayout.Button("Add Example setup"))
{
int pos = settings.TableCount;
settings.TableCount++;
table = settings.GetTableAt(pos);
if(table!=null)
{
table.Url = default_url;
table.Name = "test_table_"+pos;
}
SaveSettings();
}
if (GUILayout.Button("Open Example Google Spreadsheet"))
{
Application.OpenURL("https://docs.google.com/spreadsheet/ccc?key=0AhKBA3PeUOmddDhQNno2S09VYlpvUC1XdXdMb1NjeHc#gid=0");
}
}
GUILayout.EndScrollView();
}
void Test2( SQLiteDB db, ref string log )
{
SQLiteQuery qr;
//
// read strings
//
string testStringFromSelect = "";
qr = new SQLiteQuery(db, querySelect);
while( qr.Step() )
{
testStringFromSelect = qr.GetString("str_field");
if( testStringFromSelect != testString )
{
throw new Exception( "Test string are not equal!" );
}
byte[] testBlobFromSelect = qr.GetBlob("blob_field");
if( testBlobFromSelect.Length != testBlob.Length )
{
throw new Exception( "Test blobs are not equal!" );
}
for (int i = 0; i < testBlobFromSelect.Length; i++)
{
if( testBlobFromSelect[i] != testBlob[i] )
{
throw new Exception( "Test blobs are not equal!" );
}
}
}
if( testStringFromSelect == "" )
{
throw new Exception( "Unknowm problem!" );
}
qr.Release(); log += "\nRead and test strings and blobs.";
//
// if we reach that point it's mean we pass the test!
db.Close(); log += "\nDatabase closed!\nTest succeeded!";
}
//---------------------------------------------------------------------
public SqliteWin(string file_path)
{
mFilePath = file_path;
mSQLiteDB = new SQLiteDB();
}
public void unlock(int id) {
string dbFile = Application.persistentDataPath + "/achieveDB_playmaker.db";
SQLiteDB db = new SQLiteDB();
int yes = 1;
string query = "UPDATE achieve_table SET Unlocked = " + yes.ToString() + " WHERE id =" + id.ToString();
db.Open(dbFile);
SQLiteQuery qr = new SQLiteQuery(db, query);
qr.Step();
qr.Release();
db.Close();
}
IEnumerator TestBestForRealProject()
{
db = new SQLiteDB();
log = "";
// a product persistant database path.
string filename = Application.persistentDataPath + "/demo_from_streamingAssets2.db";
// check if database already exists.
if(!File.Exists(filename))
{
// ok , this is first time application start!
// so lets copy prebuild dtabase from StreamingAssets and load store to persistancePath with Test2
string dbfilename = "test.db";
byte[] bytes = null;
#if UNITY_EDITOR || UNITY_STANDALONE_WIN || UNITY_STANDALONE_OSX
string dbpath = "file://" + Application.streamingAssetsPath + "/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
yield return www;
bytes = www.bytes;
#elif UNITY_WEBPLAYER
string dbpath = "StreamingAssets/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
yield return www;
bytes = www.bytes;
#elif UNITY_IPHONE
string dbpath = Application.dataPath + "/Raw/" + dbfilename; log += "asset path is: " + dbpath;
try{
using ( FileStream fs = new FileStream(dbpath, FileMode.Open, FileAccess.Read, FileShare.Read) ){
bytes = new byte[fs.Length];
fs.Read(bytes,0,(int)fs.Length);
}
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n";
}
#elif UNITY_ANDROID
string dbpath = Application.streamingAssetsPath + "/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
yield return www;
bytes = www.bytes;
#endif
if ( bytes != null )
{
try{
//
//
// copy database to real file into cache folder
using( FileStream fs = new FileStream(filename, FileMode.Create, FileAccess.Write) )
{
fs.Write(bytes,0,bytes.Length); log += "\nCopy database from streaminAssets to persistentDataPath: " + filename;
}
//
// initialize database
//
db.Open(filename); log += "\nDatabase created! filename: " + filename;
Test2(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n\n Did you copy test.db into StreamingAssets ?\n";
}
}
}
else
{
// it mean we already download prebuild data base and store into persistantPath
// lest update, I will call Test
try{
//
// initialize database
//
db.Open(filename); log += "Database created! filename:"+filename;
Test(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n on WebPlayer it must give an exception, it's normal.";
}
}
}
private void CloseDatabase(ThreadQueue.TaskControl control, object state)
{
try
{
if( db != null )
{
db.Close();
db = null;
}
else
{
throw new Exception( "Database not ready!" );
}
}
catch (Exception ex)
{
Debug.LogError("SQLiteAsync : Exception : " + ex.Message);
}
}
//
// functions
//
private void OpenDatabase(ThreadQueue.TaskControl control, object state)
{
OpenState opState = state as OpenState;
try
{
db = new SQLiteDB();
db.Open(opState.Filename);
opState.Succeed = true;
}
catch (Exception ex)
{
opState.Succeed = false;
Debug.LogError("SQLiteAsync : OpenDatabase : Exception : " + ex.Message);
}
}
public int getInit(int id) {
int num = 0;
string dbFile = Application.persistentDataPath + "/playerDB.db";
SQLiteDB db = new SQLiteDB ();
db.Open (dbFile);
SQLiteQuery qr = new SQLiteQuery (db, "SELECT init FROM player_info WHERE id=?");
qr.Bind (id);
qr.Step ();
num = qr.GetInteger ("init");
qr.Release ();
db.Close ();
return num;
}
public void StoreProgress(int id, int progress) {
string dbFile = Application.persistentDataPath + "/achieveDB_playmaker.db";
SQLiteDB db = new SQLiteDB();
string query = "UPDATE achieve_table SET Progress = " + progress.ToString() + " WHERE id =" + id.ToString();
db.Open(dbFile);
SQLiteQuery qr = new SQLiteQuery(db, query);
qr.Step();
qr.Release();
db.Close();
}
public void setMoney(int money) {
string dbFile = Application.persistentDataPath + "/playerDB.db";
SQLiteDB db = new SQLiteDB ();
string query = "UPDATE player_info SET money = " + money.ToString () + " WHERE id = 1";
db.Open (dbFile);
SQLiteQuery qr = new SQLiteQuery (db, query);
qr.Step ();
qr.Release ();
db.Close ();
}
private SQLiteDB OpenDB () {
SQLiteDB sqliteDB = new SQLiteDB ();
string fileName = Application.persistentDataPath + "/quiz_box.db";
sqliteDB.Open (fileName);
return sqliteDB;
}
public void setMaxHP_MP(int maxHP, int maxMP) {
string dbFile = Application.persistentDataPath + "/playerDB.db";
SQLiteDB db = new SQLiteDB ();
string query = "UPDATE player_info SET maxhp = " + maxHP.ToString () + ", maxmp = " + maxMP.ToString () + " WHERE id = 1";
db.Open (dbFile);
SQLiteQuery qr = new SQLiteQuery (db, query);
qr.Step ();
qr.Release ();
db.Close ();
}
void OnGUI()
{
if( db == null )
{
if ( GUI.Button(new Rect (10,10,150,50), "Run SQLite Test \nat persistentDataPath") )
{
db = new SQLiteDB();
string filename = Application.persistentDataPath + "/demo_1.db";
log = "";
try{
//
// initialize database
//
db.Open(filename); log += "Database created! filename:"+filename;
Test(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n on WebPlayer it must give an exception, it's normal.";
}
}
if ( GUI.Button(new Rect (10,70,150,70), "Run SQLite Test \nat :memory:\nbest for cache") )
{
db = new SQLiteDB();
log = "";
try{
//
// initialize database
//
db.OpenInMemory(); log += "Database created! in :memory:";
Test(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n";
}
}
if ( GUI.Button(new Rect (10,150,150,70), "Run SQLite Test \nwith stream\nbest for WebPlayer") )
{
db = new SQLiteDB();
MemoryStream memStream = new MemoryStream();
log = "";
try{
//
// initialize database
//
db = new SQLiteDB();
db.OpenStream("stream1",memStream); log += "Database created! named stream: stream1";
Test(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n";
}
}
if ( GUI.Button(new Rect (10,230,150,70), "Run SQLite Test \nwith streamingAssets") )
{
db = new SQLiteDB();
log = "";
string dbfilename = "test.db";
byte[] bytes = null;
#if UNITY_EDITOR || UNITY_STANDALONE_WIN || UNITY_STANDALONE_OSX
string dbpath = "file://" + Application.streamingAssetsPath + "/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#elif UNITY_WEBPLAYER
string dbpath = "StreamingAssets/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#elif UNITY_IPHONE
string dbpath = Application.dataPath + "/Raw/" + dbfilename; log += "asset path is: " + dbpath;
try{
using ( FileStream fs = new FileStream(dbpath, FileMode.Open, FileAccess.Read, FileShare.Read) ){
bytes = new byte[fs.Length];
fs.Read(bytes,0,(int)fs.Length);
}
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n";
}
#elif UNITY_ANDROID
string dbpath = Application.streamingAssetsPath + "/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#endif
if ( bytes != null )
{
try{
//
// create and write the asset into memory stream
//
MemoryStream memStream = new MemoryStream();
memStream.Write(bytes,0,bytes.Length);
//
// initialize database
//
db.OpenStream("stream2",memStream); log += "\nDatabase created! named stream: stream2";
Test2(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n\n Did you copy test.db into StreamingAssets ?\n";
}
}
}
if ( GUI.Button(new Rect (170,10,150,70), "Run SQLite Test \nfor streamingAssets db\nwhich moved to \npersistentDataPath") )
{
db = new SQLiteDB();
log = "";
string dbfilename = "test.db";
byte[] bytes = null;
#if UNITY_EDITOR || UNITY_STANDALONE_WIN || UNITY_STANDALONE_OSX
string dbpath = "file://" + Application.streamingAssetsPath + "/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#elif UNITY_WEBPLAYER
string dbpath = "StreamingAssets/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#elif UNITY_IPHONE
string dbpath = Application.dataPath + "/Raw/" + dbfilename; log += "asset path is: " + dbpath;
try{
using ( FileStream fs = new FileStream(dbpath, FileMode.Open, FileAccess.Read, FileShare.Read) ){
bytes = new byte[fs.Length];
fs.Read(bytes,0,(int)fs.Length);
}
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n";
}
#elif UNITY_ANDROID
string dbpath = Application.streamingAssetsPath + "/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#endif
if ( bytes != null )
{
try{
string filename = Application.persistentDataPath + "/demo_from_streamingAssets.db";
//
//
// copy database to real file into cache folder
using( FileStream fs = new FileStream(filename, FileMode.Create, FileAccess.Write) )
{
fs.Write(bytes,0,bytes.Length); log += "\nCopy database from streaminAssets to persistentDataPath: " + filename;
}
//
// initialize database
//
db.Open(filename); log += "\nDatabase created! filename: " + filename;
Test2(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n\n Did you copy test.db into StreamingAssets ?\n";
}
}
}
//
// Very common scenario for most products.
//
if ( GUI.Button(new Rect (170,90,150,70), "Run SQLite\nfor real project scenario") )
{
db = new SQLiteDB();
log = "";
// a product persistant database path.
string filename = Application.persistentDataPath + "/demo_from_streamingAssets2.db";
// check if database already exists.
if(!File.Exists(filename))
{
// ok , this is first time application start!
// so lets copy prebuild dtabase from StreamingAssets and load store to persistancePath with Test2
string dbfilename = "test.db";
byte[] bytes = null;
#if UNITY_EDITOR || UNITY_STANDALONE_WIN || UNITY_STANDALONE_OSX
string dbpath = "file://" + Application.streamingAssetsPath + "/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#elif UNITY_WEBPLAYER
string dbpath = "StreamingAssets/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#elif UNITY_IPHONE
string dbpath = Application.dataPath + "/Raw/" + dbfilename; log += "asset path is: " + dbpath;
try{
using ( FileStream fs = new FileStream(dbpath, FileMode.Open, FileAccess.Read, FileShare.Read) ){
bytes = new byte[fs.Length];
fs.Read(bytes,0,(int)fs.Length);
}
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n";
}
#elif UNITY_ANDROID
string dbpath = Application.streamingAssetsPath + "/" + dbfilename; log += "asset path is: " + dbpath;
WWW www = new WWW(dbpath);
Download(www);
bytes = www.bytes;
#endif
if ( bytes != null )
{
try{
//
//
// copy database to real file into cache folder
using( FileStream fs = new FileStream(filename, FileMode.Create, FileAccess.Write) )
{
fs.Write(bytes,0,bytes.Length); log += "\nCopy database from streaminAssets to persistentDataPath: " + filename;
}
//
// initialize database
//
db.Open(filename); log += "\nDatabase created! filename: " + filename;
Test2(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n\n Did you copy test.db into StreamingAssets ?\n";
}
}
}
else
{
// it mean we already download prebuild data base and store into persistantPath
// lest update, I will call Test
try{
//
// initialize database
//
db.Open(filename); log += "Database created! filename:"+filename;
Test(db, ref log);
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n on WebPlayer it must give an exception, it's normal.";
}
}
}
#if ENCRYPTION
//
// ENCRYPTION
//
if ( GUI.Button(new Rect (170,170,150,70), "Run SQLite\nfor ENCRYPTION scenario") )
{
try {
db = new SQLiteDB();
log = "";
// a product persistant database path.
string filename = Application.persistentDataPath + "/demo_from_encryption.db";
File.Delete(filename);
db.Open(filename);
//
// set ENCRYPTION
//
SQLiteQuery qr = new SQLiteQuery(db,"PRAGMA hexkey=\"0x0102030405060708090a0b0c0d0e0f10\";");
qr.Step();
qr.Release();
//
// create table
//
qr = new SQLiteQuery(db, queryCreate);
qr.Step();
qr.Release(); log += "\nTable created.";
//
// insert string and blob
//
qr = new SQLiteQuery(db, queryInsert);
qr.Bind(testString);
qr.Bind(testBlob);
qr.Step();
qr.Release(); log += "\nInsert test string and blob.";
// close
db.Close();
// and open again
db.Open(filename);
//
// set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
//
qr = new SQLiteQuery(db,"PRAGMA hexkey=\"0x0102030405060708090a0b0c0d0e0f10\";");
qr.Step();
qr.Release();
// do test
Test2( db, ref log );
} catch (Exception e){
log += "\nTest Fail with Exception " + e.ToString();
log += "\n on WebPlayer it must give an exception, it's normal.";
}
}
#endif
}
else
{
if ( GUI.Button(new Rect (10,10,150,50), "Back") )
{
db = null;
}
GUI.Label (new Rect (10,70,600,600), log);
}
}
//データベースを開く
private SQLiteDB OpenDatabase () {
SQLiteDB sqliteDB = new SQLiteDB ();
string fileName = Application.persistentDataPath + "/" + DatabaseHelper.DATABASE_FILE_NAME;
sqliteDB.Open (fileName);
return sqliteDB;
}
void Update () {
if(test == true)
{
test = false;
SQLiteQuery qr = null;
SQLiteDB db = null;
try{
db = new SQLiteDB();
db.Open(FILE);
db.Key("0x0102030405060708090a0b0c0d0e0f10");
// or
//qr = new SQLiteQuery(db, queryKey);
//qr.Step();
//qr.Release();
//qr = null;
qr = new SQLiteQuery(db,queryCreate);
qr.Step();
qr.Release();
qr = null;
qr = new SQLiteQuery(db,queryCreate2);
qr.Step();
qr.Release();
qr = null;
qr = new SQLiteQuery(db, queryInsert);
qr.Bind(testString);
qr.Bind(testBlob);
qr.Step();
qr.Step();
qr.Step();
qr.Release();
qr = null;
db.Close();
db = null;
UnityEngine.Debug.Log("Close and open again.");
db = new SQLiteDB();
db.Open(FILE);
db.Key("0x0102030405060708090a0b0c0d0e0f10");
// or
//qr = new SQLiteQuery(db, queryKey);
//qr.Step();
//qr.Release();
//qr = null;
qr = new SQLiteQuery(db,queryCreate3);
qr.Step();
qr.Release();
qr = null;
qr = new SQLiteQuery(db, queryInsert);
qr.Bind(testString);
qr.Bind(testBlob);
qr.Step();
qr.Step();
qr.Step();
qr.Release();
qr = null;
String testString2;
qr = new SQLiteQuery(db, querySelect);
while(qr.Step())
{
testString2 = qr.GetString("str_field");
testString2.ToString();
}
qr.Release();
qr = null;
db.Close();
db = null;
UnityEngine.Debug.Log("Done");
}catch(Exception e)
{
UnityEngine.Debug.LogError(e.Message);
if(qr!=null)
qr.Release();
qr = null;
if(db!=null)
db.Close();
db=null;
}
}
}
public SQLiteLoader(string filename)
{
this.db = new SQLiteDB(filename);
}
