POC: GBDB Adapter

• Designed based on openservicebroker api
• No tests

---

Get started:

# pacakges inside are names as `gpdb-adapter`

$ git clone git@github.com:degaurab/gbb-adapter.git gpdb-adapter
$ cd gpdb-adapter
$ ./scripts/install-dependencies.sh

$ go build .

---

TODO:

• Add default space for user when we initializing user

• update API endpoints to match brokerAPI endpoints

  router.HandleFunc("/v2/service_instances/{instance_id}", handler.getInstance).Methods("GET")
  router.HandleFunc("/v2/service_instances/{instance_id}", handler.provision).Methods("PUT")
  router.HandleFunc("/v2/service_instances/{instance_id}", handler.deprovision).Methods("DELETE")
  router.HandleFunc("/v2/service_instances/{instance_id}/last_operation", handler.lastOperation).Methods("GET")
  router.HandleFunc("/v2/service_instances/{instance_id}", handler.update).Methods("PATCH")
  
  router.HandleFunc("/v2/service_instances/{instance_id}/service_bindings/{binding_id}", handler.getBinding).Methods("GET")
  router.HandleFunc("/v2/service_instances/{instance_id}/service_bindings/{binding_id}", handler.bind).Methods("PUT")
  router.HandleFunc("/v2/service_instances/{instance_id}/service_bindings/{binding_id}", handler.unbind).Methods("DELETE")
  
  router.HandleFunc("/v2/service_instances/{instance_id}/service_bindings/{binding_id}/last_operation", handler.lastBindingOperation).Methods("GET")

• Fix scope of GRANT PRIVILAGES command

postgres=# \l
                                   List of databases
    Name     |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-------------+----------+----------+-------------+-------------+-----------------------
 clientxvlbz | postgres | UTF8     | en_CA.UTF-8 | en_CA.UTF-8 | =Tc/postgres         +
             |          |          |             |             | postgres=CTc/postgres+
             |          |          |             |             | xvlbz=CTc/postgres
 gbb         | postgres | UTF8     | en_CA.UTF-8 | en_CA.UTF-8 |
 postgres    | postgres | UTF8     | en_CA.UTF-8 | en_CA.UTF-8 |
 template0   | postgres | UTF8     | en_CA.UTF-8 | en_CA.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres
 template1   | postgres | UTF8     | en_CA.UTF-8 | en_CA.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres
(5 rows)

• Make sure delete works.
• Move testing to container

---

template sql files

We can update the files in ./templates/create_*.sql, which are used to bootstrap users with:

• user and password

• default schema associated with the user

• with all the access to that schema

• ./templates/create_schema.sql

  • used to bootstrap schema associated with the user
  • Limitation:
    • you can only use schema_name and schema_username variables in create_schema.sql file, if you are updating the schema details.

• ./templates/create_user.sql

  • used to bootstrap user
  • Limitation:
    • you can only use schema_username if create_user.sql file, if you are updating the user details.

---

Build and Run

#-----------------------
$ cd github.com/degaurab/gbdp-adapter
$ go build .

## run
$ ./gpdb-adapter --config <path-to-config> --catalog <path-to-catalog>

## Add catalog and config file to `/tmp`
## Samples are in `config/samples`
## Default path:
### //CatalogPath for testing
### const CatalogPath = "/tmp/catalog.yml"
### //ConfigPath for testing
### const ConfigPath = "/tmp/service-config.yml"
# -----------------------


### different terminal

## to view catalog
$ curl -X GET http://localhost:8080/v2/catalog | jq .

## to create binding (need to be fixed)
$ curl -X PUT http://localhost:8080/v2/create_binding | jq .

{
  "result": {
    "user_name": "rUser",
    "schema_name": "rSchema",
    "password": "password"
  },
  "error": ""
}