Prepared Statement Class

class attachsql.statement
execute()

Start execution a prepared statement

Returns:True on success
Return type:boolean
reset()

Reset a prepared statement

Returns:True on success
Return type:boolean
send_long_data(param_no, data)

Send a long data packet as a server parameter

Parameters:
  • param_no (int) – The parameter to set (starting from 0)
  • data (str) – The data to set
Returns:

True on success
Return type:

boolean
param_count()

The number of parameters in the query to be set

Returns:The number of parameters
Return type:int
set_int(param_no, data[, is_unsigned])

Sets a parameter as an integer

Parameters:
  • param_no (int) – The parameter to set (starting from 0)
  • data (int) – The data to set
  • is_unsigned (boolean) – Whether or not the data is unsigned (False by default)
Returns:

True on success
Return type:

boolean
set_bigint(param_no, data[, is_unsigned])

Sets a parameter as a bigint

Parameters:
  • param_no (int) – The parameter to set (starting from 0)
  • data (longlong) – The data to set
  • is_unsigned (boolean) – Whether or not the data is unsigned (False by default)
Returns:

True on success
Return type:

boolean
set_float(param_no, data)

Sets a double precision floating point number

Parameters:
  • param_no (int) – The parameter to set (starting from 0)
  • data (float) – The data to set
Returns:

True on success
Return type:

boolean
set_string(param_no, data)

Sets a string parameter

Parameters:
  • param_no (int) – The parameter to set (starting from 0)
  • data (str) – The data to set
Returns:

True on success
Return type:

boolean
set_null(param_no)

Sets a parameter to NULL

Parameters:param_no (int) – The parameter to set (starting from 0)
Returns:True on success
Return type:boolean
set_datetime(param_no, data)

Sets a parameter to a datetime.datetime or datetime.date object

Parameters:
  • param_no (int) – The parameter to set (starting from 0)
  • data (datetime) – The date / datetime to set
Returns:

True on success
Return type:

boolean
set_time(param_no, data)

Sets a parameter to a datetime.time object

Parameters:
  • param_no (int) – The parameter to set (starting from 0)
  • data (time) – The time to set
Returns:

True on success
Return type:

boolean
row_get()

Retrieve a ready row from the buffer

Returns:True on success
Return type:boolean
get_int(column_no[, get_unsigned])

Get an int from the row

Parameters:
  • column_no (int) – The column number to get (starting from 0)
  • get_unsigned (boolean) – Whether or not to get the data as unsigned (False by default)
Returns:

The integer data
Return type:

long
get_bigint(column_no[, get_unsigned])

Get a bigint from the row

Parameters:
  • column_no (int) – The column number to get (starting from 0)
  • get_unsigned (boolean) – Whether or not to get the data as unsigned (False by default)
Returns:

The bigint data
Return type:

longlong
get_float(column_no)

Get a float from the row

Parameters:column_no (int) – The column number to get (starting from 0)
Returns:The float data
Return type:float
get_char(column_no)

Get a character string from the row

Parameters:column_no (int) – The column number to get (starting from 0)
Returns:The char data
Return type:str
get_column_type(column_no)

Get the native column type for a column, types are to be compared with Column Type Constants

Parameters:column_no (int) – The column number to get (starting from 0)
Returns:The column type
Return type:int
row_next()

Start retrieving the next row of the results

Returns:None
get_column_count()

Get the number of columns in the results

Returns:The number of columns
Return type:int