public static void DropTestDatabase() { var retry = 2; do { try { if (_server.DatabaseExist(GlobalTestDatabaseName, GlobalTestDatabaseStorageType)) { _server.DropDatabase(GlobalTestDatabaseName, GlobalTestDatabaseStorageType); } break; } catch { _server.Dispose(); _server = new OServer(_hostname, _port, _rootUserName, _rootUserParssword); } Thread.Sleep(100); }while (--retry > 0); if (_server.DatabaseExist(GlobalTestDatabaseName, GlobalTestDatabaseStorageType)) { Assert.True(false, "Cannot drop test database."); } }
public void ShouldCreateAndDeleteDatabase() { string databaseName = "thisIsTestDatabaseForNetDriver"; OServer server = TestConnection.GetServer(); bool exists = server.DatabaseExist(databaseName, OStorageType.PLocal); if (exists) { server.DropDatabase(databaseName, OStorageType.PLocal); exists = server.DatabaseExist(databaseName, OStorageType.PLocal); } Assert.AreEqual(exists, false); if (!exists) { bool isCreated = server.CreateDatabase(databaseName, ODatabaseType.Graph, OStorageType.PLocal); Assert.AreEqual(isCreated, true); if (isCreated) { server.DropDatabase(databaseName, OStorageType.PLocal); exists = server.DatabaseExist(databaseName, OStorageType.PLocal); Assert.AreEqual(exists, false); } } }
private bool CreateDatabaseIfNotExists(string hostname, int port, string user, string password, string database) { using (var server = new OServer(hostname, port, user, password)) { if (!server.DatabaseExist(database, OStorageType.PLocal)) { var created = server.CreateDatabase(database, ODatabaseType.Graph, OStorageType.PLocal); using (var db = new ODatabase("localhost", 2424, "txgraph", ODatabaseType.Graph, "admin", "admin")) { db.Command("CREATE CLASS Transaction EXTENDS V"); db.Command("CREATE PROPERTY Transaction.Hash STRING"); db.Command("CREATE INDEX IndexForHash ON Transaction (Hash) UNIQUE_HASH_INDEX"); db.Command("CREATE PROPERTY Transaction.BlockTime DATETIME"); db.Command("CREATE PROPERTY Transaction.Coinbase BOOLEAN"); db.Command("ALTER PROPERTY Transaction.Coinbase DEFAULT False"); db.Command("CREATE PROPERTY Transaction.Unlinked BOOLEAN"); db.Command("ALTER PROPERTY Transaction.Unlinked DEFAULT True"); db.Command("CREATE CLASS Link EXTENDS E"); db.Command("CREATE PROPERTY Link.sTx STRING"); db.Command("CREATE PROPERTY Link.sN LONG"); db.Command("CREATE PROPERTY Link.tTx STRING"); db.Command("CREATE PROPERTY Link.tAddr STRING"); db.Command("CREATE PROPERTY Link.amount LONG"); } return(created); } else { return(true); } } }
public void TestConfigList() { OServer server = TestConnection.GetServer(); Dictionary <string, string> config = server.ConfigList(); Assert.IsTrue(config.Count > 0); }
public void TestConfigGet() { OServer server = TestConnection.GetServer(); string value = server.ConfigGet("db.document.serializer"); Assert.AreEqual("ORecordSerializerBinary", value); }
public static OServer Connect() { OServer server = new OServer(_hostname, _port, _user, _passwd); return(server); }
private static void ConnectionPoolTest() { OServer server = new OServer(Configuration["ConnectionStrings:DefaultConnection:Server"], int.Parse(Configuration["ConnectionStrings:DefaultConnection:Port"]), Configuration["ConnectionStrings:DefaultConnection:Username"], Configuration["ConnectionStrings:DefaultConnection:Password"]); if (server.DatabaseExist(Configuration["ConnectionStrings:DefaultConnection:DefaultDB"], OStorageType.PLocal)) { server.DropDatabase(Configuration["ConnectionStrings:DefaultConnection:DefaultDB"], OStorageType.PLocal); } server.CreateDatabase(Configuration["ConnectionStrings:DefaultConnection:DefaultDB"], ODatabaseType.Graph, OStorageType.PLocal); using (ODatabase database = new ODatabase(Configuration["ConnectionStrings:DefaultConnection:Server"], int.Parse(Configuration["ConnectionStrings:DefaultConnection:Port"]), Configuration["ConnectionStrings:DefaultConnection:DefaultDB"], ODatabaseType.Graph, Configuration["ConnectionStrings:DefaultConnection:Username"], Configuration["ConnectionStrings:DefaultConnection:Password"])) { database.Create.Class("Person").Run(); database.Insert().Into("Person").Set("Name", $"John").Set("LastName", $"Doe").Set("Age", 99).Run(); Parallel.For(0, 1000000, (i) => { ODocument document = database.Insert().Into("Person").Set("Name", $"John{i}").Set("LastName", $"Doe{i}").Set("Age", i).Run(); //System.Console.WriteLine(document.ORID); }); } }
static OrientDBDriver() { _server = new OServer(_hostName, _port, _rootUserName, _rootPass); DatabaseName = "MoviesRatings"; DatabaseType = ODatabaseType.Graph; DatabaseAlias = "OrientDB"; }
public void TestDbList() { OServer server = TestConnection.GetServer(); Dictionary <string, ODatabaseInfo> databases = server.Databases(); Assert.IsTrue(databases.Count > 0); }
static TestConnection() { _server = new OServer(_hostname, _port, _rootUserName, _rootUserParssword); GlobalTestDatabaseName = "globalTestDatabaseForNetDriver001"; GlobalTestDatabaseType = ODatabaseType.Graph; GlobalTestDatabaseAlias = "globalTestDatabaseForNetDriver001Alias"; }
public void TestConfigGet() { OServer server = TestConnection.GetServer(); bool IsCreated = server.ConfigSet("network.retry", "6"); string value = server.ConfigGet("network.retry"); Assert.Equal("6", value); }
public void TestDbList() { var connection = new TestConnection(); OServer server = connection.Server; Dictionary <string, string> databases = server.Databases(); Assert.IsTrue(databases.Count > 0); }
public void TestConfigGet() { var connection = new TestConnection(); OServer server = connection.Server; string value = server.ConfigGet("db.document.serializer"); Assert.AreEqual("ORecordSerializerBinary", value); }
public void TestConfigList() { var connection = new TestConnection(); OServer server = connection.Server; Dictionary <string, string> config = server.ConfigList(); Assert.IsTrue(config.Count > 0); }
//Egyszerű sql utasításokkal tölt fel, a for ciklusban beállított dokumentumokra. //Aminerekhez, public static void AThreadProc1() { OServer server = Server.Connect(); ODatabase database = new ODatabase("localhost", 2424, "TreeOfScience", ODatabaseType.Graph, "admin", "admin"); string url, json; Vertex v; AminerVertex a = new AminerVertex { }; url = @"F:\graph\aminer_papers_"; for (int i = 0; i < 1 /*55*/; i++) { using (StreamReader sr = File.OpenText(url + i + ".txt")) { while ((json = sr.ReadLine()) != null) { v = JsonConvert.DeserializeObject <Vertex>(json); if (v.authors != null) { for (int currentAuthor = 0; currentAuthor < v.authors.Length; currentAuthor++) { v.authors[currentAuthor].@class = "Author"; v.authors[currentAuthor].@type = "d"; } } a.aminer_id = v.id; a.title = v.title; a.authors = v.authors; a.year = v.year; a.venue = v.venue; a.keywords = v.keywords; a.fos = v.fos; a.n_citation = v.n_citation; a.references = v.references; a.page_stat = v.page_stat; a.page_end = v.page_end; a.doc_type = v.doc_type; a.lang = v.lang; a.publisher = v.publisher; a.volume = v.volume; a.issue = v.issue; a.issn = v.issn; a.isbn = v.isbn; a.doi = v.doi; a.pdf = v.pdf; a.url = v.url; a.Abstract = v.Abstract; json = JsonConvert.SerializeObject(a).Replace("Abstract", "abstract").Replace("type", "@type").Replace("class", "@class").Replace("doc_@type", "doc_type"); database.Command("INSERT INTO Document CONTENT " + json); } } Console.WriteLine("a" + i); } }
public void TestDbList() { using (var context = new TestDatabaseContext()) using (ODatabase database = new ODatabase(TestConnection.GlobalTestDatabaseAlias)) { OServer server = TestConnection.GetServer(); Dictionary <string, ODatabaseInfo> databases = server.Databases(); Assert.True(databases.Count > 0); } }
public TestConnectionProxy(int port) { this.port = port; _server = new OServer(_hostname, port, _rootUserName, _rootUserParssword); GlobalTestDatabaseName = "globalTestDatabaseForNetDriver001"; GlobalTestDatabaseType = ODatabaseType.Graph; GlobalTestDatabaseAlias = "globalTestDatabaseForNetDriver001AliasProxy"; GlobalTestDatabaseStorageType = TestConnection.GlobalTestDatabaseStorageType; }
public void TestConfigSet() { OServer server = TestConnection.GetServer(); // Only Set existing keys // Don't create new one bool IsCreated = server.ConfigSet("network.retry", "6"); string loadedValue = server.ConfigGet("network.retry"); Assert.IsTrue(IsCreated); Assert.AreEqual("6", loadedValue); }
/// <summary> /// 构造方法 /// </summary> public OrientDbHelper() { _server = new OServer(ConfigHelper.GetSetting("ConnectionStrings:OrientDBServer").ToString(), int.Parse(ConfigHelper.GetSetting("ConnectionStrings:OrientDBPort").ToString()), ConfigHelper.GetSetting("ConnectionStrings:OrientDBUsername").ToString(), ConfigHelper.GetSetting("ConnectionStrings:OrientDBPassword").ToString()); _odatabase = new ODatabase(ConfigHelper.GetSetting("ConnectionStrings:OrientDBServer").ToString(), int.Parse(ConfigHelper.GetSetting("ConnectionStrings:OrientDBPort").ToString()), ConfigHelper.GetSetting("ConnectionStrings:OrientDBDefaultDB").ToString(), ODatabaseType.Graph, ConfigHelper.GetSetting("ConnectionStrings:OrientDBUsername").ToString(), ConfigHelper.GetSetting("ConnectionStrings:OrientDBPassword").ToString()); }
//Éleket tölt fel, jelenleg nem működik megfelelően. public static void Edge1() { try { OServer server = Server.Connect(); ODatabase database = new ODatabase("localhost", 2424, "TreeOfScience", ODatabaseType.Graph, "admin", "admin"); string url, json; Vertex v; AminerVertex a = new AminerVertex { }; url = @"F:\graph\aminer_papers_"; for (int i = 0; i < 1; i++) { using (StreamReader sr = File.OpenText(url + i + ".txt")) { while ((json = sr.ReadLine()) != null) { v = JsonConvert.DeserializeObject <Vertex>(json); a.aminer_id = v.id; a.references = v.references; if (a.references != null) { if (a.references.Length != 0) { foreach (string refr in a.references) { //if (a.references.Length != 0) foreach (string refr in a.references) //{ // database.Command("create edge from (select from document where aminer_id = '" + a.aminer_id + "') to (select from document where aminer_id = '" + refr + "')"); //} for (int refn = 0; refn < a.references.Length; refn++) { database.Command("create edge from (select from document where aminer_id = '" + a.aminer_id + "') to (select from document where aminer_id = '" + a.references[refn] + "')"); } } } } } } Console.WriteLine("a" + i); } } catch (OException e) { Console.WriteLine(e.Message); } }
public void DropTestDatabase() { var retry = 2; do { try { if (_server.DatabaseExist(GlobalTestDatabaseName, GlobalTestDatabaseStorageType)) { _server.DropDatabase(GlobalTestDatabaseName, GlobalTestDatabaseStorageType); } break; } catch { _server.Dispose(); _server = new OServer(_hostname, port, _rootUserName, _rootUserParssword); } }while (--retry > 0); }
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); } }
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 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 TestConnection(bool ssl = false) { _ssl = ssl; _server = new OServer(HOSTNAME, PORT, ROOT_USER_NAME, ROOT_USER_PARSSWORD, ssl); GlobalTestDatabaseType = ODatabaseType.Graph; }
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 static void MagTransThr6() { OServer server = Server.Connect(); ODatabase database = new ODatabase("localhost", 2424, "TreeOfScience", ODatabaseType.Graph, "admin", "admin"); string url, json; Vertex v; MagVertex m = new MagVertex { }; url = @"F:\graph\mag_papers_"; for (int i = 112; i < 167 /*167*/; i++) { string batch; StringBuilder builder = new StringBuilder("BEGIN;\n", 250000000); using (StreamReader sr = File.OpenText(url + i + ".txt")) { for (int rcount = 1; (json = sr.ReadLine()) != null; rcount++) { v = JsonConvert.DeserializeObject <Vertex>(json); if (v.authors != null) { for (int currentAuthor = 0; currentAuthor < v.authors.Length; currentAuthor++) { v.authors[currentAuthor].@class = "Author"; v.authors[currentAuthor].@type = "d"; } } m.mag_id = v.id; m.title = v.title; m.authors = v.authors; m.year = v.year; m.venue = v.venue; m.keywords = v.keywords; m.fos = v.fos; m.n_citation = v.n_citation; m.references = v.references; m.page_stat = v.page_stat; m.page_end = v.page_end; m.doc_type = v.doc_type; m.lang = v.lang; m.publisher = v.publisher; m.volume = v.volume; m.issue = v.issue; m.issn = v.issn; m.isbn = v.isbn; m.doi = v.doi; m.pdf = v.pdf; m.url = v.url; m.Abstract = v.Abstract; json = JsonConvert.SerializeObject(m).Replace("Abstract", "abstract").Replace("type", "@type").Replace("class", "@class").Replace("doc_@type", "doc_type"); builder.Append("INSERT INTO Document CONTENT "); builder.Append(json); builder.Append(";\n"); if (rcount % 1000 == 0) { builder.Append("COMMIT;"); batch = builder.ToString(); Console.WriteLine(String.Concat(DateTime.Now, " m", i, " ", rcount / 1000)); database.SqlBatch(batch).Run(); builder.Clear(); builder.Append("BEGIN;\n"); } } } builder.Append("COMMIT;"); batch = builder.ToString(); database.SqlBatch(batch).Run(); Console.WriteLine(String.Concat(DateTime.Now, " m", i, " OK")); } }