public function up()
{
// reset db metadata cache
QFrame_Db_Table::scanDb();
QFrame_Db_Table::resetAll();
$this->auth();
$xml = file_get_contents(_path(PROJECT_PATH, 'xml', 'sig-4-0-questionnaire-definition.xml'));
QuestionnaireModel::importXML($xml);
InstanceModel::importXML($xml, 'Sample SIG Instance');
}
public function up()
{
$this->createTable('db_user', array('primary' => 'dbUserID'), array(array('dbUserID', 'integer'), array('dbUserName', 'string', array('limit' => 20)), array('dbUserPW', 'string', array('limit' => 50)), array('dbUserFullName', 'string', array('limit' => 50, 'null' => true)), array('dbUserActive', 'string', array('limit' => 1, 'default' => 'Y')), array('ACLstring', 'text', array('null' => true, 'limit' => '1M'))));
$this->createIndex('db_user', array('dbUserName'));
// reset db metadata cache
QFrame_Db_Table::scanDb();
// create some default data
$admin = new DbUserModel(array('dbUserName' => 'admin', 'dbUserPW' => 'admin', 'dbUserFullName' => 'Administrator'));
$admin->save();
$user = new DbUserModel(array('dbUserName' => 'user', 'dbUserPW' => 'user', 'dbUserFullName' => 'User'));
$user->save();
}
public function up()
{
$this->createTable('role', array('primary' => 'roleID'), array(array('roleID', 'integer'), array('roleDescription', 'string', array('limit' => 128, 'null' => true)), array('ACLstring', 'text', array('null' => true, 'limit' => '1M'))));
$this->createTable('assignment', array('primary' => 'assignmentID'), array(array('dbUserID', 'integer'), array('roleID', 'integer'), array('assignmentID', 'integer'), array('comments', 'text', array('null' => true))));
$this->createIndex('assignment', array('dbUserID', 'roleID'));
// reset db metadata cache
QFrame_Db_Table::scanDb();
// give the admin user full global rights
$adminRole = RoleModel::create(array('roleDescription' => 'Administrators'));
$adminRole->grant('view');
$adminRole->grant('edit');
$adminRole->grant('approve');
$adminRole->grant('administer');
$adminRole->save();
DbUserModel::findByUsername('admin')->addRole($adminRole)->save();
}
public function up()
{
// add the column
$this->addColumn('instance', 'hidden', 'boolean', array('default' => 0));
// reset db metadata cache
QFrame_Db_Table::scanDb();
QFrame_Db_Table::resetAll();
// make sure that existing questionnaires have a default instance (and create one if not)
$this->auth();
foreach (QuestionnaireModel::getAllQuestionnaires('instance') as $questionnaire) {
$default = $questionnaire->getDefaultInstance();
if ($default === null) {
$xml = $questionnaire->fetchQuestionnaireDefinition();
InstanceModel::importXML($xml, '_default_', array('hidden' => 1));
}
}
}
