Method __builtin.Sql.Connection()->streaming_query()

Method streaming_query

variant .Result streaming_query(object|string q)

Description

Send an SQL query synchronously to the SQL-server and return the results streaming in untyped mode.

For the arguments, please see the big_query() function.

Returns

A streaming Sql.Result object in untyped mode. This allows for having results larger than the available memory, and returning some more info about the result.

Drivers should override this prototype function.

Note

Typed mode support varies per database and per datatype. SQL datatypes which the current database cannot return as a native Pike type, will be returned as (untyped) strings.

See also

big_query, streaming_typed_query

Method streaming_query

variant .Result streaming_query(object|string q, mapping(string:mixed) bindings)

Description

Send an SQL query synchronously to the SQL-server and return the results streaming in untyped mode.

For the arguments, please see the big_query() function.

Returns

A streaming Sql.Result object in untyped mode. This allows for having results larger than the available memory, and returning some more info about the result.

Drivers that implement bindings should override this prototype function.

See also

big_query, streaming_typed_query

Method streaming_query

variant .Result streaming_query(object|string q, string|multiset|int|float|object extraarg, string|multiset|int|float|object ... extraargs)

Description

Send an SQL query synchronously to the SQL-server and return the results streaming in untyped mode.

For the arguments, please see the big_query() function.

Returns

A streaming Sql.Result object in untyped mode. This allows for having results larger than the available memory, and returning some more info about the result.

See also

big_query, streaming_typed_query