1 Star 0 Fork 0

Kook / HiSql.Gui

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
贡献代码
同步代码
取消
提示: 由于 Git 不支持空文件夾,创建文件夹后会生成空的 .keep 文件
Loading...
README
Apache-2.0

HiSql.Gui

HiSql发布时,我们就说过HiSql不仅是一个ORM框架!HiSql.GUI 是基于开源HiSql开发的一个带GUI界面的跨数据基础管理工具,提供了表创建、修改、删除等基于表的操作,同时也提供了表数据的操作如批量的数据导入导出,根据数据生成图形报表。为了节省后端开发量对表的增、删、查、改可以动态的生成API接口,后续我们将会持续维护此开源项目。

HiSql.GUI源码

HiSql.GUI的源码分成两部分前端和后台

前端源码

通过vscode 打开WEB 目录 通过命令 npm install 安装完成后再通过npm run build 编译生成前端代码在dist 目录 将编译生成的前端代码拷至后端源码HiSql.GUI 项目下的wwwroot 目录

后端源码

通过visual studio 打开 Server目录下的HiGui.sln 解决方案,运行HiSql.Gui.WebApi

注意:HiSql.Gui.WebApi 默认引用的是nuget上的HiSql.Gui.dll 如果需要测试本地的请引用项目HiSql.GUI.csproj

连接配置

在站点配置appsettings.jsonappsettings.Development.json 如下让所示

