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

Use database to store Query tempaltes #7

Open
11 tasks
hrishikeshrt opened this issue Apr 26, 2023 · 0 comments
Open
11 tasks

Use database to store Query tempaltes #7

hrishikeshrt opened this issue Apr 26, 2023 · 0 comments
Labels
enhancement New feature or request

Comments

@hrishikeshrt
Copy link
Owner

Current handling of query templates through query.json might appear quite messy and not quite in tune with relational data storage. Ideally, this should have database storage and a GUI in Admin tab for easy modification.

This might require a significant amount of changes.
Currently, the following seem necessary to implement this. (Dropping use of JSON might make it much harder. Use of JSON would require special handling on UI end)

  • Database model: Language (id, name)
  • Database model: QueryGroup (id, group_names - JSON {lang_id: group_name_text})
  • Database model: Query(id, query_group_id, cypher_template, query_texts - JSON {lang_id: query_text}, input_variables JSON {id: type}, output_order: JSON List?)
  • GUI to define languages
  • GUI to add query group names
    • Prompt to provide group names (for all languages)
  • GUI to add query details
    • Identify number of variables in Cypher query (or at least allow to manually enter to start with)
    • Prompt those many for input variables
    • Prompt to provide query text (for all languages)
    • Prompt to provide output order
@hrishikeshrt hrishikeshrt added the enhancement New feature or request label Apr 26, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant