This one is for issue #26 (implement COUNT). So far not all test suites are updated, otherwise it seem to work. Please review when you have time, meanwhile I'll update missing tests in a day or two.

Here is a question on StackOverflow with answer suggesting that this is a problem with the project. Can't run Cmake on windows with MinGW and git bash

When this command runs it creates an in memory sqlite database with all tables and throws us in the sqlite3 shell (possibly with --dump, which simply stores the tables in a sqlite db disc based file). This will allow much richer query.

What I did?

• Added interactive mode
• Fixed so that it can be executed without passing it as a string argument. like gitql select hash, author, message from commits

This PR adds support to json as per https://github.com/cloudson/gitql/issues/27

I also created a flag -json // not sure if it is the best name for the flag

In this way:

• git ql "select author,hash from commits" returns the classic table as its output.
• git ql -json "select author,hash from commits" returns a json as its output.

Please check the image below:

Fixes may be first part of #59

gitql 'select message, author from commits where message like "%author%"'
+--------------------------------+----------+
|            message             |  author  |
+--------------------------------+----------+
| support for full_message,      | cloudson |
| message, author, committer     |          |
+--------------------------------+----------+

dyld: Library not loaded: libgit2.21.dylib Referenced from: /usr/local/bin/gitql Reason: image not found [1] 56160 abort gitql "select message from commits"

I'm on Mac OSX

After makeing on Mac, fails with *.dyld thus:

$ ./gitql 'select author, message, hash from commits where "travis" in message'
dyld: Library not loaded: libgit2.21.dylib
  Referenced from: ${GOPATH}/src/github.com/cloudson/gitql/./gitql
  Reason: image not found
Abort trap: 6

According to apple developer docs, you should be able to set any of LD_LIBRARY_PATH, DYLD_LIBRARY_PATH, or DYLD_FALLBACK_LIBRARY_PATH.

but for me (on Sierra 10.12.1), only the last two work.

An alternative not requiring an environment variable is to install the libraries (link them) in /usr/local/lib.

Running this post-installation script from the same directory as make, on Mac works for me. I'll leave it to you to edit the echo out.

for i in  $(PWD)/libgit2/install/lib/lib*
do
    targ="$(basename $i)"
    bn=$targ
    dn="$(dirname $i)"
    [ -L "$i" ] && targ="$(readlink $i)"
    echo "ln -s $dn/$targ /usr/local/lib/$bn"
done

Note: If you ever run make clean from the build directory, your installed commands will stop working, so it may be wiser to copy the two main *.dyld files into /usr/local/bin, and link everything else back to them. Doing that could look something like this:

for i in  $(PWD)/libgit2/install/lib/lib*
do
    [ -L "$i" ] && echo "ln -s /usr/local/lib/$(readlink $i) /usr/local/lib/${sr}" \
                    || echo "cp $i /usr/local/lib"
done

When a commit message is spread over multiple lines E.g.:

This is first line of message:
* Second
* Third

Then only the first line This is first line of message: gets output in the table.

Great idea!

I have a problem with installation, after I've done everything by instruction, and then tried

gitql

I've got the next one:

dyld: Library not loaded: libgit2.0.dylib Referenced from: /usr/local/bin/gitql Reason: image not found Trace/BPT trap: 5

Any idea how to fix that quickly?

This query works fine

gitql "select author, message, date from commits where author like 'Oliveira'"

This one, with a double quotes in the where clause raises an error

gitql "select author, message, date from commits where author like "Oliveira""

panic: interface conversion: parser.NodeExpr is *parser.NodeId, not *parser.NodeLiteral

goroutine 1 [running]:
github.com/cloudson/gitql/parser.gWC4(0xc000175b00, 0x167734b, 0x6, 0x169a8e8, 0x6)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/parser/parser.go:503 +0x6ce
github.com/cloudson/gitql/parser.gWC3(0x1b42700, 0x1, 0x1, 0xc0000ad29a, 0x6)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/parser/parser.go:429 +0x37
github.com/cloudson/gitql/parser.gWC2(0x1b42700, 0x1, 0x1b427c0, 0xc0000ad29a, 0x6)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/parser/parser.go:403 +0x37
github.com/cloudson/gitql/parser.gWhereConds(0x15, 0x0, 0x3, 0xc00013b520)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/parser/parser.go:386 +0x26
github.com/cloudson/gitql/parser.gWhere(0xc00013b520, 0x1, 0x1, 0x0)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/parser/parser.go:380 +0x6b
github.com/cloudson/gitql/parser.gSelect(0x1, 0x0, 0xc000175c98)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/parser/parser.go:119 +0x117
github.com/cloudson/gitql/parser.gProgram(0x7ffeefbffaa6, 0x44, 0xc0000bd348, 0xc000175d18)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/parser/parser.go:64 +0x1b4
github.com/cloudson/gitql/parser.AST(...)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/parser/parser.go:46
main.runQuery(0x7ffeefbffaa6, 0x44, 0x1674e2d, 0x1, 0x16764d2, 0x5, 0x1b76da0, 0xc000194200)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/main.go:158 +0x89
main.main.func2(0xc000192140, 0x7ffeefbffaa6, 0x44)
	/Users/runner/work/gitql/go/src/github.com/cloudson/gitql/main.go:101 +0x2a7
