con = cx_Oracle.connect(data_driver.MAIN_CONNECT_STRING,encoding="UTF-8")

df_all = pd.read_sql_query(con=con， sql=str_sql)

#SQLAlchemy 建立数据库engine
#这里按照文档，用了encoding='utf-8'。 双方数据都是utf-8编码，正常应该没问题。
engine = create_engine('oracle://' + 'DATANA:datana@XE_PDB3',encoding='utf-8')

#查看数据库编码，确实是 SIMPLIFIED CHINESE_CHINA.AL32UTF8
engine.execute("select userenv('language') from dual").fetchall()

#写数据
df_all.to_sql(name='表明_table'
             ,con=engine  # utf-8 的sqlalchemy engine
             ,if_exists='replace'
             ,chunksize=10000
             ,dtype={ 'column name' : sqlalchemy.types.VARCHAR(10)  # 对于pandas中object的列，要定义类型，否则。。。自动clob也是慢
             }
             ,index=False
)

UnicodeEncodeError: 'gbk' codec can't encode character '\xa0' in position 0: illegal multibyte sequence

engine = create_engine('oracle://' + 'DATANA:datana@XE_PDB3',encoding='utf-8')

# 定义基于cx_Oracle的creator，在里面生成connection，保证使用UTF-8编码。这是能正常work的，在读取的时候也验证过。
def con_creator():
    return cx_Oracle.connect('datana/datana@XE_PDB3', encoding="UTF-8")

#连接库生成SQLAlchemy engine时，调用creator，这时encoding写上就写上吧，可能真没用。
engine = create_engine('oracle+cx_oracle://', creator=con_creator ,encoding='utf-8')


#写数据，这回没有烦人的encoding 错误了。拜拜了gbk
df_all.to_sql(name='表明_table'
             ,con=engine  # utf-8 的sqlalchemy engine
             ,if_exists='replace'
             ,chunksize=10000
             ,dtype={ 'column name' : sqlalchemy.types.VARCHAR(10)  # 对于pandas中object的列，要定义类型，否则。。。自动clob也是慢
             }
             ,index=False
)

>>> import socket
>>> socket.gethostname()
'root@bisratyalew'

>>> hostname = socket.gethostname()

>>> socket.gethostbyname('localhost')
'127.0.0.1'

>>> socket.gethostbyname(hostname) ### Returns ip address
'192.168.1.3'

import socket                   # Import socket module

port = 60000                    # Reserve a port for your service.
s = socket.socket()             # Create a socket object
host = socket.gethostname()     # Get local machine name
s.bind((host, port))            # Bind to the port
s.listen(5)                     # Now wait for client connection.

print('Server listening....')

while True:
    conn, addr = s.accept()     # Establish connection with client.
    print('Got connection from', addr)
    data = conn.recv(1024)
    print('Server received', repr(data))

    filename = 'mytext.txt'
    with open(filename, 'rb') as f:
        in_data = f.read(1024)
        while in_data:
            conn.send(in_data)
            print('Sent ', repr(in_data))
            in_data = f.read(1024)

    print('Done sending')
    conn.send('Thank you for connecting')
    conn.close()


# client side server

import socket                   # Import socket module

s = socket.socket()             # Create a socket object
host = socket.gethostname()     # Get local machine name
port = 60000                    # Reserve a port for your service.

s.connect((host, port))
s.send("Hello server!")

with open('received_file', 'wb') as f:
    print('file opened')
    while True:
        print('receiving data...')
        data = s.recv(1024)
        print('data=%s', (data))
        if not data:
            break
        # write data to a file
        f.write(data)

f.close()
print('Successfully get the file')
s.close()
print('connection closed')

"""
	File transfer protocol used to send and receive files using FTP server.
	Use credentials to provide access to the FTP client	
"""

from ftplib import FTP
ftp = FTP('xxx.xxx.x.x')  # Enter the ip address or the domain name here
ftp.login(user='username', passwd='password')
ftp.cwd('/Enter the directory here/')

"""
	The file which will be received via the FTP server
	Enter the location of the file where the file is received
"""

def recieve_file():
	file_name = 'example.txt'   """ Enter the location of the file """
	with open(file_name, 'wb') as LocalFile:
		ftp.retrbinary('RETR ' + file_name, LocalFile.write, 1024)
	ftp.quit()

"""
	The file which will be sent via the FTP server
	The file send will be send to the current working directory
"""

def send_file():
	file_name = 'example.txt'   """ Enter the name of the file """
	with open(file_name, 'rb') as LocalFile:
		ftp.storbinary('STOR ' + file_name, LocalFile)
	ftp.quit()

>>> import asyncio
>>> from concurrent.futures import ThreadPoolExecutor

>>> e = ThreadPoolExecutor()
>>> async def read_file(file_):
...     loop = asyncio.get_event_loop()
...     with open(file_) as f:
...         return (await loop.run_in_executor(e, f.read))
...
>>> ret = asyncio.run(read_file('/etc/passwd'))

import asyncio
import socket

host = 'localhost'
port = 9527
loop = asyncio.get_event_loop()
s = socket.socket(socket.AF_INET, socket.SOCK_STREAM, 0)
s.setsockopt(socket.SOL_SOCKET, socket.SO_REUSEADDR, 1)
s.setblocking(False)
s.bind((host, port))
s.listen(10)

async def handler(conn):
    while True:
        msg = await loop.sock_recv(conn, 1024)
        if not msg:
            break
        await loop.sock_sendall(conn, msg)
    conn.close()

async def server():
    while True:
        conn, addr = await loop.sock_accept(s)
        loop.create_task(handler(conn))

loop.create_task(server())
loop.run_forever()
loop.close()

import urllib.request ## urllib module is used to send request and receive response from a server. It can used to get html / JSON / XML data from an api.

webData = request.urlopen("http://www.google.com") ## It opens a connection to google.com and returns an object of class http.client.HTTPResponse

import json
json_data = json.loads(response)

import xml.dom.minidom
doc = minidom.parse("check.xml")

# split all string from a sentence
>>> import re
>>> source = "Python is great!"
>>> re.findall('[\w]+', source)   #\w 匹配所有字母
['Python', 'is', 'great!']

>>> re.match('^#?([a-f0-9]{6}|[a-f0-9]{3})$', '#ffffff')
<_sre.SRE_Match object at 0x0000000002F04120>
>>> re.match('^#?([a-f0-9]{6}|[a-f0-9]{3})$', '#cdcdcd')
<_sre.SRE_Match object at 0x0000000002EA3160>

>>> re.match('^[a-zA-Z0-9-_]{3,16}$', 'Check') is not None
True
>>> re.match('^\w|[-_]{3,16}$', 'che%ck') is not None
False

re.match('^([a-z0-9_\.-]+)@([\da-z\.-]+)\.([a-z\.]{2,6})$',
...          'check@example.com')
<_sre.SRE_Match object at 0x0000000002EA3180>