db001_employee.h File Reference

Data Structures
struct	employee_t
struct	employeeA_t
Functions
int	employee_insLz (int db_sn, employee_t *employees)
	insert datas from employees to employee in lazy mode, datas will be inserted when buffer full or employees is null.
int	employee_ins (int db_sn, employeeA_t *employee, int rows)
	insert datas from employee to employee in bulk mode, if some data[n] fails, procedure will continue from data[n+1].
int	employee_delLz (int db_sn, employee_t *employees)
	delete datas from employee by employees in lazy mode, datas will be deleted when buffer full or employees is null.
int	employee_del (int db_sn, employeeA_t *employee, int rows)
	delete datas from employee by employee in bulk mode.
int	employee_updLz (int db_sn, employee_t *employees)
	update datas by employees in lazy mode, datas will be updated when buffer full or employees is null.
int	employee_upd (int db_sn, employeeA_t *employee, int rows)
	update datas by employee in bulk mode.
void	employee_qry_by_key (int db_sn, employee_t *employees)
	query employee by primary key.
void	employee_qry_all (int db_sn, employeeA_t *employee, int *r)
	query r rows from employee.
int	employee_qry_cnt (int db_sn)
	query record count from employee.

---

Function Documentation

int employee_del	(	int	db_sn,
		employeeA_t *	employee,
		int	rows
	)

delete datas from employee by employee in bulk mode.

Parameters:

	db_sn	a database session number.
	employee	deleted data array object.
	rows	how many rows you want to delete.

Returns:

rows deleted.

int employee_delLz	(	int	db_sn,
		employee_t *	employees
	)

delete datas from employee by employees in lazy mode, datas will be deleted when buffer full or employees is null.

Parameters:

	db_sn	a database session number.
	employees	deleted data object, you can delete current datas immediately by setting employees to NULL.

Returns:

-n: fail count. 0: data buffered. +n: success count.

Examples:

testcase.pc.

int employee_ins	(	int	db_sn,
		employeeA_t *	employee,
		int	rows
	)

insert datas from employee to employee in bulk mode, if some data[n] fails, procedure will continue from data[n+1].

Parameters:

	db_sn	a database session number.
	employee	inserted data array object.
	rows	how many rows you want to insert.

Returns:

rows inserted.

int employee_insLz	(	int	db_sn,
		employee_t *	employees
	)

insert datas from employees to employee in lazy mode, datas will be inserted when buffer full or employees is null.

Parameters:

	db_sn	a database session number.
	employees	inserted data object, you can insert current datas immediately by setting employees to NULL.

Returns:

-n: fail count. 0: data buffered. +n: success count.

Examples:

testcase.pc.

void employee_qry_all	(	int	db_sn,
		employeeA_t *	employee,
		int *	r
	)

query r rows from employee.

Parameters:

	db_sn	a database session number.
	employee	resultset data array object.
	r	how many rows fetched.

void employee_qry_by_key	(	int	db_sn,
		employee_t *	employees
	)

query employee by primary key.

Parameters:

	db_sn	a database session number.
	employees	resultset data object.

int employee_qry_cnt

(

int

db_sn

)

query record count from employee.

Parameters:

db_sn

a database session number.

Examples:

testcase.pc.

int employee_upd	(	int	db_sn,
		employeeA_t *	employee,
		int	rows
	)

update datas by employee in bulk mode.

Parameters:

	db_sn	a database session number.
	employee	updated data array object.
	rows	how many rows you want to updated.

Returns:

rows updated.

int employee_updLz	(	int	db_sn,
		employee_t *	employees
	)

update datas by employees in lazy mode, datas will be updated when buffer full or employees is null.

Parameters:

	db_sn	a database session number.
	employees	deleted data object, you can delete current datas immediately by setting employees to NULL.

Returns:

-n: fail count. 0: data buffered. +n: success count.

Examples:

testcase.pc.