pip

curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
- python get-pip.py
C:\python27\scirpts下运行 easy_install pip

修改更新源

linux ~/.pip/pip.conf

1 2	[global] index-url = https://pypi.tuna.tsinghua.edu.cn/simple

windows C:\Users\xx\pip\pip.ini

[global]
timeout = 60
index-url = https://pypi.tuna.tsinghua.edu.cn/simple
trusted-host = pypi.tuna.tsinghua.edu.cn

virtualenv

1
2
3

pip install virtualenv
virtualenv --system-site-packages venv
source ./Scripts/activate

HTTP服务器

python -m http.server -h
pyhton -m http.server 80           #pyhton3中启动方式，开启的端口为80
python2 -m SimpleHTTPServer 8080    #python2启动方式

wget http://xxx/filename

上传

#!/usr/bin/env python
# This runs an HTTP server on port 8000 (or the first command line argument)
"""Simple HTTP Server With Upload. for python2
https://github.com/tualatrix/tools/blob/master/SimpleHTTPServerWithUpload.py
This module builds on BaseHTTPServer by implementing the standard GET
and HEAD requests in a fairly straightforward manner.
"""
 
 
import os
import posixpath
import BaseHTTPServer
import urllib
import cgi
import shutil
import mimetypes
import re
 
try:
    from cStringIO import StringIO
except ImportError:
    from StringIO import StringIO
 
 
