]> git.sur5r.net Git - openldap/blobdiff - servers/slapd/back-sql/init.c
matched values is "global"
[openldap] / servers / slapd / back-sql / init.c
index 645c073418091cec687737af56bec0011359fca5..4a236a17183f2407a281676d4e44ad93c53804b0 100644 (file)
@@ -3,6 +3,7 @@
  *
  * Copyright 1999-2005 The OpenLDAP Foundation.
  * Portions Copyright 1999 Dmitry Kovalev.
+ * Portions Copyright 2002 Pierangelo Masarati.
  * All rights reserved.
  *
  * Redistribution and use in source and binary forms, with or without
@@ -15,7 +16,8 @@
  */
 /* ACKNOWLEDGEMENTS:
  * This work was initially developed by Dmitry Kovalev for inclusion
- * by OpenLDAP Software.
+ * by OpenLDAP Software.  Additional significant contributors include
+ * Pierangelo Masarati.
  */
 
 #include "portable.h"
@@ -32,19 +34,25 @@ sql_back_initialize(
        BackendInfo     *bi )
 { 
        static char *controls[] = {
+               LDAP_CONTROL_ASSERT,
+               LDAP_CONTROL_MANAGEDSAIT,
 #if 0 /* needs improvements */
-#ifdef LDAP_CONTROL_NOOP
                LDAP_CONTROL_NOOP,
-#endif /* LDAP_CONTROL_NOOP */
 #endif
-#ifdef LDAP_CONTROL_VALUESRETURNFILTER
-               LDAP_CONTROL_VALUESRETURNFILTER,
-#endif /* LDAP_CONTROL_VALUESRETURNFILTER */
+#ifdef LDAP_CONTROL_X_TREE_DELETE
+               LDAP_CONTROL_X_TREE_DELETE,
+#endif /* LDAP_CONTROL_X_TREE_DELETE */
                NULL
        };
 
        bi->bi_controls = controls;
 
+       bi->bi_flags |=
+#if 0
+               SLAP_BFLAG_INCREMENT |
+#endif
+               SLAP_BFLAG_REFERRALS;
+
        Debug( LDAP_DEBUG_TRACE,"==>sql_back_initialize()\n", 0, 0, 0 );
        
        bi->bi_db_init = backsql_db_init;
@@ -133,10 +141,20 @@ backsql_db_destroy(
        free( bi->sql_subtree_cond.bv_val );
        free( bi->sql_oc_query );
        free( bi->sql_at_query );
-       free( bi->sql_insentry_query );
-       free( bi->sql_delentry_query );
-       free( bi->sql_delobjclasses_query );
-       free( bi->sql_delreferrals_query );
+       free( bi->sql_insentry_stmt );
+       free( bi->sql_delentry_stmt );
+       free( bi->sql_renentry_stmt );
+       free( bi->sql_delobjclasses_stmt );
+
+       if ( bi->sql_anlist ) {
+               int     i;
+
+               for ( i = 0; !BER_BVISNULL( &bi->sql_anlist[i].an_name ); i++ )
+               {
+                       ch_free( bi->sql_anlist[i].an_name.bv_val );
+               }
+               ch_free( bi->sql_anlist );
+       }
 
        if ( bi->sql_baseObject ) {
                entry_free( bi->sql_baseObject );
@@ -341,48 +359,48 @@ backsql_db_open(
                bi->sql_at_query = ch_strdup( backsql_def_at_query );
        }
        
-       if ( bi->sql_insentry_query == NULL ) {
+       if ( bi->sql_insentry_stmt == NULL ) {
                Debug( LDAP_DEBUG_TRACE, "backsql_db_open(): "
                        "entry insertion SQL statement not specified "
-                       "(use \"insentry_query\" directive in slapd.conf)\n",
+                       "(use \"insentry_stmt\" directive in slapd.conf)\n",
                        0, 0, 0 );
                Debug(LDAP_DEBUG_TRACE, "backsql_db_open(): "
                        "setting \"%s\" by default\n",
-                       backsql_def_insentry_query, 0, 0 );
-               bi->sql_insentry_query = ch_strdup( backsql_def_insentry_query );
+                       backsql_def_insentry_stmt, 0, 0 );
+               bi->sql_insentry_stmt = ch_strdup( backsql_def_insentry_stmt );
        }
        
-       if ( bi->sql_delentry_query == NULL ) {
+       if ( bi->sql_delentry_stmt == NULL ) {
                Debug( LDAP_DEBUG_TRACE, "backsql_db_open(): "
                        "entry deletion SQL statement not specified "
-                       "(use \"delentry_query\" directive in slapd.conf)\n",
+                       "(use \"delentry_stmt\" directive in slapd.conf)\n",
                        0, 0, 0 );
                Debug( LDAP_DEBUG_TRACE, "backsql_db_open(): "
                        "setting \"%s\" by default\n",
-                       backsql_def_delentry_query, 0, 0 );
-               bi->sql_delentry_query = ch_strdup( backsql_def_delentry_query );
+                       backsql_def_delentry_stmt, 0, 0 );
+               bi->sql_delentry_stmt = ch_strdup( backsql_def_delentry_stmt );
        }
 
-       if ( bi->sql_delobjclasses_query == NULL ) {
+       if ( bi->sql_renentry_stmt == NULL ) {
                Debug( LDAP_DEBUG_TRACE, "backsql_db_open(): "
-                       "objclasses deletion SQL statement not specified "
-                       "(use \"delobjclasses_query\" directive in slapd.conf)\n",
+                       "entry deletion SQL statement not specified "
+                       "(use \"renentry_stmt\" directive in slapd.conf)\n",
                        0, 0, 0 );
                Debug( LDAP_DEBUG_TRACE, "backsql_db_open(): "
                        "setting \"%s\" by default\n",
-                       backsql_def_delobjclasses_query, 0, 0 );
-               bi->sql_delobjclasses_query = ch_strdup( backsql_def_delobjclasses_query );
+                       backsql_def_renentry_stmt, 0, 0 );
+               bi->sql_renentry_stmt = ch_strdup( backsql_def_renentry_stmt );
        }
 
-       if ( bi->sql_delreferrals_query == NULL ) {
+       if ( bi->sql_delobjclasses_stmt == NULL ) {
                Debug( LDAP_DEBUG_TRACE, "backsql_db_open(): "
-                       "referrals deletion SQL statement not specified "
-                       "(use \"delreferrals_query\" directive in slapd.conf)\n",
+                       "objclasses deletion SQL statement not specified "
+                       "(use \"delobjclasses_stmt\" directive in slapd.conf)\n",
                        0, 0, 0 );
                Debug( LDAP_DEBUG_TRACE, "backsql_db_open(): "
                        "setting \"%s\" by default\n",
-                       backsql_def_delreferrals_query, 0, 0 );
-               bi->sql_delreferrals_query = ch_strdup( backsql_def_delreferrals_query );
+                       backsql_def_delobjclasses_stmt, 0, 0 );
+               bi->sql_delobjclasses_stmt = ch_strdup( backsql_def_delobjclasses_stmt );
        }
 
        op->o_hdr = (Opheader *)&op[ 1 ];
@@ -435,8 +453,9 @@ backsql_db_open(
        bb.bb_val.bv_len = 0;
        bb.bb_len = 0;
        backsql_strfcat( &bb, "sb",
-                       "SELECT COUNT(distinct subordinates.id) FROM ldap_entries,ldap_entries subordinates WHERE subordinates.parent=ldap_entries.id AND ",
-
+                       "SELECT COUNT(distinct subordinates.id) "
+                       "FROM ldap_entries,ldap_entries " BACKSQL_ALIASING "subordinates "
+                       "WHERE subordinates.parent=ldap_entries.id AND ",
                        &bi->sql_children_cond );
        bi->sql_has_children_query = bb.bb_val.bv_val;
  
@@ -447,6 +466,14 @@ backsql_db_open(
                        0, 0, 0 );
                return 1;
        }
+
+       /* should never happen! */
+       assert( bd->be_nsuffix != NULL );
+       
+       if ( BER_BVISNULL( &bd->be_nsuffix[ 1 ] ) ) {
+               /* enable if only one suffix is defined */
+               bi->sql_flags |= BSQLF_USE_SUBTREE_SHORTCUT;
+       }
        
        Debug( LDAP_DEBUG_TRACE, "<==backsql_db_open(): "
                "test succeeded, schema map loaded\n", 0, 0, 0 );