semvec/pypi-packages huggingface dataset:
easybd 0.1.2
大数据工具包

A common utils to use 

# db utils

## table info export to excel 

```python
from easybd.db import Mysql
mysql = Mysql("192.168.3.204", "3306", "root", "Mysql@2023", "cs", ["t_a", "t_b"])
mysql.table_info_to_excel("demo.xlsx")

```
<p align="center">
<img src="imgs/dbutil_mysql_01.png"  alt="image" width="300" height="auto">
<img src="imgs/dbutil_mysql_02.png"  alt="image" width="300" height="auto">
</p>


# excel utils
depend on above export excel to output some code,like : ddl, json files

```python
from easybd.db.ddl import DDLType
from easybd.excel import Excel


e = Excel("demo.xlsx")
table = e.get_table("t_cs")

def test_ddl2pg():
    r = e.to_ddl(DDLType.PgSql, table.table_info)
    print(r)

def test_to_json_array():
    e.to_json_array(table)
```
Nash-Geo-Scanner 1.1.0
Geo locator OFFICAL version
Requires Python: >=3.6

# Nash-NetGeoScanner

**Nash-NetGeoScanner** is a Python-based tool that combines network scanning using nmap with IP geolocation retrieval. It allows you to scan networks and obtain geographical information about IP addresses.

## Features

- **Network Scanning:** Perform network scans using nmap. The tool scans a given website link for open ports and other network-related information.
- **IP Geolocation:** Retrieve the geographical location of an IP address using an external API. The tool returns information such as city, region, country, latitude, and longitude.

## Functions

- **sanitize_input:** Cleans and formats the input string to ensure it is in a suitable format for further processing.
- **Nmap:** Scans a website link after sanitizing it, using nmap to gather network information.
- **get_location:** Queries an external API to retrieve geographical data for a given IP address.

## Usage

1. Clone the repository:
   ```bash
   git clone https://github.com/yourusername/Nash-NetGeoScanner.git
   python nash_netgeoscanner.py

Enter the website link and IP address when prompted to perform the scan and retrieve location data.

## Important Notes

Security: Running nmap with elevated permissions (sudo) based on user input can be potentially dangerous. Ensure proper input sanitization and only scan networks/IP addresses you have permission to scan.
API Key Management: Keep your API key secure. Avoid hard-coding it in the script; use environment variables or a secure vault instead.
Nash-Geo-Scanner-1.1.0 1.1.0
Geo locator OFFICAL version
Requires Python: >=3.6

# Nash-NetGeoScanner

**Nash-NetGeoScanner** is a Python-based tool that combines network scanning using nmap with IP geolocation retrieval. It allows you to scan networks and obtain geographical information about IP addresses.

## Features

- **Network Scanning:** Perform network scans using nmap. The tool scans a given website link for open ports and other network-related information.
- **IP Geolocation:** Retrieve the geographical location of an IP address using an external API. The tool returns information such as city, region, country, latitude, and longitude.

## Functions

- **sanitize_input:** Cleans and formats the input string to ensure it is in a suitable format for further processing.
- **Nmap:** Scans a website link after sanitizing it, using nmap to gather network information.
- **get_location:** Queries an external API to retrieve geographical data for a given IP address.

## Usage

1. Clone the repository:
   ```bash
   git clone https://github.com/yourusername/Nash-NetGeoScanner.git
   python nash_netgeoscanner.py

Enter the website link and IP address when prompted to perform the scan and retrieve location data.

## Important Notes

Security: Running nmap with elevated permissions (sudo) based on user input can be potentially dangerous. Ensure proper input sanitization and only scan networks/IP addresses you have permission to scan.
API Key Management: Keep your API key secure. Avoid hard-coding it in the script; use environment variables or a secure vault instead.