#!/usr/bin/env python3
# -*- coding: utf-8 -*-
' a test module '
__author__ = 'Wu Zongshuai'
import pandas as pd
from sqlalchemy import create_engine
import os
os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'
engine = create_engine("oracle://zzwyjjl:Omc5_012@10.87.72.50/OSS")
writer = pd.ExcelWriter(r'D:\邻区.xlsx')
sql = """
SELECT
BTS.CO_OBJECT_INSTANCE|| '-'||LNADJ.LNADJ_ADJ_ENB_ID 正向邻区对
,LNADJ.LNADJ_ADJ_ENB_ID|| '-'||BTS.CO_OBJECT_INSTANCE 反向邻区对
,BTS.CO_OBJECT_INSTANCE "源enb_id"
,ADJ.CO_OBJECT_INSTANCE "正向编号LNADJ_ID"
,decode(LNADJ.LNADJ_CPIAC_7,0,'oamControlled ',1,'enbControlled') "cPlaneIpAddrCtrl"
,LNADJ.LNADJ_C_PLANE_IP_ADDR "cPlaneIpAddr"