def testAnimal():
cmd = """
INSERT INTO
Animal (Name, Type)
VALUES
('Cat', 3);
"""
return sql.EXEC(cmd)
def addPet(aUser, aStat): # adds a 'pet' to the database
sql.EXEC(("""
INSERT INTO
Interactions (User, aStatus)
VALUES
('{0}','{1}');
""").format(aUser, aStat))
return
def update_MediaType(mediaID, typeID):
cmd = """
UPDATE Media
SET MediaType = {}
WHERE ID = {};
""".format(typeID, mediaID)
return sql.EXEC(cmd)
def update_MediaCategory(mediaID, categoryID):
cmd = """
UPDATE Media
SET MediaCategory = {}
WHERE ID = {};
""".format(categoryID, mediaID)
return sql.EXEC(cmd)
def insertIssue(server, stat,
userID): # adds am Issue as a server number and status
sql.EXEC(("""
INSERT INTO
Issues (ServerNumber, ServerStatus, SlackID)
VALUES
({0},'{1}', '{2}');
""").format(server, stat, userID))
return
def returnAll(slackID):
cmd = """
UPDATE
Transactions
SET
CheckIN = datetime('now','localtime')
WHERE
SlackID = '{0}'
AND CheckIN is null;
""".format(slackID)
return sql.EXEC(cmd)
def Media_adminCheckIN(mediaID):
cmd = """
UPDATE
Transactions
SET
CheckIN = datetime('now','localtime')
WHERE
MediaID = {0}
AND CheckIN is null;
""".format(mediaID)
return sql.EXEC(cmd)
def Media_adminCheckOUT(mediaID, slackID):
if isItemCheckedOut(mediaID): # can't check out something twice ... I hope
return 5
cmd = """
INSERT INTO
Transactions
(MediaID, SlackID, CheckOUT)
VALUES
({0},'{1}', datetime('now','localtime'));
""".format(mediaID, slackID)
return sql.EXEC(cmd)
def Media_CheckOUT(mediaID, slackID):
if isItemCheckedOut(mediaID): # can't check out something twice
return 5
if tooManyOut(slackID): # can only check out a cuople of items
return 4
cmd = """
INSERT INTO
Transactions
(MediaID, SlackID, CheckOUT)
VALUES
({0},'{1}', datetime('now','localtime'));
""".format(mediaID, slackID)
return sql.EXEC(cmd)
def Media_CheckIN(mediaID, slackID):
if not isItemCheckedOut(mediaID): # if this doesn't work, you'll need an admin
return 7
cmd = """
UPDATE
Transactions
SET
CheckIN = datetime('now','localtime')
WHERE
MediaID = {0}
AND SlackID = '{1}'
AND CheckIN is null;
""".format(mediaID, slackID)
return sql.EXEC(cmd)
def createAnimaltable(tableName):
cmd = ""
sql.EXEC(cmd)