Package tigase.http.upload.db.derby
Class StoredProcedures
- java.lang.Object
-
- tigase.http.upload.db.derby.StoredProcedures
-
public class StoredProcedures extends java.lang.Object
Created by andrzej on 10.08.2016.
-
-
Constructor Summary
Constructors Constructor Description StoredProcedures()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static void
allocateSlot(java.lang.String slotId, java.lang.String uploader, java.lang.String domain, java.lang.String res, java.lang.String filename, java.lang.Long filesize, java.lang.String contentType, java.sql.ResultSet[] data)
static void
domainSlotsQuery(java.lang.String domain, java.lang.String afterId, java.lang.Integer maxLimit, java.sql.ResultSet[] data)
static void
getSlot(java.lang.String slotId, java.sql.ResultSet[] data)
static void
listExpiredSlots(java.lang.String domain, java.sql.Timestamp ts, java.lang.Integer max, java.sql.ResultSet[] data)
static void
removeExpiredSlots(java.lang.String domain, java.sql.Timestamp ts, java.lang.Integer max)
static void
removeSlot(java.lang.String slotId)
static void
updateSlot(java.lang.String slotId)
static void
usedSpaceCountForDomain(java.lang.String domain, java.sql.ResultSet[] data)
static void
usedSpaceCountForUser(java.lang.String jid, java.sql.ResultSet[] data)
static void
userSlotsQuery(java.lang.String jid, java.lang.String afterId, java.lang.Integer maxLimit, java.sql.ResultSet[] data)
-
-
-
Method Detail
-
allocateSlot
public static void allocateSlot(java.lang.String slotId, java.lang.String uploader, java.lang.String domain, java.lang.String res, java.lang.String filename, java.lang.Long filesize, java.lang.String contentType, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getSlot
public static void getSlot(java.lang.String slotId, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
listExpiredSlots
public static void listExpiredSlots(java.lang.String domain, java.sql.Timestamp ts, java.lang.Integer max, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
removeExpiredSlots
public static void removeExpiredSlots(java.lang.String domain, java.sql.Timestamp ts, java.lang.Integer max) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
updateSlot
public static void updateSlot(java.lang.String slotId) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
usedSpaceCountForUser
public static void usedSpaceCountForUser(java.lang.String jid, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
usedSpaceCountForDomain
public static void usedSpaceCountForDomain(java.lang.String domain, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
userSlotsQuery
public static void userSlotsQuery(java.lang.String jid, java.lang.String afterId, java.lang.Integer maxLimit, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
domainSlotsQuery
public static void domainSlotsQuery(java.lang.String domain, java.lang.String afterId, java.lang.Integer maxLimit, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
removeSlot
public static void removeSlot(java.lang.String slotId) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
-