ajsql

Data type AjPVoid

Holds a void array with additional data. The length is known and held internally.

Saves on length calculation, and allows growth in reserved memory without changing the pointer in the calling routine.

AjPVoid is implemented as a pointer to a C data structure.

Alias name(s)

Name
AjSVoid
AjOVoid

Constructor(s)

Name	Description
ajVoidNew	Default constructor
ajVoidNewRes	Constructor with reserved size

Destructor(s)

Name	Description
ajVoidDel	Default destructor

Cast(s)

Name	Description
ajVoidGet	Retrieve a pointer from an array

Modifier(s)

Name	Description
ajVoidPut	Load a pointer array element

Attributes

Name	Type	Description
Res	ajuint	Reserved space in case of extension
Len	ajuint	Actual length used
Ptr	void**	Array of void pointers

Data type AjPSqlconnection

Holds the client type and a pointer to a SQL client library-specific connection object.

Alias name(s)

Name
AjSSqlconnection
AjOSqlconnection

Attributes

Name	Type	Description
Pconnection	void*	SQL client library-specific connection object (MYSQL*) for the MySQL client library (PGconn*) for the PostgreSQL client library
Client	AjESqlconnectionClient	Client library
Use	ajuint	Use counter

Data type AjPSqlstatement

Holds pointers to an AJAX SQL Connection and to a client library-specific result object.

Alias name(s)

Name
AjSSqlstatement
AjOSqlstatement

Attributes

Name	Type	Description
Sqlconnection	AjPSqlconnection	AJAX SQL Connection.
Presult	void*	SQL client library-specific result object (MYSQL_RES*) for the MySQL client library (PGresult*) for the PostgreSQL client library
AffectedRows	ajulong	Number of rows affected by non-SELECT SQL statements
SelectedRows	ajulong	Number of rows selected by SELECT-like SQL statements
Columns	ajuint	Number of columns returned by SELECT-like statements
Use	ajuint	Use counter

Data type AjPSqlrow

Holds an AjPChar array of C-type character strings and an AjLong array of data lengths for each column data values in SQL client library-specific result objects.

Alias name(s)

Name
AjSSqlrow
AjOSqlrow

Attributes

Name	Type	Description
Values	AjPVoid	AJAX Character Array of SQL column values
Lengths	AjPLong	AJAX Long Integer Array of SQL column value lengths
Columns	ajuint	Number of columns per row
Current	ajuint	Current column in column interactions

Data type AjISqlrow

Allows iteration over AJAX SQL Rows of an AJAX SQL Statement.

Alias name(s)

Name
AjSSqlrowiter
AjOSqlrowiter
AjPSqlrowiter

Attributes

Name	Type	Description
Sqlstatement	AjPSqlstatement	AJAX SQL Statement
Sqlrow	AjPSqlrow	AJAX SQL Result Row
Current	ajulong	Current row number