Changeset 40

Timestamp:

07/22/11 17:28:23 (14 years ago)

Author:

basvannuland

Message:

added database readers and writers for application info and facilitator info

possible to store survey application and creator info

Location:

Dev/trunk

Files:

• classes/ApplicationDatabaseInterface.php (added)
• classes/ApplicationRDFReader.php (added)
• classes/ApplicationRDFWriter.php (added)
• classes/SurveyAnswerDatabaseInterface.php (modified) (1 diff)
• classes/SurveyAnswerRDFReader.php (modified) (3 diffs)
• classes/SurveyAnswerRDFWriter.php (modified) (2 diffs)
• classes/SurveyDatabaseInterface.php (modified) (4 diffs)
• classes/SurveyRDFReader.php (modified) (2 diffs)
• classes/SurveyRDFWriter.php (modified) (1 diff)
• classes/UserRDFReader.php (added)
• classes/UserRDFWriter.php (added)
• rdfConstants.php (modified) (2 diffs)

Dev/trunk/classes/SurveyAnswerDatabaseInterface.php

@@ -16 +16 @@
  
 
-    public function __construct($surveyID=null)
-    {
-                if($surveyID == null)
-                        $surveyUID = md5( uniqid(rand(), true) );
-                else
-                        $surveyUID = $surveyID;
-                                        
-                $this->surveyAnswerRDFWriter = new SurveyAnswerRDFWriter($surveyUID);
+    public function __construct($surveyID,$userID)
+    {                                   
+                $this->surveyAnswerRDFWriter = new SurveyAnswerRDFWriter($surveyUID,$userID);
                 $this->surveyAnswerRDFReader = new SurveyAnswerRDFReader($surveyUID);
     }
         
-        
+        public function setSurveyAnswerInfo($surveyInfo)
+        {
+
+        }       
 }
 ?>

Dev/trunk/classes/SurveyAnswerRDFReader.php

@@ -3 +3 @@
 class SurveyAnswerRDFReader extends SurveyRDFReader
 {       
+        protected $tempModel;
+        
     public function __construct($surveyUID)
     {
         parent::__construct($surveyUID);
+                
+                / Create empty MemModel
+                $factory = new ModelFactory();
+                $this->tempModel = $factory->getDefaultModel();
         }
         
         public function loadSurvey()
         {
-                parent::loadSurvey();
+                parent::loadSurvey();           
+                
+        }
+        
+        public function getAnswerByQuestion($questionID)
+        {
+                $this->tempModel->loadModel($this->model);
+                
                 $answerPath = 'surveys/answers_'.$this->surveyUID;
                 $answers = array();
@@ -24 +37 @@
                 foreach($answers as $answer)
                 {
-                        $this->model->load($answerPath.'/'.$answer);
+                        $this->tempModel->load($answerPath.'/'.$answer);
                 }
-        }
+                
+                $this->tempModel->visualize();
         
-        public function getAnswer($questionID)
-        {
-        $querystring = '
+                $querystring = '
                         PREFIX  predicates: <' . SURVEYTOOL_PREDICATES_NAMESPACE . '>
                         PREFIX  resources: <' . SURVEYTOOL_RESOURCES_NAMESPACE . '>
@@ -41 +53 @@
                         }';
                         
-                $result = $this->model->sparqlQuery($querystring);
+                $result = $this->tempModel->sparqlQuery($querystring);
+                
+                $this->tempModel->close();              
+
+                $this->tempModel->visualize();
+                                
+                return $result;
+        }
+        
+        public function getAnswerByRespondent($respondentID)
+        {
+                $this->tempModel->loadModel($this->model);
+                
+                $answerPath = 'surveys/answers_'.$this->surveyUID;
+                
+                $this->tempModel->load($answerPath . '/$answer_' . $respondentID);
+                
+                $this->tempModel->visualize();
+        
+                $querystring = '
+                        PREFIX  predicates: <' . SURVEYTOOL_PREDICATES_NAMESPACE . '>
+                        PREFIX  resources: <' . SURVEYTOOL_RESOURCES_NAMESPACE . '>
+                        SELECT  ?answered 
+                        WHERE   
+                        {
+                                _question       predicates:resource_type        resources:question ;
+                                                        predicates:answered             ?answered       
+                        }';
+                        
+                $result = $this->tempModel->sparqlQuery($querystring);
+                
+                $this->tempModel->close();              
+
+                $this->tempModel->visualize();
+                                
+                return $result;
+        }
+        
+        public function getAnswerByRespondentAndQuestion($respondentID,$questionID)
+        {
+                $this->tempModel->loadModel($this->model);
+                
+                $answerPath = 'surveys/answers_'.$this->surveyUID;
+                
+                $this->tempModel->load($answerPath . '/$answer_' . $respondentID);
+                
+                $this->tempModel->visualize();
+        
+                $querystring = '
+                        PREFIX  predicates: <' . SURVEYTOOL_PREDICATES_NAMESPACE . '>
+                        PREFIX  resources: <' . SURVEYTOOL_RESOURCES_NAMESPACE . '>
+                        SELECT  ?answered 
+                        WHERE   
+                        {
+                                _question       predicates:resource_type        resources:question ;
+                                                        predicates:uid                          "'.$questionID.'"       ;
+                                                        predicates:answered             ?answered       
+                        }';
+                        
+                $result = $this->tempModel->sparqlQuery($querystring);
+                
+                $this->tempModel->close();              
+
+                $this->tempModel->visualize();
                                 
                 return $result;

Dev/trunk/classes/SurveyAnswerRDFWriter.php

@@ -20 +20 @@
         }
         
