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"));
}
}
