Relational

Relational copied to clipboard

How do you tackle nested wheres

5

things like `where foo=1 and (where bar=0 or baz=0)` ?

kapv89

Return the number of affected rows when run Mapper remove method

9

Hi Guys, How about return the number of affected rows when run Mapper remove method? Is it possible (currently) or interesting to everyone in a new PR?

ricardofontanelli

Mapping shortcuts is a great feature, not only to improve flexibility, this allow a kind of generic query, for example: ``` php if ($table=='A'){ $mapper->tableX = $mapper->tableA; } else {...

mrsoto

Bug when conditions are applied to more than one table

4

Hello all of you who develop Respect. First, let me thank you and say you're doing a really good job! I'm using Respect in a project of mine and today...

vinyanalista

Sql::orderBy doesn't quote columns

3

I've this query which does not quote columns and then mysql retrieve an incorrect order. The table has `timestamp` column ``` $mapper->news->fetchAll(Sql::orderBy('timestamp', 'id')->desc()->limit($initial, $pageSize)) ``` Resulting query: ``` SELECT news.*...

mrsoto

Many-to-many using the same table 2 times

2

Hello, How columns should be names to allow a many-to-many relationship when the same table is referenced, for example ``` table customer(id) table customer_customer(id, customer_id, other_customer_id, other_data) ``` how the...

mrsoto

Events

26

Does anyone have the intention to use events with relational? Yes, events. Like... dbms's triggers... Anyone?

nawarian

Hello, Each time I need to reduce overhead related to too many unneeded columns I've to create a database view and fetch from this view. The question is: is there...

mrsoto

At #36 @robinson-rso raised an interesting question, can we handle schemas. @tuliobraga raised #40 there are problems with lastInsertId. This made me realise that I have never tested this against...

nickl-

Respect\Relational Abstract Collections

4

# Respect\Relational Abstract Collections Respect\Relational uses Respect\Data collections to express two things: 1 - How tables are related This is done by the very nature of Collection compositing: ``` php

alganet