checksums.yaml ADDED
@@ -0,0 +1,7 @@
1
+ ---
2
+ SHA256:
3
+ metadata.gz: d5cfb9c0253ac7eb2b296b4a97710919baf69f42ecbd08f673969108aee898cc
4
+ data.tar.gz: bad87113c014874ca0d72220926238ae79991d38ce70493e05331328d982791c
5
+ SHA512:
6
+ metadata.gz: 220689da8fdb7a820f5b269b79138d159a7018a891755665b9aa5dbff8a224c318d7fb82194bd2e8b0c9bd1fcaabc9aa07eec202f50f909f9a83c85ed5ff2153
7
+ data.tar.gz: 117d7e38e73cf70147afd5fd4c102130bee28e244675330ea186bc93a759ecb4cb82031e8bf8858ce5f89e28293f5926454f242d94b1e49b50c0b294cbe0166f
data/.gitignore ADDED
@@ -0,0 +1,91 @@
1
+
2
+ # Created by https://www.gitignore.io/api/ruby,macos
3
+ # Edit at https://www.gitignore.io/?templates=ruby,macos
4
+
5
+ ### macOS ###
6
+ # General
7
+ .DS_Store
8
+ .AppleDouble
9
+ .LSOverride
10
+
11
+ # Icon must end with two \r
12
+ Icon
13
+
14
+ # Thumbnails
15
+ ._*
16
+
17
+ # Files that might appear in the root of a volume
18
+ .DocumentRevisions-V100
19
+ .fseventsd
20
+ .Spotlight-V100
21
+ .TemporaryItems
22
+ .Trashes
23
+ .VolumeIcon.icns
24
+ .com.apple.timemachine.donotpresent
25
+
26
+ # Directories potentially created on remote AFP share
27
+ .AppleDB
28
+ .AppleDesktop
29
+ Network Trash Folder
30
+ Temporary Items
31
+ .apdisk
32
+
33
+ ### Ruby ###
34
+ *.gem
35
+ *.rbc
36
+ /.config
37
+ /coverage/
38
+ /InstalledFiles
39
+ /pkg/
40
+ /spec/reports/
41
+ /spec/examples.txt
42
+ /test/tmp/
43
+ /test/version_tmp/
44
+ /tmp/
45
+
46
+ # Used by dotenv library to load environment variables.
47
+ # .env
48
+
49
+ # Ignore Byebug command history file.
50
+ .byebug_history
51
+
52
+ ## Specific to RubyMotion:
53
+ .dat*
54
+ .repl_history
55
+ build/
56
+ *.bridgesupport
57
+ build-iPhoneOS/
58
+ build-iPhoneSimulator/
59
+
60
+ ## Specific to RubyMotion (use of CocoaPods):
61
+ #
62
+ # We recommend against adding the Pods directory to your .gitignore. However
63
+ # you should judge for yourself, the pros and cons are mentioned at:
64
+ # https://guides.cocoapods.org/using/using-cocoapods.html#should-i-check-the-pods-directory-into-source-control
65
+ # vendor/Pods/
66
+
67
+ ## Documentation cache and generated files:
68
+ /.yardoc/
69
+ /_yardoc/
70
+ /doc/
71
+ /rdoc/
72
+
73
+ ## Environment normalization:
74
+ /.bundle/
75
+ /vendor/bundle
76
+ /lib/bundler/man/
77
+
78
+ # for a library or gem, you might want to ignore these files since the code is
79
+ # intended to run in multiple environments; otherwise, check them in:
80
+ # Gemfile.lock
81
+ # .ruby-version
82
+ # .ruby-gemset
83
+
84
+ # unless supporting rvm < 1.11.0 or doing something fancy, ignore this:
85
+ .rvmrc
86
+
87
+ ### Ruby Patch ###
88
+ # Used by RuboCop. Remote config files pulled in from inherit_from directive.
89
+ # .rubocop-https?--*
90
+
91
+ # End of https://www.gitignore.io/api/ruby,macos
data/.pre-commit-config.yaml ADDED
@@ -0,0 +1,15 @@
1
+ # See https://pre-commit.com for more information
2
+ # See https://pre-commit.com/hooks.html for more hooks
3
+ repos:
4
+ - repo: https://github.com/pre-commit/pre-commit-hooks
5
+ rev: v2.0.0
6
+ hooks:
7
+ - id: trailing-whitespace
8
+ - id: end-of-file-fixer
9
+ - id: check-yaml
10
+ - id: check-added-large-files
11
+
12
+ - repo: https://github.com/mattlqx/pre-commit-ruby
13
+ rev: v1.2.6
14
+ hooks:
15
+ - id: rubocop
data/.rubocop.yml ADDED
@@ -0,0 +1 @@
1
+ inherit_from: .rubocop_todo.yml
data/.rubocop_todo.yml ADDED
@@ -0,0 +1,50 @@
1
+ # This configuration was generated by
2
+ # `rubocop --auto-gen-config`
3
+ # on 2020-01-14 16:36:39 +0900 using RuboCop version 0.52.1.
4
+ # The point is for the user to remove these configuration records
5
+ # one by one as the offenses are removed from the code base.
6
+ # Note that changes in the inspected code, or installation of new
7
+ # versions of RuboCop, may require this file to be generated again.
8
+
9
+ # Offense count: 1
10
+ # Configuration parameters: Include.
11
+ # Include: **/*.gemspec
12
+ Gemspec/RequiredRubyVersion:
13
+ Exclude:
14
+ - 'tiny-presto.gemspec'
15
+
16
+ # Offense count: 3
17
+ Lint/UselessAssignment:
18
+ Exclude:
19
+ - 'spec/cluster_spec.rb'
20
+
21
+ # Offense count: 2
22
+ # Configuration parameters: CountComments, ExcludedMethods.
23
+ Metrics/BlockLength:
24
+ Max: 32
25
+
26
+ # Offense count: 1
27
+ # Configuration parameters: CountComments.
28
+ Metrics/MethodLength:
29
+ Max: 15
30
+
31
+ # Offense count: 1
32
+ # Configuration parameters: ExpectMatchingDefinition, Regex, IgnoreExecutableScripts, AllowedAcronyms.
33
+ # AllowedAcronyms: CLI, DSL, ACL, API, ASCII, CPU, CSS, DNS, EOF, GUID, HTML, HTTP, HTTPS, ID, IP, JSON, LHS, QPS, RAM, RHS, RPC, SLA, SMTP, SQL, SSH, TCP, TLS, TTL, UDP, UI, UID, UUID, URI, URL, UTF8, VM, XML, XMPP, XSRF, XSS
34
+ Naming/FileName:
35
+ Exclude:
36
+ - 'lib/tiny-presto.rb'
37
+
38
+ # Offense count: 2
39
+ Style/Documentation:
40
+ Exclude:
41
+ - 'spec/**/*'
42
+ - 'test/**/*'
43
+ - 'lib/tiny-presto.rb'
44
+ - 'lib/tiny-presto/cluster.rb'
45
+
46
+ # Offense count: 2
47
+ # Configuration parameters: AllowHeredoc, AllowURI, URISchemes, IgnoreCopDirectives, IgnoredPatterns.
48
+ # URISchemes: http, https
49
+ Metrics/LineLength:
50
+ Max: 117
data/Gemfile ADDED
@@ -0,0 +1,14 @@
1
+ # frozen_string_literal: true
2
+
3
+ source 'https://rubygems.org'
4
+
5
+ git_source(:github) { |repo_name| "https://github.com/#{repo_name}" }
6
+
7
+ gem 'docker-api'
8
+ gem 'presto-client'
9
+ gem 'rake'
10
+ gem 'rubocop'
11
+
12
+ group :development, :test do
13
+ gem 'rspec'
14
+ end
data/Gemfile.lock ADDED
@@ -0,0 +1,58 @@
1
+ GEM
2
+ remote: https://rubygems.org/
3
+ specs:
4
+ ast (2.4.0)
5
+ diff-lcs (1.3)
6
+ docker-api (1.34.2)
7
+ excon (>= 0.47.0)
8
+ multi_json
9
+ excon (0.71.1)
10
+ faraday (0.17.3)
11
+ multipart-post (>= 1.2, < 3)
12
+ msgpack (1.3.1)
13
+ multi_json (1.14.1)
14
+ multipart-post (2.1.1)
15
+ parallel (1.17.0)
16
+ parser (2.5.3.0)
17
+ ast (~> 2.4.0)
18
+ powerpack (0.1.2)
19
+ presto-client (0.6.1)
20
+ faraday (~> 0.12)
21
+ msgpack (>= 0.7.0)
22
+ rainbow (3.0.0)
23
+ rake (13.0.1)
24
+ rspec (3.8.0)
25
+ rspec-core (~> 3.8.0)
26
+ rspec-expectations (~> 3.8.0)
27
+ rspec-mocks (~> 3.8.0)
28
+ rspec-core (3.8.0)
29
+ rspec-support (~> 3.8.0)
30
+ rspec-expectations (3.8.2)
31
+ diff-lcs (>= 1.2.0, < 2.0)
32
+ rspec-support (~> 3.8.0)
33
+ rspec-mocks (3.8.0)
34
+ diff-lcs (>= 1.2.0, < 2.0)
35
+ rspec-support (~> 3.8.0)
36
+ rspec-support (3.8.0)
37
+ rubocop (0.52.1)
38
+ parallel (~> 1.10)
39
+ parser (>= 2.4.0.2, < 3.0)
40
+ powerpack (~> 0.1)
41
+ rainbow (>= 2.2.2, < 4.0)
42
+ ruby-progressbar (~> 1.7)
43
+ unicode-display_width (~> 1.0, >= 1.0.1)
44
+ ruby-progressbar (1.10.0)
45
+ unicode-display_width (1.4.0)
46
+
47
+ PLATFORMS
48
+ ruby
49
+
50
+ DEPENDENCIES
51
+ docker-api
52
+ presto-client
53
+ rake
54
+ rspec
55
+ rubocop
56
+
57
+ BUNDLED WITH
58
+ 2.0.2
data/LICENSE ADDED
@@ -0,0 +1,201 @@
1
+ Apache License
2
+ Version 2.0, January 2004
3
+ http://www.apache.org/licenses/
4
+
5
+ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
6
+
7
+ 1. Definitions.
8
+
9
+ "License" shall mean the terms and conditions for use, reproduction,
10
+ and distribution as defined by Sections 1 through 9 of this document.
11
+
12
+ "Licensor" shall mean the copyright owner or entity authorized by
13
+ the copyright owner that is granting the License.
14
+
15
+ "Legal Entity" shall mean the union of the acting entity and all
16
+ other entities that control, are controlled by, or are under common
17
+ control with that entity. For the purposes of this definition,
18
+ "control" means (i) the power, direct or indirect, to cause the
19
+ direction or management of such entity, whether by contract or
20
+ otherwise, or (ii) ownership of fifty percent (50%) or more of the
21
+ outstanding shares, or (iii) beneficial ownership of such entity.
22
+
23
+ "You" (or "Your") shall mean an individual or Legal Entity
24
+ exercising permissions granted by this License.
25
+
26
+ "Source" form shall mean the preferred form for making modifications,
27
+ including but not limited to software source code, documentation
28
+ source, and configuration files.
29
+
30
+ "Object" form shall mean any form resulting from mechanical
31
+ transformation or translation of a Source form, including but
32
+ not limited to compiled object code, generated documentation,
33
+ and conversions to other media types.
34
+
35
+ "Work" shall mean the work of authorship, whether in Source or
36
+ Object form, made available under the License, as indicated by a
37
+ copyright notice that is included in or attached to the work
38
+ (an example is provided in the Appendix below).
39
+
40
+ "Derivative Works" shall mean any work, whether in Source or Object
41
+ form, that is based on (or derived from) the Work and for which the
42
+ editorial revisions, annotations, elaborations, or other modifications
43
+ represent, as a whole, an original work of authorship. For the purposes
44
+ of this License, Derivative Works shall not include works that remain
45
+ separable from, or merely link (or bind by name) to the interfaces of,
46
+ the Work and Derivative Works thereof.
47
+
48
+ "Contribution" shall mean any work of authorship, including
49
+ the original version of the Work and any modifications or additions
50
+ to that Work or Derivative Works thereof, that is intentionally
51
+ submitted to Licensor for inclusion in the Work by the copyright owner
52
+ or by an individual or Legal Entity authorized to submit on behalf of
53
+ the copyright owner. For the purposes of this definition, "submitted"
54
+ means any form of electronic, verbal, or written communication sent
55
+ to the Licensor or its representatives, including but not limited to
56
+ communication on electronic mailing lists, source code control systems,
57
+ and issue tracking systems that are managed by, or on behalf of, the
58
+ Licensor for the purpose of discussing and improving the Work, but
59
+ excluding communication that is conspicuously marked or otherwise
60
+ designated in writing by the copyright owner as "Not a Contribution."
61
+
62
+ "Contributor" shall mean Licensor and any individual or Legal Entity
63
+ on behalf of whom a Contribution has been received by Licensor and
64
+ subsequently incorporated within the Work.
65
+
66
+ 2. Grant of Copyright License. Subject to the terms and conditions of
67
+ this License, each Contributor hereby grants to You a perpetual,
68
+ worldwide, non-exclusive, no-charge, royalty-free, irrevocable
69
+ copyright license to reproduce, prepare Derivative Works of,
70
+ publicly display, publicly perform, sublicense, and distribute the
71
+ Work and such Derivative Works in Source or Object form.
72
+
73
+ 3. Grant of Patent License. Subject to the terms and conditions of
74
+ this License, each Contributor hereby grants to You a perpetual,
75
+ worldwide, non-exclusive, no-charge, royalty-free, irrevocable
76
+ (except as stated in this section) patent license to make, have made,
77
+ use, offer to sell, sell, import, and otherwise transfer the Work,
78
+ where such license applies only to those patent claims licensable
79
+ by such Contributor that are necessarily infringed by their
80
+ Contribution(s) alone or by combination of their Contribution(s)
81
+ with the Work to which such Contribution(s) was submitted. If You
82
+ institute patent litigation against any entity (including a
83
+ cross-claim or counterclaim in a lawsuit) alleging that the Work
84
+ or a Contribution incorporated within the Work constitutes direct
85
+ or contributory patent infringement, then any patent licenses
86
+ granted to You under this License for that Work shall terminate
87
+ as of the date such litigation is filed.
88
+
89
+ 4. Redistribution. You may reproduce and distribute copies of the
90
+ Work or Derivative Works thereof in any medium, with or without
91
+ modifications, and in Source or Object form, provided that You
92
+ meet the following conditions:
93
+
94
+ (a) You must give any other recipients of the Work or
95
+ Derivative Works a copy of this License; and
96
+
97
+ (b) You must cause any modified files to carry prominent notices
98
+ stating that You changed the files; and
99
+
100
+ (c) You must retain, in the Source form of any Derivative Works
101
+ that You distribute, all copyright, patent, trademark, and
102
+ attribution notices from the Source form of the Work,
103
+ excluding those notices that do not pertain to any part of
104
+ the Derivative Works; and
105
+
106
+ (d) If the Work includes a "NOTICE" text file as part of its
107
+ distribution, then any Derivative Works that You distribute must
108
+ include a readable copy of the attribution notices contained
109
+ within such NOTICE file, excluding those notices that do not
110
+ pertain to any part of the Derivative Works, in at least one
111
+ of the following places: within a NOTICE text file distributed
112
+ as part of the Derivative Works; within the Source form or
113
+ documentation, if provided along with the Derivative Works; or,
114
+ within a display generated by the Derivative Works, if and
115
+ wherever such third-party notices normally appear. The contents
116
+ of the NOTICE file are for informational purposes only and
117
+ do not modify the License. You may add Your own attribution
118
+ notices within Derivative Works that You distribute, alongside
119
+ or as an addendum to the NOTICE text from the Work, provided
120
+ that such additional attribution notices cannot be construed
121
+ as modifying the License.
122
+
123
+ You may add Your own copyright statement to Your modifications and
124
+ may provide additional or different license terms and conditions
125
+ for use, reproduction, or distribution of Your modifications, or
126
+ for any such Derivative Works as a whole, provided Your use,
127
+ reproduction, and distribution of the Work otherwise complies with
128
+ the conditions stated in this License.
129
+
130
+ 5. Submission of Contributions. Unless You explicitly state otherwise,
131
+ any Contribution intentionally submitted for inclusion in the Work
132
+ by You to the Licensor shall be under the terms and conditions of
133
+ this License, without any additional terms or conditions.
134
+ Notwithstanding the above, nothing herein shall supersede or modify
135
+ the terms of any separate license agreement you may have executed
136
+ with Licensor regarding such Contributions.
137
+
138
+ 6. Trademarks. This License does not grant permission to use the trade
139
+ names, trademarks, service marks, or product names of the Licensor,
140
+ except as required for reasonable and customary use in describing the
141
+ origin of the Work and reproducing the content of the NOTICE file.
142
+
143
+ 7. Disclaimer of Warranty. Unless required by applicable law or
144
+ agreed to in writing, Licensor provides the Work (and each
145
+ Contributor provides its Contributions) on an "AS IS" BASIS,
146
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
147
+ implied, including, without limitation, any warranties or conditions
148
+ of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A
149
+ PARTICULAR PURPOSE. You are solely responsible for determining the
150
+ appropriateness of using or redistributing the Work and assume any
151
+ risks associated with Your exercise of permissions under this License.
152
+
153
+ 8. Limitation of Liability. In no event and under no legal theory,
154
+ whether in tort (including negligence), contract, or otherwise,
155
+ unless required by applicable law (such as deliberate and grossly
156
+ negligent acts) or agreed to in writing, shall any Contributor be
157
+ liable to You for damages, including any direct, indirect, special,
158
+ incidental, or consequential damages of any character arising as a
159
+ result of this License or out of the use or inability to use the
160
+ Work (including but not limited to damages for loss of goodwill,
161
+ work stoppage, computer failure or malfunction, or any and all
162
+ other commercial damages or losses), even if such Contributor
163
+ has been advised of the possibility of such damages.
164
+
165
+ 9. Accepting Warranty or Additional Liability. While redistributing
166
+ the Work or Derivative Works thereof, You may choose to offer,
167
+ and charge a fee for, acceptance of support, warranty, indemnity,
168
+ or other liability obligations and/or rights consistent with this
169
+ License. However, in accepting such obligations, You may act only
170
+ on Your own behalf and on Your sole responsibility, not on behalf
171
+ of any other Contributor, and only if You agree to indemnify,
172
+ defend, and hold each Contributor harmless for any liability
173
+ incurred by, or claims asserted against, such Contributor by reason
174
+ of your accepting any such warranty or additional liability.
175
+
176
+ END OF TERMS AND CONDITIONS
177
+
178
+ APPENDIX: How to apply the Apache License to your work.
179
+
180
+ To apply the Apache License to your work, attach the following
181
+ boilerplate notice, with the fields enclosed by brackets "[]"
182
+ replaced with your own identifying information. (Don't include
183
+ the brackets!) The text should be enclosed in the appropriate
184
+ comment syntax for the file format. We also recommend that a
185
+ file or class name and description of purpose be included on the
186
+ same "printed page" as the copyright notice for easier
187
+ identification within third-party archives.
188
+
189
+ Copyright [yyyy] [name of copyright owner]
190
+
191
+ Licensed under the Apache License, Version 2.0 (the "License");
192
+ you may not use this file except in compliance with the License.
193
+ You may obtain a copy of the License at
194
+
195
+ http://www.apache.org/licenses/LICENSE-2.0
196
+
197
+ Unless required by applicable law or agreed to in writing, software
198
+ distributed under the License is distributed on an "AS IS" BASIS,
199
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
200
+ See the License for the specific language governing permissions and
201
+ limitations under the License.
data/README.md ADDED
@@ -0,0 +1,39 @@
1
+ # tiny-presto
2
+
3
+ Tiny [Presto](https://prestosql.io/) cluster to check the compatibility of query result by using the specific Presto version.
4
+
5
+ # Install
6
+
7
+ ```
8
+ $ gem install tiny-presto
9
+ ```
10
+
11
+ # Prerequisites
12
+
13
+ tiny-presto uses Docker to run single node Presto cluster. Please ensure to install the Docker engine properly in advance.
14
+
15
+ See [Docker Engine overview](https://docs.docker.com/install/)
16
+
17
+ # Usage
18
+
19
+ You can run the query easily as follows.
20
+
21
+ ```ruby
22
+ rows = TinyPresto.run('show schemas')
23
+ # => [["default"], ["information_schema"]]
24
+ ```
25
+
26
+ As tiny-presto uses the memory connector as default, it is also possible to create a table.
27
+
28
+ ```ruby
29
+ TinyPresto.run("create table ctas1 as select * from (values (1, 'a'), (2, 'b')) t(c1, c2)")
30
+ rows = TinyPresto.run("select * from ctas1")
31
+ # => [[1, 'a'], [2, 'b']]
32
+ ```
33
+
34
+ To check the result consistency, `verify` method is available.
35
+
36
+ ```ruby
37
+ result = TinyPresto.verify('show schemas', [["default"], ["information_schema"]])
38
+ # result is true if the returned value by the query matched with the given expected result.
39
+ ```
data/Rakefile ADDED
@@ -0,0 +1,11 @@
1
+ #!/usr/bin/env rake
2
+ require 'bundler/gem_tasks'
3
+
4
+ require 'rake/testtask'
5
+ require 'rake/clean'
6
+
7
+ require 'rspec/core/rake_task'
8
+
9
+ RSpec::Core::RakeTask.new(:spec) do |t|
10
+ t.fail_on_error = false
11
+ end
data/lib/tiny-presto.rb ADDED
@@ -0,0 +1,50 @@
1
+ require 'tiny-presto/version'
2
+ require 'tiny-presto/cluster'
3
+
4
+ require 'singleton'
5
+ require 'presto-client'
6
+
7
+ module TinyPresto
8
+ class TinyPresto
9
+ include Singleton
10
+
11
+ attr_reader :cluster, :client
12
+
13
+ def initialize
14
+ url = 'localhost'
15
+ @cluster = Cluster.new(url)
16
+ @cluster.run
17
+ @client = Presto::Client.new(server: "#{url}:8080", catalog: 'memory', user: 'tiny-user', schema: 'default')
18
+ loop do
19
+ begin
20
+ @client.run('show schemas')
21
+ break
22
+ rescue StandardError => e
23
+ # Waiting for the cluster is launched
24
+ sleep(1)
25
+ end
26
+ end
27
+ end
28
+
29
+ def stop
30
+ @cluster.stop
31
+ end
32
+ end
33
+
34
+ def self.run(sql)
35
+ presto = TinyPresto.instance
36
+ _, rows = presto.client.run(sql)
37
+ rows
38
+ end
39
+
40
+ def self.verify(sql, expected_result)
41
+ presto = TinyPresto.instance
42
+ _, rows = presto.client.run(sql)
43
+ rows == expected_result
44
+ end
45
+
46
+ def self.ensure_stop
47
+ presto = TinyPresto.instance
48
+ presto.stop
49
+ end
50
+ end
data/lib/tiny-presto/cluster.rb ADDED
@@ -0,0 +1,34 @@
1
+ require 'docker-api'
2
+
3
+ module TinyPresto
4
+ class Cluster
5
+ def initialize(url, tag = 'latest')
6
+ @url = url
7
+ @tag = tag
8
+ @image_name = "prestosql/presto:#{@tag}"
9
+ end
10
+
11
+ def run
12
+ # Ensure to pull the specified image
13
+ Docker::Image.create('fromImage' => @image_name)
14
+ @container = Docker::Container.create(
15
+ 'Image' => @image_name,
16
+ 'HostConfig' => {
17
+ 'PortBindings' => {
18
+ '8080/tcp' => [
19
+ {
20
+ 'HostPort' => '8080'
21
+ }
22
+ ]
23
+ }
24
+ }
25
+ )
26
+ @container.start
27
+ @container
28
+ end
29
+
30
+ def stop
31
+ @container.stop
32
+ end
33
+ end
34
+ end
data/lib/tiny-presto/version.rb ADDED
@@ -0,0 +1,3 @@
1
+ module TinyPresto
2
+ VERSION = '0.0.1'.freeze
3
+ end
data/spec/cluster_spec.rb ADDED
@@ -0,0 +1,40 @@
1
+ require 'spec_helper'
2
+
3
+ RSpec.describe TinyPresto::Cluster do
4
+ describe 'cluster' do
5
+ before(:all) do
6
+ @cluster = TinyPresto::Cluster.new('localhost')
7
+ @container = @cluster.run
8
+ @client = Presto::Client.new(server: 'localhost:8080', catalog: 'memory', user: 'tiny-user', schema: 'default')
9
+ loop do
10
+ begin
11
+ @client.run('show schemas')
12
+ break
13
+ rescue StandardError => exception
14
+ puts 'Waiting for cluster ready...'
15
+ sleep(3)
16
+ end
17
+ end
18
+ puts 'Cluster is ready'
19
+ end
20
+
21
+ after(:all) do
22
+ @cluster.stop
23
+ end
24
+
25
+ it 'correct container' do
26
+ expect(@container).to be_truthy
27
+ end
28
+
29
+ it 'run read query' do
30
+ columns, rows = @client.run('show schemas')
31
+ expect(rows.length).to be(2)
32
+ end
33
+
34
+ it 'run CTAS query' do
35
+ @client.run("create table ctas1 as select * from (values (1, 'a'), (2, 'b')) t(c1, c2)")
36
+ columns, rows = @client.run('select * from ctas1')
37
+ expect(columns.map(&:name)).to match_array(%w[c1 c2])
38
+ end
39
+ end
40
+ end
data/spec/spec_helper.rb ADDED
@@ -0,0 +1,12 @@
1
+ require 'bundler'
2
+
3
+ begin
4
+ Bundler.setup(:default, :test)
5
+ rescue Bundler::BundlerError => e
6
+ warn e.message
7
+ warn 'Run `bundle install` to install missing gems'
8
+ exit e.status_code
9
+ end
10
+
11
+ require 'tiny-presto'
12
+ require 'presto-client'
data/spec/tiny_presto_spec.rb ADDED
@@ -0,0 +1,22 @@
1
+ require 'spec_helper'
2
+
3
+ RSpec.describe TinyPresto do
4
+ after(:all) do
5
+ TinyPresto.ensure_stop
6
+ end
7
+
8
+ describe 'run query' do
9
+ it 'correctly' do
10
+ rows = TinyPresto.run('show schemas')
11
+ expect(rows.size).to eq(2)
12
+ expect(rows[0]).to eq(['default'])
13
+ expect(rows[1]).to eq(['information_schema'])
14
+ end
15
+
16
+ it 'verify' do
17
+ expected = [[1, 'a'], [2, 'b']]
18
+ result = TinyPresto.verify("select * from (values (1, 'a'), (2, 'b')) t(c1, c2)", expected)
19
+ expect(result).to eq(true)
20
+ end
21
+ end
22
+ end
data/spec/version_spec.rb ADDED
@@ -0,0 +1,9 @@
1
+ require 'spec_helper'
2
+
3
+ RSpec.describe TinyPresto do
4
+ describe '#version' do
5
+ it 'correct' do
6
+ expect(TinyPresto::VERSION).to eq('0.0.1')
7
+ end
8
+ end
9
+ end
data/tiny-presto.gemspec ADDED
@@ -0,0 +1,27 @@
1
+ require File.expand_path 'lib/tiny-presto/version', File.dirname(__FILE__)
2
+
3
+ Gem::Specification.new do |gem|
4
+ gem.name = 'tiny-presto'
5
+ gem.version = TinyPresto::VERSION
6
+
7
+ gem.authors = ['Kai Sasaki']
8
+ gem.email = ['lewuathe@me.com']
9
+ gem.description = 'Wrapper for Lightweight Presto Cluster'
10
+ gem.summary = 'For Presto functionality testing'
11
+ gem.homepage = 'https://github.com/Lewuathe/tiny-presto'
12
+ gem.license = 'Apache 2.0'
13
+
14
+ gem.files = `git ls-files`.split($OUTPUT_RECORD_SEPARATOR)
15
+ gem.executables = gem.files.grep(%r{^bin/}).map { |f| File.basename(f) }
16
+ gem.test_files = gem.files.grep(%r{^(test|spec|features)/})
17
+ gem.require_paths = ['lib']
18
+ gem.has_rdoc = false
19
+
20
+ gem.required_ruby_version = '>= 2.5.0'
21
+
22
+ gem.add_dependency 'docker-api', ['~> 1.34.0']
23
+ gem.add_dependency 'faraday', ['~> 0.12']
24
+
25
+ gem.add_development_dependency 'rake', ['~> 13.0.0']
26
+ gem.add_development_dependency 'rspec', ['~> 3.9.0']
27
+ end
metadata ADDED
@@ -0,0 +1,121 @@
1
+ --- !ruby/object:Gem::Specification
2
+ name: tiny-presto
3
+ version: !ruby/object:Gem::Version
4
+ version: 0.0.1
5
+ platform: ruby
6
+ authors:
7
+ - Kai Sasaki
8
+ autorequire:
9
+ bindir: bin
10
+ cert_chain: []
11
+ date: 2020-01-14 00:00:00.000000000 Z
12
+ dependencies:
13
+ - !ruby/object:Gem::Dependency
14
+ name: docker-api
15
+ requirement: !ruby/object:Gem::Requirement
16
+ requirements:
17
+ - - "~>"
18
+ - !ruby/object:Gem::Version
19
+ version: 1.34.0
20
+ type: :runtime
21
+ prerelease: false
22
+ version_requirements: !ruby/object:Gem::Requirement
23
+ requirements:
24
+ - - "~>"
25
+ - !ruby/object:Gem::Version
26
+ version: 1.34.0
27
+ - !ruby/object:Gem::Dependency
28
+ name: faraday
29
+ requirement: !ruby/object:Gem::Requirement
30
+ requirements:
31
+ - - "~>"
32
+ - !ruby/object:Gem::Version
33
+ version: '0.12'
34
+ type: :runtime
35
+ prerelease: false
36
+ version_requirements: !ruby/object:Gem::Requirement
37
+ requirements:
38
+ - - "~>"
39
+ - !ruby/object:Gem::Version
40
+ version: '0.12'
41
+ - !ruby/object:Gem::Dependency
42
+ name: rake
43
+ requirement: !ruby/object:Gem::Requirement
44
+ requirements:
45
+ - - "~>"
46
+ - !ruby/object:Gem::Version
47
+ version: 13.0.0
48
+ type: :development
49
+ prerelease: false
50
+ version_requirements: !ruby/object:Gem::Requirement
51
+ requirements:
52
+ - - "~>"
53
+ - !ruby/object:Gem::Version
54
+ version: 13.0.0
55
+ - !ruby/object:Gem::Dependency
56
+ name: rspec
57
+ requirement: !ruby/object:Gem::Requirement
58
+ requirements:
59
+ - - "~>"
60
+ - !ruby/object:Gem::Version
61
+ version: 3.9.0
62
+ type: :development
63
+ prerelease: false
64
+ version_requirements: !ruby/object:Gem::Requirement
65
+ requirements:
66
+ - - "~>"
67
+ - !ruby/object:Gem::Version
68
+ version: 3.9.0
69
+ description: Wrapper for Lightweight Presto Cluster
70
+ email:
71
+ - lewuathe@me.com
72
+ executables: []
73
+ extensions: []
74
+ extra_rdoc_files: []
75
+ files:
76
+ - ".gitignore"
77
+ - ".pre-commit-config.yaml"
78
+ - ".rubocop.yml"
79
+ - ".rubocop_todo.yml"
80
+ - Gemfile
81
+ - Gemfile.lock
82
+ - LICENSE
83
+ - README.md
84
+ - Rakefile
85
+ - lib/tiny-presto.rb
86
+ - lib/tiny-presto/cluster.rb
87
+ - lib/tiny-presto/version.rb
88
+ - spec/cluster_spec.rb
89
+ - spec/spec_helper.rb
90
+ - spec/tiny_presto_spec.rb
91
+ - spec/version_spec.rb
92
+ - tiny-presto.gemspec
93
+ homepage: https://github.com/Lewuathe/tiny-presto
94
+ licenses:
95
+ - Apache 2.0
96
+ metadata: {}
97
+ post_install_message:
98
+ rdoc_options: []
99
+ require_paths:
100
+ - lib
101
+ required_ruby_version: !ruby/object:Gem::Requirement
102
+ requirements:
103
+ - - ">="
104
+ - !ruby/object:Gem::Version
105
+ version: 2.5.0
106
+ required_rubygems_version: !ruby/object:Gem::Requirement
107
+ requirements:
108
+ - - ">="
109
+ - !ruby/object:Gem::Version
110
+ version: '0'
111
+ requirements: []
112
+ rubyforge_project:
113
+ rubygems_version: 2.7.6
114
+ signing_key:
115
+ specification_version: 4
116
+ summary: For Presto functionality testing
117
+ test_files:
118
+ - spec/cluster_spec.rb
119
+ - spec/spec_helper.rb
120
+ - spec/tiny_presto_spec.rb
121
+ - spec/version_spec.rb