Skip to content

Instantly share code, notes, and snippets.

@LCHCAPITALHUMAIN
Forked from musketyr/GSQLExamples.groovy
Last active August 29, 2015 14:20
Show Gist options
  • Save LCHCAPITALHUMAIN/25777101db0358ef0330 to your computer and use it in GitHub Desktop.
Save LCHCAPITALHUMAIN/25777101db0358ef0330 to your computer and use it in GitHub Desktop.
import static eu.appsatori.gdata.gsql.SSQL.*
// Groovy 1.7 syntax
select(all).from("Spreadsheet").sheet("Worksheet").limit(10).offset(5)
select(1, "test", 5, "it").from("Spreadsheet")
select(all).from("Spreadsheet").order(by).column("Column Name").sort(desc)
// fancy new 1.8 syntax
select all from "Spreadsheet" sheet "Worksheet" limit 10 offset 5
select 1, "test", 5, "it" from "Spreadsheet"
select all from "Spreadsheet" order by column "Column Name" sort desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment