Python insert Examples

Example #1

File: insert_execute.py Project: YuriiKhomych/ITEA-advanced

from ex_1_define_and_create_tables_core import (
    suppliers,
    products,
    users,
    orders,
    engine,
)

ins = users.insert()
conn = engine.connect()

# conn.execute(users.insert(), [
#   {'name': 'Vasya', 'address': 'bla bla str'},
#   {'name': 'Kolya', 'address': 'conner street'},
#   {'name': 'Anton', 'address': 'basement'},
#   {'name': 'Emma', 'address': 'street3'},
# ])

# conn.execute(suppliers.insert(), [
#   {'name': 'Vasya Suplier', 'address': 'Suplierbla bla str'},
#   {'name': 'Kolya Suplier', 'address': 'Suplierconner street'},
#   {'name': 'Anton Suplier', 'address': 'Suplierbasement'},
#   {'name': 'Emma Suplier', 'address': 'Suplierstreet3'},
# ])
# conn.execute(products.insert(), [
#   {'name': 'Candy', 'supplier_id': 1, 'price': '10'},
#   {'name': 'CAr', 'supplier_id': 2,'price': '20'},
#   {'name': 'Eggs', 'supplier_id': 2,'price': '30'},
#   {'name': 'Potato', 'supplier_id': 3,'price': '40'},
#    {'name': 'Toy', 'supplier_id': 4,'price': '50'},
# ])

Example #2

File: ex_2_insert_execute.py Project: yyuliia/ITEA-advanced

from ex_1_define_and_create_tables_core import (
    users,
    addresses,
    engine,
)

ins = users.insert()
str(ins)
ins = users.insert().values(name='jack', fullname='Jack Jones')
str(ins)
ins.compile().params

conn = engine.connect()

# result = conn.execute(ins)
# INSERT INTO users (name, fullname) VALUES (?, ?)
# ('jack', 'Jack Jones')
# COMMIT
# ins.bind = engine
# str(ins)
# result.inserted_primary_key

# conn.execute(ins, id=2, name='wendy', fullname='Wendy Williams')

conn.execute(addresses.insert(), [
    {
        'user_id': 1,
        'email_address': '*****@*****.**'
    },
    {
        'user_id': 1,

Example #3

File: ex_3_select.py Project: svvay/ITEA_AC

                    users.c.name).having(func.length(users.c.name) > 4))
res = conn.execute(stmt).fetchall()

# Distinct
stmt = (select([users.c.name]).where(
    addresses.c.email_address.contains(users.c.name)).distinct())
conn.execute(stmt).fetchall()

# Insert update delete
stmt = users.update().values(fullname="Fullname: " + users.c.name)
# UPDATE users SET fullname=(? || users.name)
# ('Fullname: ',)
# COMMIT
conn.execute(stmt)

stmt = users.insert().values(name=bindparam("_name") + " .. name")
conn.execute(
    stmt,
    [
        {
            "_name": "name1"
        },
        {
            "_name": "name2"
        },
        {
            "_name": "name3"
        },
    ],
)
stmt = users.update().where(users.c.name == "jack").values(name="ed")

Example #4

File: ex_3_select.py Project: yyuliia/ITEA-advanced

# Distinct
stmt = select([users.c.name]).\
            where(addresses.c.email_address.
                   contains(users.c.name)).\
            distinct()
conn.execute(stmt).fetchall()

# Insert update delete
stmt = users.update().values(fullname="Fullname: " + users.c.name)
# UPDATE users SET fullname=(? || users.name)
# ('Fullname: ',)
# COMMIT
conn.execute(stmt)

stmt = users.insert().\
        values(name=bindparam('_name') + " .. name")
conn.execute(stmt, [
       {'id':4, '_name':'name1'},
       {'id':5, '_name':'name2'},
       {'id':6, '_name':'name3'},
    ])
stmt = users.update().\
            where(users.c.name == 'jack').\
            values(name='ed')

conn.execute(stmt)
# UPDATE users SET name=? WHERE users.name = ?
# ('ed', 'jack')
# COMMIT

result = conn.execute(users.delete().where(users.c.name == 'jack'))

Example #5

from ex_1_define_and_create_tables_core import (
    users,
    addresses,
    engine,
)

ins = users.insert()
str(ins)
ins = users.insert().values(name="jack", fullname="Jack Jones")
str(ins)
ins.compile().params

conn = engine.connect()

result = conn.execute(ins)
# INSERT INTO users (name, fullname) VALUES (?, ?)
# ('jack', 'Jack Jones')
# COMMIT
ins.bind = engine
# str(ins)
result.inserted_primary_key

# conn.execute(ins, id=2, name='wendy', fullname='Wendy Williams')

conn.execute(
    addresses.insert(),
    [
        {
            "user_id": 1,
            "email_address": "*****@*****.**"
        },