3 files changed, 0 insertions, 165 deletions
diff --git a/utils/test/vnfcatalogue/helpers/README.md b/utils/test/vnfcatalogue/helpers/README.md
deleted file mode 100644
index 6c0ca78c3..000000000
--- a/utils/test/vnfcatalogue/helpers/README.md
+++ /dev/null
@@ -1,22 +0,0 @@
-# Helper Directory
-
-## Helper to migrate database
-
-First make sure nodejs and mysql are installed. Then use
-
-```bash
-npm install bookshelf mysql knex when lodash --save
-```
-
-Create a database named **vnf_catalogue**.
-Enter the mysql credentials in migrate.js.
-
-Then use
-
-```bash
-node migrate
-```
-
-If successful the script will return success message. The current script is
-idempotent is nature, if run twice it will just return error and write nothing.
-
diff --git a/utils/test/vnfcatalogue/helpers/migrate.js b/utils/test/vnfcatalogue/helpers/migrate.js
deleted file mode 100644
index 3f4d892dc..000000000
--- a/utils/test/vnfcatalogue/helpers/migrate.js
+++ /dev/null
@@ -1,86 +0,0 @@
-/*******************************************************************************
- * Copyright (c) 2017 Kumar Rishabh(penguinRaider) and others.
- *
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Apache License, Version 2.0
- * which accompanies this distribution, and is available at
- * http://www.apache.org/licenses/LICENSE-2.0
- *******************************************************************************/
-
-var knex = require('knex')({
-    client: 'mysql',
-    connection: {
-        host     : process.env.DB_HOST,
-        user     : process.env.DB_USER,
-        password : process.env.DB_PASSWORD,
-        database : process.env.DB_DATABASE,
-        charset  : 'utf8'
-    }
-});
-var Schema = require('./schema');
-var sequence = require('when/sequence');
-var _ = require('lodash');
-function createTable(tableName) {
-    return knex.schema.createTable(tableName, function (table) {
-    var column;
-    var columnKeys = _.keys(Schema[tableName]);
-    _.each(columnKeys, function (key) {
-        if (Schema[tableName][key].type === 'text' && Schema[tableName][key].hasOwnProperty('fieldtype')) {
-        column = table[Schema[tableName][key].type](key, Schema[tableName][key].fieldtype);
-        }
-        else if (Schema[tableName][key].type === 'enum' && Schema[tableName][key].hasOwnProperty('values') && Schema[tableName][key].nullable === true) {
-        console.log(Schema[tableName][key].values);
-        column = table[Schema[tableName][key].type](key, Schema[tableName][key].values).nullable();
-        }
-        else if (Schema[tableName][key].type === 'enum' && Schema[tableName][key].hasOwnProperty('values')) {
-        console.log(Schema[tableName][key].values);
-        column = table[Schema[tableName][key].type](key, Schema[tableName][key].values).notNullable();
-        }
-        else if (Schema[tableName][key].type === 'string' && Schema[tableName][key].hasOwnProperty('maxlength')) {
-        column = table[Schema[tableName][key].type](key, Schema[tableName][key].maxlength);
-        }
-        else {
-        column = table[Schema[tableName][key].type](key);
-        }
-        if (Schema[tableName][key].hasOwnProperty('nullable') && Schema[tableName][key].nullable === true) {
-        column.nullable();
-        }
-        else {
-        column.notNullable();
-        }
-        if (Schema[tableName][key].hasOwnProperty('primary') && Schema[tableName][key].primary === true) {
-        column.primary();
-        }
-        if (Schema[tableName][key].hasOwnProperty('unique') && Schema[tableName][key].unique) {
-        column.unique();
-        }
-        if (Schema[tableName][key].hasOwnProperty('unsigned') && Schema[tableName][key].unsigned) {
-        column.unsigned();
-        }
-        if (Schema[tableName][key].hasOwnProperty('references')) {
-        column.references(Schema[tableName][key].references);
-        }
-        if (Schema[tableName][key].hasOwnProperty('defaultTo')) {
-        column.defaultTo(Schema[tableName][key].defaultTo);
-        }
-    });
-    });
-}
-function createTables () {
-    var tables = [];
-    var tableNames = _.keys(Schema);
-    tables = _.map(tableNames, function (tableName) {
-    return function () {
-        return createTable(tableName);
-    };
-    });
-    return sequence(tables);
-}
-createTables()
-.then(function() {
-    console.log('Tables created!!');
-    process.exit(0);
-})
-.catch(function (error) {
-    throw error;
-});
diff --git a/utils/test/vnfcatalogue/helpers/schema.js b/utils/test/vnfcatalogue/helpers/schema.js
deleted file mode 100644
index 4a7559ad0..000000000
--- a/utils/test/vnfcatalogue/helpers/schema.js
+++ /dev/null
@@ -1,57 +0,0 @@
-/*******************************************************************************
- * Copyright (c) 2017 Kumar Rishabh(penguinRaider) and others.
- *
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Apache License, Version 2.0
- * which accompanies this distribution, and is available at
- * http://www.apache.org/licenses/LICENSE-2.0
- *******************************************************************************/
-var Schema = {
-    photo: {
-        photo_id: {type: 'increments', nullable: false, primary: true},
-        photo_url: {type: 'string', maxlength: 254, nullable: false}
-    },
-    user: {
-        user_id: {type: 'increments', nullable: false, primary: true},
-        user_name: {type: 'string', maxlength: 254, nullable: false},
-        password: {type: 'string', maxlength: 150, nullable: false},
-        email_id: {type: 'string', maxlength: 254, nullable: false, unique: true, validations: {isEmail: true}},
-        photo_id: {type: 'integer', nullable: true, unsigned: true, references: 'photo.photo_id'},
-        company: {type: 'string', maxlength: 254, nullable: false},
-        introduction: {type: 'string', maxlength: 510, nullable: false},
-        last_login: {type: 'dateTime', nullable: true},
-        created_at: {type: 'dateTime', nullable: false},
-    },
-    vnf: {
-        vnf_id: {type: 'increments', nullable: false, primary: true},
-        vnf_name: {type: 'string', maxlength: 254, nullable: false},
-        repo_url: {type: 'string', maxlength: 254, nullable: false},
-        photo_id: {type: 'integer', nullable: true, unsigned: true, references: 'photo.photo_id'},
-        submitter_id: {type: 'integer', nullable: false, unsigned: true, references: 'user.user_id'},
-        lines_of_code: {type: 'integer', nullable: true, unsigned: true},
-        versions: {type: 'integer', nullable: true, unsigned: true},
-        no_of_developers: {type: 'integer', nullable: true, unsigned: true},
-        no_of_stars: {type: 'integer', nullable: true, unsigned: true},
-        license: {type: 'enum', nullable: false, values: ['MIT', 'GPL', 'GPL_V2', 'BSD', 'APACHE']},
-        opnfv_indicator: {type: 'enum', nullable: false, values: ['gold', 'silver', 'platinum']},
-        complexity: {type: 'enum', nullable: true, values: ['low', 'medium', 'high']},
-        activity: {type: 'enum', nullable: true, values: ['low', 'medium', 'high']},
-        last_updated: {type: 'dateTime', nullable: true},
-    },
-    tag: {
-        tag_id: {type: 'increments', nullable: false, primary: true},
-        tag_name: {type: 'string', maxlength: 150, nullable: false}
-    },
-    vnf_tags: {
-        vnf_tag_id: {type: 'increments', nullable: false, primary: true},
-        tag_id: {type: 'integer', nullable: false, unsigned: true, references: 'tag.tag_id'},
-        vnf_id: {type: 'integer', nullable: false, unsigned: true, references: 'vnf.vnf_id'},
-    },
-    vnf_contributors: {
-        vnf_contributors_id: {type: 'increments', nullable: false, primary: true},
-        user_id: {type: 'integer', nullable: false, unsigned: true, references: 'user.user_id'},
-        vnf_id: {type: 'integer', nullable: false, unsigned: true, references: 'vnf.vnf_id'},
-        created_at: {type: 'dateTime', nullable: false},
-    }
-};
-module.exports = Schema;