본문 바로가기
Home Board 시놀로지 / NAS
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
2018.02.11 22:47

Download Station Auto Delete - content

관리자
조회 수 164

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[E Channel]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[K Star]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[MBN]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[Mnet]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%live]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[On Style]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[SBS MTV]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[TV조선]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[XTM]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[E채널]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[MBC MUSIC]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[SBS MTV]%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[K-Star]%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%부작%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%전편%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E01~%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E01-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E03-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E05-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E07-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E09-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E11-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E13-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E15-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E17-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E19-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E21-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E23-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E25-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E27-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E29-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E31-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E33-%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%E35-%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%450p%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%450%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%360p%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%360%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%음악중심%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%SBS 인기가요%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%전국노래자랑%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%콘서트 7080%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%노래가 좋아%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%아이돌 리부팅%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%박진영의 파티피플%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%열린 음악회%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%EBS 스페이스 공감%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%하하랜드%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%최고의 요리비결%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%박원숙의 같이 삽시다%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%스타일 팔로우%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%철부지 브로망스%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%싱글와이프%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 곽승준의 쿨까당%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 김무명을 찾아라%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 대화가 필요한 개냥%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 둥지탈출%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 나의 영어 사춘기%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 유식한 아재들의%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 수업을 바꿔라%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 슈퍼TV%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 오늘도 스웩%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[tvN] 레벨업%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[JTBC] 밤도깨비%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[JTBC] 워너비%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[JTBC] 전체관람가%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[JTBC] 믹스나인%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[JTBC] 슈가맨%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[MBC Every1] 주간 아이돌%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[MBC Every1] Show Champion%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[MBC Every1] 맛있을 지도%'"

psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[채널A] 거인의 어깨%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[채널A] 나는 몸신이다%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[채널A] 이제 만나러 갑니다%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[채널A] 개밥 주는 남자%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[채널A] 외부자들%'"
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[채널A] 풍문으로%'"

이전 다음 위로 아래로 댓글로 가기 인쇄
  1. No Image

    psql -U postgres -d video_metadata -c "select (select path from video_file where id =video_file_id) from watch_status where uid=

    cd /volume2/XTRM_DSM/_VideoStation/ mkdir `date +%Y%m%d` echo 사용자번호_사용자명 >> /volume2/XTRM_DSM/_VideoStation/`date +%Y%m%d`/사용자명_`date +%Y%m%d`.txt; psql -U postgres -d video_metadata -c "select (select path from video_file where...
    Date2018.12.25 Category데이터베이스 Views216
    Read More
  2. No Image

    RSS Backup (Download Station RSS Backup script)

    pg_dump -U postgres download -t rss_feed -a -f /volume2/XTRM_DSM/rss_feed.sql
    Date2018.05.27 Category데이터베이스 Views172
    Read More
  3. No Image

    Download Station Auto Delete - content

    psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[E Channel]%'" psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[K Star]%'" psql -U postgres -d download -c "delete FROM downl...
    Date2018.02.11 Category데이터베이스 Views164
    Read More
  4. No Image

    Download Station Auto Delete

    su - postgres -c 'psql -U postgres -d download -c "delete from Download_queue where status in ('5','7','8','113','123')"'
    Date2018.02.11 Category데이터베이스 Views179
    Read More
Board Pagination Prev 1 Next
/ 1