Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

JOIN feature #35

Closed
henriquechehad opened this issue Dec 9, 2016 · 3 comments
Closed

JOIN feature #35

henriquechehad opened this issue Dec 9, 2016 · 3 comments
Labels
enhancement
Milestone
0.1

Comments

@henriquechehad
Copy link
Contributor

It would be interesting to have a JOIN (inner, left, etc) feature?
@avelino
Copy link
Member

avelino commented Dec 20, 2016

This first version accepts 1 join, then evolve to accept more.

Syntax query:

/DATABASE/SCHEMA/TABLE??_join=inner:users:friends.userid:$eq:users.id

Parameters:

  1. Join type
  2. Table
  3. Table field 1
  4. Operator (=, <, >, <=, >=)
  5. Table field 2

Split by :

Query Operators:

Name Description
$eq Matches values that are equal to a specified value.
$gt Matches values that are greater than a specified value.
$gte Matches values that are greater than or equal to a specified value.
$lt Matches values that are less than a specified value.
$lte Matches values that are less than or equal to a specified value.
$ne Matches all values that are not equal to a specified value.
$in Matches any of the values specified in an array.
$nin Matches none of the values specified in an array.

@henriquechehad
Copy link
Contributor Author

👍

@henriquechehad
Copy link
Contributor Author

PR: #54

@felipeweb felipeweb added this to the 0.1 milestone Dec 26, 2016
avelino pushed a commit that referenced this issue Jul 16, 2020
@joelmdesouza @crgimenes
Statements encapsulate (#35)
ae19cf3 
* created statements to postgres

* changed statements import

* Changed Adapter to encapsulate statements

* Implemented encapsulate statements to postgres

* Implemented SchemaTables methods

* Ajusted TableClause

* removed permissions.go

is not used on adapters
avelino pushed a commit that referenced this issue Aug 21, 2020
@imgbot @ImgBotApp
[ImgBot] Optimize images (#35)
7a38559 
*Total -- 5,108.93kb -> 4,291.99kb (15.99%)

/themes/hugo-theme-learn/static/images/favicon.png -- 1.22kb -> 0.59kb (51.48%)
/themes/hugo-theme-learn/exampleSite/content/basics/installation/images/chapter.png -- 85.71kb -> 46.66kb (45.56%)
/themes/hugo-theme-learn/exampleSite/content/cont/pages/images/pages-chapter.png -- 243.33kb -> 152.42kb (37.36%)
/themes/hugo-theme-learn/exampleSite/content/basics/style-customization/images/red-variant.png -- 380.82kb -> 239.39kb (37.14%)
/themes/hugo-theme-learn/exampleSite/content/basics/style-customization/images/blue-variant.png -- 380.01kb -> 238.93kb (37.13%)
/themes/hugo-theme-learn/exampleSite/content/basics/style-customization/images/green-variant.png -- 381.74kb -> 240.20kb (37.08%)
/themes/hugo-theme-learn/exampleSite/content/cont/pages/images/pages-default.png -- 310.79kb -> 196.47kb (36.78%)
/themes/hugo-theme-learn/exampleSite/static/images/showcase/tat.png -- 405.21kb -> 302.69kb (25.3%)
/static/logo.png -- 27.36kb -> 22.90kb (16.31%)
/themes/hugo-theme-learn/static/images/gopher-404.jpg -- 215.36kb -> 201.42kb (6.47%)
/themes/hugo-theme-learn/static/fonts/Novecentosanswide-Normal-webfont.svg -- 100.88kb -> 96.30kb (4.54%)
/themes/hugo-theme-learn/static/fonts/Novecentosanswide-UltraLight-webfont.svg -- 93.99kb -> 89.81kb (4.44%)
/themes/hugo-theme-learn/static/fonts/fontawesome-webfont.svg -- 433.96kb -> 425.36kb (1.98%)
/themes/hugo-theme-learn/static/fonts/Work_Sans_500.svg -- 54.16kb -> 53.15kb (1.88%)
/themes/hugo-theme-learn/static/fonts/Work_Sans_300.svg -- 54.52kb -> 53.50kb (1.87%)
/themes/hugo-theme-learn/static/fonts/Work_Sans_200.svg -- 54.57kb -> 53.55kb (1.87%)
/themes/hugo-theme-learn/static/fonts/Inconsolata.svg -- 61.54kb -> 60.54kb (1.63%)
/themes/hugo-theme-learn/static/images/clippy.svg -- 0.51kb -> 0.50kb (1.16%)
/themes/hugo-theme-learn/images/tn.png -- 141.37kb -> 139.98kb (0.99%)
/themes/hugo-theme-learn/exampleSite/static/fonts/monogramos-webfont.svg -- 257.41kb -> 256.00kb (0.55%)
/themes/hugo-theme-learn/exampleSite/content/basics/requirements/images/magic.gif -- 1,424.47kb -> 1,421.65kb (0.2%)

Signed-off-by: ImgBotApp <ImgBotHelp@gmail.com>

Co-authored-by: ImgBotApp <ImgBotHelp@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
0.1
Development

No branches or pull requests
3 participants
@avelino @henriquechehad @felipeweb