developService.proto 11.6 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);

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

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 GetRegisteDrivers(GetRequest) returns (GetRegisteDriversReplay);

cdy816's avatar
cdy816 已提交
173 174 175 176 177 178 179 180 181 182 183
  //Logout
   rpc Logout(LogoutRequest) returns (BoolResultReplay);

   //启动数据库
   rpc Start(GetRequest) returns (BoolResultReplay);

   //停止数据库
   rpc Stop(GetRequest) returns (BoolResultReplay);

}

cdy816's avatar
cdy816 已提交
184 185 186 187 188 189 190 191 192 193 194 195 196 197
//获取驱动列表返回消息
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 已提交
198 199 200 201 202 203 204 205 206 207 208 209 210 211 212
//获取数据权限列表
message GetAllDatabasePermissionRequest
{
    string LoginId=1;
    string Database=2;
}

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

cdy816's avatar
cdy816 已提交
213 214 215 216 217 218 219 220

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

cdy816's avatar
cdy816 已提交
221 222 223 224 225 226 227 228 229 230 231 232 233 234
//
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 已提交
235 236
    bool SuperPermission=4;
    repeated string Group=5;
cdy816's avatar
cdy816 已提交
237 238 239 240 241 242 243 244 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
}

//新建数据库用户
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 已提交
270 271 272 273 274 275 276
message ReNameUserRequest
{
   string loginId =1;
   string OldName=2;
   string NewName=3;
}

cdy816's avatar
cdy816 已提交
277 278 279 280 281 282
//新建用户
message NewUserRequest
{
   string loginId =1;
   string userName=2;
   string password=3;
cdy816's avatar
cdy816 已提交
283 284 285
   bool IsAdmin=4;
   bool NewDatabasePermission=5;
   repeated string Database=6;
cdy816's avatar
cdy816 已提交
286 287 288 289 290 291 292 293
}

//更新用户密码
message ModifyPasswordRequest
{
    string loginId=1;
    string userName=2;
    string password=3;
cdy816's avatar
cdy816 已提交
294
    string newpassword=4;
cdy816's avatar
cdy816 已提交
295 296 297 298 299 300 301
}

//修改用户信息
message UpdateUserRequest
{
    string loginId=1;
    string userName=2;
cdy816's avatar
cdy816 已提交
302 303 304
    bool IsAdmin=3;
    bool NewDatabasePermission=4;
    repeated string Database=5;
cdy816's avatar
cdy816 已提交
305 306
}

cdy816's avatar
cdy816 已提交
307 308 309 310 311 312
message RemoveUserRequest
{
    string loginId=1;
    string userName=2;
}

cdy816's avatar
cdy816 已提交
313 314 315 316 317 318 319 320 321 322 323 324 325 326
//更新用户密码
message UpdatePasswordRequest
{
    string loginId=1;
    string userName=2;
    string password=3;
}

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

cdy816's avatar
cdy816 已提交
327 328 329 330 331 332 333 334 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
///
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 已提交
361 362 363
    bool IsAdmin=2;
    bool NewDatabase=3;
    repeated string Databases=4;
cdy816's avatar
cdy816 已提交
364 365
}

cdy816's avatar
cdy816 已提交
366 367 368 369 370 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 405 406 407 408 409
message NewDatabaseRequest
{
    string loginId =1;
    string Database=2;
    string Desc=3;
}

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 已提交
410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435
//
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 已提交
436 437 438 439 440 441 442 443 444 445 446 447 448 449
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 已提交
450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465
//复制组
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 已提交
466
//添加组
cdy816's avatar
cdy816 已提交
467
message AddGroupRequest
cdy816's avatar
cdy816 已提交
468 469 470 471 472 473 474
{
    string LoginId=1;
    string Database=2;
    string Name=3;
    string ParentName=4;
}

cdy816's avatar
cdy816 已提交
475 476 477 478 479 480 481
message AddGroupReplay
{
    bool Result =1;
    string ErroMessage=2;
    string Group=3;
}

cdy816's avatar
cdy816 已提交
482 483 484 485 486 487 488 489
//通过名称删除用户
message RemoveByNameRequest
{
    string LoginId=1;
    string Database=2;
    string Name=3;
}

