private void removeBtn_Click(object sender, EventArgs e) { ClearDisplay(); Env env = new Env(EnvCreateFlags.None); try { Env.OpenFlags envFlags = Env.OpenFlags.Create | Env.OpenFlags.InitLock | Env.OpenFlags.InitLog | Env.OpenFlags.InitMPool | Env.OpenFlags.InitTxn | Env.OpenFlags.Recover; env.Open(homeDir, envFlags, 0); // remove existing database file Txn txn = env.TxnBegin(null, Txn.BeginFlags.None); env.DbRemove(txn, myDb, null, Env.WriteFlags.None); txn.Commit(Txn.CommitMode.None); env.Close(); // remove existing environment env = new Env(EnvCreateFlags.None); env.Remove(homeDir, Env.RemoveFlags.None); } catch (Exception ex) { errBox.Text = ex.ToString(); tabControl.SelectTab("errorPage"); } finally { env.Close(); } }
public void Delete <T>(IEnumerable <T> items) where T : class { dbName = typeof(T).FullName; initDatabase(); Txn trans = env.TxnBegin(null, Txn.BeginFlags.ReadCommitted); foreach (T t in items) { MemoryStream memKey = new MemoryStream(); MemoryStream memVal = new MemoryStream(); formatter.Serialize(memKey, t.GetHashCode()); formatter.Serialize(memVal, t); DbEntry key = DbEntry.InOut(memKey.ToArray()); DeleteStatus status = dbInstance.Delete(trans, ref key); if (status == DeleteStatus.NotFound) { Debug.Print("key {0} not found", t.GetHashCode()); } } trans.Commit(Txn.CommitMode.None); env.Close(); }
private void viewBtn_Click(object sender, EventArgs e) { ClearDisplay(); // open database and read records back - the database is transactional Env env = new Env(EnvCreateFlags.None); try { DbBTree btree; Env.OpenFlags envFlags = Env.OpenFlags.Create | Env.OpenFlags.InitLock | Env.OpenFlags.InitLog | Env.OpenFlags.InitMPool | Env.OpenFlags.InitTxn | Env.OpenFlags.Recover; env.Open(homeDir, envFlags, 0); Db db = env.CreateDatabase(DbCreateFlags.None); Txn txn = env.TxnBegin(null, Txn.BeginFlags.None); DbFile tmpDb = db.Open(txn, Path.Combine(homeDir, myDb), null, DbType.Unknown, Db.OpenFlags.None, 0); txn.Commit(Txn.CommitMode.None); if (tmpDb.DbType == DbType.BTree) { btree = (DbBTree)tmpDb; } else { throw new ApplicationException("Unexpected database type."); } List <Customer> custList = new List <Customer>(); // DbBTreeCursor implements IDisposable - will be closed through "using" using (DbBTreeCursor cursor = btree.OpenCursor(null, DbFileCursor.CreateFlags.None)) { Customer cust = null; while (GetNextRecord(cursor, ref cust)) { custList.Add(cust); } } db.Close(); DataGridViewColumn nameCol = new DataGridViewTextBoxColumn(); nameCol.Name = "NameCol"; nameCol.HeaderText = "Name"; nameCol.DataPropertyName = "Name"; dataGridView.Columns.Add(nameCol); dataGridView.DataSource = custList; tabControl.SelectTab("dataPage"); } catch (Exception ex) { errBox.Text = ex.ToString(); tabControl.SelectTab("errorPage"); } finally { env.Close(); } }
/// <summary> /// Commit all the operations of a transaction into the database. /// /// The transaction handle is freed. It and its cursors must not be used /// again after this call, except with mdbx_cursor_renew(). /// </summary> public void Commit() { if (!_released) { _released = true; Txn.Commit(_txnPtr); } else { throw new InvalidOperationException("MDBX transaction handle was freed. It can't be used again unless Reset() is called"); } }
private void btnDelete_Click(object sender, EventArgs e) { if (this.dgvGrid.Rows.Count == 0) { return; } if (MessageBox.Show("선택된 데이터를 삭제하시겠습니까?", "Delete", MessageBoxButtons.YesNo) == DialogResult.No) { return; } #region Transaction Decl SqlCommand Cmd = new SqlCommand(); SqlTransaction Txn; #endregion #region Connection Open Conn = new SqlConnection(ConnInfo); Conn.Open(); #endregion #region Transaction Init Txn = Conn.BeginTransaction("Begin Transaction"); Cmd.Transaction = Txn; Cmd.Connection = Conn; #endregion try { string delCustCode = dgvGrid.CurrentRow.Cells["CUSTCODE"].Value.ToString(); #region Transaction Commit Cmd.CommandText = $"DELETE TB_CUST_NHJ WHERE CUSTCODE = '{delCustCode}'"; Cmd.ExecuteNonQuery(); Txn.Commit(); #endregion MessageBox.Show("성공적으로 데이터를 삭제하였습니다."); btnSearch_Click(null, null); } catch (Exception ex) { // 오류가 났을 때는 ROLLBACK Txn.Rollback(); MessageBox.Show(ex.ToString()); } finally { Conn.Close(); } }
void initDatabase() { Db db = null; Txn txn = null; try { env = new Env(EnvCreateFlags.None); // configure for error and message reporting env.ErrorStream = Console.OpenStandardError( ); env.MessageStream = Console.OpenStandardOutput( ); // initialize environment for locking, logging, memory pool and transactions Env.OpenFlags envFlags = Env.OpenFlags.Create | Env.OpenFlags.InitLock | Env.OpenFlags.InitLog | Env.OpenFlags.InitMPool | Env.OpenFlags.InitTxn | Env.OpenFlags.Recover; env.Open(dbHome, envFlags, 0); // create, configure and open database under a transaction txn = env.TxnBegin(null, Txn.BeginFlags.None); db = env.CreateDatabase(DbCreateFlags.None); // set the BTree comparison function db.BTreeCompare = AppCompare; // error and message reporting already configured on environment // db.ErrorStream = errStream; // db.ErrorPrefix = Path.GetFileName(Application.ExecutablePath); // db.MessageStream = msgStream; dbInstance = (DbBTree)db.Open( txn, dbName, null, DbType.BTree, Db.OpenFlags.Create, 0); txn.Commit(Txn.CommitMode.None); } catch { } isInited = true; }
public void Save <T>(IEnumerable <T> items) where T : class { dbName = typeof(T).FullName; initDatabase(); Txn trans = env.TxnBegin(null, Txn.BeginFlags.ReadCommitted); foreach (T t in items) { MemoryStream memKey = new MemoryStream( ); MemoryStream memVal = new MemoryStream(); formatter.Serialize(memKey, t.GetHashCode()); formatter.Serialize(memVal, t); memKey.Flush(); memVal.Flush(); DbEntry key = DbEntry.InOut(memKey.ToArray()); DbEntry value = DbEntry.InOut(memVal.ToArray()); WriteStatus status = dbInstance.PutUnique(trans, ref key, ref value); if (status == WriteStatus.KeyExist) { Debug.Print("key {0} duplicated", t.GetHashCode()); } if (status == WriteStatus.KeyExist) { Delete <T>(t); WriteStatus st = dbInstance.PutUnique(trans, ref key, ref value); } } trans.Commit(Txn.CommitMode.Sync); env.Close(); }
private void btnSave_Click(object sender, EventArgs e) { if (dgvGrid.Rows.Count == 0) { return; } if (MessageBox.Show("선택된 데이터를 저장하시겠습니까??", "Save", MessageBoxButtons.YesNo) == DialogResult.No) { return; } #region Variable Init string custCode = dgvGrid.CurrentRow.Cells["CUSTCODE"].Value.ToString(); string custType = dgvGrid.CurrentRow.Cells["CUSTTYPE"].Value.ToString(); string custName = dgvGrid.CurrentRow.Cells["CUSTNAME"].Value.ToString(); string bizClass = dgvGrid.CurrentRow.Cells["BIZCLASS"].Value.ToString(); string bizType = dgvGrid.CurrentRow.Cells["BIZTYPE"].Value.ToString(); string useFlag = dgvGrid.CurrentRow.Cells["USEFLAG"].Value.ToString(); string firstDate = dgvGrid.CurrentRow.Cells["FIRSTDATE"].Value.ToString(); if (custCode == "" || custType == "" || firstDate == "") { MessageBox.Show("'거래처 코드', '거래처 타입', '거래일자' 는 빈칸으로 남겨둘 수 없습니다."); return; } if (custType == "고객사" || custType == "C") { custType = "C"; } else { custType = "V"; } if (useFlag == "미사용" || useFlag == "N") { useFlag = "N"; } else { useFlag = "Y"; } #endregion #region Transaction Decl SqlCommand Cmd = new SqlCommand(); SqlTransaction Txn; #endregion #region Connection Open Conn = new SqlConnection(ConnInfo); Conn.Open(); #endregion #region Transaction Init Txn = Conn.BeginTransaction("Test Transaction"); Cmd.Transaction = Txn; Cmd.Connection = Conn; #endregion #region Transaction Commit Cmd.CommandText = "UPDATE TB_CUST_KBM " + $" SET CUSTNAME = '{custName}', " + $" CUSTTYPE = '{custType}', " + $" BIZCLASS = '{bizClass}', " + $" BIZTYPE = '{bizType}', " + $" USEFLAG = '{useFlag}', " + $" FIRSTDATE = '{firstDate}', " + $" EDITOR = '{Common.LogInId}'," + $" EDITDATE = GETDATE() " + $" WHERE CUSTCODE = '{custCode}' " + " IF (@@ROWCOUNT =0) " + " INSERT INTO TB_CUST_KBM (CUSTCODE, CUSTTYPE, CUSTNAME, BIZCLASS, BIZTYPE, USEFLAG, FIRSTDATE, MAKEDATE, MAKER) " + $"VALUES ( '{custCode}', '{custType}', '{custName}', '{bizClass}', '{bizType}', '{useFlag}', '{firstDate}', GETDATE(), '{Common.LogInId}')"; Cmd.ExecuteNonQuery(); Txn.Commit(); #endregion MessageBox.Show("성공적으로 저장하였습니다."); Conn.Close(); }
public IList <T> Lookup <T>(ICondition condition) where T : class { dbName = typeof(T).FullName; initDatabase(); List <T> result = new List <T>( ); Txn trans = env.TxnBegin(null, Txn.BeginFlags.None); switch (condition.Name) { case "SELECT_ALL": using (DbBTreeCursor cursor = dbInstance.OpenCursor(null, DbFileCursor.CreateFlags.None)) { T cust = null; IEnumerable <KeyDataPair> lst = cursor.ItemsForward(false, DbFileCursor.ReadFlags.None); foreach (KeyDataPair pair in lst) { using (MemoryStream mem = new MemoryStream(pair.Data.Buffer)) { T t = (T)formatter.Deserialize(mem); result.Add(t); } } } break; case "SELECT_BY_CODE": SelectByCodeCondition cond = condition as SelectByCodeCondition; if (cond == null) { throw new InvalidDataException(String.Format("Invalid {0} condition", condition.Name)); } foreach (int i in cond.HashCodes) { T t = null; byte[] buf = new byte[1024]; MemoryStream key = new MemoryStream( ); MemoryStream value = new MemoryStream(); formatter.Serialize(key, i); DbEntry dbKey = DbEntry.InOut(key.ToArray()); DbEntry dbVal = DbEntry.Out(buf); while (true) { ReadStatus status = dbInstance.GetExact(trans, ref dbKey, ref dbVal, DbFile.ReadFlags.None); switch (status) { case ReadStatus.BufferSmall: if (dbVal.Buffer.Length < dbVal.Size) { value.SetLength(dbVal.Size); dbVal = DbEntry.Out(value.GetBuffer()); } continue; case ReadStatus.KeyEmpty: goto brk; case ReadStatus.NotFound: goto brk; case ReadStatus.Success: value.Position = 0; value.SetLength(dbVal.Size); value.Write(dbVal.Buffer, 0, dbVal.Size); value.Flush(); value.Seek(0, SeekOrigin.Begin); t = (T)formatter.Deserialize(value); result.Add(t); key.Dispose(); value.Dispose(); break; } } brk :; } break; default: throw new NotImplementedException(String.Format("Condition {0} is not implemented", condition.Name)); } trans.Commit(Txn.CommitMode.Sync); env.Close(); return(result); }
private void loadBtn_Click(object sender, EventArgs e) { ClearDisplay(); MemoryStream errStream = new MemoryStream(); MemoryStream msgStream = new MemoryStream(); TextWriter errWriter = new StreamWriter(errStream); TextWriter msgWriter = new StreamWriter(msgStream); Db db = null; Txn txn = null; Env env = null; try { env = new Env(EnvCreateFlags.None); // configure for error and message reporting env.ErrorStream = errStream; env.ErrorPrefix = Path.GetFileName(Application.ExecutablePath); env.MessageStream = msgStream; // initialize environment for locking, logging, memory pool and transactions Env.OpenFlags envFlags = Env.OpenFlags.Create | Env.OpenFlags.InitLock | Env.OpenFlags.InitLog | Env.OpenFlags.InitMPool | Env.OpenFlags.InitTxn | Env.OpenFlags.Recover; env.Open(homeDir, envFlags, 0); // create, configure and open database under a transaction txn = env.TxnBegin(null, Txn.BeginFlags.None); db = env.CreateDatabase(DbCreateFlags.None); // set the BTree comparison function db.BTreeCompare = AppCompare; // error and message reporting already configured on environment // db.ErrorStream = errStream; // db.ErrorPrefix = Path.GetFileName(Application.ExecutablePath); // db.MessageStream = msgStream; DbBTree btree = (DbBTree)db.Open( txn, myDb, null, DbType.BTree, Db.OpenFlags.Create, 0); txn.Commit(Txn.CommitMode.None); // create a sequence named '###sequence1' under a transaction txn = env.TxnBegin(null, Txn.BeginFlags.None); Sequence seq = btree.CreateSequence(); byte[] seqName = utf8.GetBytes("###sequence1"); DbEntry seqNameEntry = DbEntry.InOut(seqName); seq.Open(txn, ref seqNameEntry, Sequence.OpenFlags.Create); seq.Close(); txn.Commit(Txn.CommitMode.None); // open sequence again, retrieve values and then remove the sequence seq = btree.CreateSequence(); txn = env.TxnBegin(null, Txn.BeginFlags.None); // seq.CacheSize = 1000; // cannot use transactions when CacheSize > 0 seq.Open(txn, ref seqNameEntry, Sequence.OpenFlags.None); Int64 seqVal; for (int indx = 0; indx < 500; indx++) { seqVal = seq.Get(txn, 1, Sequence.ReadFlags.None); } seq.Remove(txn, Sequence.RemoveFlags.None); txn.Commit(Txn.CommitMode.None); // add a few records under a transaction Customer cust; txn = env.TxnBegin(null, Txn.BeginFlags.None); cust = new Customer("John Doe", "122 Yonge Street", "Toronto", "ON", "M5R 5T9", DateTime.Parse("Dec 22, 1965")); AddRecord(btree, txn, cust, errWriter); cust = new Customer("Jane Doby", "23 Bloor Street", "Oshawa", "ON", "L1H 2K9", DateTime.Parse("Jun 1, 1962")); AddRecord(btree, txn, cust, errWriter); cust = new Customer("Rusty Nail", "77 Bond Street", "Markham", "ON", "L3T 7Y8", DateTime.Parse("Sep 9, 1915")); AddRecord(btree, txn, cust, errWriter); cust = new Customer("Rosy Cheek", "11 Adelaide Street", "Whitby", "ON", "K3P 4H4", DateTime.Parse("Jan 2, 1980")); AddRecord(btree, txn, cust, errWriter); // this last one is a duplicate of the first record cust = new Customer("John Doe", "1459 King Street", "Toronto", "ON", "N8N 2L0", DateTime.Parse("Apr 14, 1973")); AddRecord(btree, txn, cust, errWriter); txn.Commit(Txn.CommitMode.None); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine("K E Y S T A T I S T I C S"); msgWriter.WriteLine("=================================================="); // get a key range, under a transaction txn = env.TxnBegin(null, Txn.BeginFlags.None); keyStream.Position = 0; formatter.Serialize(keyStream, "John Doe"); DbEntry key = DbEntry.InOut(keyStream.GetBuffer(), 0, (int)keyStream.Position); DbBTree.KeyRange keyRange = btree.GetKeyRange(txn, ref key); txn.Commit(Txn.CommitMode.None); msgWriter.WriteLine(); string msg = "KeyRange for 'John Doe': Less = {0}, Equal = {1}, Greater = {2}"; msgWriter.WriteLine(string.Format(msg, keyRange.Less, keyRange.Equal, keyRange.Greater)); msgWriter.WriteLine(); // retrieve some database statistics TxnStats stats = env.GetTxnStats(StatFlags.None); DbBTree.Stats btstats = btree.GetStats(null, DbFile.StatFlags.None); CacheFileStats[] cfStats = env.GetCacheFileStats(StatFlags.None); // we can also have them written to the message stream msgWriter.WriteLine("=================================================="); msgWriter.WriteLine("T R A N S A C T I O N S T A T I S T I C S"); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine(); msgWriter.Flush(); env.PrintTxnStats(StatPrintFlags.None); msgWriter.WriteLine(); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine("L O G S T A T I S T I C S"); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine(); msgWriter.Flush(); env.PrintLogStats(StatPrintFlags.All); msgWriter.WriteLine(); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine("L O C K S T A T I S T I C S"); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine(); msgWriter.Flush(); env.PrintLogStats(StatPrintFlags.All); msgWriter.WriteLine(); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine("C A C H E S T A T I S T I C S"); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine(); msgWriter.Flush(); env.PrintCacheStats(CacheStatPrintFlags.All); msgWriter.WriteLine(); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine("B T R E E S T A T I S T I C S"); msgWriter.WriteLine("=================================================="); msgWriter.WriteLine(); msgWriter.Flush(); btree.PrintStats(DbFile.StatPrintFlags.All); } catch (BdbException) { if (txn != null && !txn.IsDisposed) { txn.Abort(); } // errors are reported through error stream already return; } catch (Exception ex) { if (txn != null && !txn.IsDisposed) { txn.Abort(); } errWriter.WriteLine(ex.ToString()); return; } finally { if (db != null) { db.Close(); } if (env != null) { env.Close(); } msgWriter.Flush(); string msgText = utf8.GetString(msgStream.GetBuffer()); if (msgText != "") { msgBox.Text = msgText; } msgWriter.Close(); errWriter.Flush(); string errText = utf8.GetString(errStream.GetBuffer()); if (errText != "") { errBox.Text = errText; tabControl.SelectTab("errorPage"); } errWriter.Close(); } }