class SimpleHTTPRequestHandler(BaseHTTPServer.BaseHTTPRequestHandler):
 
    """Simple HTTP request handler with GET/HEAD/POST commands.
    This serves files from the current directory and any of its
    subdirectories.  The MIME type for files is determined by
    calling the .guess_type() method. And can reveive file uploaded
    by client.
    The GET/HEAD/POST requests are identical except that the HEAD
    request omits the actual contents of the file.
    """
 
    #server_version = "SimpleHTTPWithUpload/" + __version__
 
    def do_GET(self):
        """Serve a GET request."""
        f = self.send_head()
        if f:
            self.copyfile(f, self.wfile)
            f.close()
 
    def do_HEAD(self):
        """Serve a HEAD request."""
        f = self.send_head()
        if f:
            f.close()
 
    def do_POST(self):
        """Serve a POST request."""
        r, info = self.deal_post_data()
        print r, info, "by: ", self.client_address
        f = StringIO()
        f.write('<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">')
        f.write("<html>\n<title>Upload Result Page</title>\n")
        f.write("<body>\n<h2>Upload Result Page</h2>\n")
        f.write("<hr>\n")
        if r:
            f.write("<strong>Success:</strong>")
        else:
            f.write("<strong>Failed:</strong>")
        f.write(info)
        f.write("<br><a href=\"%s\">back</a>" % self.headers['referer'])
        f.write("<hr><small>Powered By: bones7456, check new version at ")
        f.write("<a href=\"http://li2z.cn/?s=SimpleHTTPServerWithUpload\">")
        f.write("here</a>.</small></body>\n</html>\n")
        length = f.tell()
        f.seek(0)
        self.send_response(200)
        self.send_header("Content-type", "text/html")
        self.send_header("Content-Length", str(length))
        self.end_headers()
        if f:
            self.copyfile(f, self.wfile)
            f.close()
 
    def deal_post_data(self):
        boundary = self.headers.plisttext.split("=")[1]
        remainbytes = int(self.headers['content-length'])
        line = self.rfile.readline()
        remainbytes -= len(line)
        if boundary not in line:
            return (False, "Content NOT begin with boundary")
        line = self.rfile.readline()
        remainbytes -= len(line)
        fn = re.findall(r'Content-Disposition.*name="file"; filename="(.*)"', line)
        if not fn:
            return (False, "Can't find out file name...")
        path = self.translate_path(self.path)
        fn = os.path.join(path, fn[0])
        while os.path.exists(fn):
            fn += "_"
        line = self.rfile.readline()
        remainbytes -= len(line)
        line = self.rfile.readline()
        remainbytes -= len(line)
        try:
            out = open(fn, 'wb')
        except IOError:
            return (False, "Can't create file to write, do you have permission to write?")
 
        preline = self.rfile.readline()
        remainbytes -= len(preline)
        while remainbytes > 0:
            line = self.rfile.readline()
            remainbytes -= len(line)
            if boundary in line:
                preline = preline[0:-1]
                if preline.endswith('\r'):
                    preline = preline[0:-1]
                out.write(preline)
                out.close()
                return (True, "File '%s' upload success!" % fn)
            else:
                out.write(preline)
                preline = line
        return (False, "Unexpect Ends of data.")
 
    def send_head(self):
        """Common code for GET and HEAD commands.
        This sends the response code and MIME headers.
        Return value is either a file object (which has to be copied
        to the outputfile by the caller unless the command was HEAD,
        and must be closed by the caller under all circumstances), or
        None, in which case the caller has nothing further to do.
        """
        path = self.translate_path(self.path)
        f = None
        if os.path.isdir(path):
            if not self.path.endswith('/'):
                # redirect browser - doing basically what apache does
                self.send_response(301)
                self.send_header("Location", self.path + "/")
                self.end_headers()
                return None
            for index in "index.html", "index.htm":
                index = os.path.join(path, index)
                if os.path.exists(index):
                    path = index
                    break
            else:
                return self.list_directory(path)
        ctype = self.guess_type(path)
        try:
            # Always read in binary mode. Opening files in text mode may cause
            # newline translations, making the actual size of the content
            # transmitted *less* than the content-length!
            f = open(path, 'rb')
        except IOError:
            self.send_error(404, "File not found")
            return None
        self.send_response(200)
        self.send_header("Content-type", ctype)
        fs = os.fstat(f.fileno())
        self.send_header("Content-Length", str(fs[6]))
        self.send_header("Last-Modified", self.date_time_string(fs.st_mtime))
        self.end_headers()
        return f
 
    def list_directory(self, path):
        """Helper to produce a directory listing (absent index.html).
        Return value is either a file object, or None (indicating an
        error).  In either case, the headers are sent, making the
        interface the same as for send_head().
        """
        try:
            list = os.listdir(path)
        except os.error:
            self.send_error(404, "No permission to list directory")
            return None
        list.sort(key=lambda a: a.lower())
        f = StringIO()
        displaypath = cgi.escape(urllib.unquote(self.path))
        f.write('<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">')
        f.write("<html>\n<title>Directory listing for %s</title>\n" % displaypath)
        f.write("<body>\n<h2>Directory listing for %s</h2>\n" % displaypath)
        f.write("<hr>\n")
        f.write("<form ENCTYPE=\"multipart/form-data\" method=\"post\">")
        f.write("<input name=\"file\" type=\"file\"/>")
        f.write("<input type=\"submit\" value=\"upload\"/></form>\n")
        f.write("<hr>\n<ul>\n")
        for name in list:
            fullname = os.path.join(path, name)
            displayname = linkname = name
            # Append / for directories or @ for symbolic links
            if os.path.isdir(fullname):
                displayname = name + "/"
                linkname = name + "/"
            if os.path.islink(fullname):
                displayname = name + "@"
                # Note: a link to a directory displays with @ and links with /
            f.write('<li><a href="%s">%s</a>\n'
                    % (urllib.quote(linkname), cgi.escape(displayname)))
        f.write("</ul>\n<hr>\n</body>\n</html>\n")
        length = f.tell()
        f.seek(0)
        self.send_response(200)
        self.send_header("Content-type", "text/html")
        self.send_header("Content-Length", str(length))
        self.end_headers()
        return f
 
    def translate_path(self, path):
        """Translate a /-separated PATH to the local filename syntax.
        Components that mean special things to the local file system
        (e.g. drive or directory names) are ignored.  (XXX They should
        probably be diagnosed.)
        """
        # abandon query parameters
        path = path.split('?', 1)[0]
        path = path.split('#', 1)[0]
        path = posixpath.normpath(urllib.unquote(path))
        words = path.split('/')
        words = filter(None, words)
        path = os.getcwd()
        for word in words:
            drive, word = os.path.splitdrive(word)
            head, word = os.path.split(word)
            if word in (os.curdir, os.pardir):
                continue
            path = os.path.join(path, word)
        return path
 
    def copyfile(self, source, outputfile):
        """Copy all data between two file objects.
        The SOURCE argument is a file object open for reading
        (or anything with a read() method) and the DESTINATION
        argument is a file object open for writing (or
        anything with a write() method).
        The only reason for overriding this would be to change
        the block size or perhaps to replace newlines by CRLF
        -- note however that this the default server uses this
        to copy binary data as well.
        """
        shutil.copyfileobj(source, outputfile)
 
    def guess_type(self, path):
        """Guess the type of a file.
        Argument is a PATH (a filename).
        Return value is a string of the form type/subtype,
        usable for a MIME Content-type header.
        The default implementation looks the file's extension
        up in the table self.extensions_map, using application/octet-stream
        as a default; however it would be permissible (if
        slow) to look inside the data to make a better guess.
        """
 
        base, ext = posixpath.splitext(path)
        if ext in self.extensions_map:
            return self.extensions_map[ext]
        ext = ext.lower()
        if ext in self.extensions_map:
            return self.extensions_map[ext]
        else:
            return self.extensions_map['']
 
    if not mimetypes.inited:
        mimetypes.init()  # try to read system mime.types
    extensions_map = mimetypes.types_map.copy()
    extensions_map.update({
        '': 'application/octet-stream',  # Default
        '.py': 'text/plain',
        '.c': 'text/plain',
        '.h': 'text/plain',
        })
 
 