cdy816's avatar
cdy816 已提交
490
//删除组
cdy816's avatar
cdy816 已提交
491
message RemoveGroupRequest
cdy816's avatar
cdy816 已提交
492 493 494 495 496 497 498
{
    string LoginId=1;
    string Database=2;
    string Name=3;
}

//
cdy816's avatar
cdy816 已提交
499
message RenameGroupRequest
cdy816's avatar
cdy816 已提交
500 501 502 503 504 505 506 507
{
    string LoginId=1;
    string Database=2;
    string OldFullName=3;
    string NewName=4;
}

//
cdy816's avatar
cdy816 已提交
508
message MoveGroupRequest
cdy816's avatar
cdy816 已提交
509 510 511 512 513 514 515 516
{
    string LoginId=1;
    string Database=2;
    string Name=3;
    string OldParentName=4;
    string NewParentName=5;
}

cdy816's avatar
cdy816 已提交
517
message ClearTagRequestMessage
cdy816's avatar
cdy816 已提交
518
{
cdy816's avatar
cdy816 已提交
519 520 521
    string LoginId=1;
    string Database=2;
    string GroupFullName=3;
cdy816's avatar
cdy816 已提交
522 523
}

cdy816's avatar
cdy816 已提交
524 525

message RemoveTagMessageRequest
cdy816's avatar
cdy816 已提交
526 527 528 529 530 531 532
{
    string LoginId=1;
     string Database=2;
    repeated int32 TagId=3;
}

//
cdy816's avatar
cdy816 已提交
533
message QueryMessageRequest
cdy816's avatar
cdy816 已提交
534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553
{
    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 已提交
554 555 556 557 558
message GetTagByGroupRequest
{
    string LoginId=1;
    string Database=2;
    string Group=3;
cdy816's avatar
cdy816 已提交
559
    int32 Index=4;
cdy816's avatar
cdy816 已提交
560 561
}

cdy816's avatar
cdy816 已提交
562 563 564 565 566 567 568
//
message BoolResultReplay
{
    bool Result =1;
    string ErroMessage=2;
}

cdy816's avatar
cdy816 已提交
569 570


cdy816's avatar
cdy816 已提交
571 572 573 574 575
//获取变量配置
message GetTagMessageReply
{
    bool Result =1;
    string ErroMessage=2;
cdy816's avatar
cdy816 已提交
576 577
    int32 Count=3;
    int32 Index=4;
cdy816's avatar
cdy816 已提交
578 579 580
    int32 TagCount=5;
    repeated RealTagMessage realTag=6;
    repeated HisTagMessage hisTag=7;
cdy816's avatar
cdy816 已提交
581 582
}

cdy816's avatar
cdy816 已提交
583 584 585 586 587 588 589
message GetRealTagMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated RealTagMessage messages=3;
}

cdy816's avatar
cdy816 已提交
590 591 592 593 594 595 596 597

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

cdy816's avatar
cdy816 已提交
598 599 600 601 602 603 604
message GetGroupMessageReply
{
    bool Result =1;
    string ErroMessage=2;
    repeated Group Group=3;
}

cdy816's avatar
cdy816 已提交
605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621
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;
622 623 624 625 626
  string Convert=7;
  int32 ReadWriteMode=8;
  double MaxValue=9;
  double MinValue=10;
  int32 Precision=11;
cdy816's avatar
cdy816 已提交
627 628 629 630 631 632 633 634 635
}

//历史变量定义
message HisTagMessage
{
 uint32 Id=1;
 uint32 Type=2;
 uint32 TagType=3;
 uint32 CompressType=4;
cdy816's avatar
cdy816 已提交
636 637
 uint64 Circle=5;
 repeated hisTagParameterItem Parameter=6;
cdy816's avatar
cdy816 已提交
638 639 640 641 642 643 644
}

message hisTagParameterItem
{
    string Name=1;
    double value=2;
}
cdy816's avatar
cdy816 已提交
645 646 647 648 649 650 651

//变量组
message TagGroup
{
    string Name=1;
    string Parent=2;
}
cdy816's avatar
cdy816 已提交
652 653 654 655 656 657

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