Skip to content

Add CRUD API calls for ISL Verse markers #476

Description

@RevantCI

Add CRUD API calls for ISL Verse markers
use same table struture as ISL Admin to avoid reengineering the API calls

  1. IslVerseMarkers(Base):
    id = Column(Integer, primary_key=True, index=True)
    isl_video_id = Column(Integer, ForeignKey("isl_bible.id", ondelete="CASCADE"),
    nullable=False, unique=True)
    verse_markers_json = Column(JSONB, nullable=False)

  2. Check valid verse for book and chapter and allow merged verse eg 12_13
    Allow chapter and verse 0 for intro if verse markers added later
    see this file for time stamp format - https://github.com/Bridgeconn/isl-manzil-web/blob/main/web-app/src/assets/data/verse_markers/1%20Corinthians_5.csv

  3. Ensure time stamp are in correct order increasing with each verse

  4. Make Crud Calls as in ISL admin except POST call
    POST call
    {
    1: [ // isl_video_id ref isl_table id col
    { //verse_markers_json
    "verse": 0,
    "time": "00:00:00:00"
    }
    ]
    }

QA

  • Testcases (ATT : 30 mins)
  • Testing(ATT : 1 hr)
  • Testing Review(ATT : 15 mins)

Metadata

Metadata

Assignees

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions