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

change database table structure to support left() and instr() #9

Open
kazurof opened this issue Nov 20, 2014 · 2 comments
Open

change database table structure to support left() and instr() #9

kazurof opened this issue Nov 20, 2014 · 2 comments
Assignees

Comments

@kazurof
Copy link
Contributor

kazurof commented Nov 20, 2014

in here.
https://github.com/MassBank/SpectrumSearch/blob/master/src/main/java/jp/massbank/spectrumsearch/db/DbAccessor.java#L78

original SQL used left() and instr(). but those function is available at MySQL , not JavaDB.
So table structure should be altered. devide name column with devide value by ';'.

@sneumann
Copy link
Member

Could this be split into multiple fields?
Or a separate table where each substring
Goes into a row. Just thinking loud here.

@kazurof
Copy link
Contributor Author

kazurof commented Nov 20, 2014

My plan is to split NAME column into multiple fields. I guess this NAME column came from "2.1.2 RECORD_TITLE " which is written in http://www.massbank.jp/manuals/MassBankRecord_en.pdf.
I guess the intention of previous code is to pick up CH$NAME only.

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

3 participants