Request: Launch Database View from function

[kiwanami]

Request: Launch Database View from function

[kiwanami]

OK, I'll show you code later.

Well, do you use history list?

[mattsears]

Thank you! I was hoping I can open the Database View with code so that I can automatically open the database for a given project (ie Ruby on Rails) I am working in.

So in code, I want to determine the project root, find the database connection settings, and launch the Database View given the database info found in the database setting files.

Thanks again for your help.

[kiwanami]

Here is a direct open code:

(defun edbi:open-db-viewer-with-info (uri &optional user auth)
  "Open Database viewer buffer with data source info."
  (let ((data-source (edbi:data-source uri user auth)) 
        (conn (edbi:start)))
    (edbi:connect conn data-source)
    (edbi:dbview-open conn)))

usage:

(edbi:open-db-viewer-with-info "dbi:Pg:dbname=xxxx" "username" "password")

Your idea sounds good. We usually open DB views for the project specific database.
The setting or parsing configuration file may be difficult to implement completely.
So, I think remembering the pair info between the project root directory and data source is reasonable to use generally.

[mattsears]

Great! That is exactly what I was looking for. Thanks!