Page MenuHomePhabricator
Files F4880271

No OneTemporary
Actions

View Options

diff --git a/AutoCoverTool/script/get_song_url.py b/AutoCoverTool/script/get_song_url.py
index 921ed8d..6e5ba6d 100644
--- a/AutoCoverTool/script/get_song_url.py
+++ b/AutoCoverTool/script/get_song_url.py
@@ -1,136 +1,314 @@
"""
获取歌曲的地址
"""
from script.common import *
from copy import deepcopy
+from online.common import update_db
def get_url_by_song_id(song_id):
sql = "select task_url,starmaker_songid from silence where starmaker_songid = {} order by task_id limit 1".format(
song_id)
ban = deepcopy(banned_user_map)
ban["db"] = "starmaker_musicbook"
data = get_data_by_mysql(sql, ban)
if len(data) > 0:
return data[0][0]
return None
def process():
arr = [
- "611752105025886914",
- "611752105030414513",
- "611752105030414549",
- "611752105016527562",
- "611752105030414557",
- "611752105030414568",
- "611752105030414576",
- "611752105025946483",
- "611752105030414580",
- "611752105030414584",
- "611752105030414588",
- "611752105030414590",
- "611752105030414597",
- "611752105030414600",
- "611752105030414608",
- "611752105030414613",
- "611752105019802732",
- "611752105030414615",
- "611752105030414619",
- "611752105030414633",
- "611752105030414638",
- "611752105030414644",
- "611752105030414647",
- "611752105030414655",
- "611752105030414660",
- "611752105030414663",
- "611752105030414669",
- "611752105030414674",
- "611752105030414678",
- "611752105030414680",
- "611752105030414682",
- "611752105030414686",
- "611752105030414689",
- "611752105030414696",
- "611752105030414702",
- "611752105030414706",
- "611752105030414707",
- "611752105030414711",
- "611752105030414717",
- "611752105030414729",
- "611752105030414742",
- "611752105020587028",
- "611752105030414752",
- "611752105030414757",
- "611752105030414761",
- "611752105030414763",
- "611752105030414766",
- "611752105030414773",
- "611752105030414776",
- "611752105030414777",
- "611752105030414779",
- "611752105030414784",
- "611752105030414890",
- "611752105030414907",
- "611752105030414915",
- "611752105030414919",
- "611752105030414925",
- "611752105030414929",
- "611752105030414932",
- "611752105030414935",
- "611752105030414937",
- "611752105019423720",
- "611752105030414943",
- "611752105030414948",
- "611752105026101090",
- "611752105030414949",
- "611752105030414957",
- "611752105030414962",
- "611752105030414963",
- "611752105030414968",
- "611752105030414973",
- "611752105030414976",
- "611752105030414981",
- "611752105030414986",
- "611752105030414988",
- "611752105030414990",
- "611752105030414993",
- "611752105030414995",
- "611752105030415003",
- "611752105030415007",
- "611752105030415009",
- "611752105030415014",
- "611752105030415018",
- "611752105030415032",
- "611752105030415044",
- "611752105030415050",
- "611752105030415052",
- "611752105030415056",
- "611752105030415058",
- "611752105030415062",
- "611752105030415067",
- "611752105017233541",
- "611752105015523266",
- "611752105030415071",
- "611752105030415074",
- "611752105030415078",
- "611752105022920230",
- "611752105030113709",
- "611752105022990449",
- "611752105030415083",
- "611752105030415087",
- "611752105030415094",
- "611752105030415100",
- "611752105030425986",
- "611752105030415103",
- "611752105030426004"
+ "611752105016642206",
+ "611752105016665828",
+ "611752105020332340",
+ "611752105020332347",
+ "611752105020390931",
+ "611752105020417679",
+ "611752105021442334",
+ "611752105021459528",
+ "611752105021810110",
+ "611752105021916843",
+ "611752105022312180",
+ "611752105022614734",
+ "611752105022615541",
+ "611752105022615665",
+ "611752105022616931",
+ "611752105022647066",
+ "611752105022647087",
+ "611752105022652047",
+ "611752105022700847",
+ "611752105022728649",
+ "611752105022728653",
+ "611752105022729255",
+ "611752105022733605",
+ "611752105022736029",
+ "611752105022740011",
+ "611752105022742166",
+ "611752105022743986",
+ "611752105022746848",
+ "611752105022748944",
+ "611752105022749272",
+ "611752105022749768",
+ "611752105022751902",
+ "611752105022752248",
+ "611752105022754267",
+ "611752105022755405",
+ "611752105022757577",
+ "611752105022758309",
+ "611752105022758395",
+ "611752105022761145",
+ "611752105022761151",
+ "611752105022764435",
+ "611752105022764965",
+ "611752105022766106",
+ "611752105022766675",
+ "611752105022774258",
+ "611752105022776257",
+ "611752105022776285",
+ "611752105022776577",
+ "611752105022776846",
+ "611752105022777151",
+ "611752105022777306",
+ "611752105022778977",
+ "611752105022779055",
+ "611752105022779169",
+ "611752105022779962",
+ "611752105022780648",
+ "611752105022784727",
+ "611752105022785048",
+ "611752105022785179",
+ "611752105022785551",
+ "611752105022811718",
+ "611752105022814368",
+ "611752105022815931",
+ "611752105022819519",
+ "611752105022824948",
+ "611752105022828998",
+ "611752105022833822",
+ "611752105022835250",
+ "611752105022838357",
+ "611752105022838544",
+ "611752105022838589",
+ "611752105022838666",
+ "611752105022839015",
+ "611752105022839300",
+ "611752105022839468",
+ "611752105022839559",
+ "611752105022892354",
+ "611752105022911042",
+ "611752105023134539",
+ "611752105023142842",
+ "611752105023588294",
+ "611752105024204862",
+ "611752105024546859",
+ "611752105024598735",
+ "611752105024938931",
+ "611752105025327479",
+ "611752105025565027",
+ "611752105025720331",
+ "611752105025741447",
+ "611752105025817802",
+ "611752105026281560",
+ "611752105026388268",
+ "611752105026421148",
+ "611752105026536897",
+ "611752105026536911",
+ "611752105026580839",
+ "611752105026648945",
+ "611752105026663363",
+ "611752105026736866",
+ "611752105027067863",
+ "611752105027112518",
+ "611752105027186556",
+ "611752105027189208",
+ "611752105027189301",
+ "611752105027326104",
+ "611752105027460089",
+ "611752105027484913",
+ "611752105027588072",
+ "611752105027611383",
+ "611752105027690075",
+ "611752105028470803",
+ "611752105028507652",
+ "611752105028528335",
+ "611752105028815367",
+ "611752105028820629",
+ "611752105028820633",
+ "611752105028878340",
+ "611752105028906600",
+ "611752105028944645",
+ "611752105028958744",
+ "611752105029006303",
+ "611752105029006319",
+ "611752105029059923",
+ "611752105029078388",
+ "611752105029090034",
+ "611752105029209546",
+ "611752105029243449",
+ "611752105029272970",
+ "611752105029291291",
+ "611752105029291294",
+ "611752105029291295",
+ "611752105029291297",
+ "611752105029291298",
+ "611752105029291304",
+ "611752105029395411",
+ "611752105029432787",
+ "611752105029570149",
+ "611752105029570153",
+ "611752105029570157",
+ "611752105029953987",
+ "611752105029954853",
+ "611752105029955024",
+ "611752105029955258",
+ "611752105029956379",
+ "611752105029956615",
+ "611752105029990162",
+ "611752105029990590",
+ "611752105029991249",
+ "611752105030103635",
+ "611752105030119229",
+ "611752105030124600",
+ "611752105030485000",
+ "611752105030485417",
+ "611752105030485428",
+ "611752105030485533",
+ "611752105030485561",
+ "611752105030485562",
+ "611752105030485565",
+ "611752105030485566",
+ "611752105030485569",
+ "611752105030485570",
+ "611752105030485572",
+ "611752105030485591",
+ "611752105030485592",
+ "611752105030485594",
+ "611752105030485595",
+ "611752105030485597",
+ "611752105030485598",
+ "611752105030485601",
+ "611752105030485602",
+ "611752105030485607",
+ "611752105030485608",
+ "611752105030485610",
+ "611752105030485612",
+ "611752105030485613",
+ "611752105030485616",
+ "611752105030485618",
+ "611752105030485620",
+ "611752105030485621",
+ "611752105030485626",
+ "611752105030485627",
+ "611752105030485631",
+ "611752105030485634",
+ "611752105030485637",
+ "611752105030485639",
+ "611752105030485642",
+ "611752105030485646",
+ "611752105030485650",
+ "611752105030485653",
+ "611752105030485655",
+ "611752105030485656",
+ "611752105030485662",
+ "611752105030485663",
+ "611752105030485666",
+ "611752105030485667",
+ "611752105030485669",
+ "611752105030485671",
+ "611752105030485672",
+ "611752105030485673",
+ "611752105030485676",
+ "611752105030485677",
+ "611752105030485679",
+ "611752105030485681",
+ "611752105030485682",
+ "611752105030485685",
+ "611752105030485687",
+ "611752105030485688",
+ "611752105030485691",
+ "611752105030485692",
+ "611752105030485693",
+ "611752105030485696",
+ "611752105030485697",
+ "611752105030485700",
+ "611752105030485702",
+ "611752105030485703",
+ "611752105030485707",
+ "611752105030485710",
+ "611752105030485711",
+ "611752105030485715",
+ "611752105030485716",
+ "611752105030485717",
+ "611752105030485721",
+ "611752105030485722",
+ "611752105030485724",
+ "611752105030485726",
+ "611752105030485727",
+ "611752105030485729",
+ "611752105030485731",
+ "611752105030485733",
+ "611752105030485734",
+ "611752105030485736",
+ "611752105030485737",
+ "611752105030485738",
+ "611752105030485739",
+ "611752105030485741",
+ "611752105030485742",
+ "611752105030485744",
+ "611752105030485745",
+ "611752105030485748",
+ "611752105030485749",
+ "611752105030485750",
+ "611752105030485755",
+ "611752105030485758",
+ "611752105030485759",
+ "611752105030485761",
+ "611752105030485763",
+ "611752105030485766",
+ "611752105030485768",
+ "611752105030485769",
+ "611752105030485772",
+ "611752105030485778",
+ "611752105030485779",
+ "611752105030485787",
+ "611752105030485790",
+ "611752105030485791",
+ "611752105030485794",
+ "611752105030485797",
+ "611752105030485799",
+ "611752105030488510",
+ "611752105030488594",
+ "611752105030488665",
+ "611752105030488713",
+ "611752105030488727",
+ "611752105030488744",
+ "611752105030488814",
+ "611752105030488836",
+ "611752105030488852",
+ "611752105030488864",
+ "611752105030488880",
+ "611752105030488962",
+ "611752105030488997",
+ "611752105030489153",
+ "611752105030489354",
+ "611752105030489380",
+ "611752105030489394",
+ "611752105030489403",
+ "611752105030489415"
]
+ ban = deepcopy(banned_user_map)
+ ban["db"] = "av_db"
+
for sid in arr:
url = get_url_by_song_id(sid)
if url is not None:
print("out,{},{}".format(url, sid))
+ sql = "replace INTO svc_queue_table (song_id, url, create_time, update_time) VALUES ({}, \"{}\", NOW(), NOW())" \
+ .format(sid, url)
+ update_db(sql, ban)
if __name__ == '__main__':
process()

File Metadata

Mime Type
text/x-diff
Expires
Sun, Jan 12, 08:29 (1 d, 11 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
1347146
Default Alt Text
(12 KB)

Event Timeline