2
votes

I'm trying to check if a username exists or not. When I call queryOrderedBychild, snapshot value is always available but it will print down the whole database of mine, not just the data which I request queryOrderby. When I call queryEqualToValue, it always return null. I've tried many ways to figure it out.

This is my code:

DataService.instance.UsersRef.queryOrdered(byChild:"Nickname").queryEqual(toValue: "kai1004pro").observe(.value, with: { (snapshot) in

        if (snapshot.value is NSNull) {
            print("not found")
        } else {
            print("found")
            print(snapshot.value)
        }




    })

This is my json tree:

Optional({
g50X0FvEsSO4L457v7NzS3dAABl1 =     {
    "User Profile" =         {
        Birthday = "Sep 20, 1992";
        Gender = Female;
        Nickname = kai1004pro;
        UserUID = g50X0FvEsSO4L457v7NzS3dAABl1;
        emailAddress = "[email protected]";
        isFollow = 0;
        isFriend = 0;
    };
};
})

This is the security rules :

"rules": {
".read": true,
".write": "auth != null",
"Users": {
  ".read": true,
  ".write": "auth != null",
  ".indexOn": ["Nickname", "User Profile"]
    }
  }
}
1
What is your UsersRef? My guess is that it links to the users id (g50X0FvEsSO4L457v7NzS3dAABl1) in this case, and Nickname is not a direct child of that, so its never finding it because its not searching the right place. When I was going through this, I also remember having an issue with .value when searching through child nodes, I used .ChildAdded and .ChildChanged instead I believe.Dallas

1 Answers

4
votes

Modify your JSON tree to include a separate node active_usernames, in that add username of every user whenever you create new user, modify whenever your user modify its username...

myApp:{
  users:{
    uid1:{....},
    uid2:{....},
    uid3:{....},
    uid4:{....},
  }
active_usernames :{
    uid1username : "true",
    uid2username : "true",
    uid3username : "true",
    uid4username : "true"
    }
}

To check your if username already exists:-

//Checking username existence
FIRDatabase.database().reference().child("active_usernames").child(self.enteredUsername.text!).observeSingleEvent(of: .value, with: {(usernameSnap) in

        if usernameSnap.exists(){
        //This username already exists

        }else{

        //Yippee!.. This can be my username
        }

    })

Also change your security rules to be readable (ONLY READABLE) to all, by manipulating the security rules.

{rules :{

   active_usernames : {

      ".read" : "true",
      ".write" : "auth != null"

      }
    }
   }

PS:- enteredUsername is the textField in which you enter your username.

Suggestion:- keep the checking code inside didChangeEditing event of the textField(For better user experience.!)