developService.proto 12.9 KB
Newer Older
cdy816's avatar
cdy816 已提交
1 2 3 4 5 6 7 8 9 10 11 12
syntax = "proto3";

option csharp_namespace = "DBDevelopService";

package dbDevelopService;

// The greeting service definition.
service DevelopServer {

  //Login
  rpc Login(LoginRequest) returns (LoginReply);

cdy816's avatar
cdy816 已提交
13 14 15 16 17 18 19
  //
  rpc IsAdmin(GetRequest) returns (BoolResultReplay);

    //
  rpc CanNewDatabase(GetRequest) returns (BoolResultReplay);


cdy816's avatar
cdy816 已提交
20
  //数据库开发服务权限操纵
cdy816's avatar
cdy816 已提交
21 22 23
  //新建用户
  rpc NewUser(NewUserRequest) returns (BoolResultReplay);

cdy816's avatar
cdy816 已提交
24
  //修改当前用户密码
cdy816's avatar
cdy816 已提交
25 26
  rpc ModifyPassword(ModifyPasswordRequest) returns (BoolResultReplay);

27
  rpc ReNameUser(ReNameUserRequest) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
28

cdy816's avatar
cdy816 已提交
29 30 31
  //修改用户信息
  rpc UpdateUser(UpdateUserRequest) returns (BoolResultReplay);

cdy816's avatar
cdy816 已提交
32 33 34
    //更新用户密码
  rpc UpdateUserPassword(UpdatePasswordRequest) returns (BoolResultReplay);

cdy816's avatar
cdy816 已提交
35 36 37 38 39 40
  //删除用户
  rpc RemoveUser(RemoveUserRequest) returns (BoolResultReplay);

  //获取开发者用户
  rpc GetUsers(GetRequest) returns (GetUsersReplay);

cdy816's avatar
cdy816 已提交
41 42 43
  //枚举权限列表
 // rpc GetPermissions(GetRequest) returns (GetPermissionsReplay);

cdy816's avatar
cdy816 已提交
44
  //数据库操作
cdy816's avatar
cdy816 已提交
45 46 47 48 49 50
  //枚举检索数据库
  rpc QueryDatabase(QueryDatabaseRequest) returns (QueryDatabaseReplay);

  //新建数据库
  rpc NewDatabase(NewDatabaseRequest) returns (BoolResultReplay);

cdy816's avatar
cdy816 已提交
51
  //数据库权限操作
cdy816's avatar
cdy816 已提交
52 53 54 55 56 57 58 59 60
  //新建数据库用户
  rpc NewDatabaseUser(NewDatabaseUserRequest) returns (BoolResultReplay);

  //修改数据库用户密码
  rpc ModifyDatabaseUserPassword(ModifyDatabaseUserPasswordRequest) returns (BoolResultReplay);

  //更新数据库用户信息
  rpc UpdateDatabaseUser(UpdateDatabaseUserRequest) returns (BoolResultReplay);

cdy816's avatar
cdy816 已提交
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
  //删除数据库用户
  rpc RemoveDatabaseUser(RemoveByNameRequest) returns (BoolResultReplay);

  //添加用户组
  rpc AddDatabaseUserGroup(AddGroupRequest) returns (BoolResultReplay);

  //获取用户组
  rpc GetDatabaseUserGroup(GetRequest) returns (GetGroupMessageReply);

  //删除用户组
  rpc RemoveDatabaseUserGroup(RemoveGroupRequest) returns (BoolResultReplay);

  //改名用户组
  rpc RenameDatabaseUserGroup(RenameGroupRequest) returns (BoolResultReplay);

  //移动组
  rpc MoveDatabaseUserGroup(MoveGroupRequest) returns (BoolResultReplay);

  //通过组获取用户
  rpc GetDatabaseUserByGroup(GetDatabaseUserByGroupRequest) returns (GetDatabaseUsersReplay);

cdy816's avatar
cdy816 已提交
82 83 84
  //添加数据库权限
  rpc NewDatabasePermission(DatabasePermissionRequest) returns (BoolResultReplay);

cdy816's avatar
cdy816 已提交
85

cdy816's avatar
cdy816 已提交
86 87 88 89 90 91
  //更新数据库权限
  rpc UpdateDatabasePermission(DatabasePermissionRequest) returns (BoolResultReplay);

  //获取数据权限列表
  rpc GetAllDatabasePermission(GetAllDatabasePermissionRequest) returns (GetAllDatabasePermissionReplay);

cdy816's avatar
cdy816 已提交
92 93 94
  //删除数据库权限
  rpc RemoveDatabasePermission(RemoveDatabasePermissionRequest) returns (BoolResultReplay);
  
cdy816's avatar
cdy816 已提交
95
  //变量操作
cdy816's avatar
cdy816 已提交
96 97 98
  //添加
  rpc AddTag(AddTagRequestMessage) returns (AddTagReplyMessage);

cdy816's avatar
cdy816 已提交
99 100 101
    //导入变量
  rpc Import(ImportTagRequestMessage) returns (ImportTagRequestReplyMessage);

cdy816's avatar
cdy816 已提交
102
  //删除
cdy816's avatar
cdy816 已提交
103
  rpc RemoveTag(RemoveTagMessageRequest) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
104

cdy816's avatar
cdy816 已提交
105 106
    //删除变量历史配置
  rpc RemoveHisTag(RemoveTagMessageRequest) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
107

cdy816's avatar
cdy816 已提交
108

cdy816's avatar
cdy816 已提交
109 110
  //批量删除变量
  rpc ClearTag(ClearTagRequestMessage) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
111

cdy816's avatar
cdy816 已提交
112 113
  //清空整个数据库
  rpc ClearAllTag(GetRequest) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
114

cdy816's avatar
cdy816 已提交
115 116
    //修改实时变量
  rpc UpdateRealTag(UpdateRealTagRequestMessage) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
117

cdy816's avatar
cdy816 已提交
118 119
  //修改历史变量
  rpc UpdateHisTag(UpdateHisTagRequestMessage) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
120 121


cdy816's avatar
cdy816 已提交
122
    //根据组获取变量
cdy816's avatar
cdy816 已提交
123 124 125 126 127
  rpc GetTagByGroup(GetTagByGroupRequest) returns (GetTagMessageReply);

  //获取所有变量
  rpc GetAllTag(GetTagByGroupRequest) returns (GetTagMessageReply);

cdy816's avatar
cdy816 已提交
128

cdy816's avatar
cdy816 已提交
129 130 131 132
  //获取所有历史变量
  rpc GetHisAllTag(GetRequest) returns (GetHistTagMessageReply);

  //查询指定条件的变量
cdy816's avatar
cdy816 已提交
133
  rpc QueryRealTag(QueryMessageRequest) returns (GetRealTagMessageReply);
cdy816's avatar
cdy816 已提交
134 135

  //查询历史变量
cdy816's avatar
cdy816 已提交
136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160
  rpc QueryHisTag(QueryMessageRequest) returns (GetHistTagMessageReply);


  //获取所有实时变量
  rpc GetRealAllTag(GetRequest) returns (GetRealTagMessageReply);


  //变量组操作
  //获取变量组
  rpc GetTagGroup(GetRequest) returns (GetTagGroupMessageReply);

  //添加变量组
  rpc AddTagGroup(AddGroupRequest) returns (AddGroupReplay);

  //粘贴组
  rpc PasteTagGroup(PasteGroupRequest) returns (PasteGroupReplay);

  //删除变量组
  rpc RemoveTagGroup(RemoveGroupRequest) returns (BoolResultReplay);

  //重命名变量组
  rpc RenameTagGroup(RenameGroupRequest) returns (BoolResultReplay);

  //移动变量组
  rpc MoveTagGroup(MoveGroupRequest) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
161 162 163 164 165 166 167 168 169



  //保存
  rpc Save(GetRequest) returns (BoolResultReplay);

  //撤销
  rpc Cancel(GetRequest) returns (BoolResultReplay);

cdy816's avatar
cdy816 已提交
170
    //数据库是否变脏
cdy816's avatar
cdy816 已提交
171 172
  rpc IsDatabaseDirty(DatabasesRequest) returns (BoolResultReplay);

cdy816's avatar
cdy816 已提交
173 174 175
  //获取驱动列表
  rpc GetRegisteDrivers(GetRequest) returns (GetRegisteDriversReplay);

cdy816's avatar
cdy816 已提交
176 177 178 179
  //Logout
   rpc Logout(LogoutRequest) returns (BoolResultReplay);

   //启动数据库
180
   rpc Start(DatabasesRequest) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
181 182

   //停止数据库
183 184 185 186 187 188
   rpc Stop(DatabasesRequest) returns (BoolResultReplay);

   //在运行不中断的情况下加载数据库
   rpc ReRun(DatabasesRequest) returns (BoolResultReplay);

   rpc IsDatabaseRunning(DatabasesRequest) returns (BoolResultReplay);
cdy816's avatar
cdy816 已提交
189

190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208
   //
   rpc GetRealDataServerPort(DatabasesRequest) returns (IntResultReplay);

   //
   rpc SetRealDataServerPort(SetRealDataServerPortRequest) returns  (BoolResultReplay);

   //
   rpc GetDriverSetting(GetDriverSettingRequest) returns (GetDriverSettingReplay);

   //
   rpc UpdateDrvierSetting(UpdateDrvierSettingRequest) returns  (BoolResultReplay);

}

