public static void Sql() { Thread.Sleep(2000); //Le thread à besoin d'attendre que la liste finale se remplisse #region Connexion connection = new MySqlConnection(connectionString); try { connection.Open(); //Ouverture de la connection } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox.Show("Impossible de se conncter, verifiez les parametres de la connexion"); } #endregion while (!_quitter) { InstaSharp.Model.Media m = new InstaSharp.Model.Media(); try { m = listefinale[placemedia]; //on choisit le media dans la liste } catch (Exception el) { } string requete; //va contenir la requete MySqlCommand command; //variable pour éxécuter la commande try { //ici on rentre les users requete = "INSERT INTO `isngr9`.`user` (`idUser`, `username`, `fullname`, `profilPicture`) VALUES ('" + m.User.Id + "', '" + m.User.Username + "', '" + m.User.FullName + "','" + m.User.ProfilePicture + "');"; command = new MySqlCommand(requete, connection); command.ExecuteNonQuery(); compteurSql++; } catch (Exception ex) { } try { if (m.Location.Name != null) // on teste si la location possède une place (un nom et un id, car sinon ceux ci sont nul et on à une erreur { try { requete = "INSERT INTO `isngr9`.`media` (`idMedia`, `idUser`, `createdtime`, `type`, `like`, `comment`) VALUES ('" + m.Id + "', '" + m.User.Id + "', '" + m.CreatedTime + "', '" + m.Type + "', '" + m.Likes.Count + "', '" + m.Comments.Count + "');"; //MessageBox.Show(requete); command = new MySqlCommand(requete, connection); System.IO.File.WriteAllText("time.txt", "&max_timestamp=" + m.CreatedTime); //On écrit dans un fichier texte le temps de la dernière photo entré, pour reprendre en cas de crash; command.ExecuteNonQuery(); requete = "INSERT INTO `isngr9`.`location` (`idLoc`, `latitude`, `idLieu`, `longitude`, `name`,`idMedia`) VALUES (NULL, '" + m.Location.Latitude + "', '" + m.Location.Id + "', '" + m.Location.Longitude + "', '" + m.Location.Name + "','" + m.Id + "');"; //MessageBox.Show(requete); command = new MySqlCommand(requete, connection); command.ExecuteNonQuery(); } catch (Exception ex) { } } else { try { requete = "INSERT INTO `isngr9`.`media` (`idMedia`, `idUser`, `createdtime`, `type`, `like`, `comment`) VALUES ('" + m.Id + "' , '" + m.User.Id + "', '" + m.CreatedTime + "', '" + m.Type + "', '" + m.Likes.Count + "', '" + m.Comments.Count + "');"; command = new MySqlCommand(requete, connection); command.ExecuteNonQuery(); System.IO.File.WriteAllText("time.txt", "&max_timestamp=" + m.CreatedTime); requete = "INSERT INTO `isngr9`.`location` (`idLoc`, `idLieu`, `latitude`, `longitude`, `name`, `idMedia`) VALUES (NULL, '0', '" + m.Location.Latitude + "', '" + m.Location.Longitude + "', 'null','" + m.Id + "');"; command = new MySqlCommand(requete, connection); command.ExecuteNonQuery(); } catch (Exception ex) { } } placemedia++; //on va au media suivant } catch (Exception el) { } } }
public static List<InstaSharp.Model.Media> lirexml(string fichier) { List<InstaSharp.Model.Media> listmedia = new List<InstaSharp.Model.Media>(); XmlDocument doc = new XmlDocument(); doc.Load(fichier); XmlNode noeud = doc.FirstChild.FirstChild; while (noeud != null) { switch (noeud.Name) { case "data": InstaSharp.Model.Media media = new InstaSharp.Model.Media(); List<InstaSharp.Model.Tag> listtag = new List<InstaSharp.Model.Tag>(); media.Tags = listtag; int compteurenfant = 0; while (compteurenfant < noeud.ChildNodes.Count) { try { //string s = noeud.FirstChild.NextSibling.Name; switch (noeud.ChildNodes[compteurenfant].Name) { #region Location case "location": InstaSharp.Model.Location location = new InstaSharp.Model.Location(); if (noeud.ChildNodes[compteurenfant].ChildNodes.Count == 4) { location.Latitude = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText; location.Name = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText.Replace("'", "''"); location.Longitude = noeud.ChildNodes[compteurenfant].ChildNodes[2].InnerText; location.Id = Convert.ToInt32(noeud.ChildNodes[compteurenfant].ChildNodes[3].InnerText); media.Location = location; } else { location.Latitude = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText; location.Longitude = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText; media.Location = location; } break; #endregion #region Tag case "tags": InstaSharp.Model.Tag t = new InstaSharp.Model.Tag(); t.Name = noeud.ChildNodes[compteurenfant].InnerText; listtag.Add(t); media.Tags = listtag; string s = media.Tags.Count.ToString(); break; #endregion #region Time case "created_time": media.CreatedTime = noeud.ChildNodes[compteurenfant].InnerText; break; #endregion #region Id case "id": media.Id = noeud.ChildNodes[compteurenfant].InnerText; break; #endregion #region Like case "likes": InstaSharp.Model.Like like = new InstaSharp.Model.Like(); like.Count = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText; media.Likes = like; break; #endregion #region Coomments case "comments": InstaSharp.Model.Comments comments = new InstaSharp.Model.Comments(); comments.Count = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText; media.Comments = comments; break; #endregion #region Type case "type": media.Type = noeud.ChildNodes[compteurenfant].InnerText; break; #endregion #region User case "user": InstaSharp.Model.User user = new InstaSharp.Model.User(); user.Username = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText.Replace("'", "''"); user.ProfilePicture = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText; user.Id = noeud.ChildNodes[compteurenfant].ChildNodes[2].InnerText; user.FullName = noeud.ChildNodes[compteurenfant].ChildNodes[3].InnerText.Replace("'", "''"); media.User = user; break; #endregion } } catch (Exception e) { } compteurenfant++; } listmedia.Add(media); break; } noeud = noeud.NextSibling; } // XmlNodeList elements = doc.DocumentElement.SelecSingletNodes("//data"); return listmedia; }
public static void Sql() { Thread.Sleep(2000); //Le thread à besoin d'attendre que la liste finale se remplisse #region Connexion connection = new MySqlConnection(connectionString); try { connection.Open(); //Ouverture de la connection } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox.Show("Impossible de se conncter, verifiez les parametres de la connexion"); } #endregion while (!_quitter) { InstaSharp.Model.Media m = new InstaSharp.Model.Media(); try { m = listefinale[placemedia]; //on choisit le media dans la liste } catch (Exception el) { } string requete; //va contenir la requete MySqlCommand command; //variable pour éxécuter la commande try { //ici on rentre les users requete = "INSERT INTO `isngr9`.`user` (`idUser`, `username`, `fullname`, `profilPicture`) VALUES ('" + m.User.Id + "', '" + m.User.Username + "', '" + m.User.FullName + "','" + m.User.ProfilePicture + "');"; command = new MySqlCommand(requete, connection); command.ExecuteNonQuery(); compteurSql++; } catch (Exception ex) { } try { if (m.Location.Name != null) // on teste si la location possède une place (un nom et un id, car sinon ceux ci sont nul et on à une erreur { try { requete = "INSERT INTO `isngr9`.`media` (`idMedia`, `idUser`, `createdtime`, `type`, `like`, `comment`) VALUES ('" + m.Id + "', '" + m.User.Id + "', '" + m.CreatedTime + "', '" + m.Type + "', '" + m.Likes.Count + "', '" + m.Comments.Count + "');"; //MessageBox.Show(requete); command = new MySqlCommand(requete, connection); System.IO.File.WriteAllText("time.txt", "&max_timestamp=" + m.CreatedTime); //On écrit dans un fichier texte le temps de la dernière photo entré, pour reprendre en cas de crash; command.ExecuteNonQuery(); requete = "INSERT INTO `isngr9`.`location` (`idLoc`, `latitude`, `idLieu`, `longitude`, `name`,`idMedia`) VALUES (NULL, '" + m.Location.Latitude + "', '" + m.Location.Id + "', '" + m.Location.Longitude + "', '" + m.Location.Name + "','" + m.Id + "');"; //MessageBox.Show(requete); command = new MySqlCommand(requete, connection); command.ExecuteNonQuery(); } catch (Exception ex) { } } else { try { requete = "INSERT INTO `isngr9`.`media` (`idMedia`, `idUser`, `createdtime`, `type`, `like`, `comment`) VALUES ('" + m.Id + "' , '" + m.User.Id + "', '" + m.CreatedTime + "', '" + m.Type + "', '" + m.Likes.Count + "', '" + m.Comments.Count + "');"; command = new MySqlCommand(requete, connection); command.ExecuteNonQuery(); System.IO.File.WriteAllText("time.txt", "&max_timestamp=" + m.CreatedTime); requete = "INSERT INTO `isngr9`.`location` (`idLoc`, `idLieu`, `latitude`, `longitude`, `name`, `idMedia`) VALUES (NULL, '0', '" + m.Location.Latitude + "', '" + m.Location.Longitude + "', 'null','" + m.Id + "');"; command = new MySqlCommand(requete, connection); command.ExecuteNonQuery(); } catch (Exception ex) { } } placemedia++; //on va au media suivant } catch (Exception el) { } } }
public static List <InstaSharp.Model.Media> lirexml(string fichier) { List <InstaSharp.Model.Media> listmedia = new List <InstaSharp.Model.Media>(); XmlDocument doc = new XmlDocument(); doc.Load(fichier); XmlNode noeud = doc.FirstChild.FirstChild; while (noeud != null) { switch (noeud.Name) { case "data": InstaSharp.Model.Media media = new InstaSharp.Model.Media(); List <InstaSharp.Model.Tag> listtag = new List <InstaSharp.Model.Tag>(); media.Tags = listtag; int compteurenfant = 0; while (compteurenfant < noeud.ChildNodes.Count) { try { //string s = noeud.FirstChild.NextSibling.Name; switch (noeud.ChildNodes[compteurenfant].Name) { #region Location case "location": InstaSharp.Model.Location location = new InstaSharp.Model.Location(); if (noeud.ChildNodes[compteurenfant].ChildNodes.Count == 4) { location.Latitude = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText; location.Name = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText.Replace("'", "''"); location.Longitude = noeud.ChildNodes[compteurenfant].ChildNodes[2].InnerText; location.Id = Convert.ToInt32(noeud.ChildNodes[compteurenfant].ChildNodes[3].InnerText); media.Location = location; } else { location.Latitude = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText; location.Longitude = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText; media.Location = location; } break; #endregion #region Tag case "tags": InstaSharp.Model.Tag t = new InstaSharp.Model.Tag(); t.Name = noeud.ChildNodes[compteurenfant].InnerText; listtag.Add(t); media.Tags = listtag; string s = media.Tags.Count.ToString(); break; #endregion #region Time case "created_time": media.CreatedTime = noeud.ChildNodes[compteurenfant].InnerText; break; #endregion #region Id case "id": media.Id = noeud.ChildNodes[compteurenfant].InnerText; break; #endregion #region Like case "likes": InstaSharp.Model.Like like = new InstaSharp.Model.Like(); like.Count = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText; media.Likes = like; break; #endregion #region Coomments case "comments": InstaSharp.Model.Comments comments = new InstaSharp.Model.Comments(); comments.Count = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText; media.Comments = comments; break; #endregion #region Type case "type": media.Type = noeud.ChildNodes[compteurenfant].InnerText; break; #endregion #region User case "user": InstaSharp.Model.User user = new InstaSharp.Model.User(); user.Username = noeud.ChildNodes[compteurenfant].ChildNodes[0].InnerText.Replace("'", "''"); user.ProfilePicture = noeud.ChildNodes[compteurenfant].ChildNodes[1].InnerText; user.Id = noeud.ChildNodes[compteurenfant].ChildNodes[2].InnerText; user.FullName = noeud.ChildNodes[compteurenfant].ChildNodes[3].InnerText.Replace("'", "''"); media.User = user; break; #endregion } } catch (Exception e) { } compteurenfant++; } listmedia.Add(media); break; } noeud = noeud.NextSibling; } // XmlNodeList elements = doc.DocumentElement.SelecSingletNodes("//data"); return(listmedia); }