Quick Start

import java.time.LocalDate;
 
// Works without any annotations!
// Java camelCase is automatically converted to database snake_case
public class Employee {
    private Long id;                // Maps to: id
    private String firstName;       // Maps to: first_name
    private String lastName;        // Maps to: last_name
    private String email;           // Maps to: email
    private Double salary;          // Maps to: salary
    private LocalDate hireDate;     // Maps to: hire_date
    private Boolean active;         // Maps to: active
 
    // Getters and setters...
}
 
// Queries table: "employee" (converted to snake_case)
// Columns: id, first_name, last_name, email, salary, hire_date, active

import com.dev10.picnic.annotations.*;
import java.time.LocalDate;
 
// Use annotations only when your table/column names differ from defaults
@Table("employees")  // Table name is "employees", not "employee"
public class Employee {
 
    @Id
    private Long id;
 
    @Column("firstname")
    private String firstName;
 
    @Column("LAST_NAME")
    private String lastName;
 
    private String email;  // No annotation needed - uses "email" as column name
    private Double salary; // No annotation needed - uses "salary" as column name
    private LocalDate hireDate; // No annotation needed - uses "hire_date" as column name
 
    private Boolean active;
 
    // Getters and setters...
}

import com.dev10.picnic.GridDataProvider;
import javax.sql.DataSource;
import java.sql.Connection;
 
// Option 1: Using DataSource (recommended for production)
DataSource dataSource = // ... obtain from Spring or connection pool
GridDataProvider gridDataProvider = new GridDataProvider(dataSource);
 
// Option 2: Using Connection (caller manages lifecycle)
try (Connection conn = dataSource.getConnection()) {
    GridDataProvider gridDataProvider = new GridDataProvider(conn);
    // Execute queries...
}

import com.dev10.picnic.beans.DevExtremeResult;
import com.dev10.picnic.beans.devextreme.DevExtremeLoadOptions;
 
// Parse client request
DevExtremeLoadOptions loadOptions = DevExtremeLoadOptionsParser.fromJson(jsonRequest);
 
// Execute query using fluent API
DevExtremeResult<Employee> result = gridDataProvider
    .query(Employee.class)
    .loadOptions(loadOptions)
    .executeDevExtreme();
 
// Access results
List<Employee> employees = (List<Employee>) result.getData();
Integer totalCount = result.getTotalCount();

@RestController
@RequestMapping("/api/employees")
public class EmployeeController {
 
    @Autowired
    private GridDataProvider gridDataProvider;  // Auto-configured bean
 
    @PostMapping("/data")
    public DevExtremeResult<Employee> getEmployees(@RequestBody DevExtremeLoadOptions loadOptions) {
        return gridDataProvider
            .query(Employee.class)
            .loadOptions(loadOptions)
            .executeDevExtreme();
    }
}

DevExtremeResult<Employee> result = gridDataProvider
    .query(Employee.class)
    .loadOptions(loadOptions)
    .executeDevExtreme();

DevExtremeResult<Employee> result = gridDataProvider
    .query(Employee.class)
    .loadOptions(loadOptions)
    .schema("hr")                                    // Database schema
    .withParameter("departmentId", 5)                // WITH clause parameter
    .withParameter("startDate", LocalDate.now())    // Multiple parameters
    .customFilter(() -> "active = true")            // Custom SQL filter
    .executeDevExtreme();

DevExtremeResult<Sale> result = gridDataProvider
    .query(Sale.class)
    .loadOptions(loadOptions)
    .rowProcessor(new RunningSumProcessor())
    .contextMetadata("userId", currentUser.getId())
    .executeDevExtreme();