Python DBUtil Examples

Example #1

File: analydata.py Project: liyustar/pydemo

# -*- coding:utf-8 -*-

from md.config.mysqlutil import DBUtil
import pandas as pd
import matplotlib
import matplotlib.pyplot as plt

# url = "table.finance.yahoo.com"

if __name__ == '__main__':

    dbutil = DBUtil()

    table_name = 'stockdata_yahoo'

    symbol = '000001'
    market = 'sz'

    query = "SELECT * FROM stockdata_yahoo"
    result = dbutil.exec(query)
    dbutil.close()

    df = pd.DataFrame(list(result), columns=('symbol', 'market', 'date', 'open', 'high', 'low', 'close', 'volumn', 'adj_close'))

    # print(df)

    fig = plt.figure()


    open_fig = fig.add_axes([0.05, 0.1, 0.9, 0.8])

Example #2

File: savedata.py Project: liyustar/pydemo

# -*- coding:utf-8 -*-

import csv
from md.config.mysqlutil import DBUtil

# url = "table.finance.yahoo.com"

if __name__ == '__main__':

    dbutil = DBUtil()

    table_name = 'stockdata_yahoo'

    symbol = '000001'
    market = 'sz'
    filename = "st.%s.%s.csv" % (symbol, market)
    print("filename<%s>", filename)

    csvReader = csv.reader(open(filename, 'r'))
    isTitle = True

    for row in csvReader:
        if isTitle:
            isTitle = False
            continue

        date = row[0]
        open = row[1]
        high = row[2]
        low = row[3]
        close = row[4]