public void Test_connection_Open_Create() { UnqliteDB db = UnqliteDB.Create(); var res = db.Open(databaseName, Unqlite_Open.CREATE); if (res) { db.Close(); } Assert.IsTrue(res); }
public void Test_KeyValue_Store() { UnqliteDB db = UnqliteDB.Create(); var res = db.Open(databaseName, Unqlite_Open.CREATE); if (res) { var res1 = db.SaveKeyValue("test", "hello world"); string value = db.GetKeyValue("test"); Assert.IsTrue(value == "hello world"); db.Close(); } }
public void Test_KeyValue_BinaryStore_With_Callback() { UnqliteDB db = UnqliteDB.Create(); var res = db.Open(databaseName, Unqlite_Open.CREATE); if (res) { var res1 = db.SaveKeyValue("test", "hello world"); db.GetKeyBinaryValue("test", (value) => { string strValue = System.Text.Encoding.ASCII.GetString(value, 0, value.Length); Assert.IsTrue(strValue == "hello world"); }); db.Close(); } }
public void Test_KeyValue_Cursor_Seek_Delete() { UnqliteDB db = UnqliteDB.Create(); var res = db.Open(databaseName, Unqlite_Open.CREATE); for (int i = 0; i < 20; i++) { db.SaveKeyValue("test" + (i + 1).ToString(), "hello world " + (i + 1).ToString()); } using (var cursor = db.CreateKeyValueCursor()) { if (cursor.Read()) { cursor.Seek("test4", Unqlite_Cursor_Seek.Match_GE); bool deleted = cursor.Delete(); Assert.IsTrue(deleted); } } db.Close(); }
public void Test_KeyValue_Cursor_Seek() { UnqliteDB db = UnqliteDB.Create(); var res = db.Open(databaseName, Unqlite_Open.CREATE); for (int i = 0; i < 20; i++) { db.SaveKeyValue("test" + (i + 1).ToString(), "hello world " + (i + 1).ToString()); } using (var cursor = db.CreateKeyValueCursor()) { if (cursor.Read()) { cursor.Seek("test1"); string value = cursor.GetValue(); Assert.IsTrue(value == "hello world 1"); } } db.Close(); }
static void Main(string[] args) { using (var session = new UnqliteDB("unqlite.db").OpenSession()) { for (int i = 100; i < 105; i++) { session.Save($"key{i}", Data.SampleParent(i)); } for (int i = 100; i < 105; i++) { var parent = session.Get <Parent>($"key{i}"); Console.WriteLine($"Parent.Id= " + parent.Id); foreach (var child in parent.Children) { Console.WriteLine($" Child.Id= " + child.Id); Console.WriteLine($" Child.Data= " + child.Data); } Console.WriteLine(); } } Console.ReadKey(); }
public void Test_KeyValue_Cursor() { UnqliteDB db = UnqliteDB.Create(); var res = db.Open(databaseName, Unqlite_Open.CREATE); for (int i = 0; i < 100; i++) { db.SaveKeyValue("test" + (i + 1).ToString(), "hello world " + (i + 1).ToString()); } using (var cursor = db.CreateKeyValueCursor()) { while (cursor.Read()) { string key = cursor.GetKey(); byte[] binaryKey = cursor.GetBinaryKey(); Console.Out.WriteLine("Key:" + key); string value = cursor.GetValue(); byte[] binaryValue = cursor.GetBinaryValue(); Console.Out.WriteLine("Value:" + value); cursor.Next(); } } db.Close(); }
public void Test_KeyValue_Cursor_with_callback() { UnqliteDB db = UnqliteDB.Create(); var res = db.Open(databaseName, Unqlite_Open.CREATE); for (int i = 0; i < 20; i++) { db.SaveKeyValue("test" + (i + 1).ToString(), "hello world " + (i + 1).ToString()); } using (var cursor = db.CreateKeyValueCursor()) { while (cursor.Read()) { cursor.GetStringKey((key) => { Console.Out.WriteLine("Key:" + key); }); cursor.GetStringValue((value) => { Console.Out.WriteLine("Value:" + value); }); cursor.Next(); } } db.Close(); }