Clojurians Log v2
sql
Hello everyone. I'm having a challenge of migrate a MySQL table for a neo4j database. I looking for some libraries and other stuff, but i would like to know if someone has any background on neo4j and clojure
Getting there.. so far setup a protocal for graph-like data structures, which for now is only implemented for in-memory. Ideally if it suppoted MySQL and neo4j it could be used to do migrations. But it's no where there yet, and also don't have time for it in the near future.
Folks, i'm using next library for get data from mysql.
i do not got it right on how put the result-set for get as-unqualified-lower-maps
I read the documentation but i do not got it how could i do my select getting the keys.
Found the problem
i was not putting {:builder-fn rs/as-unqualified-lower-maps} on the map, after reading a lot of the docs
I would strongly encourage you to work with qualified keys in hash maps by default, unless you have a critical reason not to. That's why qualified hash maps are the default.
On my case, i'll only do a select in one table for do a ETL. And with unqualified keys the data was ready to be added into the new db, wich is neo4j. But thank you anyway for your recommendation.
In general, when you work with qualified keys and pass them into any persistence library, it will strip the namespace portion off anyway (because it just calls name on the keywords) so it's safe to work with them -- and it's easier to work with Spec (and a little more descriptive overall).
@ramon.rios The Getting Started guide for next.jdbc has examples of the :builder-fn: https://cljdoc.org/d/seancorfield/next.jdbc/1.0.13/doc/getting-started#options--result-set-builders -- which I would expect everyone to read when they are... getting started... with next.jdbc 🙂
Definitely. I need to remember sometimes to read something in my second language not so fast 😅