developService.proto 12.1 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 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

}

cdy816's avatar
cdy816 已提交
192 193 194 195 196 197 198 199 200 201 202 203 204 205
//获取驱动列表返回消息
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 已提交
206 207 208 209 210 211 212 213 214 215 216 217 218 219 220
//获取数据权限列表
message GetAllDatabasePermissionRequest
{
    string LoginId=1;
    string Database=2;
}

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

cdy816's avatar
cdy816 已提交
221 222 223 224 225 226 227 228

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

cdy816's avatar
cdy816 已提交
229 230 231 232 233 234 235 236 237 238 239 240 241 242
//
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 已提交
243 244
    bool SuperPermission=4;
    repeated string Group=5;
cdy816's avatar
cdy816 已提交
245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277
}

//新建数据库用户
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 已提交
278 279 280 281 282 283 284
message ReNameUserRequest
{
   string loginId =1;
   string OldName=2;
   string NewName=3;
}

cdy816's avatar
cdy816 已提交
285 286 287 288 289 290
//新建用户
message NewUserRequest
{
   string loginId =1;
   string userName=2;
   string password=3;
cdy816's avatar
cdy816 已提交
291 292 293
   bool IsAdmin=4;
   bool NewDatabasePermission=5;
   repeated string Database=6;
cdy816's avatar
cdy816 已提交
294 295 296 297 298 299 300 301
}

//更新用户密码
message ModifyPasswordRequest
{
    string loginId=1;
    string userName=2;
    string password=3;
cdy816's avatar
cdy816 已提交
302
    string newpassword=4;
cdy816's avatar
cdy816 已提交
303 304 305 306 307 308 309
}

//修改用户信息
message UpdateUserRequest
{
    string loginId=1;
    string userName=2;
cdy816's avatar
cdy816 已提交
310 311 312
    bool IsAdmin=3;
    bool NewDatabasePermission=4;
    repeated string Database=5;
cdy816's avatar
cdy816 已提交
313 314
}

cdy816's avatar
cdy816 已提交
315 316 317 318 319 320
message RemoveUserRequest
{
    string loginId=1;
    string userName=2;
}

cdy816's avatar
cdy816 已提交
321 322 323 324 325 326 327 328 329 330 331 332 333 334
//更新用户密码
message UpdatePasswordRequest
{
    string loginId=1;
    string userName=2;
    string password=3;
}

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

cdy816's avatar
cdy816 已提交
335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368
///
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 已提交
369 370 371
    bool IsAdmin=2;
    bool NewDatabase=3;
    repeated string Databases=4;
cdy816's avatar
cdy816 已提交
372 373
}

cdy816's avatar
cdy816 已提交
374 375 376 377 378 379 380
message NewDatabaseRequest
{
    string loginId =1;
    string Database=2;
    string Desc=3;
}

381 382 383 384 385 386 387

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

cdy816's avatar
cdy816 已提交
388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424
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 已提交
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
//
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 已提交
451 452 453 454 455 456 457 458 459 460 461 462 463 464
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 已提交
465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480
//复制组
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 已提交
481
//添加组
cdy816's avatar
cdy816 已提交
482
message AddGroupRequest
cdy816's avatar
cdy816 已提交
483 484 485 486 487 488 489
{
    string LoginId=1;
    string Database=2;
    string Name=3;
    string ParentName=4;
}

cdy816's avatar
cdy816 已提交
490 491 492 493 494 495 496
message AddGroupReplay
{
    bool Result =1;
    string ErroMessage=2;
    string Group=3;
}

cdy816's avatar
cdy816 已提交
497 498 499 500 501 502 503 504
//通过名称删除用户
message RemoveByNameRequest
{
    string LoginId=1;
    string Database=2;
    string Name=3;
}

cdy816's avatar
cdy816 已提交
505
//删除组
cdy816's avatar
cdy816 已提交
506
message RemoveGroupRequest
cdy816's avatar
cdy816 已提交
507 508 509 510 511 512 513
{
    string LoginId=1;
    string Database=2;
    string Name=3;
}

