MySQL/single/sys_Random.sql · 王玮琦/APIJSON

Fetch the repository succeeded.

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 1.5K

王玮琦/APIJSON

forked from 腾讯开源/APIJSON

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (2)

Tags (63)

Manage

master

dependabot/maven/APIJSON-Java-Server/APIJSONBootOracle/com.alibaba-fastjson-1.2.25

3.9.0

3.8.6

3.7.3

3.7.1

3.7.0

3.6.5

3.6.0

3.5.7

3.5.3

3.5.0

3.4.9

3.4.5

3.4.1

3.3.0

3.2.5

3.2.0

3.1.8

3.1.7

3.1.5

3.1.1

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 2

Tags 63

APIJSON

MySQL

single

sys_Random.sql

sys_Random.sql 3.35 KB

-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
--
-- Host: apijson.cn Database: sys
-- ------------------------------------------------------
-- Server version	5.7.19-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Random`
--

DROP TABLE IF EXISTS `Random`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Random` (
 `id` bigint(15) NOT NULL COMMENT '唯一标识',
 `userId` bigint(15) NOT NULL,
 `documentId` bigint(15) NOT NULL COMMENT '测试用例 Document 的 id',
 `count` int(3) NOT NULL DEFAULT '1' COMMENT '请求次数,默认 1',
 `name` varchar(50) NOT NULL COMMENT '名称',
 `config` varchar(5000) NOT NULL COMMENT '配置',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='随机测试';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Random`
--

LOCK TABLES `Random` WRITE;
/*!40000 ALTER TABLE `Random` DISABLE KEYS */;
INSERT INTO `Random` VALUES (1575129210368,82001,1560244940013,2,'配置 1','User/id : RANDOM_IN(82001,82002,82003,70793,93793) //从这几个值随机取数\nUser/sex : RANDOM_INT(0,2) //从 0-2 随机取整数\n[]/count : RANDOM_IN(3,5,10,20,\'1\',\'s\',false,[],{}) //从这几个值随机取数\n[]/page : Math.round(10*Math.random()) //通过代码来自定义\n// []/Comment/toId : RANDOM_REAL //从数据库随机取值,替换 User/id 键值对'),(1575129533653,82001,1560244940013,5,'count 和 page','[]/count : RANDOM_IN(3,5,10,20,\'1\',\'s\',false,[],{}) //从这几个值随机取数 []/page : Math.round(10*Math.random()) //通过代码来自定义 // []/Comment/toId : RANDOM_REAL //从数据库随机取值,替换 User/id 键值对'),(1575134003381,82001,1560075285563,1,'[]/Comment/toId : RANDOM_IN(0,4,7,13,21)','[]/Comment/toId : RANDOM_IN(0,4,7,13,21) //从数据库随机取值,替换 User/id 键值对'),(1575141548694,82001,1560244940013,1,'count & page','[]/count : RANDOM_IN(3,5,10,20) //从这几个值随机取数\n[]/page : Math.round(10*Math.random()) //通过代码来自定义'),(1575141679778,82001,1560244940013,1,'随机配置 2019年12月01日 03:21','[]/count : RANDOM_IN(3,5,10) //从这几个值随机取数\n[]/page : Math.round(3*Math.random()) //通过代码来自定义');
/*!40000 ALTER TABLE `Random` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019年12月01日 23:16:14

Copy Edit Raw Blame History

TommyLemon authored 2019年12月01日 23:17 +08:00 . MySQL:更新表,新增随机配置 Random 表

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55

-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
--
-- Host: apijson.cn Database: sys
-- ------------------------------------------------------
-- Server version	5.7.19-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Random`
--

DROP TABLE IF EXISTS `Random`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Random` (
 `id` bigint(15) NOT NULL COMMENT '唯一标识',
 `userId` bigint(15) NOT NULL,
 `documentId` bigint(15) NOT NULL COMMENT '测试用例 Document 的 id',
 `count` int(3) NOT NULL DEFAULT '1' COMMENT '请求次数,默认 1',
 `name` varchar(50) NOT NULL COMMENT '名称',
 `config` varchar(5000) NOT NULL COMMENT '配置',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='随机测试';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Random`
--

LOCK TABLES `Random` WRITE;
/*!40000 ALTER TABLE `Random` DISABLE KEYS */;
INSERT INTO `Random` VALUES (1575129210368,82001,1560244940013,2,'配置 1','User/id : RANDOM_IN(82001,82002,82003,70793,93793) //从这几个值随机取数\nUser/sex : RANDOM_INT(0,2) //从 0-2 随机取整数\n[]/count : RANDOM_IN(3,5,10,20,\'1\',\'s\',false,[],{}) //从这几个值随机取数\n[]/page : Math.round(10*Math.random()) //通过代码来自定义\n// []/Comment/toId : RANDOM_REAL //从数据库随机取值,替换 User/id 键值对'),(1575129533653,82001,1560244940013,5,'count 和 page','[]/count : RANDOM_IN(3,5,10,20,\'1\',\'s\',false,[],{}) //从这几个值随机取数 []/page : Math.round(10*Math.random()) //通过代码来自定义 // []/Comment/toId : RANDOM_REAL //从数据库随机取值,替换 User/id 键值对'),(1575134003381,82001,1560075285563,1,'[]/Comment/toId : RANDOM_IN(0,4,7,13,21)','[]/Comment/toId : RANDOM_IN(0,4,7,13,21) //从数据库随机取值,替换 User/id 键值对'),(1575141548694,82001,1560244940013,1,'count & page','[]/count : RANDOM_IN(3,5,10,20) //从这几个值随机取数\n[]/page : Math.round(10*Math.random()) //通过代码来自定义'),(1575141679778,82001,1560244940013,1,'随机配置 2019年12月01日 03:21','[]/count : RANDOM_IN(3,5,10) //从这几个值随机取数\n[]/page : Math.round(3*Math.random()) //通过代码来自定义');
/*!40000 ALTER TABLE `Random` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019年12月01日 23:16:14