osamutakahashi / bolt

The wrapper library for executing INSERT/UPDATE/DELETE sql query on Google Cloud Spanner.

GitHub

Bolt

The wrapper library for executing INSERT/UPDATE/DELETE sql query on Google Cloud Spanner.

INSERT/UPDATE/DELETE Syntax

INSERT

INSERT

UPDATE

UPDATE

DELETE

DELETE

How to use

In Scala,

Write library dependency to .sbt file

libraryDependencies += "com.sopranoworks" %% "bolt" % "0.14"

And then,

import Bolt._

dbClinet.executeQuery("INSERT INTO test_tbl01 VALUES(103,'test insert');")

It uses implicit conversion.

You can use it as explicitly like this.

Nut(dbClient).executeQuery("INSERT INTO test_tbl01 VALUES(103,'test insert');")

A transaction query can be used as this.

dbClient.beginTransaction {
  tr =>
    tr.executeQuery("INSERT INTO test_tbl01 VALUES(103,'test insert');")
}

Other functions

ResultSet can be used as Iterator.

dbClient.executeQuery("SELECT * FROM test_tbl01").map {
  resultSet =>
    (resultSet.getString("id"),resultSet.getString("name"))
}

And also

dbClient.executeQuery("SELECT * FROM test_tbl01").headOption

You can use ResultSet safely like this.

dbClient.executeQuery("SELECT * FROM test_tbl01").autoclose(
  resultSet =>
      ...
)

More examples

See NutTest.scala

In Java,

import com.sopranoworks.bolt.Bolt;

Bolt.Nut nut = Bolt.Nut(client);
nut.executeQuery("INSERT INTO TEST_TABLE (ID,NAME) VALUES(101,'test');");

spanner-cli

This project also contains console spanner client application, spanne-cli.

dist/spanner-cli-0.15-SNAPSHOT.zip

MD5:c1005e19f6456d6af1c659295b86ac0b

spanner-dump

This is a bonus program. It will dump a spanner database to sql text code.

dist/spanner-dump-0.15-SNAPSHOT.zip

MD5:7a6f628d6f4ddf34ac51f5c6f9534662

Notice

A Nut instance is not thread safe. You must create a instance per thread.

Limitations

  • Bytes type is currently not supported in an INSERT/UPDATE query.
  • Only few functions are usable in an INSERT/UPDATE query.
  • CASE Conditional expression is currently not supported in an INSERT/UPDATE query.
  • UNNEST operation is currently not supported in an INSERT/UPDATE query.

There is no such a limitation in SELECT and subquery.

  • Referencing outside (INSERT/UPDATE statement's) alias in subquery is not supported in an INSERT/UPDATE query.
  • Some lterals are currently not supported.

Licence

MIT