go-sqlite | SQLite Library for Go | Database library

After investigating my fixture I quickly realized that I had accidentally made a dumpfile of my new psql db...

The reason this happened was because I got a primary key duplication error when trying to load the data the first time. This meant I had to use the dumpdata method again with the --natural-foreign and --natural-primary options. I just forgot to change my default database settings back to the initial sqlite db so instead I got a fixture of my new psql db... not my proudest moment...

Problem reproduced, and resolved by replacing -ldflags="-extld=$CC" with -ldflags="-extld=aarch64-linux-gnu-gcc".

Alternatively, you can also export the CC variable beforehand.

The error output was caused by mismatching linker (with your original build command, it was still the x86-64 linker that got invoked).

Tested on two hosts of mine: one Ubuntu 20.04 + go1.13, the other Ubuntu 18.04 + go1.16.

More explanations:

Seems that the in-line CC env variable setting is passed to the go tool, but not used in the shell's parameter substitution. The following output (Bash 5.0) demonstrates this:

This isn't tested within Docker, but should work. It can likely be optimized further, though, or modified to work in more limited build environments

What is happening is almost certainly that you did not call Close() (or otherwise consumed the rows) on the result returned by DB.Query(...).

Try:

maybe need to add this before download command:

It looks like you forgot to call statement, _ = database.Prepare("delete from people where id = 1") for the delete command. When you are calling statement.Exec("delete from people where id = 1") the statement that was previously prepared is still in effect, and it expects two arguments (firstname, lastname).

You should check for errors when doing statement.Exec() as well as that would've pointed you to the actual error.

The problem lies where you do CURRRENT_TIMESTAMP instead of CURRENT_TIMESTAMP (note number of Rs in CURRENT) and not using the DEFAULT keyword for ReviewID.

The syntax for creating a table is documented here: https://www.sqlite.org/lang_createtable.html

Remember that in order for reflect.Interface() to work, you must export the fields. To achieve what you want using reflection, you could try something like this:

The first problem is a typo in the connection string: postgresql://user:user@172.20.0.1:5432/lcp?sslmode=disable. In Go code it should be postgres://user:user@172.20.0.1:5432/lcp?sslmode=disable.

We also need to pass the full connection string as the second argument to sql.Open. For now, the dbFromURI function returns user:user@172.20.0.1:5432/lcp?sslmode=disable, but we need postgres://user:user@172.20.0.1:5432/lcp?sslmode=disable, because pq is waiting for this prefix to parse it.

After fixing this, I was able to establish a connection using a minimal postgres client based on your code.

To try this yourself, start the server with the following command: