variable vApplicationExceptionPackage=myapp.client.common;
variable vBaseServicePackage=myapp.server.common;

package myapp.client.generated;

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

package myapp.server.generated;

service TodoService
{
    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;
   }}
   
}