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.1320685130.txt.gz · Last modified: 2015/04/13 20:19 (external edit)