Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Does your library have a lower level API for reading results into lisp lists? #125

Open
vonHabsi opened this issue Feb 14, 2020 · 2 comments

Comments

@vonHabsi
Copy link

emacs-sqlite3-api has the sqlite3-column-* functions for retrieving the results of a row.

Does your package have functions which can be used in this manner?

@kostafey
Copy link
Owner

kostafey commented Feb 14, 2020

@vonHabsi Not really. It was in the early versions. It's not actually a library, it aims to be an application. The actual behavior is:

  1. The user asks JVM backend to evaluate an SQL query via Http by running Elisp function.
  2. JVM backend starts an independent process for query evaluation.
    -- Here the user can pass a request to terminate the evaluation process. --
  3. When evaluation finishes, it prints the results to the file.
  4. The JVM process asks Emacs via Http to show this result from the file in the results buffer.

So, there is no actual "result" for the query evaluation request. But it's very easy to implement. E.g. we can add an Elisp wrapper to function like this:
https://github.com/kostafey/ejc-sql/blob/master/src/ejc_sql/structure.clj#L44

Do you interested in such an API?

@vonHabsi
Copy link
Author

Do you interested in such an API?

Yes I am. I am looking for general API for SQL programming and emacs/elisp doesn't seem to have one.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants