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

[Tiago Resende]

I had to change the code I sent above, It only works without AG, I've
tested in another project. ='(

The AG table structure is much different that I thought. We have just one
table mapping all database, right?


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

> 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
>
>
>



-- 
*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/e2fee7b0/attachment-0001.html