int main(int argc, const char** argv){
ndb_init();
int _temp = false;
int _help = 0;
int _all = 0;
int _print = 0;
const char* _connectstr = NULL;
int _diskbased = 0;
const char* _tsname = NULL;
int _trans = false;
struct getargs args[] = {
{ "all", 'a', arg_flag, &_all, "Create/print all tables", 0 },
{ "print", 'p', arg_flag, &_print, "Print table(s) instead of creating it", 0},
{ "temp", 't', arg_flag, &_temp, "Temporary table", 0 },
{ "trans", 'x', arg_flag, &_trans, "Use single schema trans", 0 },
{ "connstr", 'c', arg_string, &_connectstr, "Connect string", "cs" },
{ "diskbased", 0, arg_flag, &_diskbased, "Store attrs on disk if possible", 0 },
{ "tsname", 0, arg_string, &_tsname, "Tablespace name", "ts" },
{ "usage", '?', arg_flag, &_help, "Print help", "" }
};
int num_args = sizeof(args) / sizeof(args[0]);
int optind = 0;
char desc[] =
"tabname\n"\
"This program will create one table in Ndb.\n"\
"The tables may be selected from a fixed list of tables\n"\
"defined in NDBT_Tables class\n";
if(getarg(args, num_args, argc, argv, &optind) || _help){
arg_printusage(args, num_args, argv[0], desc);
return NDBT_ProgramExit(NDBT_WRONGARGS);
}
if(argv[optind] == NULL && !_all){
arg_printusage(args, num_args, argv[0], desc);
return NDBT_ProgramExit(NDBT_WRONGARGS);
}
g_diskbased = _diskbased;
g_tsname = _tsname;
int res = 0;
if(_print){
/**
* Print instead of creating
*/
if(optind < argc){
for(int i = optind; i<argc; i++){
NDBT_Tables::print(argv[i]);
}
} else {
NDBT_Tables::printAll();
}
} else {
/**
* Creating
*/
// Connect to Ndb
Ndb_cluster_connection con(_connectstr);
if(con.connect(12, 5, 1) != 0)
{
return NDBT_ProgramExit(NDBT_FAILED);
}
Ndb MyNdb(&con, "TEST_DB" );
if(MyNdb.init() != 0){
ERR(MyNdb.getNdbError());
return NDBT_ProgramExit(NDBT_FAILED);
}
while(MyNdb.waitUntilReady() != 0)
ndbout << "Waiting for ndb to become ready..." << endl;
NdbDictionary::Dictionary* MyDic = MyNdb.getDictionary();
if (_trans) {
if (MyDic->beginSchemaTrans() == -1) {
ERR(MyDic->getNdbError());
return NDBT_ProgramExit(NDBT_FAILED);
}
}
if(_all){
res = NDBT_Tables::createAllTables(&MyNdb, _temp);
} else {
int tmp;
for(int i = optind; i<argc; i++){
ndbout << "Trying to create " << argv[i] << endl;
if((tmp = NDBT_Tables::createTable(&MyNdb, argv[i], _temp, false,
g_create_hook)) != 0)
res = tmp;
}
}
if (_trans) {
if (MyDic->endSchemaTrans() == -1) {
ERR(MyDic->getNdbError());
return NDBT_ProgramExit(NDBT_FAILED);
}
}
}
if(res != 0)
return NDBT_ProgramExit(NDBT_FAILED);
else
return NDBT_ProgramExit(NDBT_OK);
}
int main(int argc, const char** argv){
ndb_init();
int _help = 0;
int _p = 0;
const char * db = "TEST_DB";
const char* _connectstr = NULL;
struct getargs args[] = {
{ "database", 'd', arg_string, &db, "database", 0 },
{ "connstr", 'c', arg_string, &_connectstr, "Connect string", "cs" },
{ "partitions", 'p', arg_integer, &_p, "New no of partitions", 0},
{ "usage", '?', arg_flag, &_help, "Print help", "" }
};
int num_args = sizeof(args) / sizeof(args[0]);
int optind = 0;
char desc[] =
"tabname\n" \
"This program will alter no of partitions of table in Ndb.\n";
if(getarg(args, num_args, argc, argv, &optind) || _help){
arg_printusage(args, num_args, argv[0], desc);
return NDBT_ProgramExit(NDBT_WRONGARGS);
}
if(argv[optind] == NULL)
{
arg_printusage(args, num_args, argv[0], desc);
return NDBT_ProgramExit(NDBT_WRONGARGS);
}
// Connect to Ndb
Ndb_cluster_connection con(_connectstr);
if(con.connect(12, 5, 1) != 0)
{
return NDBT_ProgramExit(NDBT_FAILED);
}
Ndb MyNdb(&con, db );
if(MyNdb.init() != 0){
ERR(MyNdb.getNdbError());
return NDBT_ProgramExit(NDBT_FAILED);
}
while(MyNdb.waitUntilReady() != 0)
ndbout << "Waiting for ndb to become ready..." << endl;
NdbDictionary::Dictionary* MyDic = MyNdb.getDictionary();
for (int i = optind; i<argc; i++)
{
printf("altering %s/%s...", db, argv[i]);
const NdbDictionary::Table* oldTable = MyDic->getTable(argv[i]);
if (oldTable == 0)
{
ndbout << "Failed to retrieve table " << argv[i]
<< ": " << MyDic->getNdbError() << endl;
return NDBT_ProgramExit(NDBT_FAILED);
}
NdbDictionary::Table newTable = *oldTable;
newTable.setFragmentCount(_p);
if (MyDic->beginSchemaTrans() != 0)
goto err;
if (MyDic->prepareHashMap(*oldTable, newTable) != 0)
goto err;
if (MyDic->alterTable(*oldTable, newTable) != 0)
goto err;
if (MyDic->endSchemaTrans())
goto err;
ndbout_c("done");
}
return NDBT_ProgramExit(NDBT_OK);
err:
NdbError err = MyDic->getNdbError();
if (MyDic->hasSchemaTrans())
MyDic->endSchemaTrans(NdbDictionary::Dictionary::SchemaTransAbort);
ndbout << "Failed! "
<< err << endl;
return NDBT_ProgramExit(NDBT_FAILED);
}