def get(self,request):
     ans = self.database.executeKnowQuery('SELECT * FROM requestDetails WHERE id = ?', (request.id,))
     if (len(ans) == 0):
         return False
     ans=ans[0]
     ret = RequestDetails()
     ret.setAll(ans)
     return ret
Ejemplo n.º 2
0
 def get(self, request):
     ans = self.database.executeKnowQuery(
         'SELECT * FROM requestDetails WHERE id = ?', (request.id, ))
     if (len(ans) == 0):
         return False
     ans = ans[0]
     ret = RequestDetails()
     ret.setAll(ans)
     return ret
Ejemplo n.º 3
0
 def getAll(self):
     ans = self.database.executeKnowQuery('SELECT * from requestDetails')
     if (len(ans) == 0):
         return False
     ret = []
     for row in ans:
         temp = RequestDetails()
         temp.setAll(row)
         ret.append(temp)
     return ret
 def getAll(self):
     ans= self.database.executeKnowQuery('SELECT * from requestDetails')
     if (len(ans)==0):
         return False
     ret=[]
     for row in ans:
         temp = RequestDetails()
         temp.setAll(row)
         ret.append(temp)
     return ret
def RequestDetailsTest(db):
    rqd = RequestDetails(1, "test1", "test", "test", "test", "test", "test", "test")
    assert rqd.id == 1
    assert len(rqd.getAll()) == 8
    assert equal_tuples(rqd.getAll(), (1, "test1", "test", "test", "test", "test", "test", "test"))
    rqd.setAll((12, "test12", "test2", "tes2t", "tes2t", "tes3t", "te4st", "tes5t"))
    assert equal_tuples(rqd.getAll(), (12, "test12", "test2", "tes2t", "tes2t", "tes3t", "te4st", "tes5t"))
    assert db.isConnectionOk() == 1
    db.executeDoQuery("DROP TABLE IF EXISTS requestDetails")
    db.executeDoQuery(
        "CREATE TABLE IF NOT EXISTS requestDetails(id INTEGER PRIMARY KEY,detail1 text,detail2 text,detail3 text,detail4 text,detail5 text,detail6 text,needs text,FOREIGN KEY(id) REFERENCES request(id))"
    )
    reqDB = RequestDetailsDBInterface(db)
    request = RequestDetails(1, "test", "", "", "", "", "", "")
    request.id = reqDB.add(request)
    assert request.id != 0
    request = reqDB.get(request)
    assert request.detail1 == "test"
    request.detail1 = "test2"
    reqDB.update(request)
    request = reqDB.get(request)
    assert request.detail1 == "test2"
    a = reqDB.getAll()
    assert len(a) == 1
    assert a[0].detail1 == "test2"
    a = reqDB.getByID(1)
    assert a.detail1 == "test2"
    print("Passed RequestDetails test")
Ejemplo n.º 6
0
 def getByID(self, id):
     request = RequestDetails()
     request.id = id
     return self.get(request)
Ejemplo n.º 7
0
def RequestDetailsTest(db):
    rqd = RequestDetails(1, 'test1', 'test', 'test', 'test', 'test', 'test',
                         'test')
    assert (rqd.id == 1)
    assert (len(rqd.getAll()) == 8)
    assert (equal_tuples(
        rqd.getAll(),
        (1, 'test1', 'test', 'test', 'test', 'test', 'test', 'test')))
    rqd.setAll(
        (12, 'test12', 'test2', 'tes2t', 'tes2t', 'tes3t', 'te4st', 'tes5t'))
    assert (equal_tuples(
        rqd.getAll(),
        (12, 'test12', 'test2', 'tes2t', 'tes2t', 'tes3t', 'te4st', 'tes5t')))
    assert (db.isConnectionOk() == 1)
    db.executeDoQuery("DROP TABLE IF EXISTS requestDetails")
    db.executeDoQuery(
        "CREATE TABLE IF NOT EXISTS requestDetails(id INTEGER PRIMARY KEY,detail1 text,detail2 text,detail3 text,detail4 text,detail5 text,detail6 text,needs text,FOREIGN KEY(id) REFERENCES request(id))"
    )
    reqDB = RequestDetailsDBInterface(db)
    request = RequestDetails(1, 'test', '', '', '', '', '', '')
    request.id = reqDB.add(request)
    assert (request.id != 0)
    request = reqDB.get(request)
    assert (request.detail1 == 'test')
    request.detail1 = 'test2'
    reqDB.update(request)
    request = reqDB.get(request)
    assert (request.detail1 == 'test2')
    a = reqDB.getAll()
    assert (len(a) == 1)
    assert (a[0].detail1 == 'test2')
    a = reqDB.getByID(1)
    assert (a.detail1 == 'test2')
    print('Passed RequestDetails test')
 def getByID(self,id):
     request = RequestDetails()
     request.id = id
     return self.get(request)