Esempio n. 1
0
def set_server_fields(table, *fields):
    '''
    Specify which fields are defined by the database, i.e. autoincremental
    fields, fields with defaults, fields automatically set by a trigger.
    '''
    table._ifields = tuple(f for f in table._fields if not f in fields)
    table._insert = sql.insert(table)
    table._create = sql.create(table)
Esempio n. 2
0
def test_create():
    raw = sql.create(client).templ.raw
    assert_equal(
        raw, '''INSERT INTO client (client_id, description)
SELECT * FROM (SELECT %s, %s) AS vals
WHERE NOT EXISTS (SELECT 1 FROM client WHERE client_id=%s)''')