User Tools

Site Tools


informatica:linux:radio

This is an old revision of the document!


Airtime

select * from cc_playlist where name='Love of Lesbian-1999';

id |         name         | state | currentlyaccessing | editedby | mtime | creator | description 
17 | Love of Lesbian-1999 | ready |                  0 |          |       |         | 
(1 row)

select * from cc_files where artist_name='Love of Lesbian' and album_title='1999';

id  |              gunid               | name |   mime    |   ftype   | directory |                                       filepath                                       | state | currentlyaccessing | editedby | mtime |               md5                |                      track_title                       |   artist_name   | bit_rate | sample_rate | format |     length      | album_title | genre | comments | year | track_number | channels | url | bpm | rating | encoded_by | disc_number | mood | label | composer | encoder | checksum | lyrics | orchestra | conductor | lyricist | original_lyricist | radio_station_name | info_url | artist_url | audio_source_url | radio_station_url | buy_this_url | isrc_number | catalog_number | original_artist | copyright | report_datetime | report_location | report_organization | subject | contributor | language 
------+----------------------------------+------+-----------+-----------+-----------+--------------------------------------------------------------------------------------+-------+--------------------+----------+-------+----------------------------------+--------------------------------------------------------+-----------------+----------+-------------+--------+-----------------+-------------+-------+----------+------+--------------+----------+-----+-----+--------+------------+-------------+------+-------+----------+---------+----------+--------+-----------+-----------+----------+-------------------+--------------------+----------+------------+------------------+-------------------+--------------+-------------+----------------+-----------------+-----------+-----------------+-----------------+---------------------+---------+-------------+----------
 83 | 27457686e740efe06dff0f9f634f53b9 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Incendios De Nieve.mp3                   | empty |                  0 |          |       | d34e2d218d8a8ba820e6dc61d0e91c9b | Love Of Lesbian - Incendios De Nieve                   | Love of Lesbian | 194577   | 44100       |        | 00:05:58.269387 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
105 | 00ded83c5e4b5df39c73088a394121bd |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Algunas Plantas.mp3                      | empty |                  0 |          |       | fd15dcb4d2c30a774584d2fd615dc61b | Love Of Lesbian - Algunas Plantas                      | Love of Lesbian | 212706   | 44100       |        | 00:04:06.099591 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
207 | 67659cd5e11fff08a31b151a8b34cc66 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Miau.mp3                                 | empty |                  0 |          |       | 0f7e5166eb5f32671ebd221b9917bb05 | Love Of Lesbian - Miau                                 | Love of Lesbian | 217042   | 44100       |        | 00:04:19.84     | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
633 | 243b8319e072e0312dbb037ec956b4e8 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Te Hiero Mucho (historia del amante).mp3 | empty |                  0 |          |       | 8519aa61aff4b2e9a7ed66fb896301a8 | Love Of Lesbian - Te Hiero Mucho (historia del amante) | Love of Lesbian | 200683   | 44100       |        | 00:04:23.862857 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
246 | 480c81e215b9cfd8ac8e5cc5dfe2be74 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - 1999.mp3                                 | empty |                  0 |          |       | 028e57f8435b532df29e062189ff9e38 | Love Of Lesbian - 1999                                 | Love of Lesbian | 200468   | 44100       |        | 00:05:05.371428 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
269 | 98fbec65a3b09ee3091c1a267de98603 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - La Mirada De La Gente Que Conspira.mp3   | empty |                  0 |          |       | 34fff821ea7c76984080ddaa94b7720a | Love Of Lesbian - La Mirada De La Gente Que Conspira   | Love of Lesbian | 203301   | 44100       |        | 00:04:46.981224 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
291 | a3a5bf65656df6610916d62961882629 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Octoplasta.mp3                           | empty |                  0 |          |       | 0bd88a925b4022a41f8bbd548ae9cc8f | Love Of Lesbian - Octoplasta                           | Love of Lesbian | 207132   | 44100       |        | 00:03:46.011428 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
898 | 2859e5a0f03b50f9dc008267b790339f |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Cuando Diga Ya.mp3                       | empty |                  0 |          |       | a589042f04f456f79fd770d0df276593 | Love Of Lesbian - Cuando Diga Ya                       | Love of Lesbian | 205673   | 44100       |        | 00:02:46.922448 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
1170 | 172d14e6ead70d0b10b3a15ae12dce3e |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Voy A Romper Las Ventanas.mp3            | empty |                  0 |          |       | 2a79a7c69f27daa446d93406fab2caf1 | Love Of Lesbian - Voy A Romper Las Ventanas            | Love of Lesbian | 197424   | 44100       |        | 00:06:28.466938 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
1052 | 2a98395cb5366077370631e59f6d4c4f |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Alli Donde Soliamos Gritar.mp3           | empty |                  0 |          |       | 3a0c31e76bd1e95c9f9403175922a969 | Love Of Lesbian - Alli Donde Soliamos Gritar           | Love of Lesbian | 218658   | 44100       |        | 00:05:37.475918 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
2202 | 74308419317ae11f5ef3b57cfc6f8a30 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Las Malas Lenguas.mp3                    | empty |                  0 |          |       | 1c3045b72224a199b6913391df94266a | Love Of Lesbian - Las Malas Lenguas                    | Love of Lesbian | 210732   | 44100       |        | 00:03:33.34204  | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
2099 | 3409e7ab6cdfd8cb37768d379e2afd6b |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - El Club De Fans De John Boy.mp3          | empty |                  0 |          |       | e37ed2d250b64a5175fea147d57a1a36 | Love Of Lesbian - El Club De Fans De John Boy          | Love of Lesbian | 217261   | 44100       |        | 00:03:49.877551 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
1995 | 6c64fa299b9c98793dc0b04277b47ab6 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Cuestiones De Familia.mp3                | empty |                  0 |          |       | d3aaa28bf56bb3d2756ace88a2ce6db3 | Love Of Lesbian - Cuestiones De Familia                | Love of Lesbian | 194338   | 44100       |        | 00:03:01.159183 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 
2369 | 90b157c6c079bc49280a945ca84b85d4 |      | audio/mp3 | audioclip |         1 | Love Of Lesbian/2009.1999/Love Of Lesbian - Segundo Asalto.mp3                       | empty |                  0 |          |       | 1bbfaf2a0a6c436e57de48234a6c0a34 | Love Of Lesbian - Segundo Asalto                       | Love of Lesbian | 220736   | 44100       |        | 00:03:35.745306 | 1999        |       |          |      |              |          |     |     |        |            |             |      |       |          |         |          |        |           |           |          |                   |                    |          |            |                  |                   |              |             |                |                 |           |                 |                 |                     |         |             | 

(14 rows)

select * from cc_playlistcontents ; id | playlist_id | file_id | position | cliplength | cuein | cueout | fadein | fadeout —-+————-+———+———-+————+——-+——–+——–+——— (0 rows)

insert into cc_playlistcontents (playlist_id,file_id,cliplength,cuein) values ('17','83','00:05:58.269387','00:05:58.269387')

insert into cc_playlistcontents (playlist_id,file_id,cliplength,cuein) select 17,id,length,length from cc_files where artist_name='Love of Lesbian' and album_title='1999';

select (select id from cc_playlist where name='Love of Lesbian-1999'),id,length,length from cc_files where artist_name='Love of Lesbian' and album_title='1999';

informatica/linux/radio.1320685159.txt.gz · Last modified: 2015/04/13 20:19 (external edit)