marioidival/goga

A fully RESTful API from any existing PostgreSQL database written in Rust

goga's Issues

Matches values that are less than or equal

Create a dockerfile

Matches all values that are not equal

Matches values that are greater than

set up to postgresql only

GET /databases

restructuring project

• #10
• #11
• #12
• #13
• #14
• #15
• #16
• #27
• #43

web expose

hyper, iron, rocket, others:

http://www.arewewebyet.org/

Consider src/bin/goga.rs instead of src/main.rs

I know that having both src/lib.rs and src/main.rs is suggested in the second edition of the Rust book, but for a crate that already has src/lib.rs, it's more typical to have src/bin/goga.rs instead.

Some links:

• Rust package with both a library and a binary?

• Publishing a crate containing both lib.rs and main.rs files

GET /schemas

Basic query operations

Create basic query operations

• #28
• #29
• #30
• #31
• #32
• #33
• #34
• #35
• #36
• #37
• #38
• #39
• #40
• #41
• #42

Matches if field is not false

basic configuration

As a user, I want to edit the configuration file of Goga to:

• #51
• #52
• #53

Configure postgresql information (PG HOSH, PG USER, PG PASSWORD, PG DB)

Documentation

Write Wiki / README with:

• Development set up
• Endpoints
• Using with docker
• Using standalone

Matches if field is not true

Upload to Docker hub

Matches values that are less than

POST /:database/:schema/:table

Matches if field is not null

PATCH /:database/:schema/:table

Configure Host / Port of Goga

use launchbadge/sqlx

We need to use https://github.com/launchbadge/sqlx instead of actual connection lib.

GET /tables

rewrite basic endpoints

Rewrite endpoints:

• #18
• #19
• #20
• #21
• #22
• #23
• #24
• #25
• #26

Aggregate functions

Aggregate functions perform a calculation on a set of rows and return a single row

• #44
• #45
• #46
• #47
• #48

Need create a module of Errors

All application functions should follow Error Handling of Rust

http://stevedonovan.github.io/rust-gentle-intro/6-error-handling.html

Matches always cover the entire string

Like operation

AVG - return the average value.

Matches values that are equal

Change rocket to actix

DELETE /:database/:schema/:table

Matches non of the values specified in an array

update to rust edition 2021

GET /:database/:schema

GET /:database/:schema/:table

SUM - return the sum of all or distinct values

Matches if field is null

COUNT - return the number of values.

Matches if field is false

MAX - return the maximum value.

Derive macro

How to use this macro correctly?
Where use this macro?
When use this macro?

Friday, on Globo Reporter.

Change &str to enum

http://deterministic.space/elegant-apis-in-rust.html#what-makes-an-api-elegant
https://doc.rust-lang.org/stable/book/second-edition/ch06-01-defining-an-enum.html

Coming from dynamically typed languages, you might be tempted to use strings with specific 
values in various places.

For example: You want a function to print some input text in a color, so you use a parameter
 color of type &str. That also means you expect your users to write one of the names from a
limited number of color names (like ["red", "green", "blue", "light golden rod yellow"]).

This is not what you should do in Rust! If you know all possible variants beforehand, use an enum. 
This way, you don’t need to parse/pattern match the string – and deal with possible errors – but can 
be sure that a user of your API can only ever supply valid inputs.```

Docker set up

• #49
• #50

Matches case-insensitive always cover the entire string

ILike operation

Regex instead split

https://doc.rust-lang.org/regex/regex/index.html

Matches values that are greater than or equal

PUT /:database/:schema/:table

Matches any of the values specified in an array

MIN - return the minimum value.