Python ConnectionManager Exemples

Exemple #1

from url_builder.korbank.urls import UrlManager
from url_builder.korbank.parameters import kospi_kwargs, \
                                            corporate_loan_kwargs, \
                                            household_loan_kwargs, \
                                            exchange_rate_dollar_kwargs, \
                                            loan_usa_rate_kwargs, \
                                            loan_kor_rate_kwargs

mysql_dev = {
    'host': '--',
    'dbname': 'ec2_web_stockdata',
    'user': '******',
    'password': '******'
}

alchemy_conn = ConnectionManager.create_connection(mysql_dev)

COLUMN_LIST = [
    'STAT_NAME', 'STAT_CODE', 'ITEM_CODE1', 'ITEM_CODE2', 'ITEM_CODE3',
    'ITEM_NAME1', 'ITEM_NAME2', 'ITEM_NAME3', 'DATA_VALUE', 'TIME'
]

COLUMN_TYPE_MAPPER = {
    'STAT_NAME': 'str',
    'STAT_CODE': 'str',
    'ITEM_CODE1': 'str',
    'ITEM_CODE2': 'str',
    'ITEM_CODE3': 'str',
    'ITEM_NAME1': 'str',
    'ITEM_NAME2': 'str',
    'ITEM_NAME3': 'str',

Exemple #2

import pandas.io.sql as pandas_sql
from pandas import DataFrame
import urllib3
import json

# 사용자 정의 패키지
from credentials.restapi.api_keys import KEY_MAPPINGS
from credentials.connection.database import postgresql_dev
from db_connector.alchemy.connection_manager import ConnectionManager
from mapper.column_mapping.korbank import get_column_list, get_column_types
from korbank.util.urls import UrlManager

from korbank.parameters.parameters import kospi_kwargs, corporate_loan_kwargs, household_loan_kwargs, exchange_rate_dollar_kwargs

# Connection 생성
alchemy_conn = ConnectionManager.create_connection(postgresql_dev)

# Column Mapping
arr_columns = get_column_list()
dict_columns_type = get_column_types()

# API KEY
api_key = KEY_MAPPINGS['korbank']


def get_korbank_result(_url):
    http = urllib3.PoolManager()
    ret = http.request("GET",
                       _url,
                       headers={'Content-Type': 'application/json'})