//
message GetDriverSettingRequest
{
    string LoginId=1;
    string Driver=2;
cdy816's avatar
cdy816 已提交
209 210
}

211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227
//
message GetDriverSettingReplay
{
    bool Result =1;
    string ErroMessage=2;
    string Drivers=3;
    string SettingString=4;
}

message UpdateDrvierSettingRequest
{
 string LoginId=1;
 string Driver=2;
 string SettingString=4;
}


cdy816's avatar
cdy816 已提交
228 229 230 231 232 233 234 235 236 237 238 239 240 241
//获取驱动列表返回消息
message GetRegisteDriversReplay
{
    bool Result =1;
    string ErroMessage=2;
    repeated Driver Drivers=3;
}

message Driver
{
    string Name=1;
    repeated string Registors=2;
}

cdy816's avatar
cdy816 已提交
242 243 244 245 246 247 248 249 250 251 252 253 254 255 256
//获取数据权限列表
message GetAllDatabasePermissionRequest
{
    string LoginId=1;
    string Database=2;
}

//
message GetAllDatabasePermissionReplay
{
    bool Result =1;
    string ErroMessage=2;
    repeated DatabasePermission Permission=3;
}

cdy816's avatar
cdy816 已提交
257 258 259 260 261 262 263 264

message RemoveDatabasePermissionRequest
{
    string LoginId=1;
    string Database=2;
    string Permission=3;
}