-        public function setUserData($name)
+        public function setRespondentData($name)
         {                               
                 $resourceUser = new Resource(USER);
@@ -26 +26 @@
                 $LiteralUserName = new Literal($name);
                 $predicateName = new Resource(NAME);
-                $this->model->add(new Statement($resourceUser,$predicateUniqueID,$literalSurveyID));            
+                $this->model->add(new Statement($resourceUser,$predicateUniqueID,$LiteralUserName));            
                 
                 $literalUserID = new Literal($this->userUID);

Dev/trunk/classes/SurveyDatabaseInterface.php

@@ -1 +1 @@
 <?php
-// Survey class as intermediate for storing data from the site to the RDF database 
+// Survey database interface class as intermediate for storing data from the site to the RDF database 
 require 'rdfConstants.php';
 
@@ -15 +15 @@
  
 
-    public function __construct($surveyID=null)
+    public function __construct($surveyID)
     {
                 if($surveyID == null)
@@ -104 +104 @@
                         while (false !== ($file = readdir($handle))) {
                                 if(strstr($file, 'survey_'))
-                                        $surveyIDs[] = substr($file,0,strlen($file)-4);
+                                        $surveyIDs[] = substr($file,7,strlen($file)-11);
                         }
                 }
@@ -116 +116 @@
                 return $surveys;
         }
+        
 }
 ?>

Dev/trunk/classes/SurveyRDFReader.php

@@ -88 +88 @@
                         {       
                                 _question       predicates:resource_type        resources:question ;
-                                                        predicates:description  ?questionDescription            
+                                                        predicates:description          ?questionDescription            
                         }';
                         
@@ -156 +156 @@
                 $factory = new ModelFactory();
                 $tempmodel= $factory->getDefaultModel();
-                $tempmodel->load('surveys/'.$surveyID.'.rdf');
+                $tempmodel->load('surveys/survey_'.$surveyID.'.rdf');
                 
                 $querystring = '

Dev/trunk/classes/SurveyRDFWriter.php

@@ -42 +42 @@
                 $surveyDescription = new Literal($sDescription);
                 $this->model->add(new Statement($this->resourceSurvey,$predicateDescription,$surveyDescription));               
+        }
+        
+        public function setUserData($userID)
+        {                               
+                $resourceUser = new Resource(USER . '/' . $userID);
+                                
+                $predicateCreator = new Resource(CREATOR);
+                $this->model->add(new Statement($this->resourceSurvey,$predicateCreator,$resourceUser));
+        }
+        
+        public function setApplicationData($applicationID)
+        {
+                $resourceApplication = new Resource(APPLICATION . '/' . $userID);
+                                
+                $predicatePartOf = new Resource(PART_OF);
+                $this->model->add(new Statement($this->resourceSurvey,$predicatePartOf,$resourceApplication));
         }
         

Dev/trunk/rdfConstants.php

@@ -12 +12 @@
 define('ANSWER',SURVEYTOOL_RESOURCES_NAMESPACE . 'answer');
 define('USER',SURVEYTOOL_RESOURCES_NAMESPACE . 'user');
+define('APPLICATION',SURVEYTOOL_RESOURCES_NAMESPACE . 'application');
 
 // Predicates used for RDF triples
@@ -19 +20 @@
 define('TITLE',SURVEYTOOL_PREDICATES_NAMESPACE . 'title');
 define('DESCRIPTION',SURVEYTOOL_PREDICATES_NAMESPACE . 'description');
+define('PART_OF',SURVEYTOOL_PREDICATES_NAMESPACE . 'part_of');
+define('STYLE',SURVEYTOOL_PREDICATES_NAMESPACE . 'style');
 define('RTYPE',SURVEYTOOL_PREDICATES_NAMESPACE . 'resource_type');
 define('QTYPE',SURVEYTOOL_PREDICATES_NAMESPACE . 'question_type');
 define('HAS_QUESTION',SURVEYTOOL_PREDICATES_NAMESPACE . 'has_question');
 define('HAS_ANSWER',SURVEYTOOL_PREDICATES_NAMESPACE . 'has_answer');
-define('NUMBER_OF_ANSWERS',SURVEYTOOL_PREDICATES_NAMESPACE . 'number_of_answers');
-define('SCALE',SURVEYTOOL_PREDICATES_NAMESPACE . 'scale');
 define('ANSWERED',SURVEYTOOL_PREDICATES_NAMESPACE . 'answered');
 define('RESPONDENT',SURVEYTOOL_PREDICATES_NAMESPACE . 'respondent');