mega-pack-pbf-parser 0.1.4

Collects song information from BB Projects

# mega-pack-pbf-parser

Parse the content (songs and PBFs) of a BB project w/Mega Pack and add that data to the project database. 

- To write the required html file install this package: bb-pbf-html-writer

- pip install bb-pbf-html-writer





## Warnings

- Verify that the "packs_pbf_type" table is up-to-date. Be certain that ALL products are included in this table (i.e. check for new product releases)

- BEFORE ANYTHING ELSE, verify that you have updated the constant PROJECT_DB_PATH (full path to the project db) in constants.py



## Constants

The project uses several constants defined in tools.constants

- PROJECT_DB_PATH  - path to the project's database

- BONUS_PBF_FILES - PBFs we don't want to include because they are essentialy duplicates

- OPP_PBF_FILES - PBFs with one press play songs



## Database Tables

- packs_pbf_type: contains a listing of all PBF names, the associated productand the type (OPP, sections)

- songs: lists all songs, the associated PBF and product name and the type (OPP, sections)



## Usage



```python

from typing import List

from mega_pack_pbf_parser import Project_Parser

from mega_pack_pbf_parser import PROJECT_DB_PATH

from mega_pack_pbf_parser import create_db, insert

from mega_pack_pbf_parser import insert_songs_query





def build_db():

    """

    Demonstrates how to build the project database.

    WARNING: the script DROPS all existing tables and builds new versions.

    Be sure to add the full path to the project db to the constants.py file (PROJECT_DB_PATH)

    """

    db_path = PROJECT_DB_PATH

    script_path = r"D:\Python\scripts\rc\mega_pack_pbf_parser\mega_pack_pbf_parser\create_database.sql"

    with open(script_path) as f:

        script = f.read()

    create_db(db_path=db_path, script=script)





def insert_song_data(data: List):

    """

    Inserts song data into the project database. Prints the number of rows inserted.    

    """

    query = insert_songs_query

    db_path = PROJECT_DB_PATH

    row_count = insert(db_path=db_path, query=query, data=data)

    print(f"Inserted {row_count} rows into the database.")





def main():    

    bb_project_folder = r"C:\Users\RC\Documents\BBWorkspace\GM_Mega_Pack_Project"

    build_db()

    parser = Project_Parser(project_folder=bb_project_folder) 

    song_list = parser.run()

    insert_song_data(song_list)





if __name__ == '__main__':

    main()

```