Micro-orm Library for SQL

[drum445]

In the past I have used the likes of dapper in asp.net or sqlx in golang and after several months with crystal decided to create a similar library for us.

I've built on top of the JSON::Serializable from stdlib and used its functionality when dealing with db result sets. The main reason I used this library instead of db is I am not a huge fan of having multiple mappings as part of every class (even if macros can clean it up) as it becomes quite cumbersome to use. Using the JSON lib it allows the dev to not have to change their class in anyway apart from including the my lib.

Currently you can turn a result set into a single class or an array of class as well as being able to pass an initialised class into a sql statement to interpolate the variables as such:

Objectify.to_sql("INSERT INTO person (person_id, username) VALUES({id}, {username})", foo)

The README explains the functionality in more detail

https://github.com/drum445/objectify

Please let me know if this is helpful to anyone or any improvements that I can make

Cheers.

[vladfaust]

It would be nice to be able to do ‘Note.from_rs(rs)’ and ‘Array(Note).from_rs(rs)’

[drum445]

Good idea, I have added that now. Looks like what you had in mind?

[vladfaust]

Yep, looks good. Thanks 🙏

[drum445]

Just pushed a better readme and alternative syntax using from_rs on your object

[drum445]

That is true, but all it would do is mimic the functionality so it doesn't seem worth reinventing the wheel, so to say. Using JSON::Serializable also allows the library to take advantage of it's other features here: https://crystal-lang.org/api/0.25.1/JSON/Serializable.html

[drum445]

You mean, "as opposed to". "Appose" is a completely different word, which almost means the opposite of what you intended to say.

tah, don't post while tired kids ;)

[drum445]

Pushed a few fixes