package com.biocliq.palmyra.sample;

import com.zitlab.palmyra.api2db.script.PalmyraAppScript
import com.zitlab.palmyra.api2db.script.ScriptHelper
import com.zitlab.palmyra.api2db.pojo.Tuple
import com.zitlab.palmyra.api2db.pojo.TupleFilter
import com.zitlab.palmyra.api2db.pojo.NativeQuery;

import groovy.transform.CompileStatic

@CompileStatic
public class QueryStudent extends PalmyraAppScript{

    private static final String sqlQuery = "Select * from User where user_id = ?";

   	public int aclCheck(String subType, String action,Tuple item) {	
		return 15; 
	}
    public NativeQuery getQuery(String subType, String action, Tuple item) {
		NativeQuery query = new NativeQuery();
		query.setQuery(sqlQuery);
		query.addParams(getUser());
		return query;
	}
}