crystal-lang/crystal

The Crystal programming language | http://crystal-lang.org | Fund Crystal's development: http://is.gd/X7PRtI | Docs: http://crystal-lang.org/docs/ | API: http://crystal-lang.org/api/

Rubi

@codenoid

hi, how to statically define this value ( {"key":"val","key":"val"} ) inside crystal variable

Serdar Dogruyol - Sedo セド

@sdogruyol

@codenoid

STATIC_VAR = {"key":"val","key":"val"}

Indra Gunawan

@coderbuzz

Morning...

Rubi

@codenoid

nope, wont work @sdogruyol

it's a json value, please,

Syntax error in src/toped.cr:8: expecting token '=>', not 'val'

STATIC_VAR = {"key":"val","key":"val"}

Serdar Dogruyol - Sedo セド

@sdogruyol

@codenoid https://play.crystal-lang.org/#/r/2j4o

Hanyuan Li

@hanyuone

bmcginty Whoa, that's neat :)

Rubi

@codenoid

my static value is {"key":"val","key":"val"} not {"key" => "val","key" =>"val"}

Serdar Dogruyol - Sedo セド

@sdogruyol

the first is a NamedTuple the second is a Hash

Hanyuan Li

@hanyuone

@codenoid => is Crystal syntax for key-value pairs

Rubi

@codenoid

but its json value :(

Hanyuan Li

@hanyuone

Ohhhhh

Sorry, my mistake

Serdar Dogruyol - Sedo セド

@sdogruyol

@codenoid i still don't get your point

Hanyuan Li

@hanyuone

I don't think you can do that, You might have to wrap it around a toJSON thing

Serdar Dogruyol - Sedo セド

@sdogruyol

just use a String then

Ghost

@ghost~55586c4815522ed4b3e08557

@codenoid you want var = %({"your": "json"})

Rubi

@codenoid

why crystal didnt read first " and last " as a opening and closing string

@bew cool thanks @bew

Ghost

@ghost~55586c4815522ed4b3e08557

:smile:

Because %() %[] and %<> are other string separators

All are in the docs https://crystal-lang.org/docs/syntax_and_semantics/literals/string.html

Dru Jensen

@drujensen

or you could escape all the inner quotes ”{\"key\": \"val\",\"key2\": \"val\”}” but that is some ugly code ;)

Rubi

@codenoid

^ agree

Gabriel Torrecillas Sartori

@G4BB3R

This message was deleted

I need help, very beginner here. I am using Crecto, look my Repo.cr

module Repo
  extend Crecto::Repo

  config do |conf|
    conf.adapter = Crecto::Adapters::Mysql
    conf.database = "revistinha"
    conf.hostname = "localhost"
    conf.username = "root"
    conf.password = ""
    conf.port = 5432
  end
end

Then when I do this, it prints "Trying to insert" and then freezes forever, don't print nothing neither print an error

c = Consumidor.new
c.nome = "Gabb"
c.sobrenome = "Esperanto"

puts "Trying to insert..."
changeset = Repo.insert(c)
puts changeset.errors

After a few minutes waiting it throws an huge exception:
https://pastebin.com/TetU7nxy

unreadable

@unreadable

To be honest, I find it easier to work directly with the stdlib than the orm

Serdar Dogruyol - Sedo セド

@sdogruyol

@fridgerator can definitely help with that @G4BB3R

Gabriel Torrecillas Sartori

@G4BB3R

@krypton97 can I see a snippet of inserting/querying with your method? :)

Serdar Dogruyol - Sedo セド

@sdogruyol

@G4BB3R have you checked https://github.com/Crecto/crecto-admin/blob/6fea789f4d49c82cfec827ed14aa7ce93de9bcaa/src/CrectoAdmin/resource.cr#L86

it's written by the author of crecto :D

would definitely help you

unreadable

@unreadable

This is for inserting

    begin # assert for unique fiels
      SQLITE.exec "INSERT INTO users VALUES (?, ?, ?, ?)", SecureRandom.uuid, username, email, password
    rescue
      message = "Field already taken"
      render "views/register.ecr"
    else
      env.redirect "/"
    end

I'll paste for querying too

  res = SQLITE.query_one?("SELECT id, username, email, password FROM users WHERE username = ?", username, as: {String, String, String, String})
  if !res || res.last != password
    message = "Invalid username or password"
    render "views/login.ecr"
  else
    user = to_json({"id", "username", "email", "password"}, res)
    env.session.string("user", user)
    env.redirect("/")
  end

This is it pretty much all.

Serdar Dogruyol - Sedo セド

@sdogruyol

@krypton97 I also prefer your way

SQL is simple enough :)

Gabriel Torrecillas Sartori

@G4BB3R

damn now I can't decide xD
I was trying crecto because it seems to be productive
but this is very simple too

unreadable

@unreadable

Working with databases is one of the reasons I decided not to use go

From IRC (bridge bot)

@FromIRC

<Papierkorb> @krypton97, sidenote, please don't write a users table like that for production purposes.

Gabriel Torrecillas Sartori

@G4BB3R

why?

unreadable

@unreadable

anyway, I'm working on an auth sample with kemal

ikr lol

Gabriel Torrecillas Sartori

@G4BB3R

I am using Kemal too :)

The else after rescue is when everything is fine, without exceptions?

From IRC (bridge bot)

@FromIRC

<Papierkorb> yes

Gabriel Torrecillas Sartori

@G4BB3R

Great. thanks people

From IRC (bridge bot)

@FromIRC

<linuksz> http://sprunge.us/bjCC

Where communities thrive

People

Repo info

Activity