swat.cas.datamsghandlers.SQLTable

class swat.cas.datamsghandlers.SQLTable(table, engine, nrecs=1000, transformers=None, **kwargs)

Bases: swat.cas.datamsghandlers.PandasDataFrame

Create an SQLTable data message handler

Parameters
tablestring

Name of table in database to fetch.

enginesqlalchemy engine

sqlalchemy engine.

nrecsint, optional

Number of records to send at a time.

**kwargskeyword arguments, optional

Arguments sent to pandas.io.read_sql_table.

Returns
SQLTable data message handler object
PandasDataFrame
__init__(self, table, engine, nrecs=1000, transformers=None, **kwargs)

Initialize self. See help(type(self)) for accurate signature.

Methods

__init__(self, table, engine[, nrecs, …])

Initialize self.

create_engine(\*args, \*\*kwargs)

Return engine from sqlalchemy.create_engine()

finish(self, connection)

Finish the data sending operation

getone(self, connection, \*\*kwargs)

Get a single response from the server

getrow(self, row)

Get a row of values from the data source

send(self, connection, nrecs)

Send the records to the connection

write(self, row, values)

Write the value to the row and column specified in the buffer

Attributes

args

Property that generates the CAS action parameters for CAS actions that use a data message handler.