-
Notifications
You must be signed in to change notification settings - Fork 0
anrovla/Angela
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
*** PRV DEL *** - da ima prviot web servis sortirano po play count. 1. Vcera ti ja update-irav tabelata songs da ima validen playcount po song url. 2. Gi proveriv podatocite i vo red se. 3. Samo modificiraj go selectot vo prviot web servis da ima na kraj ordered by playcount 4. Podobri go vtoriot web servis vo select sql i dodadi / modificiraj 'and name is not null order by similarity desc' 4. Ke si raboti stariot index.html *** VTOR DEL *** - da ima multiple select (up to 5 songs) i da gi dava top 15 similarity ordered by similarity desc od SITE izbraani pesni. 1. Ke ti pratam zip so files na FB 2. Kompletno nov index_ms.html 3. Nov, tret web servis, zemi go vtoriot i napravi tret koj: - ke prima isto parametri kako vtoriot, no ke vrakja song_ID_orig, name, artist, similarity - SQL selectot: select song_ID_orig, name, artist, similarity from sim_mview where song_ID_orig = $url and name is not null order by similarity desc - Napravi novo view: sim_mview so sledniot select: - ********** view ************** CREATE VIEW `sim_mview` AS select `t2`.`name` AS `name`, `t2`.`artist` AS `artist`, `t1`.`song_ID_orig` AS `song_ID_orig`, `t1`.`similarity` AS `similarity` from (`similarity` `t1` left join `songs` `t2` on((`t2`.`url` = `t1`.`song_ID_compare`)));
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published