tree: 38fcc5290efc0102990e75086e7701bd7dd04a3a [path history] [tgz]
  1. db.go
  2. db_eval.go
  3. db_query.go
  4. db_test.go
  5. funcs.go
  6. inmem.go
  7. integration_test.go
  8. README.md
spanner/spannertest/README.md

This directory contains spannertest, an in-memory fake Cloud Spanner. A sibling directory, spansql, contains types and parser for the Cloud Spanner SQL dialect.

spansql is reusable for anything that interacts with Cloud Spanner on a syntactic basis, such as tools for handling Spanner schema (DDL).

spannertest builds on spansql for testing code that uses Cloud Spanner client libraries.

Neither of these packages aims to be performant nor exact replicas of the production Cloud Spanner. They are reasonable for building tools, or writing unit or integration tests. Full-scale performance testing or serious workloads should use the production Cloud Spanner instead.

Here's a list of features that are missing or incomplete. It is roughly ordered by ascending esotericism:

  • expression functions
  • more aggregation functions
  • INSERT/UPDATE DML statements
  • case insensitivity
  • alternate literal types (esp. strings)
  • STRUCT types
  • SELECT HAVING
  • joins
  • transaction simulation
  • expression type casting, coercion
  • SELECT aliases in FROM clause, ORDER BY
  • subselects
  • set operations (UNION, INTERSECT, EXCEPT)
  • partition support
  • conditional expressions
  • table sampling (implementation)
  • hints for table/joins