Easily implement bulk insert and ON DUPLICATE KEY UPDATEstatements with MySQL and MariaDB
Project description
multy
Package that can be easily bulk inserted with MySQL / MariaDB of Python. You can also perform inserts and updates based on primary and unique keys.
Requirement
- Python3
- MySQL >= 5.5
- MariaDB >= 5.5
- Install PyMySQL or mysqlclient
Installation
pip install multy
Bulk Insert
Example of inserting into the following table
Table Name: sample
Field | Type |
---|---|
id | int |
age | int |
name | varchar |
import multy
import pymysql
# pymysql or mysqlclient connection
con = pymysql.connect(user='', passwd='', host='localhost', db='')
# step1 The second argument is the table name
sample = multy.BulkQuery(con, 'sample')
for i in range(10):
# step2 {column name: value}
sample.add_record({
'id': 1,
'age': 28,
'name': 'test'
})
# step3 Insert execution
sample.insert().save()
Bulk Insert or Update
insert_or_update()
If the primary key or unique key already exists, it will be updated, and if it does not exist, it will be inserted.
sample = multy.BulkQuery(con, 'sample')
for i in range(10):
sample.add_record({
'id': 1,
'age': 28,
'name': 'test'
})
sample.insert_or_update().save()
If you have Django
from django.db import connection
If you are using mysqlclient or pymysql with Django, you can use the imported connection as is
from django.db import connection
import multy
sample = multy.BulkQuery(connection, 'sample')
License
multy is under MIT license.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
multy-1.0.1.tar.gz
(3.0 kB
view hashes)
Built Distribution
multy-1.0.1-py3-none-any.whl
(4.0 kB
view hashes)