Skip to content

A sample Metabase driver that connects to a database

Notifications You must be signed in to change notification settings

metabase/sample-driver

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Note: build instructions for this are out of date, please refer to the build instructions for our sample Sudoku Driver instead.

Metabase Sample Driver

This is an example of a 3rd party driver, similar to the sudoku-driver, with the following differences:

  • it connects to a real (Postgres) database and executes queries there
  • it has the test extensions defines, so that the full Metabase core test suite can run against it

Note: although this is a functionally identical clone of the Postgres driver we ship with the product, it should not be used in production. It will not be maintained regularly or supported for production usage.

Usage

Build the same way as the suduko-driver

clojure -X:dev:build

Testing

Set Up

Running the Metabase test suite using your driver requires a bit of one-time setup. You will need to create (or edit, if you have an existing one), your personal deps.edn file at ~/.clojure/deps.edn, to add a new alias for your custom driver. Note that if you have this :aliases map already, you will just need to create a new entry here.

{:aliases {
  :user/sample-driver {:extra-paths ["/path/to/sample-driver/test"]
                       :extra-deps {metabase/sample-driver {:local/root "/path/to/sample-driver"}}}
}}

Interactive Testing

To run Metabase tests, go to your Metabase core repository, then run the following:

MB_SAMPLE_DRIVER_TEST_PLUGIN_MANIFEST_PATH=/path/to/sample-driver/resources/metabase-plugin.yaml clojure -M:dev:ee:ee-dev:drivers:drivers-dev:user:trace:deps-alpha:user/sample-driver:nrepl >/tmp/metabase/repl.out 2>&1

If you want to use remote Java debugging to diagnose test issues, you can add the following options right after clojure above. These will enble the remote debugger (on port 15319, although you can change it), and also disable local variable clearing, so you can more easily walk up the call stack when suspended at a breakpoint.

-J-Dclojure.compiler.disable-locals-clearing=true -J-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=15319

Once the nREPL starts up, you can run the following:

;; load the interactive testing namespace
(require '[dev.driver.testing.interactive :as interactive])

;; test your driver interactively
(interactive/interactively-test-driver :sample-driver)

At this point, you should see a series of prompts on the screen to enter all the driver's connection properties. Enter a value for each one, hitting enter after each value. At the end, you will see some output like the following:

Storing to store db-details to `user/details`.
Run `(user/test-connect!) to test a connection using these details`.
Use `(user/run-tests!)` to execute tests against the connection details you entered.  Pass an optional argument to only run certain tests.  Ex:
  `(run-tests! 'metabase.query-processor-test.string-extracts-test)`

Now, you can simply run details to see the map of connection details you just entered (which corresponds to the values you would type in the UI Admin section for this database).

To test that a connection can be successfully established, just run (test-connect!) and you should see Successfully connected (or an error message if it fails). You can also run a small test suite using:

(run-tests! 'metabase.query-processor-test.string-extracts-test)

To run the full test suite, simply leave out the argument, but note this is involved and will take a while. In either case, a report will be printed at the end.

About

A sample Metabase driver that connects to a database

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published