df2mysql

v0.0.3

提供了一组方法，用于与 Microsoft SQL Server 数据库进行交互。允许执行各种操作，如连接到 SQL Server、创建和删除数据库、创建和删除表、添加和删除列、插入和检索数据等。 For more information about how to use this package see README

Latest version published 1 year ago

License: MIT

PyPI

GitHub

Package Health Score

38 / 100

security
Security review needed
popularity
Limited
maintenance
Inactive
community
Limited

Explore Similar Packages

mysql
55

Popularity

Limited

GitHub Stars: 1
Forks: 1
Contributors: 1

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package df2mysql, we found that it has been starred 1 times.

Security

Security review needed

Security and license risk for latest version

Release Date: Jul 14, 2023
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
1
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

MIT

Security Policy

We found a way for you to contribute to the project! Looks like df2mysql is missing a security policy.

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Inactive

Commit Frequency

No Recent Commits

Open Issues: 0
Open PR: 0
Last Release: 1 year ago
Last Commit: 1 year ago

Further analysis of the maintenance status of df2mysql based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Inactive.

An important project maintenance signal to consider for df2mysql is that it hasn't seen any new versions released to PyPI in the past 12 months, and could be considered as a discontinued project, or that which receives low attention from its maintainers.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Community

Limited

Readme: Yes
Contributing.md: No
Code of Conduct: No
Contributors: 1
Funding: No

This project has seen only 10 or less contributors.

We found a way for you to contribute to the project! Looks like df2mysql is missing a Code of Conduct.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: >=3.7

Age: 1 year
Latest Release: 1 year ago
Dependencies: 2 Direct / 6 Total
Versions: 3
Maintainers: 1
Wheels: OS Independent

Readme

df2mysql 是一个用于连接和操作 Microsoft SQL Server 数据库的 Python 包。它提供了一个名为 Database 的类，可以使用该类的方法执行各种数据库操作，如创建和删除数据库、创建和删除表、插入和检索数据等。

使用方法：以下是使用 df2mysql 包的一般步骤：

安装包：通过运行 pip install df2mysql 安装包。
导入包：在你的 Python 脚本或交互式会话中使用 from df2mysql import Database 导入 Database类。

3.创建 Database 实例：通过创建 Database 类的实例并提供 SQL Server 主机、用户名和密码来建立数据库连接。

db = Database(host='your_host', user='your_username', password='your_password')

4.连接到数据库：使用 connect_db(database) 方法连接到指定的数据库。

db.connect_db(database='your_database')

5.执行数据库操作：使用 Database 类提供的方法执行数据库操作，如创建表、插入数据、检索数据等。

db.create_table(database='your_database', table_name='your_table', table_head=['column1', 'column2'])
db.insert_data(database='your_database', table_name='your_table', data=your_data)
result = db.select_data(database='your_database', table_name='your_table')

6.关闭连接：在完成所有数据库操作后，使用 close() 方法关闭数据库连接。

db.close()

请确保已安装 pymssql 和其他所需的依赖项，并提供正确的数据库连接信息。这样，你就可以使用 df2mysql 包连接到 Microsoft SQL Server 数据库并执行相应的操作了。

df2mysql dependencies

pandas pymssql

FAQs

What is df2mysql?

提供了一组方法，用于与 Microsoft SQL Server 数据库进行交互。允许执行各种操作，如连接到 SQL Server、创建和删除数据库、创建和删除表、添加和删除列、插入和检索数据等。. Visit Snyk Advisor to see a full health score report for df2mysql, including popularity, security, maintenance & community analysis.

Is df2mysql popular?

The python package df2mysql receives a total of 57 weekly downloads. As such, df2mysql popularity was classified as limited. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is df2mysql well maintained?

We found indications that df2mysql is an Inactive project. See the full package health analysis to learn more about the package maintenance status.

Is df2mysql safe to use?

While scanning the latest version of df2mysql, we found that a security review is needed. A total of 0 vulnerabilities or license issues were detected. See the full security scan results.

Last updated on 10 September-2024, at 22:05 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP