saulotarsobc/jw-sing-language-merge

Merge two JW Sign Language backup files

JW Sign Language merge bkp files

Help

• jwlibrary-plus - @GeiserX(Sergio Fernández)

Python

Use in python

git clone https://github.com/saulotarsobc/jw-sing-language-merge.git
cd jw-sing-language-merge/py
python3 -m venv .venv

source .venv/Scripts/activate # windows
# .venv
pip install -r requirements.txt # to pip update -> 'python.exe -m pip install --upgrade pip'
# .venv
python src/main.py;

Tables

• ✅ Location
• ✅ Tag
• ✅ TagMap
• ✅ Note
• ✅ Bookmark
• ✅ UserMark
• ✅ BlockRange
• ✅ InputField
• 🟥 LastModified
• ✅ IndependentMedia
• ✅ PlaylistItem
• ✅ PlaylistItemAccuracy
• ✅ PlaylistItemIndependentMediaMap
• ✅ PlaylistItemLocationMap
• ✅ PlaylistItemMarker
• ✅ PlaylistItemMarkerParagraphMap
• ✅ PlaylistItemMarkerBibleVerseMap

jw-sing-language-merge's Issues

get the LastModification from the database and insert it into manifest.json

Bug

>> Copiando dados da base-1 para a nova base
>> Copiando dados da base-2 para a nova base
Traceback (most recent call last):
  File "C:\Users\saulo\OneDrive\Documentos\Github\libras\jw-sing-language-merge\py\src\main.py", line 843, in <module>
    getDataFromDb2()
  File "C:\Users\saulo\OneDrive\Documentos\Github\libras\jw-sing-language-merge\py\src\main.py", line 746, in getDataFromDb2
    cur3.execute("INSERT INTO PlaylistItem VALUES(?,?,?,?,?,?,?)", (nextId, r[1], r[2], r[3], r[4], r[5], r[6]))
sqlite3

Possibility to pass the path of .jwlibrary files via 'arg'

import sys

# Obter argumentos da linha de comando
argumentos = sys.argv

# O primeiro argumento (argumentos[0]) é o nome do script
# Os argumentos subsequentes são os parâmetros fornecidos
print("Argumentos:", argumentos)

# Acessar argumentos individuais
if len(argumentos) > 1:
    parametro1 = argumentos[1]
    parametro2 = argumentos[2]
    print("Parâmetro 1:", parametro1)
    print("Parâmetro 2:", parametro2)
else:
    print("Nenhum parâmetro fornecido.")

Improve the manifest.json generator

Web system for speakers to create their playlist

LS - Events

This will help a lot when you have big events like lots of speakers

UNIQUE constraint failed: Location.KeySymbol, Location.IssueTagNumber, Location.MepsLanguage, Location.DocumentId, Location.Track, Location.Type

Traceback (most recent call last):
  File "C:\Users\saulo\OneDrive\Documentos\Github\libras\jw-sing-language-merge\py\src\main.py", line 932, in <module>
    getDataFromDb2()
  File "C:\Users\saulo\OneDrive\Documentos\Github\libras\jw-sing-language-merge\py\src\main.py", line 771, in getDataFromDb2
    cur3.execute("INSERT INTO Location VALUES(?,?,?,?,?,?,?,?,?,?)", (nextId, r[1], r[2], r[3], r[4], r[5], r[6], r[7], r[8], r[9]))
sqlite3.IntegrityError: UNIQUE constraint failed: Location.KeySymbol, Location.IssueTagNumber, Location.MepsLanguage, Location.DocumentId, Location.Track, Location.Type 

The error sqlite3.IntegrityError: UNIQUE constraint failed: Location.KeySymbol, Location.IssueTagNumber, Location.MepsLanguage, Location.DocumentId, Location.Track, Location.Type indicates that there has been a violation of the unique key constraint on the Location table. This means that an insertion is being attempted that violates the uniqueness condition defined for the mentioned columns.

Add the possibility to customize the default thumbnail

from PIL import Image

# Dimensões da nova imagem
largura = 200
altura = 100

# Cor de preenchimento da imagem (no formato RGB)
cor = (255, 0, 0)  # Vermelho

# Criar uma nova imagem com a cor especificada
nova_imagem = Image.new('RGB', (largura, altura), cor)

# Salvar a nova imagem como um arquivo PNG
nova_imagem.save('nova_imagem.png')

Aplicação básica com python para rodar no terminal

Application with electron to merge JW Sign Language backups

Bug in Location table

>> Copiando dados da base-1 para a nova base
>> Copiando dados da base-2 para a nova base
Traceback (most recent call last):
  File "C:\Users\saulo\OneDrive\Documentos\Github\libras\jw-sing-language-merge\py\src\main.py", line 849, in <module>
    getDataFromDb2()
  File "C:\Users\saulo\OneDrive\Documentos\Github\libras\jw-sing-language-merge\py\src\main.py", line 695, in getDataFromDb2
    cur3.execute("INSERT INTO Location VALUES(?,?,?,?,?,?,?,?,?,?)", (nextId, r[1], r[2], r[3], r[4], r[5], r[6], r[7], r[8], r[9]))
sqlite3.IntegrityError: UNIQUE constraint failed: Location.BookNumber, Location.ChapterNumber, Location.KeySymbol, Location.MepsLanguage, Location.Type

Create relationships between tables

Confusing references from the songs with the Bible