cdy816's avatar
cdy816 已提交
265 266 267 268 269 270 271 272 273 274 275 276 277 278
//
message DatabasePermissionRequest
{
    string LoginId=1;
    string Database=2;
    DatabasePermission Permission=3;
}

//
message DatabasePermission
{
    string Name=1;
    string Desc=2;
    bool EnableWrite=3;
cdy816's avatar
cdy816 已提交
279 280
    bool SuperPermission=4;
    repeated string Group=5;
cdy816's avatar
cdy816 已提交
281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313
}

//新建数据库用户
message NewDatabaseUserRequest
{
    string LoginId=1;
    string Database=2;
    string userName=3;
    string password=4;
       string Group=5;
    repeated string permission=6;
}

//更新数据库用户密码
message ModifyDatabaseUserPasswordRequest
{
    string loginId=1;
    string Database=2;
    string userName=3;
    string password=4;
}

//修改数据库用户信息
message UpdateDatabaseUserRequest
{
    string loginId=1;
     string Database=2;
    string userName=3;
    string Group=4;
    repeated string permission=5;

}

cdy816's avatar
cdy816 已提交
314 315 316 317 318 319 320
message ReNameUserRequest
{
   string loginId =1;
   string OldName=2;
   string NewName=3;
}

cdy816's avatar
cdy816 已提交
321 322 323 324 325 326
//新建用户
message NewUserRequest
{
   string loginId =1;
   string userName=2;
   string password=3;
cdy816's avatar
cdy816 已提交
327 328 329
   bool IsAdmin=4;
   bool NewDatabasePermission=5;
   repeated string Database=6;
cdy816's avatar
cdy816 已提交
330 331 332 333 334 335 336 337
}

//更新用户密码
message ModifyPasswordRequest
{
    string loginId=1;
    string userName=2;
    string password=3;
cdy816's avatar
cdy816 已提交
338
    string newpassword=4;
cdy816's avatar
cdy816 已提交
339 340 341 342 343 344 345
}

//修改用户信息
message UpdateUserRequest
{
    string loginId=1;
    string userName=2;
cdy816's avatar
cdy816 已提交
346 347 348
    bool IsAdmin=3;
    bool NewDatabasePermission=4;
    repeated string Database=5;
cdy816's avatar
cdy816 已提交
349 350
}

cdy816's avatar
cdy816 已提交
351 352 353 354 355 356
message RemoveUserRequest
{
    string loginId=1;
    string userName=2;
}

cdy816's avatar
cdy816 已提交
357 358 359 360 361 362 363 364 365 366 367 368 369 370
//更新用户密码
message UpdatePasswordRequest
{
    string loginId=1;
    string userName=2;
    string password=3;
}

message GetPermissionsReplay
{
    bool Result =1;
    repeated string Permission=2;
}

