Hydrahon

Hydrahon copied to clipboard

Hello there, how is it going? I've run into a interesting puzzle trying to emulate the row_number function. With raw SQL, I found how to do it in two ways:...

clodoaldofavaro

hi, I tried something like this SELECT * FROM `produtos` WHERE qt < minqt AND id_user = 2 $Produto->select() ->where('id_user',$id_user) ->where('qt','

joaosn

This sql query is not running on mysql 8 because the `*` is wrapped with ``` ` ```

agussuroyo

Hello, When using the subquery in the developer branch there seems to be an issue with the select function. for example: ``` $ret = $builder->select(["a" => function ($q) { $q->table("table2");...

ghost

Hydrahon returns a two dimensional array. But give no quick option to get first()

stanliwise

Execute raw queries

1

Hi, Is there any way to run raw queries using Hydrahon? I want to truncate a table, but I haven't found a function in Hydrahon, and also haven't found a...

neto737

I was trying to go through the hydrahon documentation yesterday and it took me sometime to connect the dot, as the first initialization of hydrahon uses $hydrahon and later in...

stanliwise

fetch style for select queries

2

`class Person { private $id; private $name; private $age; }` Hi. I want to mapping the columns of the result set to named properties in the class. Example: `$h->table('person') ->select()...

eburhan

Insert ID and Rows Affected

2

Currently when inserting, updating and deleting there is no return value at all. This should be trivial to add, by supplementing the FetchableInterface with a InsertableInterface (could return an array...

NickStallman

Using SQL UNION / UNION ALL operator

1

Is there a possibility to create queries with the UNION or UNION ALL operator? Something like this would be useful: ``` $h->table('students') ->select('column_name') ->union() ->table('teachers') ->select('column_name') ->get(); ``` Resulting in:...

samiharju