Package tigase.http.upload.db.derby

Class StoredProcedures

java.lang.Object

tigase.http.upload.db.derby.StoredProcedures

public class StoredProcedures
extends Object

Created by andrzej on 10.08.2016.

Constructor Summary

Constructors

Constructor	Description
StoredProcedures()

Method Summary

Modifier and Type	Method	Description
static void	allocateSlot(String slotId, String uploader, String domain, String res, String filename, Long filesize, String contentType, ResultSet[] data)
static void	domainSlotsQuery(String domain, String afterId, Integer maxLimit, ResultSet[] data)
static void	getSlot(String slotId, ResultSet[] data)
static void	listExpiredSlots(String domain, Timestamp ts, Integer max, ResultSet[] data)
static void	removeExpiredSlots(String domain, Timestamp ts, Integer max)
static void	removeSlot(String slotId)
static void	updateSlot(String slotId)
static void	usedSpaceCountForDomain(String domain, ResultSet[] data)
static void	usedSpaceCountForUser(String jid, ResultSet[] data)
static void	userSlotsQuery(String jid, String afterId, Integer maxLimit, ResultSet[] data)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

StoredProcedures

public StoredProcedures()

Method Details

allocateSlot

public static void allocateSlot(String slotId,
 String uploader,
 String domain,
 String res,
 String filename,
 Long filesize,
 String contentType,
 ResultSet[] data)
                         throws SQLException

Throws:

SQLException

getSlot

public static void getSlot(String slotId,
 ResultSet[] data)
                    throws SQLException

Throws:

SQLException

listExpiredSlots

public static void listExpiredSlots(String domain,
 Timestamp ts,
 Integer max,
 ResultSet[] data)
                             throws SQLException

Throws:

SQLException

removeExpiredSlots

public static void removeExpiredSlots(String domain,
 Timestamp ts,
 Integer max)
                               throws SQLException

Throws:

SQLException

updateSlot

public static void updateSlot(String slotId)
                       throws SQLException

Throws:

SQLException

usedSpaceCountForUser

public static void usedSpaceCountForUser(String jid,
 ResultSet[] data)
                                  throws SQLException

Throws:

SQLException

usedSpaceCountForDomain

public static void usedSpaceCountForDomain(String domain,
 ResultSet[] data)
                                    throws SQLException

Throws:

SQLException

userSlotsQuery

public static void userSlotsQuery(String jid,
 String afterId,
 Integer maxLimit,
 ResultSet[] data)
                           throws SQLException

Throws:

SQLException

domainSlotsQuery

public static void domainSlotsQuery(String domain,
 String afterId,
 Integer maxLimit,
 ResultSet[] data)
                             throws SQLException

Throws:

SQLException

removeSlot

public static void removeSlot(String slotId)
                       throws SQLException

Throws:

SQLException