[aerogear-dev] SQLite Store Order By and Auto Increment ID

[Tiago Resende]

It's not as much beautiful as I liked, but it works.

Is there anyway to use AG implementation to read the cursor with all fields
and retrieve the object? I've used "read" to do the magic, but I didn't
like it.

public Collection<T> readSorted(EnumSort enumSort) {
        String tableName = getTableName();
        String fieldName = getIdFieldName();

        String sql = "SELECT %s FROM %s ORDER BY %s %s";
        if (enumSort == EnumSort.ASCENDING) {
            sql = String.format(sql, fieldName, tableName, fieldName,
"ASC");
        } else {
            sql = String.format(sql, fieldName, tableName, fieldName,
"DESC");
        }

        Collection<T> collection = new ArrayList<T>();

        SQLiteDatabase database = this.getReadableDatabase();
        Cursor cursor = database.rawQuery(sql, new String[]{});
        for (cursor.moveToFirst(); !cursor.isAfterLast();
cursor.moveToNext()) {
            collection.add(this.read(cursor.getInt(0)));
        }

        return collection;
    }


2014-03-17 18:54 GMT-03:00 Tiago Resende <tiagor87 at gmail.com>:

> The "order by" problem I solved implementing an extension for AG Store.
>
>
>
>
>
>
> 2014-03-17 18:45 GMT-03:00 Tiago Resende <tiagor87 at gmail.com>:
>
> The AeroGear isn't reading the last Id saved in database, so, it starts
>> over and over again, overwriting my old data every time a open my
>> application.
>>
>>
>> 2014-03-17 18:11 GMT-03:00 Daniel Passos <daniel at passos.me>:
>>
>>>  Hi Thiago,
>>>
>>> Nice questions. Answers inline.
>>>
>>> On Sun, Mar 16, 2014 at 6:20 PM, Tiago Resende <tiagor87 at gmail.com>wrote:
>>>
>>>> Hi guys, thanks for the other day, you really helped me.
>>>>
>>>> I have two questions today.
>>>>
>>>> How can I perform a query using "order by" statement in SQLStore?
>>>>
>>>> I did a readAll, then I ordered in memory using Ordering<T>.
>>>>
>>>
>>> Unfortunately. We don't have this option for now.
>>>
>>>
>>>> The second question is how can I indicate to AeroGear that it should
>>>> use an auto increment primary key for a table. I created an AutoGeneratorId
>>>> Class, but it's not working beautifully for SQLStore. I had to create an
>>>> update method and call it for every object, I didn't like it, but I
>>>> couldn't find a better solution reading the documentation.
>>>>
>>>
>>> No, who creates the id is always idGenerator. What's the problem?
>>>
>>>
>>>> I really appreciate your help.
>>>>
>>>> Thanks.
>>>>
>>>> --
>>>> *Tiago de Carvalho Resende*
>>>>
>>>
>>> _______________________________________________
>>> aerogear-dev mailing list
>>> aerogear-dev at lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>>
>>
>>
>>
>> --
>> *Tiago de Carvalho Resende*
>> Desenvolvedor
>>
>> "O importante não é saber fazer,
>>
>> é saber de onde copiar."
>>
>>  por Bernardo Esbérard
>>
>>
>>
>
>
>
> --
> *Tiago de Carvalho Resende*
> Desenvolvedor
>
> "O importante não é saber fazer,
>
> é saber de onde copiar."
>
> por Bernardo Esbérard
>
>
>



-- 
*Tiago de Carvalho Resende*
Desenvolvedor

"O importante não é saber fazer,

é saber de onde copiar."

por Bernardo Esbérard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20140317/d16e016d/attachment.html