Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Does franca support join query? how hard is it to implement this lib using ruby? #12

Open
ruichao-factual opened this issue Jul 27, 2016 · 1 comment
Assignees
Labels

Comments

@ruichao-factual
Copy link
Collaborator

Sometimes, we need to fetch data that are stored in multi tables, especially for relational database. Does franca-js support this kind of query?

Another question, is it hard to implement a similar lib using ruby?

@chen-factual
Copy link
Collaborator

Yes, not but directly. We specify a table field that goes into the SQL query, i.e. SELECT * FROM table. So for the table field you can actually drop a join, like if you set table: "tabA INNER JOIN tabB ON tabA.id = tabB.id", your select query will beSELECT * FROM tabA INNER JOIN tabB ON tabA.id = tabB.id`.

Another question, is it hard to implement a similar lib using ruby?

All Franca does is translating a map to a string (Postgres, Solr) or another map (Mongo), so it's should be totally doable in Ruby. When Fanchen's done with re-architecting for writes, it shouldn't be difficult to do a Ruby port if that's desired (I'm guessing for rails?)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants