django-pgtrigger
django-pgtrigger copied to clipboard
Opus10
Write Postgres triggers for your Django models
Posting this here in case anyone is interested or happens to bump into the same issue. I'm just describing the problem I've encountered as I have not had time yet...
Integrate pgtrigger into django's check system similar to other Django model constructs. Key pieces of behavior desired: 1. Duplicate trigger name checks happen in the check system instead of during...
Version 3 integrates ``django-pgtrigger`` with the Django migration system, along with several other superficial updates. Version 4 changes the behavior of using triggers in multi-database environments. **TL;DR** Most users can...
More of a question than a bug -- is there a best practice for doing migrations when triggers exist? Right now I'm just doing a manage pgtrigger uninstall before I...
I can't create `CONSTRAINT TRIGGER` and also set `DEFERRABLE INITIALLY DEFERRED` settings.
Here's an example representation of my models: ```py class Tag(models.Model): user = models.ForeignKey('auth.User', on_delete=models.CASCADE) class Activity(models.Model): user = models.ForeignKey('auth.User', on_delete=models.CASCADE) tags = models.ManyToManyField(Tag, through='TagBinding') class TagBinding(models.Model): tag = models.ForeignKey(Tag) activity...
I'm principally interested in using this library for denormalizations - thinks like: ```python class BlogEntry(Model) # ... num_comments = IntegerField() class Comment(Model): entry = ForeignKey(BlogEntry) # ... ``` Where that...
@tomage leaving a placeholder here for MySQL support since it is actively under development. So far it looks like MySQL support is going to be close to feature compliance with...
Code like this: ```python with pgtrigger.ignore(): try: do_something() # raises database error except: # handle exception without reraising ``` Will currently crash, as the `RESET` statement emitted by pgtrigger will...
I tried to add a trigger to update a `SearchVectorField` with a field that has a relation to another table class MyModel(models.Model): search_vector = SearchVectorField() class Meta: triggers = [...
