A simple ORM for databases and CSV files to be used in groovy scripts

License: MIT

Language: Groovy

Keywords: csv, groovy, orm

GStorm - Groovy Single Table ORM

Gstorm is very light persistence helper for simple scenarios such as groovy scripts.


class Person { String name, project }       // this is your model class

def g = new Gstorm()
g.stormify(Person)                          // table automatically gets created for this class

def person = new Person(name: "kunal", project: "gstorm")

person.save()                               // which saves object to db

def result = Person.where("name = 'kunal'") // pass any standard SQL where clause
println result

println "all records -> ${Person.all}"      // get all objects from db

person.name = "kunal dabir"
person.save()                               // saves the object back to db

println Person.get(person.id)               // loads the object by id

person.delete()                             // delete the person from db

Running it

To see gstorm in action just execute following from command line:

groovy https://raw.github.com/kdabir/gstorm/master/examples/getting_started.groovy

Provided you have groovy installed, you don't need to install anything else.

Why Gstorm?

In groovy scripts, when you need persistence, and you often feel hibernate is overkill but handwritten SQL is headache. You don't want to connect to external Database server and still wish you could just create a table and save objects as quickly as possible. You hate writing SQL for trivial CRUD but still want to be able to harness the power of SQL when need be. You can then try Gstorm.

Gstorm take very simple approach to solve this problem by focusing just on needs of persistence mechanism required for small scripts/projects.

The market is already flooded with ORMs and NoSQL databases. It's pointless to introduce anything that's heavy, complex, rigid and tries to solve all the problems in the world.

What good a Single Table ORM would do?

  • Creates Tables for you
  • Allows you to persist objects without worrying about CRUD SQL statements
  • Very light layer, no jar baggage
  • Can still fire complex SQL queries that would have been difficult in NoSQL or plain collection backed DBs
  • Typically this would be useful in scripts, Not in multi-layered web applications or any complex use cases
  • Doesn't handle any relationships or complex data types

Gstorm uses HSQLDB syntax internally.

Getting started

Grab GStorm using

@GrabResolver(name='gstorm', root='http://dl.bintray.com/kdabir/maven')
@GrabConfig(systemClassLoader = true) @Grab('gstorm:gstorm:0.6')

Create instance of Gstorm

def g = new Gstorm()

You may pass optionally pass object of java.sql.Connection or groovy.sql.Sql

def g = new Gstorm(sql)

where sql is an instance of groovy.sql.Sql

And gstormify your model


Just go through the example's source and test and have fun.

Project status

Build Status

Gstorm is tiny project with very specific use case. There is long list of items that I would want to complete before calling it feature complete. The project is under active development and is not yet suitable for production grade applications.

Changelog :


  • support @WithoutId annotation to map to tables that do not have any id field and hence classes will not have id specific methods
  • first cut of support for @Csv annotation to open CSV files as table. File can be set using setCsvFile() method of Gstorm.
  • capability to provide custom type mappings as well changing the default type mapping if no type mapping is found
  • ability to chain stormify and return the Gstorm instance


  • support count() method and count property on Model class. count(clause) can take a where like condition
  • support Gstorm(Connection) which can take java.sql.Connection object
  • support Gstorm() constructor which create in memory db (HSQLDB) automatically
  • support Gstorm(dbpath) constructor which creates HSQLDB with the specified file path
  • add hsqldb as compile/runtime dependency to project, so it will be used by default. User can always exclude it if it's not required.


  • support @Id annotation. limitation: The id has to be a numeric (Integer) field in class
  • heavy refactoring internally, keeping the api intact


  • support primitive numbers (int/long). Floating point numbers are stored as string as of yet.
  • Support table name to be different from the class name. Class can be annotated with @Table("TABLE_NAME") to specify table name.
  • support date/time to be stored.
  • internal refactoring


  • enableQueryLogging to enable sql query logging
  • get() to load a model by id


  • autogenerated id property on model
  • ability to update() or save() when model has id
  • using gradle to publish to maven repo
  • travis ci
  • added all method/property


  • initial prototype
  • save() and where() methods added

Project Statistics

Sourcerank 6
Repository Size 255 KB
Stars 66
Forks 8
Watchers 12
Open issues 14
Dependencies 0
Contributors 1
Tags 9
Last updated
Last pushed

Top Contributors See all

Kunal Dabir

Recent Tags See all

v0.7.1 March 27, 2016
0.7.1 March 27, 2016
v0.7 May 28, 2014
v0.4 May 28, 2014
v0.6 March 03, 2014
v0.5 February 19, 2014
v0.3 April 25, 2013
v0.2 April 23, 2013
v0.1 April 21, 2013

Something wrong with this page? Make a suggestion

Last synced: 2017-11-24 19:03:31 UTC

Login to resync this repository