问题描述

我是 Firebase 和 NoSQL 的新手.我有一个 Android 演示，带有一个城市自动完成文本字段，我想在输入时从我的 Firebase 数据库中填充我拥有的城市.

I'm new to Firebase and NoSQL. I have an Android Demo, with a City Autocomplete Text Field in which I want to populate the cities I have from my Firebase DB, while typing.

{   "cities":{
        "Guayaquil":true,
        "Gualaceo":true,
        "Quito":true,
        "Quevedo":true,
        "Cuenca":true,
        "Loja":true,
        "Ibarra":true,
        "Manta":true
    }
}

这是我目前所拥有的.

如何从以字母开头的数据库城市中检索(从键盘输入)?如果我开始输入G"，我想收到Guayaquil"和Gualaceo".

How can I retrieve from the DB cities that start with a letter (input from keyboard)? If I start typing "G", I want to receive "Guayaquil" and "Gualaceo".

如果我使用 orderByValue 总是返回一个空快照.

If I use orderByValue always returns an empty snapshot.

如果我使用 orderByKey 返回整个列表.

If I use orderByKey return the whole list.

    Query citiesQuery = databaseRef.child("cities").startAt(input).orderByValue();
    citiesQuery.addValueEventListener(new ValueEventListener() {
        @Override
        public void onDataChange(DataSnapshot dataSnapshot) {
            List<String> cities = new ArrayList<String>();
            for (DataSnapshot postSnapshot: dataSnapshot.getChildren()) {
                cities.add(postSnapshot.getValue().toString());
            }

注意:如果您能推荐更好的数据结构，欢迎您.

Note: If you can recommend a better data structure, you're welcome.

推荐答案

@NicholasChen 已发现问题.但这是您使用 3.x SDK 实现的方式:

@NicholasChen has identified the problem. But here's the way you'd implement using the 3.x SDK:

DatabaseReference cities = databaseRef.child("cities")
Query citiesQuery = cities.orderByKey().startAt(input).endAt(input+"uf8ff");
citiesQuery.addValueEventListener(new ValueEventListener() {
    @Override
    public void onDataChange(DataSnapshot dataSnapshot) {
        List<String> cities = new ArrayList<String>();
        for (DataSnapshot postSnapshot: dataSnapshot.getChildren()) {
            cities.add(postSnapshot.getValue().toString());
        }

从用户输入开始，到以用户输入开头的最后一个字符串结束，您将获得所有匹配项

By starting at the user input and ending at the last string that starts with the user input, you get all matching items

对于相对较短的项目列表，Ryan 的方法也可以正常工作.但是上面的 Firebase 查询会过滤服务器端.

For relatively short lists of items Ryan's approach will also work fine. But the above Firebase query will filter server-side.

我刚刚运行了这段代码:

I just ran this code:

    DatabaseReference databaseRef = FirebaseDatabase.getInstance().getReference("39714936");

    String input = "G";

    DatabaseReference cities = databaseRef.child("cities");
    Query citiesQuery = cities.orderByKey().startAt(input).endAt(input + "uf8ff");
    citiesQuery.addValueEventListener(new ValueEventListener() {
        @Override
        public void onDataChange(DataSnapshot dataSnapshot) {
            List<String> cities = new ArrayList<String>();

            for (DataSnapshot postSnapshot : dataSnapshot.getChildren()) {
                cities.add(postSnapshot.getValue().toString());
            }
            System.out.println(cities);
        }

        @Override
        public void onCancelled(DatabaseError databaseError) {

        }
    });

它打印出来了:

是的

是的

如此明显地匹配两个城市.

So clearly matches two cities.

随意对我的数据库进行测试:https://stackoverflow.firebaseio.com/39714936

Feel free to test against my database: https://stackoverflow.firebaseio.com/39714936