예제 #1
0
파일: Sequence.php 프로젝트: kafruhs/fws
 private function _insertNewSequence()
 {
     $table = DB::table('sequence');
     $statement = new base_database_statement_Insert();
     $statement->setTable($table);
     $statement->setColumnValue($table->getColumn('class'), DB::term($this->class));
     $statement->setColumnValue($table->getColumn('num'), DB::term($this->nextSeq));
     $statement->insertDatabase();
 }
예제 #2
0
파일: BaseObject.php 프로젝트: kafruhs/fws
 /**
  * insert a new revision of the given Object
  *
  * @param base_database_Table
  * @throws base_database_Exception
  */
 private function _insertNewData(base_database_Table $table)
 {
     $statement = new base_database_statement_Insert();
     $statement->setTable($table);
     foreach ($this->_fields as $fieldName => $value) {
         if (empty($value) || $fieldName == 'PK') {
             continue;
         }
         if (in_array($fieldName, $this->mnFields)) {
             continue;
         }
         $fi = $this->getFieldinfo($fieldName);
         $dtObj = $fi->getDatatypeObject();
         $value = $dtObj->toDB($value);
         $statement->setColumnValue($table->getColumn($fieldName), DB::term($value));
     }
     $statement->insertDatabase();
     foreach ($this->mnFields as $fieldName) {
         $fi = $this->getFieldinfo($fieldName);
         $this->_saveMNField($fi);
     }
 }
예제 #3
0
 /**
  * saves the given Connection
  *
  * @throws base_exception_BaseConnectionObject
  */
 public function save()
 {
     if ($this->_validateNeededInformation() != self::SAVE_VALIDATION_SUCCESSFULL) {
         return self::SAVE_OBJECT_ALREADY_EXISTS;
     }
     $insert = new base_database_statement_Insert();
     $table = DB::table($this->table);
     $insert->setTable($table);
     $properties = ['classLeft', 'classRight', 'lkLeft', 'lkRight'];
     foreach ($properties as $property) {
         $insert->setColumnValue($table->getColumn($property), DB::term($this->$property));
     }
     $insert->insertDatabase();
     return self::SAVE_SUCCESSFULL;
 }
예제 #4
0
파일: Manager.php 프로젝트: kafruhs/fws
 /**
  * creates the admin user
  *
  * @param OutputDevice $od
  * @throws base_database_Exception
  */
 public function createAdminUser(OutputDevice $od)
 {
     $user = new User();
     if (!is_null($user->load(1))) {
         return;
     }
     $seq = new Sequence('User');
     $adminData['LK'] = $seq->getNextSequence();
     $adminData['firstEditor'] = 1;
     $dateTime = new base_date_model_DateTime();
     $adminData['firstEditTime'] = $dateTime->toDB();
     $adminData['editor'] = 1;
     $adminData['editTime'] = $dateTime->toDB();
     $adminData['userid'] = 'admin';
     $adminData['password'] = '******';
     $adminData['firstName'] = 'Admin';
     $adminData['lastName'] = 'Admin';
     $adminData['email'] = '*****@*****.**';
     $statement = new base_database_statement_Insert();
     $table = DB::table('user');
     $statement->setTable($table);
     foreach ($adminData as $fieldName => $value) {
         $statement->setColumnValue($table->getColumn($fieldName), DB::term($value));
     }
     $dbObj = base_database_connection_Mysql::get();
     $dbObj->beginTransaction();
     $seq->save();
     $statement->insertDatabase();
     $dbObj->endTransaction();
     base_install_Message::printOut('----- Admin User created -----', $od);
 }