sqlite-requests 0.0.2

Represent SQLite queries and executes as request objects
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139

syntax = "proto3";

package sqlite_commands;

// TODO: Rename Result -> Response

message ProtoQueryRequest {
  string sql = 1;
  ProtoQueuedParameters queued_parameters = 2;
}

message ProtoQueuedParameters {
  oneof queued_parameters {
    ProtoQueuedIndexedParameters queued_indexed_parameters = 1;
    ProtoQueuedNamedParameters queued_named_parameters = 2;
  }
}

message ProtoQueuedIndexedParameters {
  repeated ProtoIndexedParameters queued_indexed_parameters = 1;
}

message ProtoQueuedNamedParameters {
  repeated ProtoNamedParameters queued_named_parameters = 1;
}

message ProtoIndexedParameters {
  repeated ProtoValue parameters = 1;
}

message ProtoNamedParameters {
  repeated ProtoNamedParameter parameters = 1;
}

message ProtoNamedParameter {
  string name = 1;
  ProtoValue value = 2;
}

message ProtoValue {
  oneof value {
    /// The value is a `NULL` value.
    ProtoNull null = 1;
    /// The value is a signed integer.
    int64 integer = 2;
    /// The value is a floating point number.
    double real = 3;
    /// The value is a text string.
    string text = 4;
    /// The value is a blob of data
    bytes blob = 5;
  }
}

message ProtoNull {
}

message ProtoQueryResponse {
  repeated ProtoQueryResultSet query_result_sets = 1;
}

message ProtoQueryResultSet {
  repeated ProtoQueryResultRow rows = 1;
}

message ProtoQueryResultRow {
  repeated ProtoValue row = 1;
}

message ProtoExecuteRequest {
  string sql = 1;
  ProtoQueuedParameters queued_parameters = 2;
}

message ProtoExecuteResponse {
  repeated ProtoExecuteResult execute_results = 1;
}

message ProtoExecuteResult {
  uint64 changes = 1;
}

message ProtoBulkQueryRequest {
  repeated ProtoQueryRequest queries = 1;
}

message ProtoBulkQueryResponse {
  repeated ProtoQueryResponse query_responses = 1;
}

message ProtoBulkExecuteRequest {
  repeated ProtoExecuteRequest executes = 1;
}

message ProtoBulkExecuteResponse {
  repeated ProtoExecuteResponse execute_responses = 1;
}

message ProtoSqliteRequest {
  oneof request {
    ProtoSqliteQuery query = 1;
    ProtoSqliteExecute execute = 2;
  }
}

message ProtoSqliteResponse {
  oneof response {
    ProtoSqliteQueryResponse query = 1;
    ProtoSqliteExecuteResponse execute = 2;
  }
}

message ProtoSqliteQuery {
  oneof query {
    ProtoQueryRequest single = 1;
    ProtoBulkQueryRequest bulk = 2;
  }
}

message ProtoSqliteQueryResponse {
  oneof response {
    ProtoQueryResponse single = 1;
    ProtoBulkQueryResponse bulk = 2;
  }
}

message ProtoSqliteExecute {
  oneof execute {
    ProtoExecuteRequest single = 1;
    ProtoBulkExecuteRequest bulk = 2;
  }
}

message ProtoSqliteExecuteResponse {
  oneof response {
    ProtoExecuteResponse single = 1;
    ProtoBulkExecuteResponse bulk = 2;
  }
}