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");
}
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 static void CreateTestPool()
{
OClient.CreateDatabasePool(
_hostname,
_port,
GlobalTestDatabaseName,
GlobalTestDatabaseType,
_username,
_password,
GlobalTestDatabasePoolSize,
GlobalTestDatabaseAlias
);
}
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 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);
}
}
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");
}
}
}
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);
}
}
}
}
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);
}
}
}
}
