1. pandas.DataFrame.to_sql to MySQL
 
Until pandas include the option of INSERT IGNORE in the default pd.DataFrame.to_sql class, here is the best solution:
 
from sqlalchemy.ext.compiler import compiles
from sqlalchemy.sql.expression import Insert

# adds the word IGNORE after INSERT in sqlalchemy
@compiles(Insert)
def _prefix_insert_with_ignore(insert, compiler, **kw):
    return compiler.visit_insert(insert.prefix_with('IGNORE'), **kw)
 
Now you can run your normal df.to_sql commands!
 
from sqlalchemy import create_engine
from sqlalchemy.ext.compiler import compiles
from sqlalchemy.sql.expression import Insert

@compiles(Insert)
def _prefix_insert_with_ignore(insert, compiler, **kw):
    return compiler.visit_insert(insert.prefix_with('IGNORE'), **kw)

df.index.rename('index_column', inplace=True)
sqlEngine = create_engine('mysql+pymysql://'+dbUser+':'+dbPass+'@'+dbHost+'/'+dbDbse, pool_recycle=3600)
dbConnection = sqlEngine.connect()
try: df.to_sql(dbTble, con=dbConnection, if_exists='append')
except ValueError as vx: print(vx)
except Exception as ex: print(ex)
else: print("Table %s created successfully."%dbTble)
 
2. SQL Server
 
If you really need to run multiple threads at the same time you can enable the ignore_dup_key option on the primary key.
 
This will just give a warning instead of an error when an insert would result in a duplicate key violation. But instead of failing it will discard the row(s) that if inserted would cause the uniqueness violation.
 
CREATE TABLE [dbo].[DeleteMe](
[id] [uniqueidentifier] NOT NULL,
[Value] [varchar](max) NULL,
CONSTRAINT [PK_DeleteMe] 
PRIMARY KEY ([id] ASC) 
WITH (IGNORE_DUP_KEY = ON));
 
Example on sqlfiddle
 
Paul White's detailed explanation on the IGNORE_DUP_KEY option. Thanks Paul.
 
 

We are writing to inform you that your company is not in compliance with the Apple Developer Program License Agreement (PLA).
 
Section 11.2 (Termination) states:
 
(f) if You engage, or encourage others to engage, in any misleading, fraudulent, improper, unlawful or dishonest act relating to this Agreement, including, but not limited to, misrepresenting the nature of Your submitted Application (e.g., hiding or trying to hide functionality from Apple’s review, falsifying consumer reviews for Your Application, etc.).
 
Be aware that manipulating App Store chart rankings, user reviews or search index may result in the loss of your developer program membership.
 
Please address this issue promptly.
 
 
 
 
 
收到苹果警告邮件，出现的原因是：机刷下载，机刷评论，集中时间app进入用户过多，解决办法：老老实实承认错误。争取宽大处理。
 
 
 
 
 

 
 
关于EOF occurred in violation of protocol (_ssl.c:661)的解决办法
 
 
直接上代码（python版本2.7）
`import requests
r = requests.get('https://www.zjkill.com/news/')
r.encoding = 'utf8'
print r.text
print r.status_code,r.url`
报错
 
 

  requests.exceptions.SSLError: ("bad handshake: SysCallError(-1, 'Unexpected EOF')",)
  
经过一番查找，发现是requests不在支持3DES stream cipher。
  
下面是解决办法，注意ruquests版本2.11及以下的
 
 
 
from requests.adapters import HTTPAdapter
from requests.packages.urllib3.poolmanager import PoolManager
import ssl

class MyAdapter(HTTPAdapter):
    def init_poolmanager(self, connections, maxsize, block=False):
        self.poolmanager = PoolManager(num_pools=connections,
                                       maxsize=maxsize,
                                       block=block,
                                       ssl_version=ssl.PROTOCOL_TLSv1)
s = requests.Session()
s.mount('https://', MyAdapter())
r = requests.get('https://www.zjkill.com/news/')
r.encoding = 'utf8'
print r.text
 
 

 
如果requests版本是2.12及以上
 
 
import requests
                from requests.adapters import HTTPAdapter
                from requests.packages.urllib3.util.ssl_ import create_urllib3_context
                CIPHERS = (
                    'ECDH+AESGCM:DH+AESGCM:ECDH+AES256:DH+AES256:ECDH+AES128:DH+AES:ECDH+HIGH:'
                    'DH+HIGH:ECDH+3DES:DH+3DES:RSA+AESGCM:RSA+AES:RSA+HIGH:RSA+3DES:!aNULL:'
                    '!eNULL:!MD5'
                )

                class DESAdapter(HTTPAdapter):
                    """
                    A TransportAdapter that re-enables 3DES support in Requests.
                    """

                    def init_poolmanager(self, *args, **kwargs):
                        context = create_urllib3_context(ciphers=CIPHERS)
                        kwargs['ssl_context'] = context
                        return super(DESAdapter, self).init_poolmanager(*args, **kwargs)

                    def proxy_manager_for(self, *args, **kwargs):
                        context = create_urllib3_context(ciphers=CIPHERS)
                        kwargs['ssl_context'] = context
                        return super(DESAdapter, self).proxy_manager_for(*args, **kwargs)

                s = requests.Session()
                s.mount('https://www.zjkill.com/', DESAdapter())
                r = s.get(url)
                r.encoding = 'utf8'
                print r.text
 
 

 
因为我用的python2.7，python3的解决办法就不写，那个更简单，可以自行网上搜索。
附上参考链接Configuring TLS With Requests
 

(tensorflow) C:\Users\pc>pip install dvc -i https://pypi.tuna.tsinghua.edu.cn/simple/
Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple/
WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLEOFError(8, 'EOF occurred in violation of protocol (_ssl.c:749)'),)': /simple/dvc/
WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLEOFError(8, 'EOF occurred in violation of protocol (_ssl.c:749)'),)': /simple/dvc/
WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLEOFError(8, 'EOF occurred in violation of protocol (_ssl.c:749)'),)': /simple/dvc/
WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLEOFError(8, 'EOF occurred in violation of protocol (_ssl.c:749)'),)': /simple/dvc/
WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLEOFError(8, 'EOF occurred in violation of protocol (_ssl.c:749)'),)': /simple/dvc/
Could not fetch URL https://pypi.tuna.tsinghua.edu.cn/simple/dvc/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host='pypi.tuna.tsinghua.edu.cn', port=443): Max retries exceeded with url: /simple/dvc/ (Caused by SSLError(SSLEOFError(8, 'EOF occurred in violation of protocol (_ssl.c:749)'),)) - skipping
ERROR: Could not find a version that satisfies the requirement dvc
ERROR: No matching distribution found for dvc
Could not fetch URL https://pypi.tuna.tsinghua.edu.cn/simple/pip/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host='pypi.tuna.tsinghua.edu.cn', port=443): Max retries exceeded with url: /simple/pip/ (Caused by SSLError(SSLEOFError(8, 'EOF occurred in violation of protocol (_ssl.c:749)'),)) - skipping
 
显然pip是使用国内的python镜像源，没有被墙。
 仔细检测发现，是打开的VPN软件忘记了关闭，关闭以后恢复正常。