python cx_oracle in语句_Python cx_Oracle.insert方法代码示例

# 需要导入模块: import cx_Oracle [as 别名]

# 或者: from cx_Oracle import insert [as 别名]

def insert(self, tablename, seqname=None, _test=False, **values):

"""

Inserts `values` into `tablename`. Returns current sequence ID.

Set `seqname` to the ID if it's not the default, or to `False`

if there isn't one.

>>> db = DB(None, {})

>>> q = db.insert('foo', name='bob', age=2, created=SQLLiteral('NOW()'), _test=True)

>>> q

>>> q.query()

'INSERT INTO foo (age, created, name) VALUES (%s, NOW(), %s)'

>>> q.values()

[2, 'bob']

"""

def q(x): return "(" + x + ")"

if values:

#needed for Py3 compatibility with the above doctests

sorted_values = sorted(values.items(), key=lambda t: t[0])

_keys = SQLQuery.join(map(lambda t: t[0], sorted_values), ', ')

_values = SQLQuery.join([sqlparam(v) for v in map(lambda t: t[1], sorted_values)], ', ')

sql_query = "INSERT INTO %s " % tablename + q(_keys) + ' VALUES ' + q(_values)

else:

sql_query = SQLQuery(self._get_insert_default_values_query(tablename))

if _test: return sql_query

db_cursor = self._db_cursor()

if seqname is not False:

sql_query = self._process_insert_query(sql_query, tablename, seqname)

if isinstance(sql_query, tuple):

# for some databases, a separate query has to be made to find

# the id of the inserted row.

q1, q2 = sql_query

self._db_execute(db_cursor, q1)

self._db_execute(db_cursor, q2)

else:

self._db_execute(db_cursor, sql_query)

try:

out = db_cursor.fetchone()[0]

except Exception:

out = None

if not self.ctx.transactions:

self.ctx.commit()

return out