0

I've got this script

#!/bin/bash
name=test.sqlite
idx=1
while [ -e $name.$idx ]; do 
    idx=`expr $idx + 1`; 
done
while [ $idx -gt 1 ]; do 
    nidx=`expr $idx - 1`; mv $name.$nidx $name.$idx; idx=$nidx; 
done
[ ! -e $name ] || mv $name $name.1
sqlite3 test.sqlite < /path/to/db_schema.sh

and db_schema.sh

create table objects(id integer primary key autoincrement, name text, crc integer not null);
create index objects_idx on objects(crc);

create table symbols(id integer primary key autoincrement, name text, crc integer not null);
create index symbols_idx on symbols(crc);

create table provides(object_id integer not null, symbol_id integer not null);
create index provides_idx_sym on provides(symbol_id);
create index provides_idx_obj on provides(object_id);
create unique index provides_idx_key on provides(object_id, symbol_id);

create table depends(object_id integer not null, symbol_id integer not null);
create index depends_idx_sym on depends(symbol_id);
create index depends_idx_obj on depends(object_id);
create unique index depends_idx_key on depends(object_id,symbol_id);

This did work until today. What I tried so far

  1. hard-coding the path to db_schema.sh
  2. setting a variable to the file ($DB_SCHEMA_VAR)
  3. setting the path as variable but hardcoding the file ($PATH_TO_FILE/db_schema.sh)
  4. changing the folder the file is in and the three above

I also checked if the file is executable (it is), wrote a little line testing if the file is present

if [ -f db_schema.sh ] ; then .... 

before the database gets created. The test shows db_schema.sh is there, but as soon as db_schema.sh gets called, it suddenly is no longer present.

And here the log output as asked for by Barefoot IO

+ DB_INIT (this is because i call it as a function and it is not a stand-alone script)
+ cd DB_wdsfasdfg
+ name=test.sqlite
+ idx=1
+ '[' -e test.sqlite.1 ']'
+ '[' 1 -gt 1 ']'
+ '[' '!' -e test.sqlite ']'
+ sqlite3 test.sqlite
./files/functions/init_db.sh: line 22: ./files/functions/db_schema.sh: No such file or directory
3
  • What's the error? There's a few things happening on your script -- narrow it down to the problem area.
    – Jeff Schaller
    Feb 20, 2016 at 20:54
  • It would be helpful if you traced the script and shared the log: bash -x scriptfile 2> trace.log. Feb 20, 2016 at 21:16
  • gonna add this, it may take a moment
    – chris
    Feb 20, 2016 at 21:17

1 Answer 1

1

I assume that init_db.sh and db_schema.sh are in the same directory.

The combination of cd and a file name that's relative to the current working directory, ./files/functions/db_schema.sh, suggests that db_schema.sh cannot be found because the current working directory is no longer what it was at the time that ./files/functions/init_db.sh was invoked.

If the script was in the correct directory before cd DB_wdsfasdfg, then perhaps it will suffice to return to that directory, using cd -, before invoking sqlite3.

Alternatively, you can specify an absolute pathname -- a pathname beginning with a / -- which is independent of the current directory.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.