From f237c7b95134621c0a32eda31f186c53bfcd2e46 Mon Sep 17 00:00:00 2001 From: Morgan Richomme Date: Fri, 8 Sep 2017 08:43:19 +0200 Subject: Remove VNF catalogue from releng It has been transfered to sample vnf repo [1] [1]: https://git.opnfv.org/samplevnf/tree/VNF_Catalogue Change-Id: I418151bd24517efeb66fc0ae76cb9e091bd130f6 Signed-off-by: Morgan Richomme --- utils/test/vnfcatalogue/helpers/README.md | 22 -------- utils/test/vnfcatalogue/helpers/migrate.js | 86 ------------------------------ utils/test/vnfcatalogue/helpers/schema.js | 57 -------------------- 3 files changed, 165 deletions(-) delete mode 100644 utils/test/vnfcatalogue/helpers/README.md delete mode 100644 utils/test/vnfcatalogue/helpers/migrate.js delete mode 100644 utils/test/vnfcatalogue/helpers/schema.js (limited to 'utils/test/vnfcatalogue/helpers') 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; -- cgit 1.2.3-korg