README
db_operations is a small tool to simplify the daily operation of the database.
Currently, for MySQL, sqlserver and Oracle databases:
-It can query the fields, data volume and other information of the table in the database.
-Query the tables in the database.
-Gets the record of the table in the database.
-It simplifies the execution of SQL statement query, update and other operations.
For PostgreSQL database:
-The records in the table can be obtained.
-The data can be put into the database in batches.
-It simplifies the execution of SQL statement query, update and other operations.
Installation
db_operations depends on:
- Python(>=3.6)
- pandas
- pymysql
- pymssql
- cx_Oracle
- psycopg2
- io
使用指南
db_operations是一个简化日常操作数据库的小工具。
目前针对MySQL,SqlServer及Oracle数据库:
-
可查询数据库中表的字段、数据量等信息。
-
查询数据库中表的条目。
-
获取数据库中表的记录。
-
简化了执行SQL语句查询、更新等操作。
针对postgresql数据库:
- 可获取表中记录。
- 可将数据批量放入数据库。
- 简化了执行SQL语句查询、更新等操作。
安装
db_operations依赖于:
- Python(>=3.6)
- pandas
- pymysql
- pymssql
- cx_Oracle
- psycopg2
- io