public TwitterAPPUser LoadUserByScreenName(string screenName)
{
TwitterAPPUser twitterUser = null;
var command = new MySqlCommand("SELECT id, followersCount, friendsCount, userProcessed FROM TwitterUser WHERE screen_name = ?screen_name");
command.Parameters.AddWithValue("?screen_name", screenName);
command.Connection = GenerateConnection();
command.Connection.Open();
var dr = command.ExecuteReader();
if (dr.Read())
{
twitterUser = new TwitterAPPUser();
twitterUser.screen_name = screenName;
twitterUser.id_str = dr.GetString(0);
twitterUser.followers_count = dr.GetInt32(1);
twitterUser.friends_count = dr.GetInt32(2);
twitterUser.userProcessed = dr.GetBoolean(3);
}
dr.Close();
command.Connection.Close();
return twitterUser;
}
protected UserInfo ExtractUserInfo(ITwitterExtractorByUser extractor, TwitterAPPUser user)
{
var userInfo = new TwitterRepstr_User();
var jsonResponse = extractor.GetResponse(user);
var response = JsonConvert.DeserializeObject<UserInfo>(jsonResponse);
return response;
}
public void SaveUserFollower(TwitterAPPUser user, TwitterAPPUser followerUser)
{
var command = new SqlCeCommand("INSERT INTO SEGUIDORES_TWITTER (IDTWITTER, IDTWITTERSEGUIDOR) VALUES (@IDTWITTER, @IDTWITTERSEGUIDOR)");
command.Parameters.Add("IDTWITTER", user.id_str);
command.Parameters.Add("IDTWITTERSEGUIDOR", followerUser.id_str);
SQLOperation.ExecuteSQLCommand(command);
}
public void SaveUserFollower(TwitterAPPUser user, TwitterAPPUser followerUser)
{
var command = new SqlCeCommand("INSERT INTO TwitterFollowers (id, id_Follower) VALUES (@id, @id_Follower)");
command.Parameters.Add("id", user.id_str);
command.Parameters.Add("id_Follower", followerUser.id_str);
SQLOperation.ExecuteSQLCommand(command);
}
public void SaveNewUser(TwitterAPPUser user)
{
var command = new SqlCeCommand("INSERT INTO USUARIOS_TWITTER (IDTWITTER, USERTWITTER) VALUES (@IDTWITTER, @USERTWITTER)");
command.Parameters.Add("IDTWITTER", user.id_str);
command.Parameters.Add("USERTWITTER", user.screen_name);
SQLOperation.ExecuteSQLCommand(command);
}
public void SaveNewUser(TwitterAPPUser user)
{
var command = new SqlCeCommand("INSERT INTO TwitterUser (id, screen_name, followersCount, friendsCount) VALUES (@id, @screen_name, @followersCount, @friendsCount)");
command.Parameters.Add("id", user.id_str);
command.Parameters.Add("screen_name", user.screen_name);
command.Parameters.Add("followersCount", user.followers_count);
command.Parameters.Add("friendsCount", user.friends_count);
SQLOperation.ExecuteSQLCommand(command);
}
public void SaveUserFollower(TwitterAPPUser user, TwitterAPPUser followerUser)
{
var command = new MySqlCommand("INSERT INTO TwitterFollowers (id, id_Follower) VALUES (?id, ?id_Follower)");
command.Parameters.AddWithValue("?id", user.id_str);
command.Parameters.AddWithValue("?id_Follower", followerUser.id_str);
command.Connection = GenerateConnection();
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
}
public void SaveNewUser(TwitterAPPUser user)
{
var conn = GenerateConnection();
conn.Open();
var command = conn.CreateCommand();
command.CommandText = "INSERT INTO TwitterUser (id, screen_name, followersCount, friendsCount, userProcessed) VALUES (?id, ?screen_name, ?followersCount, ?friendsCount, 0)";
command.Parameters.AddWithValue("?id", user.id_str);
command.Parameters.AddWithValue("?screen_name", user.screen_name);
command.Parameters.AddWithValue("?followersCount", user.followers_count);
command.Parameters.AddWithValue("?friendsCount", user.friends_count);
command.ExecuteNonQuery();
conn.Close();
}
public TwitterAPPUser LoadUser(string userId)
{
TwitterAPPUser twitterUser = null;
var command = new SqlCeCommand("SELECT USERTWITTER FROM USUARIOS_TWITTER WHERE IDTWITTER = @IDTWITTER");
command.Parameters.Add("IDTWITTER", userId);
var dr = SQLOperation.ExecuteSQLCommandWithResult(command);
if (dr.Read())
{
twitterUser = new TwitterAPPUser();
twitterUser.id_str = userId;
twitterUser.screen_name = dr.GetString(0);
}
dr.Close();
return twitterUser;
}
public void teste()
{
var relationshipReps = new GetRelationshipStatus();
var userSource = new TwitterAPPUser();
var userTarget = new TwitterAPPUser();
var opt = new RepositoryOptions();
var userRep = new LoadUser();
opt.twitterUser.screen_name = "amosbatista";
userSource = userRep.GetUser(opt);
opt.twitterUser.screen_name = "oficial_cp";
userTarget = userRep.GetUser(opt);
opt.twitterUser = userSource;
opt.twitterUser_Target = userTarget;
var result = relationshipReps.Get(opt);
result.ToString();
}
public List<TwitterAPPUser> LoadAllUnrecognizedUsers()
{
List<TwitterAPPUser> userList = null;
var command = new SqlCeCommand("SELECT IDTWITTER, USERTWITTER FROM USUARIOS_TWITTER WHERE USERTWITTER = 'Not identified'");
var dr = SQLOperation.ExecuteSQLCommandWithResult(command);
TwitterAPPUser twitterUser;
while(dr.Read())
{
if (userList == null)
userList = new List<TwitterAPPUser>();
twitterUser = new TwitterAPPUser();
twitterUser.id_str = dr.GetInt64(0).ToString();
twitterUser.screen_name = dr.GetString(1);
userList.Add(twitterUser);
}
dr.Close();
return userList;
}
public TwitterAPPUser LoadUserByScreenName(string screenName)
{
TwitterAPPUser twitterUser = null;
var command = new SqlCeCommand("SELECT id, followersCount, friendsCount FROM TwitterUser WHERE screen_name = @screen_name");
command.Parameters.Add("screen_name", screenName);
var dr = SQLOperation.ExecuteSQLCommandWithResult(command);
if (dr.Read())
{
twitterUser = new TwitterAPPUser();
twitterUser.screen_name = screenName;
twitterUser.id_str = dr.GetString(0);
twitterUser.followers_count = dr.GetInt32(1);
twitterUser.followers_count = dr.GetInt32(2);
}
dr.Close();
return twitterUser;
}
public TwitterAPPUser LoadUser(string userId)
{
TwitterAPPUser twitterUser = null;
var command = new SqlCeCommand("SELECT screen_name, followersCount, friendsCount FROM TwitterUser WHERE id = @id");
command.Parameters.Add("id", userId);
var dr = SQLOperation.ExecuteSQLCommandWithResult(command);
if (dr.Read())
{
twitterUser = new TwitterAPPUser();
twitterUser.id_str = userId;
twitterUser.screen_name = dr.GetString(0);
twitterUser.followers_count = dr.GetInt32(1);
twitterUser.followers_count = dr.GetInt32(2);
}
dr.Close();
return twitterUser;
}
public void GenerateNetWorkStatistics(NetWorkStatisticsProperties searchProp)
{
// Cleaning database
var userDB = new UserRepository();
var followerDB = new UserRelationshipRepository();
// Main list
var processedUserList = new TwitterUserList(); // Used in the interaction
// Arrays of friends and followers
var friendsReps = new FriendsIdList();
var followersReps = new FollowerIdList();
var userLookUp = new UserLookUp();
var relationshipReps = new GetRelationshipStatus();
var followersList = new List<TwitterAPPUser>();
var followersIdList = new UserIdList();
var friendsList = new List<TwitterAPPUser>();
var friendsIdList = new UserIdList();
var opt = new RepositoryOptions();
var newFollowersUser = new TwitterAPPUser();
var newFriendUser = new TwitterAPPUser();
var newUserToSave = new TwitterAPPUser();
// Lists of FR and FF from each user
var actualUserFriendIdList = new UserIdList();
var actualUserFollowerIdList = new UserIdList();
var idListToProcess = new UserIdList();
var userListToProcess = new List<TwitterAPPUser>();
var relationshipStatus = new RelationshipStatus_FinalResult();
// Determine the kind of process
if (searchProp.generateNewStatistic == true)
{
userDB.EraseAllData();
followerDB.EraseAllData();
// Setting the user for the first time
opt.twitterUser.screen_name = searchProp.twitterName;
// Loading me as the first user
var twitterUserRep = new LoadUser();
var mainUser = twitterUserRep.GetUser(opt);
// Save the user
userDB.SaveNewUser(mainUser);
userDB.SetUserAsProcessed(mainUser); // To impeding the first user to be processed again
// Generation of FR (friends) and FF (followers) list
opt.twitterUser.id_str = mainUser.id_str;
// Getting the friends and followers list
followersIdList = followersReps.GetFollowers(opt);
friendsIdList = friendsReps.GetFriends(opt);
opt.userList = followersIdList;
followersList = userLookUp.GetUserCompleteList(opt);
opt.userList = friendsIdList;
friendsList = userLookUp.GetUserCompleteList(opt);
// Reading all followers list
foreach (TwitterAPPUser user in followersList)
{
// Save the current user
userDB.SaveNewUser(user);
// Save the relationship
followerDB.SaveUserFollower(mainUser, user);
}
// Reading all friends list
foreach (TwitterAPPUser user in friendsList)
{
// Save the current user
userDB.SaveNewUser(user);
// Save the relationship
followerDB.SaveUserFollower(user, mainUser);
}
// Combinning the 2 list
userListToProcess.AddRange(friendsList);
userListToProcess.AddRange(followersList);
}
else
{
// Load the list of the users
userListToProcess = userDB.LoadUnprocessedUsers();
}
// Reading all this list, to get each contacts
foreach (TwitterAPPUser userSource in userListToProcess)
{
foreach (TwitterAPPUser userTarget in userListToProcess)
{
opt.twitterUser = userSource;
opt.twitterUser_Target = userTarget;
relationshipStatus = relationshipReps.Get(opt);
// Saving the user relationship, by the result response
if (relationshipStatus.relationship.target.following == true)
followerDB.SaveUserFollower(userSource, userTarget);
if (relationshipStatus.relationship.target.followed_by == true)
followerDB.SaveUserFollower(userTarget, userSource);
}
// After all, indicate the user was processed
userDB.SetUserAsProcessed(userSource);
}
}
public void SetUserAsProcessed(TwitterAPPUser user)
{
var command = new MySqlCommand("UPDATE TwitterUser SET userProcessed = 1 WHERE ID = ?id");
command.Parameters.AddWithValue("?id", user.id_str);
command.Connection = GenerateConnection();
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
}
public List<TwitterAPPUser> LoadUnprocessedUsers()
{
var userList = new List<TwitterAPPUser>();
TwitterAPPUser newUser;
var command = new MySqlCommand("SELECT id, screen_name, followersCount, friendsCount, userProcessed FROM TwitterUser WHERE userProcessed = 0");
command.Connection = GenerateConnection();
command.Connection.Open();
var dr = command.ExecuteReader();
while (dr.Read())
{
newUser = new TwitterAPPUser();
newUser.id_str = dr.GetString(0);
newUser.screen_name = dr.GetString(1);
newUser.followers_count = dr.GetInt32(2);
newUser.friends_count = dr.GetInt32(3);
newUser.userProcessed = dr.GetBoolean(4);
userList.Add(newUser);
}
dr.Close();
command.Connection.Close();
return userList;
}
private void ExtractFollowersAndFriendsFromUser(string userId, UserIdList contactList)
{
var opt = new RepositoryOptions();
var friendsReps = new FriendsIdList();
var followersReps = new FollowerIdList();
var mainUser = new TwitterAPPUser();
mainUser.id_str = userId;
var newUserToSave = new TwitterAPPUser();
var userDB = new UserRepository();
var followerDB = new UserRelationshipRepository();
// Get the friend list of this user
opt.twitterUser.id_str = mainUser.id_str;
var actualUserFriendIdList = friendsReps.GetFriends(opt);
// Select a list of these friends that are in the friends/followers list of the user
var idListToProcess = new UserIdList();
idListToProcess.ids.AddRange(from actualUserId in actualUserFriendIdList.ids where contactList.ids.Contains(actualUserId) select actualUserId);
// List all this users ids
foreach (decimal actualUserId in idListToProcess.ids)
{
// Save the relationship of this user
newUserToSave = new TwitterAPPUser();
newUserToSave.id_str = actualUserId.ToString();
followerDB.SaveUserFollower(newUserToSave, mainUser);
}
// Get the follower list of this user
idListToProcess.ids.Clear();
opt.twitterUser.id_str = mainUser.id_str;
var actualUserFollowerIdList = followersReps.GetFollowers(opt);
// Select a list of these followers that are in the friends/followers list of the user
idListToProcess.ids.AddRange(from actualUserId in actualUserFollowerIdList.ids where contactList.ids.Contains(actualUserId) select actualUserId);
// List all this users ids
foreach (decimal actualUserId in idListToProcess.ids)
{
// Save the relationship of this user
newUserToSave = new TwitterAPPUser();
newUserToSave.id_str = actualUserId.ToString();
followerDB.SaveUserFollower(mainUser, newUserToSave);
}
// After all, indicate the user was processed
userDB.SetUserAsProcessed(mainUser);
}
protected TwitterProcess()
{
MyUser = new TwitterAPPUser();
MyUser.id_str = MyUserData.TwitterID;
MyUser.screen_name = MyUserData.TwitterUser;
}
public void GenerateNetWorkStatistics(string twitterName, string deepnessCount)
{
// Cleaning database
var userDB = new UserRepository();
var followerDB = new UserRelationshipRepository();
userDB.EraseAllData();
followerDB.EraseAllData();
// Main list
var userListToProcess = new TwitterUserList();
var processedUserList = new TwitterUserList(); // Used in the interaction
// Arrays of friends and followers
var friendsReps = new FriendsIdList();
var followersReps = new FollowerIdList();
var userLookUp = new UserLookUp();
var followersList = new List<TwitterAPPUser>();
var followersIdList = new UserIdList();
var friendsList = new List<TwitterAPPUser>();
var friendsIdList = new UserIdList();
var opt = new RepositoryOptions();
var newFollowersUser = new TwitterAPPUser();
var newFriendUser = new TwitterAPPUser();
// Setting the user for the first time
opt.twitterUser.screen_name = twitterName;
// Loading me as the first user
var twitterUserRep = new LoadUser();
var firstUser = twitterUserRep.GetUser(opt);
// Setting the first array
userListToProcess.users.Add(firstUser);
opt.twitterUser.screen_name = "";
// Main loop
for (int processorCount = 0; processorCount < Int16.Parse(deepnessCount); processorCount++)
{
foreach (TwitterAPPUser user in userListToProcess.users)
{
// Setting the user for the first time
opt.twitterUser.id_str = user.id_str;
// Verify if the user is the same of the first
if (user.id_str == firstUser.id_str && userListToProcess.users.Count > 1)
continue;
// Getting the friends and followers list
followersIdList = followersReps.GetFollowers(opt);
opt.userList.ids = followersIdList.ids;
//followersList = userLookUp.GetUserCompleteList(opt);
friendsIdList = friendsReps.GetFriends(opt);
opt.userList.ids = friendsIdList.ids;
//friendsList = userLookUp.GetUserCompleteList(opt);
foreach (decimal followerUserId in followersIdList.ids )
{
newFollowersUser = new TwitterAPPUser();
newFollowersUser.id_str = followerUserId.ToString();
newFollowersUser.screen_name = "";
// Saving the the twitters users
//if (userDB.LoadUser(newFollowersUser.id_str) == null)
userDB.SaveNewUser(newFollowersUser);
followerDB.SaveUserFollower(user, newFollowersUser);
// Appending these users to the result
processedUserList.users.Add(newFollowersUser);
}
foreach (decimal friendUserId in friendsIdList.ids)
{
newFriendUser = new TwitterAPPUser();
newFriendUser.id_str = friendUserId.ToString();
newFriendUser.screen_name = "";
// Saving the the twitters users
//if (userDB.LoadUser(newFriendUser.id_str) == null)
userDB.SaveNewUser(newFriendUser);
followerDB.SaveUserFollower(newFriendUser, user);
// Appending these users to the result
processedUserList.users.Add(newFriendUser);
}
processedUserList.users.AddRange(friendsList);
}
// Setting the result to the main list
userListToProcess.users.Clear();
userListToProcess.users.AddRange(processedUserList.users);
processedUserList.users.Clear();
}
}
