Example #1
0
        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();
            }
        }
Example #2
0
        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();
        }
Example #3
0
        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();
            }
        }
Example #4
0
 /// <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");
     }
 }
Example #5
0
        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();
            }
        }
Example #6
0
        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;
        }
Example #7
0
        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();
        }
Example #8
0
        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();
        }
Example #9
0
        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);
        }
Example #10
0
        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();
            }
        }