{
  "Kestrel": {
    "EndPoints": {
      "Http": {
        "Url": "http://*:5170"
      }
    }
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "HiGui": {
    "SiteUrl": "http://127.0.0.1:5170",
    /*连接字符串*/
    "DbConnection": {
      "DbType": "SqlServer",
      "DbServer": "Hone_HiData",
      //"ConnectionString": "server=(local);uid=sa;pwd=Hone@123;database=Hone;Encrypt=True; TrustServerCertificate=True;",
      "ConnectionString": "server=192.168.10.88,7433;uid=sa;pwd=abcabc;database=Hone_HiData;;Encrypt=True; TrustServerCertificate=True;",
      "Schema": "dbo"
    }
  }
}

HiSql.Gui 支持多种数据库 只要是HiSql支持的库都可以. HiGui.DbConnection.DbType 该节点可配置当前使用的数据类型 注意当前类型一定引用HiSql支持的数据库包

启动

  • 第一步

    打开项目配置文件 Server/HiSql.Gui.WebApi/appsettings.Development.json,修改连接数据库连接字符串

image

  • 第二步

    编译启动项目,访问地址

    默认地址:http://127.0.0.1:5170/hidataweb/index.html#/login

    帐号:hisql 密码:123456

用户登录

表创建

表结构

当HiSql GUI启动后会自动扫描数据库中所有表结构,自动建立和缓存表结构信息. 后续对表的结构操作和表信息和字段操作都会自动在Hi_TabModelHi_FieldModel 保存起来.

系统表:

 `Hi_TabModel` :表基本信息
 `Hi_FieldModel`:表字段基本信息
 `Hi_FieldModelExt`:表字段扩展信息表,主要存放表字段高级配置
 `Hi_Domain`:系统中枚举数据
 `Hi_DataElement`:系统枚举值保存表
 `Hi_DataType`:数据库表字段类型
 `Hi_Version`:HiSql版本信息
 `Hi_UserInfo`:登录用户信息
 `Hi_UserRole`:用户角色信息
 `Hi_Api`:HiApi 主体信息表
 `Hi_ApiBlock`:HiApi 代码块信息表
 `Hi_ApiParam`:HiApi 代码块参数表
 `Hi_ViewExt`: 视图设计信息存储表

创建表步骤:

点击数据表=>再点创建=>填写表名和表描述,注意:==表名只能是英文==,因为会做为最终物理表的名字 image

  • 默认有4个标准字段,建议添加CreateTime,CreateName,ModiTime,ModiName
  • 如果有excel,可以选择excel列导入,导入后再修改列类型,设置好主键即可保存.
  • 也可以点击增加列来新增字段,或者点复制表字段快速复制其他表的列
  • 注意: ==切记设置主键列==

表索引:

勾选要创建的索引列保存即可以创建索引 image

表数据:

展示当前表里存在的数据,也可以对表数据进行CURD

API

针对每个数据表我们都生成了可以直接增,删,改,查的Api接口,以及完整的文档描述 image

图表

针对当前数据库的数据表,可以创建分析图表

视图

可以通过视图设计器创建视图,其他操作和数据表基本一致

数据接口

数据接口是为了快速创建API

image 功能开发目标:

  • HiSql查询功能块
  • JavaScript逻辑功能模块
  • 日志收集
  • 性能监控
  • 单元测试

一个数据接口由多个功能块构成,每个功能块由入参,出参,功能体构成,功能体可以是HiSQL,TS代码,或者功能函数.

image

定时任务

目前定时任务支持SQL数据自动定时导出到新表,自动导出并推送到指定Url地址,后续会结合数据接口实现更加高级的功能

HiSQL定时任务

image

Excel模板数据导出

image

Apache License Version 2.0, January 2022 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions for use, reproduction, and distribution as defined by Sections 1 through 9 of this document. "Licensor" shall mean the copyright owner or entity authorized by the copyright owner that is granting the License. "Legal Entity" shall mean the union of the acting entity and all other entities that control, are controlled by, or are under common control with that entity. For the purposes of this definition, "control" means (i) the power, direct or indirect, to cause the direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial ownership of such entity. "You" (or "Your") shall mean an individual or Legal Entity exercising permissions granted by this License. "Source" form shall mean the preferred form for making modifications, including but not limited to software source code, documentation source, and configuration files. "Object" form shall mean any form resulting from mechanical transformation or translation of a Source form, including but not limited to compiled object code, generated documentation, and conversions to other media types. "Work" shall mean the work of authorship, whether in Source or Object form, made available under the License, as indicated by a copyright notice that is included in or attached to the work (an example is provided in the Appendix below). "Derivative Works" shall mean any work, whether in Source or Object form, that is based on (or derived from) the Work and for which the editorial revisions, annotations, elaborations, or other modifications represent, as a whole, an original work of authorship. For the purposes of this License, Derivative Works shall not include works that remain separable from, or merely link (or bind by name) to the interfaces of, the Work and Derivative Works thereof. "Contribution" shall mean any work of authorship, including the original version of the Work and any modifications or additions to that Work or Derivative Works thereof, that is intentionally submitted to Licensor for inclusion in the Work by the copyright owner or by an individual or Legal Entity authorized to submit on behalf of the copyright owner. For the purposes of this definition, "submitted" means any form of electronic, verbal, or written communication sent to the Licensor or its representatives, including but not limited to communication on electronic mailing lists, source code control systems, and issue tracking systems that are managed by, or on behalf of, the Licensor for the purpose of discussing and improving the Work, but excluding communication that is conspicuously marked or otherwise designated in writing by the copyright owner as "Not a Contribution." "Contributor" shall mean Licensor and any individual or Legal Entity on behalf of whom a Contribution has been received by Licensor and subsequently incorporated within the Work. 2. Grant of Copyright License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare Derivative Works of, publicly display, publicly perform, sublicense, and distribute the Work and such Derivative Works in Source or Object form. 3. Grant of Patent License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, use, offer to sell, sell, import, and otherwise transfer the Work, where such license applies only to those patent claims licensable by such Contributor that are necessarily infringed by their Contribution(s) alone or by combination of their Contribution(s) with the Work to which such Contribution(s) was submitted. If You institute patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Work or a Contribution incorporated within the Work constitutes direct or contributory patent infringement, then any patent licenses granted to You under this License for that Work shall terminate as of the date such litigation is filed. 4. Redistribution. You may reproduce and distribute copies of the Work or Derivative Works thereof in any medium, with or without modifications, and in Source or Object form, provided that You meet the following conditions: (a) You must give any other recipients of the Work or Derivative Works a copy of this License; and (b) You must cause any modified files to carry prominent notices stating that You changed the files; and (c) You must retain, in the Source form of any Derivative Works that You distribute, all copyright, patent, trademark, and attribution notices from the Source form of the Work, excluding those notices that do not pertain to any part of the Derivative Works; and (d) If the Work includes a "NOTICE" text file as part of its distribution, then any Derivative Works that You distribute must include a readable copy of the attribution notices contained within such NOTICE file, excluding those notices that do not pertain to any part of the Derivative Works, in at least one of the following places: within a NOTICE text file distributed as part of the Derivative Works; within the Source form or documentation, if provided along with the Derivative Works; or, within a display generated by the Derivative Works, if and wherever such third-party notices normally appear. The contents of the NOTICE file are for informational purposes only and do not modify the License. You may add Your own attribution notices within Derivative Works that You distribute, alongside or as an addendum to the NOTICE text from the Work, provided that such additional attribution notices cannot be construed as modifying the License. You may add Your own copyright statement to Your modifications and may provide additional or different license terms and conditions for use, reproduction, or distribution of Your modifications, or for any such Derivative Works as a whole, provided Your use, reproduction, and distribution of the Work otherwise complies with the conditions stated in this License. 5. Submission of Contributions. Unless You explicitly state otherwise, any Contribution intentionally submitted for inclusion in the Work by You to the Licensor shall be under the terms and conditions of this License, without any additional terms or conditions. Notwithstanding the above, nothing herein shall supersede or modify the terms of any separate license agreement you may have executed with Licensor regarding such Contributions. 6. Trademarks. This License does not grant permission to use the trade names, trademarks, service marks, or product names of the Licensor, except as required for reasonable and customary use in describing the origin of the Work and reproducing the content of the NOTICE file. 7. Disclaimer of Warranty. Unless required by applicable law or agreed to in writing, Licensor provides the Work (and each Contributor provides its Contributions) on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR PURPOSE. You are solely responsible for determining the appropriateness of using or redistributing the Work and assume any risks associated with Your exercise of permissions under this License. 8. Limitation of Liability. In no event and under no legal theory, whether in tort (including negligence), contract, or otherwise, unless required by applicable law (such as deliberate and grossly negligent acts) or agreed to in writing, shall any Contributor be liable to You for damages, including any direct, indirect, special, incidental, or consequential damages of any character arising as a result of this License or out of the use or inability to use the Work (including but not limited to damages for loss of goodwill, work stoppage, computer failure or malfunction, or any and all other commercial damages or losses), even if such Contributor has been advised of the possibility of such damages. 9. Accepting Warranty or Additional Liability. While redistributing the Work or Derivative Works thereof, You may choose to offer, and charge a fee for, acceptance of support, warranty, indemnity, or other liability obligations and/or rights consistent with this License. However, in accepting such obligations, You may act only on Your own behalf and on Your sole responsibility, not on behalf of any other Contributor, and only if You agree to indemnify, defend, and hold each Contributor harmless for any liability incurred by, or claims asserted against, such Contributor by reason of your accepting any such warranty or additional liability. END OF TERMS AND CONDITIONS APPENDIX: How to apply the Apache License to your work. To apply the Apache License to your work, attach the following boilerplate notice, with the fields enclosed by brackets "[]" replaced with your own identifying information. (Don't include the brackets!) The text should be enclosed in the appropriate comment syntax for the file format. We also recommend that a file or class name and description of purpose be included on the same "printed page" as the copyright notice for easier identification within third-party archives. Copyright [yyyy] [name of copyright owner] Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

简介

暂无描述 展开 收起
Apache-2.0
取消

发行版

暂无发行版

贡献者

全部

近期动态

加载更多
不能加载更多了
1
https://gitee.com/idkook/HiSql.Gui.git
git@gitee.com:idkook/HiSql.Gui.git
idkook
HiSql.Gui
HiSql.Gui
main

搜索帮助