openlsd.database.data.postgresql.LSDPostGreSQLSpecific Class Reference

Collaboration diagram for openlsd.database.data.postgresql.LSDPostGreSQLSpecific:

[legend]

List of all members.

---

Detailed Description

Class for specific PostGreSQL Request

Author:

Frederic Bregier LGPL

Static Public Member Functions
static LSDDbPreparedStatement	ipport_findfirst (LSDDbAdmin admin)
static LSDDbPreparedStatement	legacy_findfirst (LSDDbAdmin admin)
static long	op_newindex (LSDDbAdmin admin)
static void	op_createOpFromCheck (LSDDbAdmin admin, long lid, long sid, long did, String md5, int op, Timestamp opdate, long idip, long idipto)
static long	op_createOpForDocument (LSDDbAdmin admin, long lid, long sid, long did, String md5, int op, Timestamp opdate, long idip)
static long	op_createOpFromLegacyStorage (LSDDbAdmin admin, long lid, long sid, long idip)
static boolean	op_refreshIdx (LSDDbAdmin admin)
static ArrayList< LSDDbOp >	op_validOps (LSDDbAdmin admin)
static LSDDbPreparedStatement	getPrimaryOp (LSDDbAdmin admin)
static LSDDbPreparedStatement	service_findfirst (LSDDbAdmin admin)
static LSDDbPreparedStatement	storage_findfirstInNew (LSDDbAdmin admin, long lid)
static String	documents_findIndexCommit (LSDDbAdmin admin, long lid, long sumsize, int nb)
static String	document_findIndexCommit (LSDDbAdmin admin, long lid, long filesize)
static String	documents_findIndexCommitOp (LSDDbAdmin admin, long lid, long sumsize, int nb, long idip)
static String	document_findIndexCommitOp (LSDDbAdmin admin, long lid, long filesize, long idip)
static LSDDbPreparedStatement	admin_get (LSDDbAdmin admin, long lid)
static LSDDbPreparedStatement	check_get (LSDDbAdmin admin, LSDDbPreparedStatement p_check_get, long lid, long start, long end, Timestamp opdate)
static String	check_getSQLDB (Timestamp opdate, boolean localcheckmd5, long newlid)
static String	check_getSQLLSD (Timestamp opdate, boolean localcheckmd5, long newlid)
static String	check_getSQLDBDual (Timestamp opdate, Timestamp limitdate, boolean localcheckmd5, long newlid)
static String	check_getSQLLSDDual (Timestamp opdate, Timestamp limitdate, boolean localcheckmd5, long newlid)
static int	check_load (LSDDbAdmin admin, String outputfile)
static LSDDbPreparedStatement	getSizeDocument (LSDDbAdmin admin)
Static Private Attributes
static ArrayList< LSDDbIpPort >	listipstatic = null
static long	sidstatic = LSDConstants.invalide_idx

---

Member Function Documentation

static LSDDbPreparedStatement openlsd.database.data.postgresql.LSDPostGreSQLSpecific.ipport_findfirst

(

LSDDbAdmin

admin

)

[static]

IpPort FindFirst

Parameters:

admin

Returns:

the LSDDbPreparedStatement

static LSDDbPreparedStatement openlsd.database.data.postgresql.LSDPostGreSQLSpecific.legacy_findfirst

(

LSDDbAdmin

admin

)

[static]

Legacy FindFirst

Parameters:

admin

Returns:

the LSDDbPreparedStatement

static long openlsd.database.data.postgresql.LSDPostGreSQLSpecific.op_newindex

(

LSDDbAdmin

admin

)

[static]

Get a new index in Op Table. Does not commit so the caller needs to do commit.

Parameters:

admin

Returns:

the new next index in Op Table

static void openlsd.database.data.postgresql.LSDPostGreSQLSpecific.op_createOpFromCheck	(	LSDDbAdmin	admin,
		long	lid,
		long	sid,
		long	did,
		String	md5,
		int	op,
		Timestamp	opdate,
		long	idip,
		long	idipto
	)			[static]

Create Op for Check for the Document and IDIP as source and IDIPTO as target

Parameters:

	admin
	lid
	sid
	did
	md5
	op
	opdate
	idip
	idipto

static long openlsd.database.data.postgresql.LSDPostGreSQLSpecific.op_createOpForDocument	(	LSDDbAdmin	admin,
		long	lid,
		long	sid,
		long	did,
		String	md5,
		int	op,
		Timestamp	opdate,
		long	idip
	)			[static]

Create Ops for Document and IDIP

Parameters:

	admin
	lid
	sid
	did
	md5
	op
	opdate
	idip

Returns:

the new associated idop

static long openlsd.database.data.postgresql.LSDPostGreSQLSpecific.op_createOpFromLegacyStorage	(	LSDDbAdmin	admin,
		long	lid,
		long	sid,
		long	idip
	)			[static]

Create Op from Document for the specific Legacy and Storage and IDIP

Parameters:

	admin
	lid
	sid
	idip

Returns:

the number of created Op or (-1) if an error occurs

static boolean openlsd.database.data.postgresql.LSDPostGreSQLSpecific.op_refreshIdx

(

LSDDbAdmin

admin

)

[static]

Update new index in Op Table.

Parameters:

admin

Returns:

True if OK

static ArrayList<LSDDbOp> openlsd.database.data.postgresql.LSDPostGreSQLSpecific.op_validOps

(

LSDDbAdmin

admin

)

[static]

Get list of Ops that are ready to be executed (only LSDConstants.NBLINEOP)

Parameters:

admin

Returns:

The ArrayList<LSDDbOp> or NULL in case of error

