Golang: Get Results from a MySQL Stored Procedure with Parameters

-
After much research and thought, I figured out how to call a MySQL stored procedure and get the results from it. The key is using multiStatements=true and autocommit=true in the connection string.

Make sure your stored procedure returns a result set, like:
...
    -- return one result set
    SELECT v_record_id AS id;
END;;

Connection string:
myDb, err := sql.Open("mysql", "user:password@/somedb?multiStatements=true&autocommit=true")

Golang query code:
var id sql.NullInt64
row := myDb.QueryRow(
  "CALL SaveUrl(?, ?)",
  data.URL,
  data.Title,
)

if err := row.Scan(&id); err != nil {
  return -1, fmt.Errorf("unable to save URL: %s", err)
}

More detailed Github Gist code sample.

I hope it helps someone else.

Soli Deo gloria

Comments

Post a Comment

Popular posts from this blog

Text Sherlock the OpenGrok alternative (Source Code Search Engine)

-
Image
OpenGrok has taken much to long to setup in the past, so in my dissatisfaction, I wrote Text Sherlock . Text Sherlock strives to be an easy to setup version of OpenGrok , written in Python. Think of Text Sherlock as a personal source code search engine. But, it can be run from a dedicated server. Features: It has built-in support for whoosh and xapian backends. It provides a web search interface similar to GitHub. It quickly installs. Set the configuration options in the local_settings.yml script. Then run an installation script in your install directory. Once done, everything is a simple command. Web search interface. Matched document interface. Well documented and it works as expected. Check it out and drop a comment or submit an issue via GitHub. https://github.com/cbess/text-sherlock
Read more

Python SUDS with Windows Authentication (SOAP)

-
While intergrating Plone with CRM4, I stumbled upon Suds. However, it didn't support NTLM. Then I found python-ntlm, and merged the two libs. Below is the result. You can add it at the bottom of suds/transport.py class WindowsHttpAuthenticated(HttpAuthenticated): """ Provides Windows (NTLM) http authentication. @ivar pm: The password manager. @ivar handler: The authentication handler. @author: Christopher Bess """ def __init__(self, options): # try to import ntlm support try: from ntlm import HTTPNtlmAuthHandler except ImportError: raise Exception("Cannot import python-ntlm module") return HttpTransport.__init__(self, options) self.pm = u2.HTTPPasswordMgrWithDefaultRealm() self.handler = HTTPNtlmAuthHandler.HTTPNtlmAuthHandler(self.pm) self.urlopener = u2.build_opener(self.handler) u2.install_opener(self.urlopener) ...
Read more

How to remove, update, or replace the WKWebView inputAccessoryView

-
Many others, including myself, have been trying to safely modify the WKWebView.inputAccessoryView. Now in iOS 13+, you can do it! TL;DR; The WebKit team update the code, Apple updated their dependency in iOS 13. Swift code sample: import WebKit class RichEditorWebView: WKWebView { var accessoryView: UIView? override var inputAccessoryView: UIView? { // remove/replace the default accessory view return accessoryView } } In another class somewhere: // set accessory view to replace it, if left untouched, then it will be removed let webView = RichEditorWebView() webView.accessoryView = SomeAwesomeInputAccessoryView() Because WebKit is a library that iOS uses (like SQLite), I assumed that Apple would update that dependency as well for iOS 13, since the change was resolved around June 2019. References: https://trac.webkit.org/changeset/246229/webkit#file1 https://bugs.webkit.org/show_bug.cgi?id=198631 It was too difficult to find the answer, s...
Read more