lolitado
Library for using database and API
How to call database?
You need to do these things：
- put all sql in sql.yml or in code
- put database connect info in xx_db.yml
run case like
pool = Lolitado:Pool.new('xx_db.yml')
db = pool.use(:db =>'db_name')
sql = "select * from identity.user where phone = '+86 139 0000 0000"
result = db.query(sql)How to call API?
run case like
* Rest API
class TestRest
include Lolitado
def initialize
base_uri 'https://xxx.com'
end
def get_details_of_a_city city_slug, locale
add_headers({'Accept-Language' => locale})
request('get', "/cities/#{city_slug}")
end
end
* Graph API
class TestGraph
include Lolitado
def initialize
base_uri 'https://xxx.com'
end
def user_login payload
add_headers({'Content-Type' => "application/json"})
query = "mutation login($input: UserLoginInput!) {userLogin(input:$input) {authToken}}"
graph_request(query, payload)
end
endHow to encrypt/decrypt credential file?
- Initialize Box with secret key of environment variable
- file_encrypt to encrypt the file
- file_decrypt to decrypt the file
box = Lolitado:Box.new('ENV_KEY')
box.file_encrypt('file_name')
box.file_decrypt('encrypt_file_name')