예제 #1
0
import urllib.request
from bs4 import BeautifulSoup
import pyodbc
from ms_access.connectDB import StockDB

#주식정보 페이지 숫자만큼 range를 정해준다.
# conn = pyodbc.connect(Driver='{Microsoft Access Driver (*.mdb, *.accdb)}'
# #                      ,DBQ='C:\\Users\\SIDeok\\git\\WebscrapingForStock\\WebscrapingForStock\\ms_access\\StockDB.mdb')
#                       ,DBQ='C:\\Users\\SIDeok\\git\\WebscrapingForStock\\WebScrapingForStock\\ms_access\\StockDB.mdb')
# cs = conn.cursor()
conn = StockDB()
cs = conn.getCursor()

for i in range(1, 2):
    pageCont = urllib.request.urlopen(
        'https://finance.naver.com/item/sise_day.nhn?code=148070&page=' +
        str(i))
    soup_m = BeautifulSoup(pageCont.read(), "html.parser")
    soup_tab = soup_m.find("table", {"class": "type2"})

    #tr태그를 읽어온뒤 date가 있는 항목만 처리한다.
    tdArray = soup_tab.findAll("span")
    idx = 0
    for j in tdArray:
        if (j.contents.__len__() != 0 and j['class'][1] == 'p10'):
            date = j.contents[0]
            val = tdArray[idx + 1].contents[0]
            print(str(i) + ", " + date.replace(".", "") + " ,  " + val)
            cs.execute("INSERT INTO TB_KOPSEF_BOND10 VALUES('" +
                       date.replace(".", "-") + "'," + val.replace(",", "") +
                       ")")
예제 #2
0
파일: DBconnTest.py 프로젝트: sideok/MyWeb
'''
Created on 2018. 12. 13.

@author: SIDeok
'''
from ms_access.connectDB import StockDB

DB = StockDB()
cs = DB.getCursor()

cs.execute("delete from test")
cs.commit()
cs.close()