sqlalchemy orm - change column in a table depending on another table
<p>I have a 3 tables </p>

<p>table 1</p>

<pre><code>| id  | name |
|:---:|:----:|
| 1   | name |
</code></pre>

<p>table 2</p>

<pre><code>| id  | name | status |
|:---:|:----:|:------:|
| 1   | name |  True  |
</code></pre>

<p>table 3</p>

<pre><code>| id_table1  | id_table2 | datetime | status_table2 |
|:----------:|----------:|:--------:|:-------------:|
|     1      |     1     |01/11/2011|     True      |
</code></pre>

<hr>

<p>How I can change a status in table 2 when I create a link in table 3, with sqlalchemy ORM in python, status must be changed when link in table 3 created and also must be changed when link deleted, who have any cool and simple ideas?</p>

<p>solved problem by use ORM Events</p>

python postgresql orm sqlalchemy