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

SimpleUnitTest - Easy iPhone and iPad Unit Test

-
Image
SimpleUnit(Test) for iPhone/iPad test driven development, fast. Notes: - Problem, you have a relatively large codebase, that isn't unit tested and you need a really fast way to get test driven development. - I love Python unit tests, because you drop in a folder (pkg), create a module and import yo junks. Bam, unit test heaven. I looked around on the net for something, similar (for about an hour) and found nothing. - This was done quick and dirty, to get test driven development fast and zero fuss - It works without any scripts, build settings changes or target touching (see example proj) - 100% safe (with cond. compilation) and incredibly easy to institute - Drop in the folder, add two lines of code (import and tests runner call), and start writing unit tests! - It also allows you to have a near native/real world environment. - I also wanted a unit test system that would let my app start to setup the database, app vars, etc. - Keep in...
Read more