phpesp-devel

[phpesp-dev] true or false: responses can be recovered if the survey is blown away?

[Bishop B. <ph...@id...>]

All,

I have a question about the phpESP underlying design: if you delete a =20
survey to which a response points, can you still recover the answers =20
given in the response?  For example, say you have this:

mysql> select id,survey_id,complete from response;
+----+-----------+----------+
| id | survey_id | complete |
+----+-----------+----------+
|  7 |        18 | Y        |
|  6 |        18 | Y        |
|  8 |        18 | Y        |
|  9 |        18 | Y        |
| 10 |        18 | Y        |
| 11 |        17 | N        |
| 13 |        20 | N        |
| 14 |        21 | Y        |
+----+-----------+----------+

and then you do this:
delete from survey where id=3D18


Can you get the responses made for response ids 6, 7, 8, 9, and 10?  =20
If so, is there a convenient function to get those responses as an =20
array/object?

Thanks!
bishop

--=20
Bishop Bettini
ideacode, Inc.
(main) +1 919 341 5170 / (fax) +1 919 521 4100

Visit us on the web at:
ideacode.com          Professional software research and development
reviewmysoftware.com  Improve sales! Review your software before you release
bytejar.com           Solutions to those annoying development problems

Re: [phpesp-dev] true or false: responses can be recovered if the survey is blown away?

[Matthew G. <mat...@gm...>]

On Sun, 2008-01-20 at 20:16 -0500, Bishop Bettini wrote:
> All,
> 
> I have a question about the phpESP underlying design: if you delete a  
> survey to which a response points, can you still recover the answers  
> given in the response?  For example, say you have this:
> 
> mysql> select id,survey_id,complete from response;
> +----+-----------+----------+
> | id | survey_id | complete |
> +----+-----------+----------+
> |  7 |        18 | Y        |
> |  6 |        18 | Y        |
> |  8 |        18 | Y        |
> |  9 |        18 | Y        |
> | 10 |        18 | Y        |
> | 11 |        17 | N        |
> | 13 |        20 | N        |
> | 14 |        21 | Y        |
> +----+-----------+----------+
> 
> and then you do this:
> delete from survey where id=18
> 
If you remember the survey ID then yeah you could, but why?
> 
> Can you get the responses made for response ids 6, 7, 8, 9, and 10?   
> If so, is there a convenient function to get those responses as an  
> array/object?
> 
It's been so long, I would need to look over the code, but if a function
exists, it should be easy to find.

> Thanks!
> bishop
> 

Re: [phpesp-dev] true or false: responses can be recovered if the survey is blown away?

[Bishop B. <ph...@id...>]

>> [snip]
>>
> If you remember the survey ID then yeah you could, but why?

I'm writing a bulk uploader, so the admin can load their many =20
thousands of surveys (per time period), and I'm considering data =20
consistency repercussions if I do something like DELETE FROM survey =20
WHERE realm =3D 'foo'.

The bulk uploader has a hard requirement to not touch response data, =20
so I wondered if I performed that delete if the data would still be =20
recoverable.  I didn't know if you needed the survey to know the =20
question structure to get the responses back.

But, it really shouldn't be an issue, because I should only delete =20
surveys that are not activated or done -- those are guaranteed to not =20
have any responses.


>> Can you get the responses made for response ids 6, 7, 8, 9, and 10?
>> If so, is there a convenient function to get those responses as an
>> array/object?
>>
> It's been so long, I would need to look over the code, but if a function
> exists, it should be easy to find.

Okay, I'll dig.  My client wants all kinds of roll-up reports, so one =20
convenient function would be nice.  I've not seen a single =20
phpESP-native object, so I'm guessing that's out. :)


Thanks!
bishop

--=20
Bishop Bettini
ideacode, Inc.
(main) +1 919 341 5170 / (fax) +1 919 521 4100

Visit us on the web at:
ideacode.com          Professional software research and development
reviewmysoftware.com  Improve sales! Review your software before you release
bytejar.com           Solutions to those annoying development problems