swat.cas.datamsghandlers.SQLQuery¶
-
class
swat.cas.datamsghandlers.SQLQuery(query, engine, nrecs=1000, transformers=None, **kwargs)¶ Bases: swat.cas.datamsghandlers.PandasDataFrame
Create an SQLQuery data message handler
- Parameters
- querystring
SQL query.
- enginesqlalchemy engine
sqlalchemy engine.
- nrecsint or long, optional
Number of records to send at a time.
- **kwargsany, optional
Arguments sent to pandas.io.sql.read_sql_query().
- Returns
- SQLQuery data message handler object
See also
- pandas.io.sql.read_sql_query()
- PandasDataFrame
-
__init__(self, query, engine, nrecs=1000, transformers=None, **kwargs)¶ Initialize self. See help(type(self)) for accurate signature.
Methods
__init__(self, query, 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.