lazyins 0.0.4

A stupid MySQL insert helper

lazyins

A stupid MySQL insert helper

This tool makes MySQL table with the values, then insert the values.

Install

python -m pip install lazyins

Usage

Set environment variables to connect your database.

export LAZYINS_HOST="localhost"
export LAZYINS_PORT=3306
export LAZYINS_USER="root"
export LAZYINS_PASSWD="password"

Then make cursor.

from lazyins import Cursor
cur = Cursor()

This Cursor() function also recieves host, port, user, passwd, db_name, and table_name as arguments.

Case 1

If you have two list to insert MySQL database.

names = ['value1', 'value2', 'value3']
values = [1, 2, 3.3]

You can make table and insert with cur.register(values, names). The column types will be assumed.

Case 2

You have a list of tuple like that.

data = [('value1', 1), ('value2', 2), ('value3', 3.3)]

This simple cur.register(data) works.

Case 3

If you want to let it assume almost all values, but you want set explicit types for some values. For example, you need to set tinyint instead of int (assumed) for value2,

explicit_types = [('values', 'tinyint')]
cur.register(values, names, explicit_types=explicit_types)

Detail option

For string, default length is 40. If you need more, cur.default_char_length = 100.