mhayashi1120/emacs-esqlite

sqlite file manipulate utilities

emacs-esqlite's Issues

(wrong-type-argument sequencep :null) sample "Async Read API"

I execute the following code with referring sample "Async Read API"

(esqlite-async-read english_phrase_db "SELECT * FROM headings" (lambda (data) (message "%s" (mapconcat 'identity data ", "))))

I got the following error.
esqlite issue?
or my sqlite3 database table null data is not good?

Debugger entered--Lisp error: (wrong-type-argument sequencep :null) mapconcat(identity ("1" "うれしい・楽しい" "0" "スタンダード表現" "0" "わーい!" "Wow!" "Wow! は、喜び、驚き(「わーぁ!」)、賞賛(「すごい」)などを表す。" "Whoopee!" :null :null :null :null "0" "Let's eat out tonight." "今夜は食事にでかけようよ" "Wow! I want to have sushi." "わーい! 私、お寿司がたべたいな") ", ") (message "%s" (mapconcat (quote identity) data ", ")) (lambda (data) (message "%s" (mapconcat (quote identity) data ", ")))(("1" "うれしい・楽しい" "0" "スタンダード表現" "0" "わーい!" "Wow!" "Wow! は、喜び、驚き(「わーぁ!」)、賞賛(「すごい」)などを表す。" "Whoopee!" :null :null :null :null "0" "Let's eat out tonight." "今夜は食事にでかけようよ" "Wow! I want to have sushi." "わーい! 私、お寿司がたべたいな")) ... esqlite-async-read--filter(#<process Esqlite> accept-process-output(#<process Esqlite> 0.20775294303894043) esqlite-sleep(#<process Esqlite>) esqlite-async-read--maybe-error(#<process Esqlite>) esqlite-async-read("~/bin/sqlite3_sample/english_phrase.db" "SELECT * FROM headings" (lambda (data) (message "%s" (mapconcat (quote identity) data ", ")))) eval((esqlite-async-read english_phrase_db "SELECT * FROM headings" (function (lambda (data) (message "%s" (mapconcat (quote identity) data ", "))))) nil) elisp--eval-last-sexp(nil) eval-last-sexp(nil) funcall-interactively(eval-last-sexp nil) call-interactively(eval-last-sexp nil nil) command-execute(eval-last-sexp)

Calling esqlite with a customised sqliterc file

I wanted to use sqlite with the pcre library loaded so that I could use regular expressions in WHERE clauses. I ended up doing this by creating my own sqliterc file with a .load pcre line. I got calls to esqlite-helm-call-command to pick this up by wrapping them with (let ((esqlite--default-init-file .... Is there a better way of doing this?

Could you correct the typo , sample code "Async Read API"

https://github.com/mhayashi1120/Emacs-esqlite#async-read-api
Sample code:
... (message "%s" (mapcocnat ...

cocnat is typo.
concat is correct.

Failure under mac

Some users of http://www.github.com/areina/helm-dash have found issues with it on mac.

We traced the issue until esqlite (or even pcsv), but I'm not sure how to fix it.

Could you take a look into it? The tests fail there, so at least we have a reproducible failure

EDIT:
Sorry, I wrote the message in a hurry. Here are the couple of issues.
dash-docs-el/helm-dash#24
dash-docs-el/helm-dash#25

I could try for a few minutes a mac, and saw that the queries were not processed correctly, and I just got the query back with a '^M' at the end of every line. That sounds like a encoding error of the end-of-lines. we tried to track it but failed to find the issue.