8.9-python管理

一、回顾

[root@python ~]# vim test.py
​
a=3
b=4
print(a+b)
print(a**2+b**2)
print(25**0.5)
​
[root@python ~]# python3 test.py 
7
25
5.0
​
​
#调试test.py脚本
[root@python ~]# python3 -m pdb test.py 
> /root/test.py(1)<module>()
-> a=3
(Pdb) n
> /root/test.py(2)<module>()
-> b=4
(Pdb) n
> /root/test.py(3)<module>()
-> print(a+b)
(Pdb) n
7
> /root/test.py(4)<module>()
-> print(a**2+b**2)
(Pdb) n
25
> /root/test.py(5)<module>()
-> print(25**0.5)
(Pdb) n
5.0
--Return--
> /root/test.py(5)<module>()->None
-> print(25**0.5)
​
​
​
[root@python ~]# python3
Python 3.6.8 (default, Nov 14 2023, 16:29:52) 
[GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import random
>>> random
<module 'random' from '/usr/lib64/python3.6/random.py'>
>>> 
[1]+  已停止               python3
[root@python ~]# vim /usr/lib64/python3.6/random.py
[root@python ~]# fg
python3
​
​
>>> random
<module 'random' from '/usr/lib64/python3.6/random.py'>
>>> random.randint(0,10)
9
>>> random.randint(0,10)
2
>>> random.randint(0,10)
8
>>> random.randint(0,10)
4

二、python管理

1.方法一

1.设置清华镜像（从国内下载安装包，提高下载和安装速度）

2.安装pandas数据分析工具（pandas是知名的数据分析工具，pandas有完整的数据读取工具，以及DateFrame数据框架，用于保存从数据库中读取的数据 ）

3.安装pymysql连接器（oracle为开发者提供的python管理mysql 的⼯具，通过这个⼯具，就恶意在不替原有代码的情况下，应对 数据库软件的升级）

[root@python ~]# pip3 config set global.index-url https://pypi.tuna.tsinghua.edu.cn/simple
​
[root@python ~]# pip3 install pymysql
​
[root@python ~]# pip3 install pandas

>>> import pandas
>>> import pymysql
>>> import pandas
>>> import whel
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ModuleNotFoundError: No module named 'whel'
>>> pymysql
<module 'pymysql' from '/usr/local/lib64/python3.6/site-packages/pymysql/__init__.py'>
>>> pandas
<module 'pandas' from '/usr/local/lib64/python3.6/site-packages/pandas/__init__.py'>
>>> import pymysql as pm
>>> import pandas as pd
>>> pm
<module 'pymysql' from '/usr/local/lib64/python3.6/site-packages/pymysql/__init__.py'>
>>> pd
<module 'pandas' from '/usr/local/lib64/python3.6/site-packages/pandas/__init__.py'>
​
>>> conn=pm.connect(
... host='123.249.27.70',
... user='abcd',
... password='abcd',
... database='test',
... port=6001);
>>> conn
<pymysql.connections.Connection object at 0x7fc060751400>
>>> cursor=conn.cursor()
>>> cursor
<pymysql.cursors.Cursor object at 0x7fc060e87860>
>>> sql="select * from student"
>>> sql
'select * from student'
>>> cursor.execute(sql)
5
>>>  cursor.fetchall()
  File "<stdin>", line 1
    cursor.fetchall()
    ^
IndentationError: unexpected indent
>>> cursor.fetchall()
((1, '章三', '男'), (2, '李四', '女'), (3, '小凤仙', '女'), (4, '章丘铁锅', '男'), (6, '孙颖莎', '女'))
>>> cursor.description
(('id', 3, None, 11, 11, 0, False), ('name', 253, None, 180, 180, 0, False), ('gender', 253, None, 16, 16, 0, False))
>>> head=[]
>>> desc=cursor.description
>>> for var in desc:
...     print(var[0])
... 
id
name
gender
>>> for var in desc:
...     head.append(var[0])
... 
>>> head
['id', 'name', 'gender']
>>> pd.DataFrame(data=cursor.fetchall(),columns=head)
Empty DataFrame
Columns: [id, name, gender]
Index: []
>>> cursor.fetchall()
()
>>> cursor.execute(sql)
5
>>> res=cursor.fetchall()
>>> res
((1, '章三', '男'), (2, '李四', '女'), (3, '小凤仙', '女'), (4, '章丘铁锅', '男'), (6, '孙颖莎', '女'))
>>> head
['id', 'name', 'gender']
>>> pd.DataFrame(data=res,columns=head)
   id  name gender
0   1    章三      男
1   2    李四      女
2   3   小凤仙      女
3   4  章丘铁锅      男
4   6   孙颖莎      女
>>>

2.方法二

[root@python ~]# vim python_mysql.py
​
class Python_Mysql_01(object):
​
        def __init__(self):
                print("test")
​
if __name__=="__main__":
                pmp1=Python_Mysql_01()
        
[root@python ~]# python3 python_mysql.py
test           

import pymysql
​
class Python_Mysql_01(object):
​
        def __init__(self):
                print("test")
        def getConn(self):
                conn=pymysql.connect(
                        host='123.249.27.70',
                        user='abcd',
                        password='abcd',
                        database='test',
                        port=6001
                )
                print(conn)
                return conn
​
if __name__=="__main__":
        #初始化Python_Mysql_01类，创建实例，pmp，之后所有的方法都可以在实列中调用
        pmp=Python_Mysql_01()
        pmp.getConn()
        
[root@python ~]# python3 python_mysql.py
test
<pymysql.connections.Connection object at 0x7f9952e396a0>
​

import pymysql
​
class Python_Mysql_01(object):
​
        def __init__(self):
                print("test")
        def getConn(self):
                conn=pymysql.connect(
                        host='123.249.27.70',
                        user='abcd',
                        password='abcd',
                        database='test',
                        port=6001
                )
#               print(conn)
                return conn
​
if __name__=="__main__":
        #初始化Python_Mysql_01类，创建实例，pmp，之后所有的方法都可以在实列中调用
        pmp=Python_Mysql_01()
        # 获得conn
        conn=pmp.getConn()
        #获得游标
        cursor=conn.cursor()
        print(cursor)
[root@python ~]# python3 python_mysql.py
test
<pymysql.cursors.Cursor object at 0x7f99af8e0d30>
​
​

[root@python ~]# vim  python_mysql_01 
​
import pymysql
import pandas
​
class Python_Mysql_01(object):
​
    def __init__(self):
        print("======================")
​
    def getConn(self):
        conn=pymysql.connect(
            host=input("sign host_ip|name:"),
            user=input("sign database username:"),
            password=input("sign database password:"),
            database=input("sign database name:"),
            port=int(input("sign port no "))
        )
#       print(conn)
        return conn
​
    def getRes(self,cursor,sql):
        cursor.execute(sql)
​
        # 获得查询的数据
        data=cursor.fetchall()
​
        # 表头
        head=[item[0] for item in cursor.description]
                
        # 组成pandas数据框 DataFrame
        return pandas.DataFrame(data=data,columns=head)
​
if __name__=="__main__":
    # 初始化Python_Mysql_01类，创建实例，pmp，之后所有的方法都可以在实例中调用
    pmp=Python_Mysql_01()
    # 获得conn
    conn=pmp.getConn()
​
    #获得游标   
    cursor=conn.cursor()
#   print(cursor)
    tablename=input("sign tablename")
    df=pmp.getRes(cursor,"select * from "+tablename)
    print(df)   
​

[root@python ~]# python3 -m pip install --upgrade pip
​
[root@python ~]# which pyinstaller
/usr/local/bin/pyinstaller
[root@python ~]# pyinstaller --onefile python_mysql_01.py 
​
[root@python ~]# ls
anaconda-ks.cfg  dist    py001.py  py003.py     python_mysql_01.py    python_mysql.py
build            for.py  py002.py  __pycache__  python_mysql_01.spec  test.py
[root@python ~]# cd dist/
[root@python dist]# ls
python_mysql_01
​
​
​
[root@python dist]# ./python_mysql_01 
​
sign host_ip|name:123.249.27.70
sign database username:abcd
sign database password:abcd
sign database name:test
sign port no 6001
sign tablenamestudent
   id  name gender
0   1    章三      男
1   2    李四      女
2   3   小凤仙      女
3   4  章丘铁锅      男
4   6   孙颖莎      女
​
​

[root@python dist]# cd
[root@python ~]# python3 -m http.server 9000
​
Serving HTTP on 0.0.0.0 port 9000 (http://0.0.0.0:9000/) ...
192.168.2.1 - - [09/Aug/2024 17:36:42] "GET / HTTP/1.1" 200 -
192.168.2.1 - - [09/Aug/2024 17:36:42] code 404, message File not found
192.168.2.1 - - [09/Aug/2024 17:36:42] "GET /favicon.ico HTTP/1.1" 404 -

浏览器访问：192.168.2.40:9000

后台运行
​
[root@python ~]# nohup python3 -m http.server 9000 &
[3] 2740
[root@python ~]# nohup: 忽略输入并把输出追加到"nohup.out"