Onyx Framework/Lobby

Enjoy the performance 💪 https://onyxframework.org

Adrian Madrid

@aemadrid

just trying to debug something

but it is still a nice way to document/show people what your app can do

figured out my problem but it would have been nice to know

Dainel Vera

@arubinofaux_twitter

Hey @vladfaust quick question, i was just testing EDA with a redis url that contains a password. it resulted in this error

DEBUG [19:56:36.550 #1] [redis] CLIENT ID

Unhandled exception: NOAUTH Authentication required. (MiniRedis::Error)
  from ???
  from /usr/share/crystal/src/pointer.cr:434:13 in 'receive'
  from lib/mini_redis/src/mini_redis.cr:176:15 in 'send_impl'
  from lib/mini_redis/src/mini_redis.cr:89:5 in '???'
  from lib/onyx-http/src/onyx-http/ext/http/request/path_params.cr:1:1 in '__crystal_main'
  from /usr/share/crystal/src/crystal/main.cr:47:14 in 'main'
  from __libc_start_main
  from _start
  from ???

Vlad Faust

@vladfaust

Well, there is no specification in Redis for URI authentication, and mini_redis does not implement any custom wrapping as well

As a workaround, you could pass custom MiniRedis instance to Onyx::EDA: Onyx::EDA::Channel::Redis.new

Mini::Redis.new(uri)

Just call redis.send("AUTH", password) before, as seen at redis.io

You could create an issue @ mini_redis if you think this should be automated

Dainel Vera

@arubinofaux_twitter

@vladfaust thanks for the reply, it makes a lot more sense to me now

Qinsi (James) ZHU

@qszhu

Is there a way to use aggregate functions with the SQL builder? Currently I’m using the raw SQL like Onyx::SQL.scalar(“select avg(score) from scores where …”).

Vlad Faust

@vladfaust

That's the perfect way. Query builder is designed to be minimal, with very common things only

Qinsi (James) ZHU

@qszhu

I see. Thanks!

Vlad Faust

@vladfaust

Also, you could do that: Onyx::SQL.scalar(User.where(a: b).select("avg(score)"))

As most of query builder methods support raw SQL

Qinsi (James) ZHU

@qszhu

Nice! Wasn't aware of that

Vlad Faust

@vladfaust

The real reason for Query builder existence is that I didn't want to type full table names in SQL queries =) And also converting SQL rows to Crystal. That's minimal

I never intended to replace SQL. You should know raw SQL to make it work better, anyway

Qinsi (James) ZHU

@qszhu

Just enough to solve my problem👍

Vlad Faust

@vladfaust

That's another Onyx's motto =)

Qinsi (James) ZHU

@qszhu

I’m trying to return all the fields of a reference with join according to the doc: https://docs.onyxframework.org/sql/query.html#join Say I want to get all the fields of author. Do I have to write raw sql like

  .join(author: true) do |x|
    x.select(“author.*”)
  end

or is there any other way?

Vlad Faust

@vladfaust

Onyx::SQL is broken on 0.29.0. See onyxframework/sql#106. Any help would be appreciated

Vlad Faust

@vladfaust

Everything's fine, gonna update to 0.29.0 tomorrow :tada:

Hey @qszhu, sorry for the late response. You can do this:

.join(author: true, &.select(User))

This would effectively select all the fields of the author with proper table naming author. instead of users.

Qinsi (James) ZHU

@qszhu

I see. Now that makes sense. Thanks!

Mia Iversen

@chillfox

I am not really getting how to make this work.
(first time I am trying to use a database instead of flat files)

what I would like to do is:

p headings[0].book.title

The code...
(sqlite)

CREATE TABLE book (
  book         INTEGER      PRIMARY KEY,
  title           TEXT              NOT NULL
);

CREATE TABLE heading (
  heading  INTEGER  PRIMARY KEY,
  title      TEXT     NOT NULL,
  page     INTEGER  NOT NULL,
  book     INTEGER  NOT NULL,
  FOREIGN KEY (book) REFERENCES book(book)
);

class Models::Book
  include Onyx::SQL::Model

  schema book do
    pkey book : Int64
    type title : String, not_null: true
  end
end

class Models::Heading
  include Onyx::SQL::Model

  schema heading do
    pkey heading : Int64
    type title : String, not_null: true
    type page : Int32, not_null: true
    type book : Book, not_null: true, key: "book"
  end
end


headings = Onyx::SQL.query(Models::Heading.join(book: true, &.select(Models::Book)))
pp headings

Mia Iversen

@chillfox

The error I get when trying the above

Error in src/mini_index.cr:73: no overload matches 'Models::Heading.join', book: Bool
Overloads are:
 - Onyx::SQL::Model::ClassQueryShortcuts(T)#join(table : String, on : String, as _as : String | ::Nil = nil, type : Onyx::SQL::Query::JoinType = :inner)
 - Onyx::SQL::Model::ClassQueryShortcuts(T)#join(reference : T::Reference, on : String | ::Nil = nil, as _as : String = reference.to_s.underscore, type : Onyx::SQL::Query::JoinType = :inner)
 - Onyx::SQL::Model::ClassQueryShortcuts(T)#join(reference : T::Reference, klass, *, on : String | ::Nil = nil, as _as : String = reference.to_s.underscore, type : JoinType = :inner, &block)

  headings = Onyx::SQL.query(Models::Heading.join(book: true, &.select(Models::Book)))

I can work around it like this

headings = Onyx::SQL.query(Models::Heading.all)
books = Onyx::SQL.query(Models::Book.all)

pp books.select {|b| b.book == headings[0].book.try(&.book)} .first.title

Does anyone have any idea of what I am doing wrong?

Cristian Șerb

@cserb

This message was deleted

Marwan Rabbâa

@waghanza

Hi, has anyone create a static binary of an onyx app ?

https://github.com/the-benchmarker/web-frameworks/pull/1578#issuecomment-522216109

Daniel Worrall

@Daniel-Worrall

Can I use EDA https://github.com/onyxframework/eda to emit a generic Event so I can handle events from "all" events?

Vlad Faust

@vladfaust

Sorry, I don't understand the question

Daniel Worrall

@Daniel-Worrall

I was looking to subscribe a handler to a generic class like Foo(T) but I worked around it by subscribing it on Foo(All) where all is a union alias

Then when I have Foo(Specific) i can emit it, then make a new Foo(All) from that and emit it too. Not ideal but it's okay

Where communities thrive

People

Repo info

Activity