static LSDDbPreparedStatement openlsd.database.data.postgresql.LSDPostGreSQLSpecific.getPrimaryOp

(

LSDDbAdmin

admin

)

[static]

Get the Primary Op object with status = OPStatusTodo

Parameters:

admin

Returns:

the LSDDbPrepareStatement

static LSDDbPreparedStatement openlsd.database.data.postgresql.LSDPostGreSQLSpecific.service_findfirst

(

LSDDbAdmin

admin

)

[static]

Service FindFirst

Parameters:

admin

Returns:

the LSDDbPreparedStatement

static LSDDbPreparedStatement openlsd.database.data.postgresql.LSDPostGreSQLSpecific.storage_findfirstInNew	(	LSDDbAdmin	admin,
		long	lid
	)			[static]

Storage FindFirst

Parameters:

	admin
	lid

Returns:

the LSDDbPreparedStatement

static String openlsd.database.data.postgresql.LSDPostGreSQLSpecific.documents_findIndexCommit	(	LSDDbAdmin	admin,
		long	lid,
		long	sumsize,
		int	nb
	)			[static]

Find index for several documents that will be in the same Storage.

Parameters:

	admin
	lid
	sumsize
	nb

Returns:

the result as "newsid newdids";

static String openlsd.database.data.postgresql.LSDPostGreSQLSpecific.document_findIndexCommit	(	LSDDbAdmin	admin,
		long	lid,
		long	filesize
	)			[static]

Find index for one document.

Parameters:

	admin
	lid
	filesize

Returns:

the result as "newsid newdid";

static String openlsd.database.data.postgresql.LSDPostGreSQLSpecific.documents_findIndexCommitOp	(	LSDDbAdmin	admin,
		long	lid,
		long	sumsize,
		int	nb,
		long	idip
	)			[static]

Find index for several documents that will be in the same Storage (only LSDConstants.NBLINEOP) and create temporary Op entries.

Parameters:

	admin
	lid
	sumsize
	nb
	idip	of the source

Returns:

the result as "newsid newdids newidops";

static String openlsd.database.data.postgresql.LSDPostGreSQLSpecific.document_findIndexCommitOp	(	LSDDbAdmin	admin,
		long	lid,
		long	filesize,
		long	idip
	)			[static]

Find index for one document and create temporary Op entry.

Parameters:

	admin
	lid
	filesize
	idip	of the source

Returns:

the result as "newsid newdid newidop";

static LSDDbPreparedStatement openlsd.database.data.postgresql.LSDPostGreSQLSpecific.admin_get	(	LSDDbAdmin	admin,
		long	lid
	)			[static]

Admin Get

Parameters:

	admin
	lid

Returns:

the LSDDbPreparedStatement

static LSDDbPreparedStatement openlsd.database.data.postgresql.LSDPostGreSQLSpecific.check_get	(	LSDDbAdmin	admin,
		LSDDbPreparedStatement	p_check_get,
		long	lid,
		long	start,
		long	end,
		Timestamp	opdate
	)			[static]

Check Get

Parameters:

	admin
	p_check_get
	lid
	start
	end
	opdate

Returns:

the LSDDbPreparedStatement

static String openlsd.database.data.postgresql.LSDPostGreSQLSpecific.check_getSQLDB	(	Timestamp	opdate,
		boolean	localcheckmd5,
		long	newlid
	)			[static]

Get the request string to check DB

Parameters:

	opdate
	localcheckmd5
	newlid

Returns:

the request string

static String openlsd.database.data.postgresql.LSDPostGreSQLSpecific.check_getSQLLSD	(	Timestamp	opdate,
		boolean	localcheckmd5,
		long	newlid
	)			[static]

Get the request string to check LSD

Parameters:

	opdate
	localcheckmd5
	newlid

Returns:

the request string

static String openlsd.database.data.postgresql.LSDPostGreSQLSpecific.check_getSQLDBDual	(	Timestamp	opdate,
		Timestamp	limitdate,
		boolean	localcheckmd5,
		long	newlid
	)			[static]

Get the request string to check DB

Parameters:

	opdate
	limitdate
	localcheckmd5
	newlid

Returns:

the request string

static String openlsd.database.data.postgresql.LSDPostGreSQLSpecific.check_getSQLLSDDual	(	Timestamp	opdate,
		Timestamp	limitdate,
		boolean	localcheckmd5,
		long	newlid
	)			[static]

Get the request string to check LSD

Parameters:

	opdate
	limitdate
	localcheckmd5
	newlid

Returns:

the request string

static int openlsd.database.data.postgresql.LSDPostGreSQLSpecific.check_load	(	LSDDbAdmin	admin,
		String	outputfile
	)			[static]

Check with Load

Parameters:

	admin
	outputfile

Returns:

the number of lines loaded

static LSDDbPreparedStatement openlsd.database.data.postgresql.LSDPostGreSQLSpecific.getSizeDocument

(

LSDDbAdmin

admin

)

[static]

Return the Prepare Statement for get Size from Document in one Legacy/Storage

Parameters:

admin

Returns:

the LSDDbPrepareStatement

---

Member Data Documentation

ArrayList<LSDDbIpPort> openlsd.database.data.postgresql.LSDPostGreSQLSpecific.listipstatic = null [static, private]

Try to reuse previous listip

long openlsd.database.data.postgresql.LSDPostGreSQLSpecific.sidstatic = LSDConstants.invalide_idx [static, private]

Try to reuse previous listip : sid

---

The documentation for this class was generated from the following file:

• OpenLSD/ClientSupport/openlsd/database/data/postgresql/LSDPostGreSQLSpecific.java