base on SQL 审核查询平台 <div align="center"> # <a href="https://archerydms.com/" target="_blank" rel="noopener noreferrer">Archery</a> <h4> SQL 审核查询平台<h4> [](https://github.com/hhyo/Archery/actions/workflows/django.yml) [](https://github.com/hhyo/archery/releases/) [](https://codecov.io/gh/hhyo/archery) [](https://img.shields.io/pypi/pyversions/django/) [](https://docs.djangoproject.com/zh-hans/4.1/) [](https://github.com/hhyo/Archery/actions/workflows/docker-image.yml) [](https://hub.docker.com/r/hhyo/archery/) [](http://github.com/hhyo/archery/blob/master/LICENSE) [](https://github.com/psf/black) [文档](https://archerydms.com/) | [FAQ](https://github.com/hhyo/archery/wiki/FAQ) | [Releases](https://github.com/hhyo/archery/releases/)  </div> 功能清单 ==== | 数据库 | 查询 | 审核 | 执行 | 备份 | 数据字典 | 慢日志 | 会话管理 | 账号管理 | 参数管理 | 数据归档 | |------------| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | MySQL | √ | √ | √ | √ | √ | √ | √ | √ | √ | √ | | MsSQL | √ | × | √ | × | √ | × | × | × | × | × | | Redis | √ | × | √ | × | × | × | × | × | × | × | | PgSQL | √ | × | √ | × | × | × | × | × | × | × | | Oracle | √ | √ | √ | √ | √ | × | √ | × | × | × | | MongoDB | √ | √ | √ | × | × | × | √ | √ | × | × | | Phoenix | √ | × | √ | × | × | × | × | × | × | × | | ODPS | √ | × | × | × | × | × | × | × | × | × | | ClickHouse | √ | √ | √ | × | × | × | × | × | × | × | | Cassandra | √ | × | √ | × | × | × | × | × | × | × | | Doris | √ | × | √ | × | × | × | × | × | × | × | 快速开始 =============== ### 系统体验 [在线体验](https://demo.archerydms.com) | 账号 | 密码 | | --- | --- | | archer | archer | ### Docker 参考 https://github.com/hhyo/archery/wiki/docker 手动安装 =============== [部署说明](https://github.com/hhyo/archery/wiki/manual) 运行测试 =============== ``` python manage.py test -v 3 ``` 依赖清单 =============== ### 框架 - [Django](https://github.com/django/django) - [Bootstrap](https://github.com/twbs/bootstrap) - [jQuery](https://github.com/jquery/jquery) ### 前端组件 - 菜单栏 [metisMenu](https://github.com/onokumus/metismenu) - 主题 [sb-admin-2](https://github.com/BlackrockDigital/startbootstrap-sb-admin-2) - 编辑器 [ace](https://github.com/ajaxorg/ace) - SQL美化 [sql-formatter](https://github.com/zeroturnaround/sql-formatter) - 表格 [bootstrap-table](https://github.com/wenzhixin/bootstrap-table) - 表格编辑 [bootstrap-editable](https://github.com/vitalets/x-editable) - 下拉菜单 [bootstrap-select](https://github.com/snapappointments/bootstrap-select) - 文件上传 [bootstrap-fileinput](https://github.com/kartik-v/bootstrap-fileinput) - 时间选择 [bootstrap-datetimepicker](https://github.com/smalot/bootstrap-datetimepicker) - 日期选择 [daterangepicker](https://github.com/dangrossman/daterangepicker) - 开关 [bootstrap-switch](https://github.com/Bttstrp/bootstrap-switch) - Markdown展示 [marked](https://github.com/markedjs/marked) ### 服务端 - 队列任务 [django-q](https://github.com/Koed00/django-q) - MySQL Connector [mysqlclient-python](https://github.com/PyMySQL/mysqlclient-python) - MsSQL Connector [pyodbc](https://github.com/mkleehammer/pyodbc) - Redis Connector [redis-py](https://github.com/andymccurdy/redis-py) - PostgreSQL Connector [psycopg2](https://github.com/psycopg/psycopg2) - Oracle Connector [cx_Oracle](https://github.com/oracle/python-cx_Oracle) - MongoDB Connector [pymongo](https://github.com/mongodb/mongo-python-driver) - Phoenix Connector [phoenixdb](https://github.com/lalinsky/python-phoenixdb) - ODPS Connector [pyodps](https://github.com/aliyun/aliyun-odps-python-sdk) - ClickHouse Connector [clickhouse-driver](https://github.com/mymarilyn/clickhouse-driver) - SQL解析/切分/类型判断 [sqlparse](https://github.com/andialbrecht/sqlparse) - MySQL Binlog解析/回滚 [python-mysql-replication](https://github.com/noplay/python-mysql-replication) - LDAP [django-auth-ldap](https://github.com/django-auth-ldap/django-auth-ldap) - 序列化 [simplejson](https://github.com/simplejson/simplejson) - 时间处理 [python-dateutil](https://github.com/paxan/python-dateutil) ### 功能依赖 - 可视化 [pyecharts](https://github.com/pyecharts/pyecharts) - MySQL审核/执行/备份 [goInception](https://github.com/hanchuanchuan/goInception)|[inception](https://github.com/hhyo/inception) - MySQL索引优化 [SQLAdvisor](https://github.com/Meituan-Dianping/SQLAdvisor) - SQL优化/压缩 [SOAR](https://github.com/XiaoMi/soar) - My2SQL [my2sql](https://github.com/liuhr/my2sql) - 表结构同步 [SchemaSync](https://github.com/hhyo/SchemaSync) - 慢日志解析展示 [pt-query-digest](https://www.percona.com/doc/percona-toolkit/3.0/pt-query-digest.html)|[aquila_v2](https://github.com/thinkdb/aquila_v2) - 大表DDL [gh-ost](https://github.com/github/gh-ost)|[pt-online-schema-change](https://www.percona.com/doc/percona-toolkit/3.0/pt-online-schema-change.html) - MyBatis XML解析 [mybatis-mapper2sql](https://github.com/hhyo/mybatis-mapper2sql) - RDS管理 [aliyun-openapi-python-sdk](https://github.com/aliyun/aliyun-openapi-python-sdk) - 数据加密 [django-mirage-field](https://github.com/luojilab/django-mirage-field) 贡献代码 =============== 可查阅主页的开发计划以及依赖清单，在对应Issues中回复认领，或者直接提交PR，感谢你对Archery的贡献 贡献包括但不限于以下方式： - [Wiki文档](https://github.com/hhyo/Archery/wiki)（开放编辑） - Bug修复 - 新功能提交 - 代码优化 - 测试用例完善 交流反馈 =============== - 使用咨询、需求沟通：[Discussions](https://github.com/hhyo/Archery/discussions) - Bug提交：[Issues](https://github.com/hhyo/archery/issues) 致谢 =============== - [archer](https://github.com/jly8866/archer) Archery 项目是基于 archer 二次开发而来 - [goInception](https://github.com/hanchuanchuan/goInception) 一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具 - [JetBrains Open Source](https://www.jetbrains.com/zh-cn/opensource/?from=archery) 为项目提供免费的 IDE 授权 [<img src="https://resources.jetbrains.com/storage/products/company/brand/logos/jb_beam.png" width="200"/>](https://www.jetbrains.com/opensource/) ", Assign "at most 3 tags" to the expected json: {"id":"2594","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"