Download Symphony Space Live Documentation

Thank you for your interest in the Symphony Space Live source code and supporting documents. Here, you can download the most recent codebase for your own use.

The files included are as follows:

symphony_mycroft.sql

This is an SQL database that will provide the structure and a few examples in each table of the database. Most of the tables are easily explained, but here is a breakout of the tables and their rows. This is how the database is configured for Symphony Space Live.

ssl_artists – a list of artists.

id - auto assigned

tag_name – displayed artist name

alpha_artist_name – the fields used to alphabetize the artist list

active – if the item will be shown in the system

ssl_genres – the main way the content is separated

id - auto assigned

tag_name – title of the genre

ssl_programs – the main items of content.

id - auto assigned

program_name – the title of the program

alpha_program_name – how the program will be displayed alphabetically

keyword – a keyword used for reference through the app and the database

filename – not used within the app, depreciated

the_performance – text describing the performance

about_the_music – text about the music performed

artist_credits – listed artist credits for the program

playlist – not the track list, but a playlist, which can include more information than track names

record_date – when the program was released

record_datestamp – when the program was recorded

autoplay – depreciated

artists – references to the ’id’ field in the ‘ssl_artists’ table

genres - references to the ’id’ field in the ‘ssl_genre’ table

subgenres - references to the ’id’ field in the ‘ssl_subgenre’ table

series - references to the ’id’ field in the ‘ssl_series’ table

tags - references to the ’id’ field in the ‘ssl_tags’ table

active – if the item will be shown in the system

ssl_promoted – references for the two promoted items at the top of the apps

id - auto assigned

program – references the ‘keyword’ field in the ‘ssl_programs’ table

image - URL for non-retina display screens

image_retina – URL for retina display screens

ssl_series – each program is part of a series that could span genres, this declares the series

id - auto assigned

tag_name – name of the series

ssl_subgenres – declares the subgenres used through the app and database

id - auto assigned

tag_name – name of the subgenre (jazz, classical, etc)

parent_genre – references the ‘id’ field in the ‘ssl_genres’ table

ssl_tags – each program is tagged for further classification, not referenced in the app

id - auto assigned

tag_name – name of the tag you would like used

ssl_tracks – declares mp3s as a part of a program and provides meta-data information

id - auto assigned

program – references the ‘id’ field in the ‘ssl_programs’ table

track – the # track of the individual item

artist – artist to display

duration – length of track

include_in_random_player – depreciated

webservices.zip

These files contains the server side php that retrieves information from the database. General.php contains the database username and other information.

Symphony Space Live iOS.zip and Symphony Space Live Android.zip

Symphony Space Live Android.zip

SymphonySpaceLiveHomeHelper.java

- Line 132 contains a reference to the Symphony Space Live credits page, which corresponds to when the "About Symphony Space Live" button is pressed.

Symphony Space Live iOS.zip

RootViewController.m

- Line 799 contains a reference to the Symphony Space Live credits page, which corresponds to when the "About Symphony Space Live" button is pressed.

- Line 870 contains the string for where the mp3s for the Symphony Space Live are hosted on Amazon's S3 servers.

- Line 895 contains the string which references program images hosted on Symphony Space's servers.

PerformanceDetailController.m

- Line 86 contains the string which references program images hosted on Symphony Space's servers.

- Line 94 contains the string for where the mp3s for the Symphony Space Live are hosted on Amazon's S3 servers.

Performance.m

- Line 35 contains the string which references program images hosted on Symphony Space's servers.

NetworkData.m

- Line 44 contains a reference to the get_subgenrewise_performance.php file in the webservices

- Line 52 contains a reference to the get_all_artists.php file in the webservices.

- Line 107 contains a reference to the get_performances.php file in webservices.

- Line 128 contains a reference to the get_performance_details.php file in webservices

- Line 141 contains a reference to the get_genre_performance.php file in webservices

- Line 164 contains a reference to the get_promos.php file in webservices

File structure:

The URL of the mp3 files is not listed within the database. Instead, the files are formulaically titled, including their directories. The location of the files is within the application, but it looks like this: **SERVER LOCATION**/keyword/track number.mp3

DOWNLOADS AND DOCUMENTATION
iOS Symphony Space Live iOS.zip Android Symphony Space Live Android.zip Web Services Directory