/* edwUndeprecate - Undeprecate a list of file accessions.. */
#include "common.h"
#include "linefile.h"
#include "hash.h"
#include "options.h"
#include "encodeDataWarehouse.h"
#include "edwLib.h"
#include "obscure.h"

void usage()
/* Explain usage and exit. */
{
errAbort(
  "edwUndeprecate - Undeprecate a list of file accessions.\n"
  "usage:\n"
  "   edwUndeprecate accessions.txt\n"
  "where accessions.txt is a list of ENCFF accessions separated by spaces and or new lines.\n"
  );
}

/* Command line validation table. */
static struct optionSpec options[] = {
   {NULL, 0},
};

void edwUndeprecate(char *fileName)
/* edwUndeprecate - Undeprecate a list of file accessions.. */
{
char **words, *buf;
int wordCount;
readAllWords(fileName, &words, &wordCount, &buf);
verbose(1, "Read %d accessions from %s\n", wordCount, fileName);

struct sqlConnection *conn = edwConnectReadWrite();
int i;
for (i=0; i<wordCount; ++i)
    {
    char query[512];
    sqlSafef(query, sizeof(query), "select * from edwValidFile where licensePlate='%s'", words[i]);
    struct edwValidFile *vf = edwValidFileLoadByQuery(conn, query);
    if (vf == NULL)
       errAbort("%s doesn't exist in edwValidFile table", words[i]);
    sqlSafef(query, sizeof(query), "update edwFile set deprecated='' where id=%u", vf->fileId);
    sqlUpdate(conn, query);
    }
verbose(1, "Undeprecated %d files\n", i);
}

int main(int argc, char *argv[])
/* Process command line. */
{
optionInit(&argc, argv, options);
if (argc != 2)
    usage();
edwUndeprecate(argv[1]);
return 0;
}