Example 1 fails (OS X)

[bmayer0122]

$ ls -ltr * | q "select c1,count(1) from - group by c1"
Traceback (most recent call last):
File "/usr/local/bin/q", line 485, in
table_creator.populate()
File "/usr/local/bin/q", line 379, in populate
self._flush_inserts()
File "/usr/local/bin/q", line 415, in _flush_inserts
self.db.execute_and_fetch(insert_row_stmt)
File "/usr/local/bin/q", line 111, in execute_and_fetch
self.cursor.execute(q)
sqlite3.OperationalError: near ")": syntax error

[harelba]

Thanks for pointing it out! It's a bug in the ls flags i've provided. fixing now.

[harelba]

Fixed. The ls command should include the -d flag:
$ ls -ltrd * | q "select c1,count(1) from - group by c1"

Not using the -d flag causes the ls output to descend to directories and be non-tabular in nature. Besides, I need to make error display better (already have a ticket on this).

I've just pushed the fix, but if you're using homebrew in order to download it, then you'll still be getting the old version. I'll bump the version numbers in the homebrew formula.

[harelba]

homebrew formula updated to version 1.1, which includes this fix - Will update when homebrew will integrate the pull request.

[harelba]

Pull request for homebrew formula has been merged. q v1.1 will now be installed when using homebrew, fixing the issue.

@bmayer0122 Thanks for noting this.