⚠ In case you've missed it we are migrating to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. Very soon this forum will be read-only and archived. ⚠


tee_porsche

Member Since 03 May 2012
Offline Last Active Jan 06 2013 11:40 AM
-----

Posts I've Made

In Topic: Is it applicable for Oracle database

30 December 2012 - 08:20 PM

Yes It Is. 10g and 11g compatible. works with my XE too.

In Topic: Full Compatible Verion With Oracle, Now Available. pheeeew!

30 December 2012 - 08:18 PM

hi All, I've made a lot of changes to the oracle gcrud library ..This should make it compatible with previous version. for now I'm trying to keep up with the latest changes ....would upload the changes as soon as I'm done.

Sorry for the late response been working with other projects.

Regards

In Topic: Full Compatible Verion With Oracle, Now Available. pheeeew!

12 July 2012 - 08:45 AM

Please update the db_relation_n_n_update function in the grocery_crud_model of the last zip attachment in order for the realation_n_n functionality to work.


  function db_relation_n_n_update($field_info, $post_data ,$main_primary_key)
    {





	

	 $this->db->where($field_info->primary_key_alias_to_this_table, $main_primary_key);
 
 
 
  
	 if(!empty($post_data))
	  $this->db->where_not_in($field_info->primary_key_alias_to_selection_table , $post_data);
	 $this->db->delete($field_info->relation_table);
	
	 $counter = 0;
	
  
	    if(!empty($post_data))
	 {   
 
  /**ob_start();
  var_dump($post_data);
  $xxx = ob_get_clean();
  $xxx .= '<br/>primary_key_alias_to_this_table:'.$field_info->primary_key_alias_to_this_table;
  $xxx .= '<br/>primary_key_alias_to_selection_table:'.$field_info->primary_key_alias_to_selection_table;
  $xxx .= '<br/>main_primary_key:'. $main_primary_key;
   var_dump($where_array);
    $xxx .= ob_get_clean();
	   $xxx .= '<br/>relation_table:'. $field_info->relation_table;
	   $xxx .= '<br/>priority_field_relation_table:'. $field_info->priority_field_relation_table;
    $xxx .= '<br/>Count:'. $count;
    if ( ! write_file(@'./debug.txt', $xxx))
    {
	 // echo 'Unable to write the file';
    }
    else
    {
	 // echo 'File written!';
    }
   
    **/
	  foreach($post_data as $primary_key_value)
	  {
    $where_array = array(
	    $field_info->primary_key_alias_to_this_table => $main_primary_key,
	    $field_info->primary_key_alias_to_selection_table => $primary_key_value,
	   );
  
    $this->db->where($where_array);
    $count = $this->db->from($field_info->relation_table)->count_all_results();
   
   
    if($count == 0)
    {
   
   
    if(!empty($field_info->priority_field_relation_table))
    $where_array[$field_info->priority_field_relation_table] = $counter;
	 
					
  
	   $sql = "select {$field_info->relation_table}_SEQ.nextval AS NEXTID from dual";
		  $query = $this->db->query($sql);
		  $row = $query->row();
		  $newid= $row->NEXTID;
			    $pkfield = $this->get_primary_key("{$field_info->relation_table}"); 
		  $where_array[$pkfield] = $newid;
 
   
  
	   $this->db->insert($field_info->relation_table, $where_array);
	
	
    }elseif($count >= 1 && !empty($field_info->priority_field_relation_table))
    {
	 $this->db->update( $field_info->relation_table, array($field_info->priority_field_relation_table => $counter) , $where_array);
    }
   
    $counter++;
	  }
  
  
  
  
 
  }
    }
   

In Topic: Full Compatible Verion With Oracle, Now Available. pheeeew!

26 June 2012 - 11:58 AM

you can find my latest version here  Attached File  groceryoracle.zip   142.97K   714 downloads .... but remember to use sequences
{TABLENAME}_SEQ to mimic autonumbers in mysql which was my little dirty hack to allow the insert functionality work on oracle

that is  FILMS table would have FILMS_SEQ as its sequence in oracle
i've modified the oci drivers to reflect updates too.

Happy coding y'all

In Topic: Server side validation

21 May 2012 - 02:58 PM

I also got this issue.... any help would be appreciated