mysql mingw

카테고리 없음 2025. 4. 24. 09:58

/c/Program Files/MySQL/MySQL Server 8.0/bin
$ ./mysql.exe -uroot -p1234 kunnodae < /e/big.sql


C:\Users\{user}\AppData\Roaming\DBeaverData\workspace6\.metadata\.plugins\org.eclipse.e4.workbench\workbench.xmi 

삭제




from PyPDF2 import PdfReader, PdfWriter

target_file = "part-과정관리.pdf"

# 원본 PDF 파일 열기
reader = PdfReader("total.pdf")

# 새 PDF 작성을 위한 객체 생성
writer = PdfWriter()

# 인덱스는 0부터 시작
for page_num in range(81, 89):
    writer.add_page(reader.pages[page_num])

# 결과를 새로운 PDF로 저장
with open(target_file, "wb") as output_file:
    writer.write(output_file)

print(f"{target_file} 파일이 생성되었습니다.")


$ /c/Program\ Files/LibreOffice/program/soffice.exe --headless --convert-to pdf *.pptx


$ cat 1.txt
aa
bb

sed -i "s/^/'/; s/$/',/" 1.txt

$ cat 1.txt
'aa',
'bb',


from pptx import Presentation
import glob
f = open("ppt.txt", 'w', encoding='utf-8')

for eachfile in glob.glob("*.pptx"):
    prs = Presentation(eachfile)
    print(eachfile)
    print("----------------------")
    for slide in prs.slides:
        for shape in slide.shapes:
            if hasattr(shape, "text"):
                print(shape.text)
                f.write(shape.text)


f.close()

import yt_dlp

def download_video(url):
    # yt-dlp 옵션 설정
    ydl_opts = {
        'outtmpl': '%(title)s.%(ext)s',  # 파일 이름 형식 (제목과 확장자로 저장)
        'format': 'best',  # 가장 좋은 품질로 다운로드
    }

    # yt-dlp 다운로드 수행
    with yt_dlp.YoutubeDL(ydl_opts) as ydl:
        ydl.download([url])

if __name__ == "__main__":
    url = input("다운로드할 URL을 입력하세요: ")
    download_video(url)


from konlpy.tag import Kkma

# Kkma 객체 생성
kkma = Kkma()

# 복합어 예시
texts = [ '관리자유저ID', '관리자이름']

# 배열 원소 최대 갯수 5개로 가정
max_elements = 5

# 형태소 분석
for text in texts:
    morphs = kkma.morphs(text)
    # 형태소가 5개 미만일 경우 앞에 ,,, 을 추가
    result = ','.join(morphs)  # 형태소들을 ,로 연결
    result = ',' * (max_elements - len(morphs)) + result  # 부족한 부분 만큼 , 을 추가

    print(result)