Computed columns and extras like COLLATE

[SelvinPL]

what about computed columns ... i know we have a views and it is a lots of works since you are using projection parameter from CP.query as columns in db.query without mapper... take a look at my(runtime) generator documentation and search for computed https://selvinlistsyncsample.codeplex.com/documentation ...(also you can add extras to the Column like Column.COLLATE) ...

[hamsterksu]

about computed columns:
what do you mean? a + b as c? sum(a) as c?

[hamsterksu]

if you want to select value and make some actions in the select you just need to provide projection to CP.query

Example:

String[] projection = new String[]{"LTRIM(RTRIM(" + YourTable.Name+ " || ' ' || " + YourTable.Description + "))"}

cp.query(uri, projection, ........)

[hamsterksu]

if you want to define this expression in databse query you can use RawQuery

[hamsterksu]

also i have a plugin for my library: https://github.com/hamsterksu/annotatedsql-projection-plugin
you can define projection in table/view/query definition

Example:

@Projection("LTRIM(RTRIM(" + YourTable.Name+ " || ' ' || " + YourTable.Description + ")) as super_value")
String MY_SUPER_PROJECTION = "Super"

[SelvinPL]

ok, plugin, just delete this issue but still it will be good to point the projection plugin on main page https://github.com/hamsterksu/Android-AnnotatedSQL

[hamsterksu]

in this demo app - https://github.com/hamsterksu/annotatedsql_demo
i have query with group by when i calculate comments count.

[SelvinPL]

what about extras ? CREATE TABLE .... COLUMN1 TEXT COLLATE LOCALIZED

[hamsterksu]

what about extras ? CREATE TABLE .... COLUMN1 TEXT COLLATE LOCALIZED

you can use default attribut of Column annotation
@column(type=TEXT, default=" '' COLLATE LOCALIZED")

value of default attirbute will be appended after column type

[SelvinPL]

there is no default attribute at this moment

[hamsterksu]

sorry, my misstake

@Column(type = Type.TEXT, defVal = "'' COLLATE LOCALIZED")

but it will not work :( lib generates sql like

description TEXT DEFAULT ('' COLLATE LOCALIZED))

I will add new attribute collate to the @column.

thanks,

[hamsterksu]

one another comment about View and query w/o mapping:
for each view lib generates ViewName2 class with new columns names.
column name will be genarted by the following tempalte:

<table_alias_name>_<column_name>

i did it to prevent ambiguous column error

[SelvinPL]

yeah, i saw that when i was analyzing generated code :) anyway nice library/generator

[hamsterksu]

"extra" attribute was added. version 1.10.3