//
cdy816's avatar
cdy816 已提交
514
message RenameGroupRequest
cdy816's avatar
cdy816 已提交
515 516 517 518 519 520 521 522
{
    string LoginId=1;
    string Database=2;
    string OldFullName=3;
    string NewName=4;
}

//
cdy816's avatar
cdy816 已提交
523
message MoveGroupRequest
cdy816's avatar
cdy816 已提交
524 525 526 527 528 529 530 531
{
    string LoginId=1;
    string Database=2;
    string Name=3;
    string OldParentName=4;
    string NewParentName=5;
}

cdy816's avatar
cdy816 已提交
532
message ClearTagRequestMessage
cdy816's avatar
cdy816 已提交
533
{
cdy816's avatar
cdy816 已提交
534 535 536
    string LoginId=1;
    string Database=2;
    string GroupFullName=3;
cdy816's avatar
cdy816 已提交
537 538
}

cdy816's avatar
cdy816 已提交
539 540

message RemoveTagMessageRequest
cdy816's avatar
cdy816 已提交
541 542 543 544 545 546 547
{
    string LoginId=1;
     string Database=2;
    repeated int32 TagId=3;
}

//
cdy816's avatar
cdy816 已提交
548
message QueryMessageRequest
cdy816's avatar
cdy816 已提交
549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568
{
    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 已提交
569 570 571 572 573
message GetTagByGroupRequest
{
    string LoginId=1;
    string Database=2;
    string Group=3;
cdy816's avatar
cdy816 已提交
574
    int32 Index=4;
575 576 577 578 579 580 581
    repeated FilterMessageItem Filters=5;
}

message FilterMessageItem
{
    string key=1;
    string value=2;
cdy816's avatar
cdy816 已提交
582 583
}

cdy816's avatar
cdy816 已提交
584 585 586 587 588 589 590
//
message BoolResultReplay
{
    bool Result =1;
    string ErroMessage=2;
}

cdy816's avatar
cdy816 已提交
591 592


cdy816's avatar
cdy816 已提交
593 594 595 596 597
//获取变量配置
message GetTagMessageReply
{
    bool Result =1;
    string ErroMessage=2;
cdy816's avatar
cdy816 已提交
598 599
    int32 Count=3;
    int32 Index=4;
cdy816's avatar
cdy816 已提交
600 601 602
    int32 TagCount=5;
    repeated RealTagMessage realTag=6;
    repeated HisTagMessage hisTag=7;
cdy816's avatar
cdy816 已提交
603 604
}

cdy816's avatar
cdy816 已提交
605 606 607 608 609 610 611
message GetRealTagMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated RealTagMessage messages=3;
}

cdy816's avatar
cdy816 已提交
612 613 614 615 616 617 618 619

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

cdy816's avatar
cdy816 已提交
620 621 622 623 624 625 626
message GetGroupMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated Group Group=3;
}

cdy816's avatar
cdy816 已提交
627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643
message GetHistTagMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated HisTagMessage messages=3;
}


//实时变量配置
message RealTagMessage
{
  uint32 Id=1;
  uint32 TagType=2;
  string Name = 3;
  string Group = 4;
  string Desc = 5;
  string LinkAddress = 6;
644 645 646 647 648
  string Convert=7;
  int32 ReadWriteMode=8;
  double MaxValue=9;
  double MinValue=10;
  int32 Precision=11;
cdy816's avatar
cdy816 已提交
649 650 651 652 653 654 655 656 657
}

//历史变量定义
message HisTagMessage
{
 uint32 Id=1;
 uint32 Type=2;
 uint32 TagType=3;
 uint32 CompressType=4;
cdy816's avatar
cdy816 已提交
658 659
 uint64 Circle=5;
 repeated hisTagParameterItem Parameter=6;
cdy816's avatar
cdy816 已提交
660 661 662 663 664 665 666
}

message hisTagParameterItem
{
    string Name=1;
    double value=2;
}
cdy816's avatar
cdy816 已提交
667 668 669 670 671 672 673

//变量组
message TagGroup
{
    string Name=1;
    string Parent=2;
}
cdy816's avatar
cdy816 已提交
674 675 676 677 678 679

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