variable vBaseServicePackage = myapp.server.common;

package myapp.client.generated;

bean TodoBean
{
    int todoId;
    String description;
    int rank;
}

bean AttributeBean
{
        String name;
        String displayName;
}

bean IdLabel 
{
        String id;
        String label;
}

package myapp.server.generated;

service DoneService
{
    List<TodoBean> getTodoList()
    <<
        select todo_id, description, rank 
        from t_todo
        order by rank
    >>

    int getNextSequenceValue() 
    <<
        select nextval('seq_todo')
    >>

    int getMaxRank() 
    <<
        select max(rank) from t_todo 
    >>
 
    void insertTask( int id, String description, int rank)
    <<
        insert into t_todo(todo_id, description, rank)
        values(?, ?, ?)
    >>

    int addNewTask(String task)
    {{
        int newId=getNextSequenceValue();
        int newRank=1+getMaxRank();
        insertTask(newId,task,newRank);
        return newId;
    }}
}