def test(HandlerClass=SimpleHTTPRequestHandler,
         ServerClass=BaseHTTPServer.HTTPServer):
    BaseHTTPServer.test(HandlerClass, ServerClass)
 
if __name__ == '__main__':
    test()

FTP服务器

pip install pyftpdlib
# 默认 IP 为本机所有可用 IP，端口为 2121，匿名，只读
python -m pyftpdlib

#指定参数
python -m pyftpdlib -i 192.168.100.49 -w -d /tmp/ -u mike -P 123456

转exe



pip install pyinstaller
C:\Users\Manhua\AppData\Local\Programs\Python\Python38\Scripts\pyinstaller.exe -w --onefile --hidden-import PySide6 .\QTImgClassifier.py

-F：仅仅生成一个文件，不暴露其他信息，启动较慢。
-D：生成一个文件夹，里面是多文件模式，启动快。
-w：窗口模式打包，不显示控制台。
-c：跟图标路径，作为应用icon。
–-hidden-import 应用需要的包，但是没有被打包进来，这里的错误是最多的，因为一般是第三方包隐式调用其他包，然后打包出来的程序显示Fatal Error不能运行。

使用pyinstaller打包的时候有看到缺少api-ms-win-core-path-l1-1-0.dll的警告，尝试下载这个DLL确依然不能解决问题。
是因为Python3.9已经不再支持Win7了，最后发布二进制的是Python3.8.10 https://www.python.org/ftp/python/3.8.10/


pip install py2exe
先写一个简单的脚本，文件名：helloworld.py
还需要个用于发布程序的设置脚本：mysetup.py
```python
from distutils.core import setup
import py2exe
from setuptools import find_packages

options = {
    "py2exe":
        {
            "compressed": 1,  # 压缩
            "optimize": 2,
            "bundle_files": 1  # 所有文件打包成一个 exe 文件
        }
}
setup(
    options=options,
    zipfile=None,
    packages=find_packages(
        where='network/auth/requests',
        include=['*'],  # alternatively: `exclude=['additional*']`
    ),
    console=["NetworkHelper.py"])

python mysetup.py py2exe

整个dist目录发布

===
pip install nuitka
https://sourceforge.net/projects/mingw-w64/files/mingw-w64/mingw-w64-release/
x86_64-7.3.0-release-win32-seh-rt_v5-rev0.7z

python -m nuitka –disable-console –show-memory –show-progress –standalone –plugin-enable=pyside6 hello.py
python -m nuitka –onefile hello.py [make sure that the mere standalone is working, before turning to single file]

–disable-console

pyHive

from pyhive import hive
conn = hive.connect(host = '10.xx',      # 主机
                    port = 10199,                  # 端口 
                    database = 'dw',            # 数据库
                    auth = 'CUSTOM',                 
                    username = 'zeppelin',                 
                    password = 'xxx')

# 自行查询
cursor = conn.cursor()
cursor.execute('select 1')
for result in cursor.fetchall():
    print(result)
cursor.close() 
conn.close()

# 使用pandas
import pandas as pd
pd.read_sql_query('select * from dim.xx limit 3'
                 ,conn)

sqlAlchemy

from sqlalchemy.engine import create_engine
hive_engine = create_engine("hive://zeppelin:passowrd@10.xx:10199?auth=CUSTOM")
import pandas as pd

pd.set_option('display.max_rows', 1000) # 打印最大行数
pd.set_option('display.max_columns', 100)# 打印最大列数
pd.set_option('display.max_colwidth', 100)

sql = """
select * from dim.mcloud_behavior limit 3
"""
pd.read_sql_query(sql,hive_engine)

函数参数提示

在函数后面输入问号后执行即可查看文档