GSQLCursorPrivate

typedef struct _GSQLCursorPrivate GSQLCursorPrivate;

enum GSQLCursorState

typedef enum {
	GSQL_CURSOR_STATE_ERROR,
	GSQL_CURSOR_STATE_NONE,
	
	GSQL_CURSOR_STATE_RUN,
	GSQL_CURSOR_STATE_OPEN,
	GSQL_CURSOR_STATE_STOP,
	GSQL_CURSOR_STATE_FETCH,
	GSQL_CURSOR_STATE_FETCHED
} GSQLCursorState;

enum GSQLCursorBindType

typedef enum {
	GSQL_CURSOR_BIND_BY_NAME,
	GSQL_CURSOR_BIND_BY_POS
} GSQLCursorBindType;

enum GSQLCursorStmtType

typedef enum {

	GSQL_CURSOR_STMT_SELECT,
	GSQL_CURSOR_STMT_EXEC,
	GSQL_CURSOR_STMT_INSERT,
	GSQL_CURSOR_STMT_UPDATE,
	GSQL_CURSOR_STMT_DELETE,
	GSQL_CURSOR_STMT_DML, /* Common stmt type for Ins, Upd, Del */
	GSQL_CURSOR_STMT_CREATE,
	GSQL_CURSOR_STMT_DROP,
	GSQL_CURSOR_STMT_ALTER,
	GSQL_CURSOR_STMT_DDL /* commont stmt type for create, drop, alter */
} GSQLCursorStmtType;

GSQL_CURSOR_TYPE

#define GSQL_CURSOR_TYPE 			(gsql_cursor_get_type ())

GSQLCursor

typedef struct _GSQLCursor GSQLCursor;

gsql_cursor_new ()

GSQLCursor*         gsql_cursor_new                     (GSQLSession *session,
                                                         gchar *sql);

Creates a new GSQLCursor object

gsql_cursor_get_state ()

GSQLCursorState     gsql_cursor_get_state               (GSQLCursor *cursor);

gsql_cursor_open_with_bind ()

GSQLCursorState     gsql_cursor_open_with_bind          (GSQLCursor *cursor,
                                                         gboolean background,
                                                         GSQLCursorBindType btype,
                                                         ...);

Run the cursor statement with binds. Pay attention to the args in example usage:

gsql_cursor_open_with_bind (cursor, FALSE, GSQL_CURSOR_BIND_BY_POS, G_TYPE_STRING, owner, G_TYPE_INT, 23, -1)

gsql_cursor_open_with_bind (cursor, FALSE, GSQL_CURSOR_BIND_BY_NAME, G_TYPE_STRING, "owner" G_TYPE_STRING, owner, G_TYPE_STRING, "type", G_TYPE_INT, 23, -1)

gsql_cursor_open ()

GSQLCursorState     gsql_cursor_open                    (GSQLCursor *cursor,
                                                         gboolean background);

Run the cursor statement.

gsql_cursor_stop ()

void                gsql_cursor_stop                    (GSQLCursor *cursor);

Stop the statement execution.

gsql_cursor_fetch ()

gint                gsql_cursor_fetch                   (GSQLCursor *cursor,
                                                         gint rows);

Fetch the result.

gsql_cursor_close ()

void                gsql_cursor_close                   (GSQLCursor *cursor);

Close the cursor.

gsql_cursor_notify_set ()

void                gsql_cursor_notify_set              (GSQLCursor *cursor,
                                                         gboolean notify);

Set the notify property.

The "close" signal

void                user_function                      (GSQLCursor *gsqlcursor,
                                                        gpointer    user_data)       : Run First

The "state-changed" signal

void                user_function                      (GSQLCursor *gsqlcursor,
                                                        gpointer    user_data)       : Run First