TOOL-DB

# setting mysqll connect tools.

## python

```python
import pymysql

def getConnect():
    try:
        connect = pymysql.connect('127.0.0.1', 'tester', 'tester', 'cmdb', 3306)
        return connect
    except Exception as e:
        print( e )

def selectByParameters( sql, params = None ):
    try:
        connect = getConnect()
        cursor = connect.cursor( pymysql.cursors.DictCursor )
        cursor.execute( sql, params )
        result = cursor.fetchall()
        return result
    except Exception as e:
        print( e )
    finally:
        try:
            cursor.close()
        except Exception as e:
            print(e)
        try:
            connect.close()
        except Exception as e:
            print(e)

def updateByParameters( sql, params = None ):
    try:
        connect = getConnect()
        cursor = connect.cursor( pymysql.cursors.DictCursor )
        count = cursor.execute( sql, params )
        connect.commit()
        return count
    except Exception as e:
        connect.rollback()
        print( e )
    finally:
        try:
            cursor.close()
        except Exception as e:
            print(e)
        try:
            connect.close()
        except Exception as e:
            print(e)

#测试查询封装，带查询查询封装
if __name__ == "__main__":
    sql = 'select * from servers'
    result = selectByParameters(sql)
    print( result )

if __name__ == "__main__":
    sql = 'select * from servers where name = %s'
    params = ("nginx", )
    result = selectByParameters(sql, params=params)
    print( result )
```