Skip to main content

A Django model manager providing insert on conflict for PostgreSQL database tables.

Project description

Introduction

https://img.shields.io/pypi/v/django-postgres-ioc.svg

Django ORM manager for Postgresql Came from Rock@luojilab

Replace update_or_create Without transaction, when using update_or_create may raise IntegrityError Because thread 1 execute update affect 0 row and at the same time, thread 2 insert it then thread 1 do insert will trigger UniqueKey conflict.

This method will use INSERT ON CONFLICT feature to fix this.

Requirements

  • Python >= 2.6 (tested on 2.7 and 3.6)
  • Django >= 1.7
  • PostgreSQL >= 9.5

Installation

Running following command:

$ python setup.py install

Or using pip:

$ pip install -U django-postgres-ioc

Usage

Python code:

from django.db import models
from ioc import IOCManager

class Test(models.Model):
    code = models.CharField(max_length=50, unique=True))
    name = models.CharField(max_length=100

    objects = IOCManager()

Test.objects.create_or_update(
    conflict="code",
    code="luojilab",
    defaults={
        "name": "LuojiLab",
    },
)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for django-postgres-ioc, version 0.0.2
Filename, size File type Python version Upload date Hashes
Filename, size django_postgres_ioc-0.0.2-py3-none-any.whl (3.4 kB) File type Wheel Python version py3 Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page