public static bool placeMigration(ElasticClient elastic)
{
using (var context = new YoupDEVEntities())
{
var places = (from p in context.EVE_LieuEvenement
select p).ToList<EVE_LieuEvenement>();
foreach(var place in places){
Place placeElastic = new Place(place.LieuEvenement_id.ToString(), place.Nom, place.Ville, place.Latitude, place.Longitude);
var indexP = elastic.Index(placeElastic);
}
}
return true;
}
//Migration blog
public static bool blogMigration(ElasticClient elastic)
{
using (var context = new YoupDEVEntities())
{
var blogs = (from b in context.BLOG_Blog
select b).ToList<BLOG_Blog>();
foreach (var blog in blogs)
{
Blog blogElastic = new Blog(blog.Blog_id.ToString(), blog.TitreBlog, blog.Theme_id.ToString());
var indexB = elastic.Index(blogElastic);
/* var visits = (from v in context.BLOG_Visite
where v.Blog_Id == blog.Blog_id
select v).Count();*/
var articles = (from a in context.BLOG_Article
where a.Blog_id == blog.Blog_id
select a).ToList<BLOG_Article>();
foreach (var article in articles)
{
BlogPost articleElastic = new BlogPost(article.Article_id.ToString(), article.ContenuArticle, blog.Utilisateur_id.ToString(), article.TitreArticle);
var indexA = elastic.Index(articleElastic);
var comments = (from c in context.BLOG_Commentaire
where c.Article_id == article.Article_id
select c).ToList<BLOG_Commentaire>();
foreach (var comment in comments)
{
BlogPostComment commentElastic = new BlogPostComment(comment.Commentaire_id.ToString(), comment.ContenuCommentaire, comment.Utilisateur_id.ToString());
var indexBPC = elastic.Index(commentElastic);
}
}
}
}
return true;
}
//Migration user
public static bool userMigration(ElasticClient elastic)
{
using (var context = new YoupDEVEntities())
{
//Get BASE
var users = (from u in context.UT_Utilisateur
select u).ToList<UT_Utilisateur>();
//Translate into LUCENE
foreach (var user in users)
{
//Age (years only)
var now = DateTime.Now.Year;
var dob = user.DateNaissance.Year;
int userAge = (int)(now - dob);
//Create entity into LUCENE
Profile profileElastic = new Profile(user.Utilisateur_id.ToString(), user.Prenom, user.Nom, user.Pseudo, user.Situation, userAge, user.Sexe, user.Ville);
//Index entity
var indexU = elastic.Index(profileElastic);
}
}
return true;
}
//Migration forum
public static bool forumMigration(ElasticClient elastic)
{
using (var context = new YoupDEVEntities())
{
//Get BASE
var postforums = (from m in context.FOR_Message
select m).ToList<FOR_Message>();
//Translate into LUCENE
foreach (var postforum in postforums)
{
//Create entity into LUCENE
PostForum postforumElastic = new PostForum(postforum.Message_id.ToString(), "test", postforum.ContenuMessage ,postforum.DatePoste,postforum.UT_Utilisateur.Pseudo);
// public PostForum(string _Id, string _board, string _content, DateTime _date, string _author)
//Index entity
var indexFS = elastic.Index(postforumElastic);
}
}
return true;
}
//Migration event
public static bool eventMigration(ElasticClient elastic)
{
using (var context = new YoupDEVEntities())
{
//Get BASE
var events = (from e in context.EVE_Evenement
select e).ToList<EVE_Evenement>();
//Translate into LUCENE
foreach (var _event in events)
{
//Place
// Place placeElastic = new Place(place.LieuEvenement_id.ToString(), place.Nom, place.Ville);
Place eventPlace = new Place(_event.LieuEvenement_id.ToString(), _event.EVE_LieuEvenement.Nom, _event.EVE_LieuEvenement.Ville,
_event.EVE_LieuEvenement.Latitude, _event.EVE_LieuEvenement.Longitude);
//Create entity into LUCENE
//WARNING -- TImeslot missing --
/*
** public string Timeslot { get; set; } <<<!!!>>>
public Event(string _Id, string _Name, long _Type, DateTime _Date, Place _EPlace, string _Adresse, string _Timeslot <<<!!!>>>)*/
Event eventElastic = new Event(_event.Evenement_id.ToString(), _event.TitreEvenement, _event.Categorie_id, _event.DateEvenement, eventPlace, _event.EVE_LieuEvenement.Adresse);
//Index entity
var indexES = elastic.Index(eventElastic);
}
}
return true;
}
