public FriendMigration(string connectString, string userServiceUrl) { using (m_connection = new MySqlConnection(connectString)) { using (m_db = new opensim(m_connection)) { m_userUrl = userServiceUrl; m_userUrl = userServiceUrl; var friends = from f in m_db.friends select f; int i = 0; foreach (var friend in friends) { CreateFriend(friend); if (++i % 100 == 0) Console.Write("+"); } } } }
public UserMigration(string connectString, string userServiceUrl, string gridOwner) { using (m_connection = new MySqlConnection(connectString)) { using (m_db = new opensim(m_connection)) { m_userUrl = userServiceUrl; m_userUrl = userServiceUrl; var users = from u in m_db.useraccounts select u; foreach (var user in users) { CreateUser(user, gridOwner); Console.Write("+"); } } } if (!m_masterUserSet) Console.WriteLine("No grid owner set. You should manually assign one user to have an access level of 255 in the database"); }
private void CreateAssetSet(string lstr, string hstr) { string query = String.Format("SELECT * FROM assets where id > '{0}' and id <= '{1}'", lstr, hstr); Console.WriteLine(String.Empty); Console.WriteLine(query); using (m_db = new opensim(m_connection)) { var assets = m_db.ExecuteQuery<assets>(query); int count = 0; foreach (var asset in assets) { CreateAsset(asset); if (++count % 10 == 0) Console.Write("."); } } }