#include <iostream>
#include <limits>

#include "../shared/DatabaseWithRetry.h"
#include "../shared/GlobalConfigFile.h"
#include "NfsHelper.h"


/* This is a tool for migrating data from the mysql database to the filesystem.
 * This goes with MiscNFS.[Ch].  This will only be used in the transition.
 * After that we will remove the layout column from the cloud_layout table,
 * so this program won't even run correctly after that.
 */

using namespace NfsHelper;

int main(int argc, char **argv)
{
  addConfigItemsFromFile("../../live_server/config_common.txt");
  if (!addConfigItemsFromCommandLine(argv + 1))
  {   
    return 1;
  }
  configItemsComplete();

  int64_t strategyId = getConfigItem("start_after", 0);
  std::cout<<"start_after="<<strategyId<<std::endl;
  const int64_t NO_LIMIT = std::numeric_limits< int64_t >::max();
  const int64_t maxCount = getConfigItem("max_count", NO_LIMIT);
  std::cout<<"max_count=";
  if (maxCount == NO_LIMIT)
    std::cout<<"NO_LIMIT";
  else
    std::cout<<maxCount;
  std::cout<<std::endl;

  DatabaseWithRetry database("wally-balls", "database");
  for (int64_t count = 0; count < maxCount; count++)
  {
    std::string sql =
      "SELECT strategy_id,layout FROM cloud_layout WHERE strategy_id>"
      + ntoa(strategyId) + " ORDER BY strategy_id ASC LIMIT 1";
    MysqlResultRef result = database.tryQueryUntilSuccess(sql);
    if (!result->rowIsValid()) break;
    strategyId = result->getIntegerField(0, 0);
    std::cout<<count<<":  "<<pathForFile(strategyId)<<std::endl;
    TclList errorMessage = saveToDisk(strategyId, result->getStringField(1));
    if (!errorMessage.empty())
    {
      std::cout<<"unable to create file:  "<<(std::string)errorMessage
	       <<std::endl;
      break;
    }
  }
}