public void ShouldExecuteSimpleGremlinQuery()
{
using (TestDatabaseContext testContext = new TestDatabaseContext())
{
using (ODatabase database = new ODatabase(TestConnection.ConnectionOptions))
{
OVertex vertex1 = database
.Create.Vertex <OVertex>()
.Set("Foo", "foo string value 1")
.Set("Bar", 12345)
.Run();
OVertex vertex2 = database
.Create.Vertex <OVertex>()
.Set("Foo", "foo string value 2")
.Set("Bar", 54321)
.Run();
OEdge edge1 = database
.Create.Edge <OEdge>()
.From(vertex1)
.To(vertex2)
.Set("Foo", "foo string value 3")
.Set("Bar", 123)
.Run();
OCommandResult documents = database.Gremlin("g.V");
}
}
}
public ODocument Run()
{
var operation = new LoadRecord(_orid, _fetchPlan, _connection.Database);
var result = new OCommandResult(_connection.ExecuteOperation(operation));
return(result.ToSingle().To <ODocument>());
}
public ODocument Run()
{
var operation = new LoadRecord(_orid, _fetchPlan, _connection.Database);
var result = new OCommandResult(_connection.ExecuteOperation(operation));
return result.ToSingle().To<ODocument>();
}
public T Run <T>()
where T : class, new()
{
var operation = new LoadRecord(_orid, _fetchPlan, _connection.Database);
var result = new OCommandResult(_connection.ExecuteOperation(operation));
return(result.ToSingle().To <T>());
}
public void truncateDatabase()
{
using (ODatabase database = new ODatabase(opts))
{
string queryTruncateUser = string.Format("truncate class User unsafe");
string queryTruncateFriend = string.Format("truncate class Friend unsafe");
OCommandResult commandResult = database.Command(queryTruncateUser);
commandResult = database.Command(queryTruncateFriend);
}
}
public void writeRecursiveUsers(VK.VKMan rootUser, VK.VKObjects vkInstance, int currDepth, int depth, List <MainWindow.conditionArr> listConditions)
{
using (ODatabase database = new ODatabase(opts))
{
var Users = vkInstance.getFriendsListFromXML(rootUser.id, listConditions);
Statistic.Statistic.LogVertex(depth, Users.Count);
foreach (VK.VKMan User in Users)
{
string queryString = String.Format("UPDATE user set first_name='{0}', last_name='{1}', sex='{2}',bday='{3}',country='{4}'," +
"city='{5}',interests='{6}',music='{7}',movies='{8}',games='{9}',about='{10}', vkid='{11}'" +
" UPSERT WHERE vkid='{11}'",
User.first_name, User.last_name, User.sex, DateTimeAdapter(User.bday), User.country, User.city, User.interests,
User.music, User.movies, User.games, "", User.id);
string queryStringSelectORID = string.Format("SELECT FROM user WHERE vkid={0}", User.id);
try
{
OCommandResult commandResult = database.Command(queryString);
OCommandResult commandSelectORIDResult = database.Command(queryStringSelectORID);
User.ORID = commandSelectORIDResult.ToDocument().GetField <ODocument>("Content").GetField <ORID>("@ORID").ToString();
List <ODocument> result = database.Query(queryStringSelectORID);
foreach (ODocument document in result)
{
User.ORID = document.ORID.ToString();
}
//Логируем
var comupsert = string.Format("CREATE EDGE Friend FROM {0} TO {1} SET weight={2}", rootUser.ORID, User.ORID, User.rootEdgeWeigth);
database.Command(string.Format("CREATE EDGE Friend FROM {0} TO {1} SET weight={2}", rootUser.ORID, User.ORID, User.rootEdgeWeigth));
//Statistic.Statistic.LogEdge(depth,);//Логгируем
if (currDepth < depth)
{
currDepth++;
writeRecursiveUsers(User, vkInstance, currDepth, depth, listConditions);
currDepth--;
}
}
catch (OException ex)
{
Statistic.Statistic.logError(ex.ToString());
Console.WriteLine(String.Format("There are problems with {0} {1}", User.first_name, User.last_name));
}
}
}
}
/// <summary>
/// Записать в базу список пользователей (без связей)
/// </summary>
/// <param name="Users"></param>
/// <returns></returns>
public bool WriteVKUsers(List <VK.VKMan> Users)
{
using (ODatabase database = new ODatabase(databaseAlias))
{
foreach (VK.VKMan User in Users)
{
Console.WriteLine("User has been added");
OCommandResult commandResult = database.Command(String.Format("INSERT INTO user (first_name,last_name,sex,bday,country," +
"city,interests,music,movies,games,about)" +
"values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')",
User.first_name, User.last_name, User.sex, DateTimeAdapter(User.bday), User.country, User.city, User.interests,
User.music, User.movies, User.games, User.about)
);
User.ORID = commandResult.ToDocument().ORID.ToString();
}
return(true);
}
}
/// <summary>
/// Записать в базу список пользователей (без связей)
/// </summary>
/// <param name="Users"></param>
/// <returns></returns>
public bool WriteVKUsers(List <VK.VKMan> Users)
{
using (ODatabase database = new ODatabase(opts))
{
foreach (VK.VKMan User in Users)
{
//TODO Т.к. мы вставляем через UPSERT, то не получаем ORID. Поэтому надо наверно через select по уникальному vkid его получать.
Console.WriteLine("User has been added");
var strUpsert = String.Format("UPDATE user set first_name='{0}', last_name='{1}', sex='{2}',bday='{3}',country='{4}'," +
"city='{5}',interests='{6}',music='{7}',movies='{8}',games='{9}',about='{10}', vkid='{11}'" +
" UPSERT WHERE vkid='{11}'",
User.first_name, User.last_name, User.sex, DateTimeAdapter(User.bday), User.country, User.city, User.interests,
User.music, User.movies, User.games, "", User.id);
string queryString = String.Format("UPDATE user set first_name='{0}', last_name='{1}', sex='{2}',bday='{3}',country='{4}'," +
"city='{5}',interests='{6}',music='{7}',movies='{8}',games='{9}',about='{10}', vkid='{11}'" +
" UPSERT WHERE vkid='{11}'",
User.first_name, User.last_name, User.sex, DateTimeAdapter(User.bday), User.country, User.city, User.interests,
User.music, User.movies, User.games, "", User.id);
string queryStringSelectORID = string.Format("SELECT FROM user WHERE vkid={0}", User.id);
/*
* OCommandResult commandResult = database.Command(String.Format("INSERT INTO user (first_name,last_name,sex,bday,country," +
* "city,interests,music,movies,games,about, vkid)" +
* "values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}', '{11}')",
* User.first_name, User.last_name, User.sex, DateTimeAdapter(User.bday), User.country, User.city, User.interests,
* User.music, User.movies, User.games, "", User.id)
* );
*/
OCommandResult commandResult = database.Command(queryString);
//OCommandResult commandSelectORIDResult = database.Command(queryStringSelectORID);
//Переделывал работу с ORIENT CLIENT
//User.ORID = commandSelectORIDResult.ToDocument().GetField<ODocument>("Content").GetField<ORID>("@ORID").ToString();
List <ODocument> result = database.Query(queryStringSelectORID);
foreach (ODocument document in result)
{
User.ORID = document.ORID.ToString();
}
}
return(true);
}
}
/// <summary>
/// Записать в базу друзей пользователя
/// </summary>
/// <param name="rootUser">Главнвый пользователь</param>
/// <param name="Users">Его друзья</param>
/// <returns></returns>
public bool WriteVKUserFriends(VK.VKMan rootUser, List <VK.VKMan> Users)
{
using (ODatabase database = new ODatabase(databaseAlias))
{
foreach (VK.VKMan User in Users)
{
Console.WriteLine("User has been added");
OCommandResult commandResult = database.Command(String.Format("INSERT INTO user (first_name,last_name,sex,bday,country," +
"city,interests,music,movies,games,about)" +
"values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')",
User.first_name, User.last_name, User.sex, "1900-10-10 00:00:00", User.country, User.city, User.interests,
User.music, User.movies, User.games, User.about)
);
var test = commandResult.ToDocument()["ORID"];
User.ORID = commandResult.ToDocument().ORID.ToString();
database.Command(string.Format("CREATE EDGE FROM {0} TO {1} SET weight={2}", rootUser.ORID, User.ORID, calculateWeigth()));
var i = 0;
}
return(true);
}
}