cdy816's avatar
cdy816 已提交
371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404
///
message GetDatabaseUserByGroupRequest
{
    string LoginId=1;
    string Database=2;
    string Group=3;
}

//
message GetDatabaseUsersReplay
{
    bool Result =1;
    string ErroMessage=2;
   repeated DatabaseUserMessage Users=3;
}

//数据库用户信息
message DatabaseUserMessage
{
    string userName=1;
    string Group=2;
    repeated string permission=3;
}

message GetUsersReplay
{
    bool Result =1;
    string ErroMessage=2;
   repeated UserMessage Users=3;
}

message UserMessage
{
    string userName=1;
cdy816's avatar
cdy816 已提交
405 406 407
    bool IsAdmin=2;
    bool NewDatabase=3;
    repeated string Databases=4;
cdy816's avatar
cdy816 已提交
408 409
}

cdy816's avatar
cdy816 已提交
410 411 412 413 414 415 416
message NewDatabaseRequest
{
    string loginId =1;
    string Database=2;
    string Desc=3;
}

417 418 419 420 421 422 423

message DatabasesRequest
{
    string loginId=1;
    string Database=2;
}

cdy816's avatar
cdy816 已提交
424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460
message QueryDatabaseRequest
{
   string loginId =1;
}

message QueryDatabaseReplay
{
    bool Result =1;
    string ErroMessage=2;
   repeated KeyValueMessage Database=3;
}

message LoginRequest
{
    string userName=1;
    string password=2;
}

message LoginReply
{
    string loginId=1;
}

message LogoutRequest
{
    string LoginId=1;
}

//
message AddTagRequestMessage
{
    string loginId =1;
     string Database=2;
    RealTagMessage realTag = 3;
    HisTagMessage hisTag = 4;
}

cdy816's avatar
cdy816 已提交
461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486
//
message AddTagReplyMessage
{
    int32 TagId = 1;
    bool Result =2;
    string ErroMessage=3;
}


message ImportTagRequestMessage
{
    string loginId=1;
    string Database=2;
     RealTagMessage realTag = 3;
    HisTagMessage hisTag = 4;
    int32 Mode=5;
}


message ImportTagRequestReplyMessage
{
    int32 TagId = 1;
    bool Result =2;
    string ErroMessage=3;
}

cdy816's avatar
cdy816 已提交
487 488 489 490 491 492 493 494 495 496 497 498 499 500
message UpdateRealTagRequestMessage
{
    string loginId=1;
    string Database=2;
    RealTagMessage tag = 3;
}

message UpdateHisTagRequestMessage
{
    string loginId=1;
    string Database=2;
    HisTagMessage tag = 3;
}

cdy816's avatar
cdy816 已提交
501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516
//复制组
message PasteGroupRequest
{
    string LoginId=1;
    string Database=2;
    string GroupFullName=3;
    string TargetParentName=4;
}

message PasteGroupReplay
{
    bool Result =1;
    string ErroMessage=2;
    string Group=3;
}

cdy816's avatar
cdy816 已提交
517
//添加组
cdy816's avatar
cdy816 已提交
518
message AddGroupRequest
cdy816's avatar
cdy816 已提交
519 520 521 522 523 524 525
{
    string LoginId=1;
    string Database=2;
    string Name=3;
    string ParentName=4;
}

cdy816's avatar
cdy816 已提交
526 527 528 529 530 531 532
message AddGroupReplay
{
    bool Result =1;
    string ErroMessage=2;
    string Group=3;
}

cdy816's avatar
cdy816 已提交
533 534 535 536 537 538 539 540
//通过名称删除用户
message RemoveByNameRequest
{
    string LoginId=1;
    string Database=2;
    string Name=3;
}

cdy816's avatar
cdy816 已提交
541
//删除组
cdy816's avatar
cdy816 已提交
542
message RemoveGroupRequest
cdy816's avatar
cdy816 已提交
543 544 545 546 547 548 549
{
    string LoginId=1;
    string Database=2;
    string Name=3;
}

//
cdy816's avatar
cdy816 已提交
550
message RenameGroupRequest
cdy816's avatar
cdy816 已提交
551 552 553 554 555 556 557 558
{
    string LoginId=1;
    string Database=2;
    string OldFullName=3;
    string NewName=4;
}

//
cdy816's avatar
cdy816 已提交
559
message MoveGroupRequest
cdy816's avatar
cdy816 已提交
560 561 562 563 564 565 566 567
{
    string LoginId=1;
    string Database=2;
    string Name=3;
    string OldParentName=4;
    string NewParentName=5;
}

