tanweerdev / fat_ecto Goto Github PK

Query mechanism for Ecto

Elixir 100.00%

ecto elixir-library query-language query-mechanism utils

fat_ecto's Introduction

Hi there 👋

I am a senior full-stack software engineer with a focus on building intuitive and effective web applications in Elixir(Erlang), Nodejs, Ruby, Golang and Angular/react/Vue using best practices and common design patterns. I am a problem solver, architect and have more than 7 years of industry Experience.

I can inter-convert nodejs, elixir/erlang, RoR codebase.
I have a very firm grasp in TDD, deployments and API development.
I have a firm grasp in working with iot devices(via mqtt).
I provide High-quality, maintainable backend and frontend solutions.
I can work on creating complex web applications.
I can create single-page web applications (SPA) using Angular/Vue/React.
I offer services in 3rd party API integrations.
Payment gateways integration (Stripe, PayPal etc).
Graphql
IoT/IoT core Backend + APIS
Able to work as part of a team or solely. I can also lead/manage a team for you.

I have worked on enterprise level applications and projects with millions of users. I have good experience with indexing, complex queries, caching, common security holes and dealing with big data.

fat_ecto's People

Contributors

Stargazers

Watchers

Forkers

fahad-fk ibarrae kashanahmed867 rotabull

fat_ecto's Issues

FatEcto.FatContext generates a lot of warnings upon compilation

Upon compiling fat_ecto for the first time, I get the following warnings:

==> fat_ecto
Compiling 25 files (.ex)
warning: function nil.all/1 is undefined (module nil is not available)
Found at 2 locations:
  lib/fat_ecto/context.ex:68
  lib/fat_ecto/paginator.ex:66

warning: function nil.all/2 is undefined (module nil is not available)
  lib/fat_ecto/context.ex:140

warning: function nil.delete/1 is undefined (module nil is not available)
  lib/fat_ecto/context.ex:116

warning: function nil.delete_all/1 is undefined (module nil is not available)
  lib/fat_ecto/context.ex:122

warning: function nil.get/2 is undefined (module nil is not available)
Found at 2 locations:
  lib/fat_ecto/context.ex:76
  lib/fat_ecto/context.ex:85

warning: function nil.get!/2 is undefined (module nil is not available)
  lib/fat_ecto/context.ex:72

warning: function nil.get_by/2 is undefined (module nil is not available)
  lib/fat_ecto/context.ex:96

warning: function nil.insert/1 is undefined (module nil is not available)
  lib/fat_ecto/context.ex:104

warning: function nil.one/1 is undefined (module nil is not available)
Found at 6 locations:
  lib/fat_ecto/context.ex:24
  lib/fat_ecto/context.ex:43
  lib/fat_ecto/context.ex:49
  lib/fat_ecto/context.ex:56
  lib/fat_ecto/paginator.ex:76
  lib/fat_ecto/query.ex:158

warning: function nil.preload/2 is undefined (module nil is not available)
Found at 5 locations:
  lib/fat_ecto/context.ex:68
  lib/fat_ecto/context.ex:78
  lib/fat_ecto/context.ex:86
  lib/fat_ecto/context.ex:97
  lib/fat_ecto/context.ex:141

warning: function nil.update/1 is undefined (module nil is not available)
  lib/fat_ecto/context.ex:111

I see that one can use this module by use FatEcto.FatContext, repo: MyRepo, but I'm not doing this as I don't need this module so it generates a lot of useless warnings. Any ideas?

How to create "or" statements in the same table/field

Hi again 👋

I was wondering how could we create the following query?

select parent.* 
left join child on child.parent_id = parent.id 
where ((child.field > 5 and child.field < 2) or (child.field IS NULL))

I know that there's the "$or" key at the moment but it doesn't seem to do what we need 😢.

Thanks in advance again for the help!

Error while using `$where` with DateTime values

Hi! First, let me thank you for all the effort in this library 🎉

I'm opening this issue because there's seems to be an error when applying eq operations with DateTime values (potentially with other date-time structs too).

The one bellow works correctly:

opts = %{
  "child_table" => %{
    "$where" => %{
      "inserted_at" => %{
        "$gt" => ~U[2020-01-01 00:00:00Z],
        "$lt" => ~U[2022-01-01 00:00:00Z]
      },
      "value" => 3000
    }
  }
}

build!(MyApp.Model, %{"include" => opts})

But the following example doesn't seem to work 😞. Is there's something wrong with the options and trying to apply in this case?

opts = %{
  "child_table" => %{
    "$where" => %{
      "inserted_at" => ~U[2022-01-01 00:00:00Z],
      "value" => 3000
    }
  }
}

build!(MyApp.Model, %{"include" => opts})

Here's the stack trace of the error:

[error] ** (Protocol.UndefinedError) protocol Enumerable not implemented for ~U[2020-01-01 00:00:00Z] of type DateTime (a struct)
    (elixir 1.11.2) lib/enum.ex:1: Enumerable.impl_for!/1
    (elixir 1.11.2) lib/enum.ex:141: Enumerable.reduce/3
    (elixir 1.11.2) lib/enum.ex:3461: Enum.reduce/3
    (stdlib 3.14) maps.erl:233: :maps.fold_1/3
    (fat_ecto 0.5.0) lib/fat_ecto/query/where.ex:741: FatEcto.FatQuery.FatWhere.build_where/4
    (fat_ecto 0.5.0) lib/fat_ecto/query/include.ex:113: anonymous fn/4 in FatEcto.FatQuery.FatInclude.build_include/4
    (stdlib 3.14) maps.erl:233: :maps.fold_1/3

tanweerdev / fat_ecto Goto Github PK

fat_ecto's Introduction

Hi there 👋

fat_ecto's People

Contributors

Stargazers

Watchers

Forkers

fat_ecto's Issues

FatEcto.FatContext generates a lot of warnings upon compilation

How to create "or" statements in the same table/field

Error while using `$where` with DateTime values

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent