Changeset 41

Timestamp:

10/30/2008 10:45:34 PM (14 years ago)

Author:

marcus

Message:

r26 | stittgen | 2008-02-11 16:00:39 +0100 (Mo, 11 Feb 2008) | 1 line

sfd2db now checks the environment for SFDBREQSCRIPTFILE to determine the command for executing statements in a scriptfile (default is mysql).

File:

• SH_SHM/trunk/source/seed_io/sfd2db.c (modified) (4 diffs)

SH_SHM/trunk/source/seed_io/sfd2db.c

@@ -3 +3 @@
  *      ========
  *
- * $Revision: 23 $, $Date: 2008-02-05 12:56:20 +0100 (Di, 05 Feb 2008) $
+ * $Revision: 26 $, $Date: 2008-02-11 16:00:39 +0100 (Mo, 11 Feb 2008) $
  *
  * reads lines from sfdfile and creates commands to insert into sfdb database
@@ -42 +42 @@
         char     abspath[cBcFileLth+1];     /* path to sfdfile */
         char     sfdbreq[cBcLineLth+1];     /* request command to sfdb database */
+        char     sfdbreqscriptfile[cBcLineLth+1];       /* request command to sfdb database for executing statements in a scriptfile*/
         char     *env;                      /* pointer to environment */
         char     shellcmd[cBcLongStrLth+1]; /* shell command */
@@ -99 +100 @@
                 strcpy( sfdbreq, env );
         } /*endif*/
+
+        env = (char *)getenv( "SFDBREQSCRIPTFILE" );
+        if  (env == NULL)  {
+                strcpy( sfdbreqscriptfile, "mysql" );
+        } else {
+                if  (strlen(env) > cBcLineLth)  {
+                        fprintf( stderr, "%s: SFDBREQSCRIPTFILE too long.  Abort.\n", argv[0] );
+                        return 1;
+                } /*endif*/
+                strcpy( sfdbreqscriptfile, env );
+        } /*endif*/
+
 
         /* temporary file */
@@ -325 +338 @@
                 /*sprintf( shellcmd, "cat %s", tmpfile );*/
                 /*system( shellcmd );*/
-                sprintf( shellcmd, "sql sfdb <%s", tmpfile );
+                sprintf( shellcmd, "%s sfdb < %s", sfdbreqscriptfile, tmpfile );
                 /*printf( "--> executing %s\n", shellcmd );*/
                 system( shellcmd );