파이썬 DB 생성 및 업데이트

파이썬 DB 생성 및 업데이트

<

>

# Ch05_StockPriceAPI\Investar\DBUpdater.py

# SDA1\StockAnal\DBUpdater.py

import requests

import pandas as pd

import pymysql

from datetime import datetime

from bs4 import BeautifulSoup

import json

import calendar

from threading import Timer

import re

###########################################################################

# 1회생성 후 주석처리할것  생성명 upbitda, kiwoomdb 만 변경해서 등록

#conn = pymysql.connect(host='localhost', user='root', passwd='abcdefg', charset='utf8')

#cursor = conn.cursor()

#sql = "CREATE DATABASE upbitdb" #업비트용 db

#sql = "CREATE DATABASE kiwoomdb" #주식용 db

#cursor.execute(sql)

#conn.commit()

#conn.close()

#self.client = pymongo.MongoClient('localhost', 27017) #생성한 몽고디비 클라이언트 연결

##############################################################################

<

>