github.com/urfave/cli/v2.(*App).RunContext(0xc0000be300, 0x174a5e0, 0xc0000ac000, 0xc0000a8000, 0x2, 0x2, 0x0, 0x0)
	/Users/runner/go/pkg/mod/github.com/urfave/cli/[email protected]/app.go:315 +0x6bf
github.com/urfave/cli/v2.(*App).Run(...)

Bumps goreleaser/goreleaser-action from 3 to 4.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Bumps github.com/go-git/go-git/v5 from 5.4.2 to 5.5.1.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Bumps github.com/urfave/cli/v2 from 2.23.0 to 2.23.7.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

i tried to use count in SQL but got an error:

gitql> select author, count(author) as count from commits group by author
Error: Expected T_ID and found T_COUNT

So is count is not supported yet?

The idea of this issue is exactly what we had on https://github.com/filhodanuvem/gitql/issues/23, I'm duplicating it as an upvote with the hope that we are getting some contribution on hacktoberfest21.

What we expect is to see some numbers on how gitql behaves with big repositories such as kubernetes. Does the queries with filtering take longer to respond? Some ideas on how this could be achieved:

• Use the go testing package to create some benchmarks from the source code point of view ( against the function runtime.runQuery() )
• Any other benchmark tool (pure bash script is also accepted)
• Run the benchmark on every merge on GitHub Actions, if possible mark the job as allow_failure.

We use bats to run functional tests on GitHub Actions. But the action is failing in the setup only on Windows VMs. This might be a problem in the action version itself or it is not well configured.

C:\Windows\system32\tar.exe xz -C D:\a\_temp\443effea-912b-4f54-b64f-2707d310082a -f D:\a\_temp\c91d5722-6f45-42f2-b33d-4d132f5d8de8
bats-core-1.2.1/test/fixtures/parallel/setup_file/setup_file1.bats: Can't create '\\\\?\\D:\\a\\_temp\\443effea-912b-4f54-b64f-2707d310082a\\bats-core-1.2.1\\test\\fixtures\\parallel\\setup_file\\setup_file1.bats'
bats-core-1.2.1/test/fixtures/parallel/setup_file/setup_file2.bats: Can't create '\\\\?\\D:\\a\\_temp\\443effea-912b-4f54-b64f-2707d310082a\\bats-core-1.2.1\\test\\fixtures\\parallel\\setup_file\\setup_file2.bats'
bats-core-1.2.1/test/fixtures/parallel/setup_file/setup_file3.bats: Can't create '\\\\?\\D:\\a\\_temp\\443effea-912b-4f54-b64f-2707d310082a\\bats-core-1.2.1\\test\\fixtures\\parallel\\setup_file\\setup_file3.bats'
bats-core-1.2.1/test/fixtures/parallel/suite/parallel1.bats: Can't create '\\\\?\\D:\\a\\_temp\\443effea-912b-4f54-b64f-2707d310082a\\bats-core-1.2.1\\test\\fixtures\\parallel\\suite\\parallel1.bats'
bats-core-1.2.1/test/fixtures/parallel/suite/parallel2.bats: Can't create '\\\\?\\D:\\a\\_temp\\443effea-912b-4f54-b64f-2707d310082a\\bats-core-1.2.1\\test\\fixtures\\parallel\\suite\\parallel2.bats'
bats-core-1.2.1/test/fixtures/parallel/suite/parallel3.bats: Can't create '\\\\?\\D:\\a\\_temp\\443effea-912b-4f54-b64f-2707d310082a\\bats-core-1.2.1\\test\\fixtures\\parallel\\suite\\parallel3.bats'
bats-core-1.2.1/test/fixtures/parallel/suite/parallel4.bats: Can't create '\\\\?\\D:\\a\\_temp\\443effea-912b-4f54-b64f-2707d310082a\\bats-core-1.2.1\\test\\fixtures\\parallel\\suite\\parallel4.bats'
tar.exe: Error exit delayed from previous errors.
Error: The process 'C:\Windows\system32\tar.exe' failed with exit code 1

I've opened a PR to show how can you test that. https://github.com/filhodanuvem/gitql/pull/131 https://github.com/filhodanuvem/gitql/runs/3886290856?check_suite_focus=true