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

Client needs a method to collect all inductions #2

Open
thmosqueiro opened this issue Jan 24, 2017 · 0 comments
Open

Client needs a method to collect all inductions #2

thmosqueiro opened this issue Jan 24, 2017 · 0 comments
Assignees

Comments

@thmosqueiro
Copy link
Member

Client already implemented a way to get data back from the server, but we need to get a list of inductions. We need in faroreDB a method that retrieves all rows in MEASUREMENT for a list of inductions. It is important to pay attention to how the query is written thou, to make sure the indices are used.

I believe somehting on these lines should work:

select * from MEASUREMENT where ind_id in (1,2,3) and enose = 1

However, because no timestamp is given, I wonder if the main index won't be just ignored. Because ind_id has an index already, without enose we should be fine. This is, in a way, assuming that inductions may be linked to more than one enose. However, we may drop this if that is the problem.

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

No branches or pull requests

2 participants