cdy816's avatar
cdy816 已提交
568
message ClearTagRequestMessage
cdy816's avatar
cdy816 已提交
569
{
cdy816's avatar
cdy816 已提交
570 571 572
    string LoginId=1;
    string Database=2;
    string GroupFullName=3;
cdy816's avatar
cdy816 已提交
573 574
}

cdy816's avatar
cdy816 已提交
575 576

message RemoveTagMessageRequest
cdy816's avatar
cdy816 已提交
577 578 579 580 581 582 583
{
    string LoginId=1;
     string Database=2;
    repeated int32 TagId=3;
}

//
cdy816's avatar
cdy816 已提交
584
message QueryMessageRequest
cdy816's avatar
cdy816 已提交
585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604
{
    string LoginId=1;
    string Database=2;
    repeated KeyValueMessage conditions=3;
}

//
message KeyValueMessage
{
    string key=1;
    string value=2;
}

//
message GetRequest
{
    string LoginId=1;
    string Database=2;
}

cdy816's avatar
cdy816 已提交
605 606 607 608 609
message GetTagByGroupRequest
{
    string LoginId=1;
    string Database=2;
    string Group=3;
cdy816's avatar
cdy816 已提交
610
    int32 Index=4;
611 612 613
    repeated FilterMessageItem Filters=5;
}

614 615 616 617 618 619 620
message SetRealDataServerPortRequest
{
    string LoginId=1;
    int32 Port=2;
    string Database=3;
}

621 622 623 624
message FilterMessageItem
{
    string key=1;
    string value=2;
cdy816's avatar
cdy816 已提交
625 626
}

cdy816's avatar
cdy816 已提交
627 628 629 630 631 632 633
//
message BoolResultReplay
{
    bool Result =1;
    string ErroMessage=2;
}

cdy816's avatar
cdy816 已提交
634

635 636 637 638 639 640
message IntResultReplay
{
    bool Result =1;
    int32 value=2;
    string ErroMessage=3;
}
cdy816's avatar
cdy816 已提交
641

cdy816's avatar
cdy816 已提交
642 643 644 645 646
//获取变量配置
message GetTagMessageReply
{
    bool Result =1;
    string ErroMessage=2;
cdy816's avatar
cdy816 已提交
647 648
    int32 Count=3;
    int32 Index=4;
cdy816's avatar
cdy816 已提交
649 650 651
    int32 TagCount=5;
    repeated RealTagMessage realTag=6;
    repeated HisTagMessage hisTag=7;
cdy816's avatar
cdy816 已提交
652 653
}

cdy816's avatar
cdy816 已提交
654 655 656 657 658 659 660
message GetRealTagMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated RealTagMessage messages=3;
}

cdy816's avatar
cdy816 已提交
661 662 663 664 665 666 667 668

message GetTagGroupMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated TagGroup Group=3;
}

cdy816's avatar
cdy816 已提交
669 670 671 672 673 674 675
message GetGroupMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated Group Group=3;
}

cdy816's avatar
cdy816 已提交
676 677 678 679 680 681 682 683 684 685 686
message GetHistTagMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated HisTagMessage messages=3;
}


//实时变量配置
message RealTagMessage
{
cdy816's avatar
cdy816 已提交
687
  int32 Id=1;
cdy816's avatar
cdy816 已提交
688 689 690 691 692
  uint32 TagType=2;
  string Name = 3;
  string Group = 4;
  string Desc = 5;
  string LinkAddress = 6;
693 694 695 696 697
  string Convert=7;
  int32 ReadWriteMode=8;
  double MaxValue=9;
  double MinValue=10;
  int32 Precision=11;
cdy816's avatar
cdy816 已提交
698 699 700 701 702
}

//历史变量定义
message HisTagMessage
{
cdy816's avatar
cdy816 已提交
703
 int32 Id=1;
cdy816's avatar
cdy816 已提交
704 705 706
 uint32 Type=2;
 uint32 TagType=3;
 uint32 CompressType=4;
cdy816's avatar
cdy816 已提交
707 708
 uint64 Circle=5;
 repeated hisTagParameterItem Parameter=6;
cdy816's avatar
cdy816 已提交
709 710 711 712 713 714 715
}

message hisTagParameterItem
{
    string Name=1;
    double value=2;
}
cdy816's avatar
cdy816 已提交
716 717 718 719 720 721 722

//变量组
message TagGroup
{
    string Name=1;
    string Parent=2;
}
cdy816's avatar
cdy816 已提交
723 724 725 726 727 728

message Group
{
    string Name=1;
    string Parent=2;
}