flmnh-mgcl / spesql Goto Github PK

• Create user
• Update user
• Delete user
• Create table
• Update table (name)
• Delete table

look into and solve, not parsing the field/value pairs properly

This would allow for more complex queries to be constructed, such as selecting from a relation rather than a table or updating tuples returned from a select query, more control over conditional groups, etc

Currently when a session expires there is no reconnect / re-authentication flow. When a user makes a request with an invalid session, they should be prompted to reenter credentials.

• Insert Bulk
• Single Insert
• Single Update
• Bulk Update
• Select
• Count
• Create Table
• Create User
• Delete Specimen
• Delete Table
• Delete User

not applicable for advanced query building/input

add an option to download failed rows on insertions

Pending issue #10 create the form for making select queries

Some odd/incorrect country names, such as Viet Nam over Vietnam. This causes issues in uploading

I believe this is related to the CSV parser being used

Look into allowing users to create their own accounts that only get validated/activated after an admin reviews and approves the account. Not sure if this is something they want, but it might be a better workflow

try catch block is not working, example of breaking bug:

1000ft -> invalid unit error, could not locate unit. The js-quantity library expects 1000 ft. I believe the try catch is not working because the validate field of the register (react hook form) is causing some sync issues? I have to look into it.

Allow user to update/create their MySQL connection config

when not toggled, all inserts fail if any invalid rows
when toggled, failures get skipped

On error, on large insert complete, etc

Should find one generalized 'bad' sound and one 'neutral' or 'positive' sound

• create user
• edit user
• delete user
• create table
• edit table
• delete table

https://www.npmjs.com/package/node-xlsx

or

https://stackoverflow.com/questions/46909260/reading-excel-file-in-reactjs

Currently, a user would have to scroll through the select options to find the target. Ideally, they should also be able to type search parameters to filter to list of options in the dropdown

This bug is only for SINGLE updates.

Example:

update specimen without an identificationQualifier to have a value
attempt another update to remove it
error occurs

utilize tailwinds new features to create a dark mode theme

option to query database before insertion to check for duplicate lep numbers

This is a library issue, I am waiting on the new release of the file upload library I am using and then I will close this issue

I will edit this comment as I finish the logs for each function

• Insert Bulk
• Single Insert
• Single Update
• Bulk Update
• Select
• Count
• Delete

currently bulk insert calls single insert in a loop, however this is not an ideal solution. look into actual batch query solutions

I will use react-hook-form

main features:

• detect and use child form element validation functions
• give each form element ability to take in own validation function

The specimen selection (row selection) breaks if I were to narrow my select query to something like:

SELECT field1,field2 FROM databaseTable;

This would include:

• header
• dropdown menus
• modal
• query forms
• main table from query data
• etc

Once the converted app LOOKS like the original, I will start parsing out the more specific, demanding conversions as their own issues to properly track progress made on each

My select component will default to the first option in the list if none are selected. This is not my desired functionality.

• single update
• batch update
• delete

There are some conflicts regarding how some of the data should be formatted. As such, temporarily these validators will be short circuited to return true for all values until the conflicts are resolved among the researchers.

I've tried almost all documented methods for supplying an icon without success. There are a couple of issues on electron repository about this, so I'll likely wait for an update to see if it is fixed

I have discovered each chart type in react google charts potentially has an entirely different options typing. For example, Sankey charts are not configurable with titles, legends, and have a different color definition scheme. I will need to therefore create these separate types and toggle between them when toggling between chart types.

current config implementation needs rework

On very large logs, the new implementation for error logs stutters significantly on both initial load and indexing search. I think virtualization might be able to be used? However, syntax highlighting should be maintained to increase readability.

• Insert Bulk
• Single Insert
• Bulk Update
• Select
• Count
• Admin Ops

Create a separate project for the UI implemented here, so it may be used in other museum projects