2 * Copyright 1999, Dmitry Kovalev <mit@openldap.org>, All rights reserved.
4 * Redistribution and use in source and binary forms are permitted only
5 * as authorized by the OpenLDAP Public License. A copy of this
6 * license is available at http://www.OpenLDAP.org/license.html or
7 * in file LICENSE in the top-level directory of the distribution.
15 #include <sys/types.h>
20 #include "schema-map.h"
24 char backsql_def_oc_query[]="SELECT id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM ldap_oc_mappings";
25 char backsql_def_at_query[]="SELECT name,sel_expr,from_tbls,join_where,add_proc,
26 delete_proc,param_order,expect_return,sel_expr_u FROM ldap_attr_mappings WHERE oc_map_id=?";
27 char backsql_def_delentry_query[]="DELETE FROM ldap_entries WHERE id=?";
28 char backsql_def_insentry_query[]="INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)";
29 char backsql_def_subtree_cond[]="ldap_entries.dn LIKE CONCAT('%',?)";
30 char backsql_id_query[]="SELECT id,keyval,oc_map_id FROM ldap_entries WHERE ";
33 char backsql_check_dn_ru_query[] = "SELECT dn_ru from ldap_entries";
35 char* backsql_strcat(char* dest,int *buflen, ...)
41 //Debug(LDAP_DEBUG_TRACE,"==>my_strcat()\n");
42 va_start(strs,buflen);
43 if (dest==NULL || *buflen<=0)
45 dest=(char*)ch_calloc(BACKSQL_STR_GROW,sizeof(char));
46 *buflen=BACKSQL_STR_GROW;
49 while ((cstr=va_arg(strs,char*)) != NULL)
52 grow=BACKSQL_MAX(BACKSQL_STR_GROW,cslen);
53 if (*buflen-cdlen < cslen)
55 //Debug(LDAP_DEBUG_TRACE,"my_strcat(): buflen=%d, cdlen=%d, cslen=%d -- reallocating dest\n",
56 // *buflen,cdlen,cslen);
57 dest=(char*)ch_realloc(dest,(*buflen)+grow*sizeof(char));
60 Debug(LDAP_DEBUG_ANY,"my_strcat(): could not reallocate string buffer.\n",0,0,0);
63 //Debug(LDAP_DEBUG_TRACE,"my_strcat(): new buflen=%d, dest=%p\n",*buflen,dest,0);
69 //Debug(LDAP_DEBUG_TRACE,"<==my_strcat() (dest='%s')\n",dest,0,0);
73 int backsql_entry_addattr(Entry *e,char *at_name,char *at_val,unsigned int at_val_len)
75 Attribute *c_at=e->e_attrs;
76 struct berval* add_val[2];
78 AttributeDescription *ad;
82 Debug(LDAP_DEBUG_TRACE,"backsql_entry_addattr(): at_name='%s', at_val='%s'\n",at_name,at_val,0);
84 cval.bv_len=at_val_len;
89 rc = slap_str2ad( at_name, &ad, &text );
90 if( rc != LDAP_SUCCESS )
92 Debug(LDAP_DEBUG_TRACE,"backsql_entry_addattr(): failed to find AttributeDescription for '%s'\n",at_name,0,0);
96 rc = attr_merge(e,ad,add_val);
101 Debug(LDAP_DEBUG_TRACE,"backsql_entry_addattr(): failed to merge value '%s' for attribute '%s'\n",at_val,at_name,0);
105 Debug(LDAP_DEBUG_TRACE,"<==backsql_query_addattr()\n",0,0,0);
109 char* backsql_get_table_spec(char **p)
116 while(**p && **p!=',') (*p)++;
120 #define BACKSQL_NEXT_WORD {while (*s && isspace(*s)) s++; if (!*s) return res; q=s; while (*q && !isspace(*q)) q++; if (*q) *q++='\0';}
122 res=backsql_strcat(res,&res_len,s,NULL);//table name
126 if (!strcasecmp(s,"as"))
131 //res=backsql_strcat(res,&res_len," AS ",s,NULL);//table alias
132 //oracle doesn't understand AS :(
133 res=backsql_strcat(res,&res_len," ",s,NULL);//table alias
137 int backsql_merge_from_clause(char **dest_from,int *dest_len,char *src_from)
139 char *s,*p,*srcc,*pos,e;
141 //Debug(LDAP_DEBUG_TRACE,"==>backsql_merge_from_clause(): dest_from='%s',src_from='%s'\n",
142 // dest_from,src_from,0);
143 srcc=ch_strdup(src_from);
147 s=backsql_get_table_spec(&p);
148 // Debug(LDAP_DEBUG_TRACE,"backsql_merge_from_clause(): p='%s' s='%s'\n",p,s,0);
149 if (*dest_from==NULL)
150 *dest_from=backsql_strcat(*dest_from,dest_len,s,NULL);
152 if((pos=strstr(*dest_from,s))==NULL)
153 *dest_from=backsql_strcat(*dest_from,dest_len,",",s,NULL);
154 else if((e=pos[strlen(s)])!='\0' && e!=',')
155 *dest_from=backsql_strcat(*dest_from,dest_len,",",s,NULL);
159 // Debug(LDAP_DEBUG_TRACE,"<==backsql_merge_from_clause()\n",0,0,0);
164 #endif /* SLAPD_SQL */