static void CreateDatabasePoolTest() { var serverConnInfo = Configuration.GetSection("ConnectionStrings:DefaultConnection").GetChildren().ToDictionary(x => x.Key); OClient.CreateDatabasePool( serverConnInfo["Server"].Value, int.Parse(serverConnInfo["Port"].Value), serverConnInfo["DefaultDB"].Value, ODatabaseType.Graph, serverConnInfo["Username"].Value, serverConnInfo["Password"].Value, 10, "AppConnection" ); using (var database = new ODatabase("AppConnection")) { var documents = database.Query("select from v"); foreach (var item in documents) { System.Console.WriteLine("Name: {0} Type: {1}", item.GetField <string>("name"), item.GetField <string>("type")); } } OClient.DropDatabasePool("AppConnection"); }
static void CreateDatabasePoolTest() { OClient.CreateDatabasePool( "localhost", 2424, "GratefulDeadConcerts", ODatabaseType.Graph, "root", "root", 10, "AppConnection" ); using (var database = new ODatabase("AppConnection")) { var documents = database.Query("select from v"); foreach (var item in documents) { System.Console.WriteLine("Name: {0} Type: {1}", item.GetField <string>("name"), item.GetField <string>("type")); } } OClient.DropDatabasePool("AppConnection"); }
public override void Init(int flowCount, long flowRecordCount) { this.flowCount = flowCount; this.flowRecordCount = flowRecordCount; databases = new ODatabase[flowCount]; var connect = OClient.CreateDatabasePool(Server, Port, DatabaseTest, ODatabaseType.Document, Ussername, Password, flowCount, CollectionName); for (int i = 0; i < flowCount; i++) { ODatabase database = new ODatabase(CollectionName); databases[i] = database; } databases[0].Command("DROP CLASS Tick"); databases[0].Command("CREATE Class Tick"); databases[0].Command("CREATE PROPERTY Tick.Key long"); databases[0].Command("CREATE PROPERTY Tick.Symbol string"); databases[0].Command("CREATE PROPERTY Tick.Timestamp DATETIME"); databases[0].Command("CREATE PROPERTY Tick.Bid double"); databases[0].Command("CREATE PROPERTY Tick.Ask double"); databases[0].Command("CREATE PROPERTY Tick.BidSize integer"); databases[0].Command("CREATE PROPERTY Tick.AskSize integer"); databases[0].Command("CREATE PROPERTY Tick.Provider string"); databases[0].Command("CREATE INDEX Tick.Key Dictionary"); }
public void ShouldReturnDatabaseToPoolAfterCloseAndDisposeCall() { using (TestDatabaseContext testContext = new TestDatabaseContext()) { Assert.AreEqual( TestConnection.GlobalTestDatabasePoolSize, OClient.DatabasePoolCurrentSize(TestConnection.GlobalTestDatabaseAlias) ); ODatabase database = new ODatabase(TestConnection.GlobalTestDatabaseAlias); Assert.AreEqual( TestConnection.GlobalTestDatabasePoolSize - 1, OClient.DatabasePoolCurrentSize(TestConnection.GlobalTestDatabaseAlias) ); database.Close(); Assert.AreEqual( TestConnection.GlobalTestDatabasePoolSize, OClient.DatabasePoolCurrentSize(TestConnection.GlobalTestDatabaseAlias) ); database.Dispose(); Assert.AreEqual( TestConnection.GlobalTestDatabasePoolSize, OClient.DatabasePoolCurrentSize(TestConnection.GlobalTestDatabaseAlias) ); } }
public override void Finish() { OClient.DropDatabasePool(CollectionName); foreach (var database in databases) { database.Close(); } }
private MovieManager() { tClient = new TClient(); imdbClient = new ImdbClient(); oClient = new OClient(); tmdbApiKey = tClient.Key; youTubeClient = new YouTubeService(new BaseClientService.Initializer() { ApiKey = "AIzaSyDFaNumZ4ZE3hDY-yDQi9VY_WDEYrS3xvo", ApplicationName = "Google Play Android Developer" }); }
public OrientDB() { OClient.CreateDatabasePool( "localhost", 2424, "VK", ODatabaseType.Graph, "root", "admin", 100, databaseAlias ); }
public static void CreatePool() { OClient.CreateDatabasePool( _hostName, _port, DatabaseName, DatabaseType, _username, _pass, DatabasePoolSize, DatabaseAlias ); }
public static void CreateTestPool() { OClient.CreateDatabasePool( _hostname, _port, GlobalTestDatabaseName, GlobalTestDatabaseType, _username, _password, GlobalTestDatabasePoolSize, GlobalTestDatabaseAlias ); }
public void CreateTestPool() { OClient.CreateDatabasePool( HOSTNAME, PORT, GLOBAL_TEST_DATABASE_NAME, GlobalTestDatabaseType, USERNAME, PASSWORD, GlobalTestDatabasePoolSize, GLOBAL_TEST_DATABASE_ALIAS ); }
static void Main(string[] args) { _server = new OServer(_hostname, _port, _rootUserName, _rootUserPassword); //If the DB already exists I delete it if (_server.DatabaseExist(_DBname, OStorageType.PLocal)) { _server.DropDatabase("TestDatabaseName", OStorageType.PLocal); Console.WriteLine("Database " + _DBname + " deleted"); } //Creating the new DB _server.CreateDatabase(_DBname, ODatabaseType.Graph, OStorageType.PLocal); Console.WriteLine("Database " + _DBname + " created"); //Connect to the DB and populate it OClient.CreateDatabasePool( "127.0.0.1", 2424, _DBname, ODatabaseType.Graph, _username, _password, 10, "myTestDatabaseAlias" ); Console.WriteLine("Connected to the DB " + _DBname); using (ODatabase database = new ODatabase("myTestDatabaseAlias")) { database .Create.Class("TestClass") .Extends <OVertex>() .Run(); OVertex createdVertex = database .Create.Vertex("TestClass") .Set("name", "LucaS") .Run(); Console.WriteLine("Created vertex with @rid " + createdVertex.ORID); } }
public void ShouldRetrieveAndReturnDatabaseFromPool() { using (TestDatabaseContext testContext = new TestDatabaseContext()) { Assert.AreEqual( TestConnection.GlobalTestDatabasePoolSize, OClient.DatabasePoolCurrentSize(TestConnection.GlobalTestDatabaseAlias) ); using (ODatabase database = new ODatabase(TestConnection.GlobalTestDatabaseAlias)) { Assert.AreEqual( TestConnection.GlobalTestDatabasePoolSize - 1, OClient.DatabasePoolCurrentSize(TestConnection.GlobalTestDatabaseAlias) ); } Assert.AreEqual( TestConnection.GlobalTestDatabasePoolSize, OClient.DatabasePoolCurrentSize(TestConnection.GlobalTestDatabaseAlias) ); } }
static void CreateDatabaseTestManualy() { var serverConnInfo = Configuration.GetSection("ConnectionStrings:DefaultConnection").GetChildren().ToDictionary(x => x.Key); using (var server = new OServer(serverConnInfo["Server"].Value, int.Parse(serverConnInfo["Port"].Value), serverConnInfo["Username"].Value, serverConnInfo["Password"].Value)) { var created = false; try { var exists = server.DatabaseExist("TestManualy", OStorageType.PLocal); if (exists) { server.DropDatabase("TestManualy", OStorageType.PLocal); } created = server.CreateDatabase("TestManualy", ODatabaseType.Document, OStorageType.PLocal); if (!created) { throw new Exception("Database not created"); } exists = server.DatabaseExist("TestManualy", OStorageType.PLocal); if (!exists) { throw new Exception("Database not exists"); } System.Console.WriteLine("Database created - get server configuration"); var config = server.ConfigList(); foreach (var item in config) { System.Console.WriteLine("{0} : {1}", item.Key, item.Value); } System.Console.WriteLine("try connect to the database and query"); OClient.CreateDatabasePool( serverConnInfo["Server"].Value, int.Parse(serverConnInfo["Port"].Value), "TestManualy", ODatabaseType.Graph, serverConnInfo["Username"].Value, serverConnInfo["Password"].Value, 10, "AppConnection" ); using (var database = new ODatabase("AppConnection")) { var documents = database.Query("select from OUser"); foreach (var item in documents) { System.Console.WriteLine("Name: {0} Status: {1}", item.GetField <string>("name"), item.GetField <string>("status")); } } OClient.DropDatabasePool("AppConnection"); } finally { if (created) { server.DropDatabase("TestManualy", OStorageType.PLocal); } } } }
//public int IntParseFast(string value) //{ // int result = 0; // for (int i = 0; i < value.Length; i++) // { // char letter = value[i]; // result = 10 * result + (letter - 48); // } // return result; //} /// <summary> /// Parse RidBags ex. %[content:binary]; where [content:binary] is the actual binary base64 content. /// </summary> /// <param name="i"></param> /// <param name="recordString"></param> /// <param name="document"></param> /// <param name="fieldName"></param> /// <returns></returns> private int ParseRidBags(int i, string recordString, ODocument document, string fieldName) { //move to first base64 char i++; StringBuilder builder = new StringBuilder(); while (recordString[i] != ';') { builder.Append(recordString[i]); i++; } // use a list as it preserves order at this stage which may be important when using ordered edges var rids = new List <ORID>(); var value = Convert.FromBase64String(builder.ToString()); using (var stream = new MemoryStream(value)) using (var reader = new BinaryReader(stream)) { var first = reader.ReadByte(); int offset = 1; if ((first & 2) == 2) { // uuid parsing is not implemented offset += 16; } if ((first & 1) == 1) // 1 - embedded,0 - tree-based { var entriesSize = reader.ReadInt32EndianAware(); for (int j = 0; j < entriesSize; j++) { var clusterid = reader.ReadInt16EndianAware(); var clusterposition = reader.ReadInt64EndianAware(); rids.Add(new ORID(clusterid, clusterposition)); } } else { // Maybe not parse this type of Field and only then Requested retrieve ? // Lazy loading if (_connection == null || !_connection.IsActive) { throw new OException(OExceptionType.Connection, "Connection is not opened or is null"); } // Tree based RidBag - (collectionPointer)(size:int)(changes) // Collection Pointer - (fileId:long)(pageIndex:long)(pageOffset:int) var fileId = reader.ReadInt64EndianAware(); var pageIndex = reader.ReadInt64EndianAware(); var pageOffset = reader.ReadInt32EndianAware(); // size var size = reader.ReadInt32EndianAware(); //only process ridbag if size > 0, otherwise the call to SBTreeBonsaiFirstKey operation makes the connection crash (the server probably isn't expecting this use case) if (size > 0) { // Changes - (changesSize:int)[(link:rid)(changeType:byte)(value:int)]* var changesSize = reader.ReadInt32EndianAware(); for (int j = 0; j < changesSize; j++) { throw new NotImplementedException("RidBag Changes not yet implemented"); } var operation = new SBTreeBonsaiFirstKey(null); operation.FileId = fileId; operation.PageIndex = pageIndex; operation.PageOffset = pageOffset; // Not realy quiete about this var connection = OClient.ReleaseConnection(_connection.Alias); var entries = new Dictionary <ORID, int>(); try { var orid = connection.ExecuteOperation(operation); var ft = true; var key = orid.GetField <ORID>("rid"); do { var op = new SBTreeBonsaiGetEntriesMajor(null); op.FileId = fileId; op.PageIndex = pageIndex; op.PageOffset = pageOffset; op.FirstKey = key; op.Inclusive = ft; var res = connection.ExecuteOperation(op); entries = res.GetField <Dictionary <ORID, int> >("entries"); rids.AddRange(entries.Keys); if (entries.Count == 0) { break; } key = entries.Last().Key; ft = false; } while (true); } finally { OClient.ReturnConnection(connection); } } } } document[fieldName] = rids; //move past ';' i++; return(i); }
public void DropTestPool() { OClient.DropDatabasePool(GLOBAL_TEST_DATABASE_ALIAS); }
static void CreateDatabaseTestManualy() { using (var server = new OServer("127.0.0.1", 2424, "root", "root")) { var created = false; try { created = server.CreateDatabase("TestManualy", ODatabaseType.Document, OStorageType.PLocal); if (!created) { throw new Exception("Database not created"); } var exists = server.DatabaseExist("TestManualy", OStorageType.PLocal); if (!exists) { throw new Exception("Database not exists"); } System.Console.WriteLine("Database created - get server configuration"); var config = server.ConfigList(); foreach (var item in config) { System.Console.WriteLine("{0} : {1}", item.Key, item.Value); } System.Console.WriteLine("try connect to the database and query"); OClient.CreateDatabasePool( "localhost", 2424, "TestManualy", ODatabaseType.Graph, "root", "root", 10, "AppConnection" ); using (var database = new ODatabase("AppConnection")) { var documents = database.Query("select from OUser"); foreach (var item in documents) { System.Console.WriteLine("Name: {0} Status: {1}", item.GetField <string>("name"), item.GetField <string>("status")); } } OClient.DropDatabasePool("AppConnection"); } finally { if (created) { server.DropDatabase("TestManualy", OStorageType.PLocal); } } } }
static void ConnectionPoolTest() { using (TestDatabaseContext testContext = new TestDatabaseContext()) { using (ODatabase database = new ODatabase(TestConnection.GlobalTestDatabaseAlias)) { database .Create.Class("Person") .Extends <OVertex>() .Run(); database .Create.Class("Spouse") .Extends <OVertex>() .Run(); ODocument person1 = database .Create.Vertex("Person") .Set("Name", "Johny") .Run(); ODocument spouse1 = database .Create.Vertex("Spouse") .Set("Name", "Mary") .Run(); ODocument spouse2 = database .Create.Vertex("Spouse") .Set("Name", "Julia") .Run(); // TODO: check what happens in command execution ODocument edge1 = database .Create.Edge <OEdge>() .From(person1) .To(spouse1) .Run(); ODocument edge2 = database .Create.Edge <OEdge>() .From(person1) .To(spouse2) .Run(); List <ODocument> docs = database.Query("select from Person"); } bool exit = false; using (ODatabase database = new ODatabase(TestConnection.GlobalTestDatabaseAlias)) { database .Create.Class("TestClass") .Extends <OVertex>() .Run(); database .Create.Vertex("TestClass") .Set("foo", "foo string value 1") .Set("bar", 123) .Run(); database .Create.Vertex("TestClass") .Set("foo", "foo string value 2") .Set("bar", 1233) .Run(); } while (!exit) { System.Console.WriteLine( "Current pool size: {0} @ {1} : {2}", OClient.DatabasePoolCurrentSize(TestConnection.GlobalTestDatabaseAlias), DateTime.Now.ToString(), Query().Count ); string line = System.Console.ReadLine(); if (line.Equals("exit")) { exit = true; } } } }
public static void DropTestPool() { OClient.DropDatabasePool(GlobalTestDatabaseAlias); }
static void Main(string[] args) { _server = new OServer(_hostname, _port, _rootUserName, _rootUserPassword); if (!_server.DatabaseExist(_DBname, OStorageType.PLocal)) { _server.CreateDatabase(_DBname, ODatabaseType.Graph, OStorageType.PLocal); Console.WriteLine("Database " + _DBname + " created"); //Connect to the DB OClient.CreateDatabasePool( _hostname, _port, _DBname, ODatabaseType.Graph, _username, _password, 10, _aliasDB ); Console.WriteLine("Connected to the DB " + _DBname); using (ODatabase database = new ODatabase(_aliasDB)) { //Classes and properties creation database .Create .Class("Users") .Extends <OVertex>() .Run(); database .Create .Property("userID", OType.Integer) .Class("users") .Run(); //Populate the DB OVertex vertexUser = new OVertex(); vertexUser.OClassName = "Users"; vertexUser .SetField("userID", 1); OVertex createVertexUser = database .Create.Vertex(vertexUser) .Run(); Console.WriteLine("Created vertex " + createVertexUser.OClassName + " with @rid " + createVertexUser.ORID + " and userID " + createVertexUser.GetField <int>("userID")); } } else { //Connection OClient.CreateDatabasePool( _hostname, _port, _DBname, ODatabaseType.Graph, _username, _password, 10, _aliasDB ); Console.WriteLine("Connected to the DB " + _DBname); using (ODatabase database = new ODatabase(_aliasDB)) { database .Update() .Class("Users") .Set("userID", 2) .Upsert() .Where("userID") .Equals(2) .Run(); Console.WriteLine("Operation executed"); } } }
public void SendMessage(OClient msgType, string msg, Socket client) => Handler.Server.Send(client, BytesCompress.CompressPacket(BytesTransformation.TransformIt((int)msgType, msg), "OPacket"));