Batch Importer (Bib/Acq) (UXPROD-47)

[MODSOURCE-130] Create standard tables using LiquiBase Created: 26/Dec/19  Updated: 10/Jun/20  Resolved: 04/May/20

Status: Closed
Project: mod-source-record-storage
Components: None
Affects versions: None
Fix versions: 3.2.0
Parent: Batch Importer (Bib/Acq)

Type: Task Priority: P2
Reporter: Oleksii Kuzminov Assignee: William Welling
Resolution: Done Votes: 0
Labels: data-import, epam-folijet, performance
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Defines
defines MODSOURCE-97 Improve performance and refactoring o... Closed
defines UXPROD-2363 SRS Performance Improvements Closed
Sprint: EPAM BatchLoader Sprint 40
Story Points: 3
Development Team: Folijet
Epic Link: Batch Importer (Bib/Acq)

 Description   

Steps

  • Use LB and write a migration script to create all regular tables according to design
  • Use design described in umbrella
  • Don't change services and endpoints and dao


 Comments   
Comment by Oleksii Kuzminov [ 29/Apr/20 ]

William Welling I think we missed metadata fields in tables
Can you plz add metadata?

Comment by William Welling [ 29/Apr/20 ]

Oleksii Kuzminov I can add fields. What is the desired table, types, and constraints for the metadata fields?

Comment by Oleksii Kuzminov [ 29/Apr/20 ]

William Welling https://github.com/folio-org/raml/blob/9d7fe883b4e08a262ee3cffc69c33f8b7b63710b/schemas/metadata.schema
I hope this schema will be helpful
We can create a separate table for metadata and fk from snapshot and record tables on it

Comment by William Welling [ 29/Apr/20 ]

Oleksii Kuzminov Are these the same as fields on new records_lb table? https://github.com/folio-org/mod-source-record-storage/blob/master/mod-source-record-storage-server/src/main/resources/liquibase/tenant/scripts/v-0.0.1/2020-04-27--13-00-create-records-table.xml#L52

As described in the ER diagram

Comment by Oleksii Kuzminov [ 29/Apr/20 ]

William Welling yes, sorry, I did not notice
So it's ok for me

Comment by Kateryna Senchenko [ 04/May/20 ]

Hi William Welling, can we close this ticket?

Comment by Kateryna Senchenko [ 04/May/20 ]

William Welling, closing this ticket. In case there're any issues, a separate ticket will be raised. Thanks

Generated at Thu Feb 08 22:13:16 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.