CJPPsz87

1DROP TABLE IF EXISTS `qalnk`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `qalnk` (
5  `id` bigint(20) NOT NULL,
6  `answer_id` bigint(20) DEFAULT NULL,
7  `date_deleted` bigint(20) DEFAULT NULL,
8  `deleted_by_user_ap_id` varchar(36) DEFAULT NULL,
9  `expression_id` bigint(20) DEFAULT NULL,
10  `expression_type` varchar(255) DEFAULT NULL,
11  `ordering` int(11) DEFAULT NULL,
12  `question_id` bigint(20) DEFAULT NULL,
13  `expression_for_deselect_id` bigint(20) DEFAULT NULL,
14  PRIMARY KEY (`id`),
15  KEY `FK6661B19F393DFCD` (`expression_id`),
16  KEY `FK6661B195182DDCD` (`question_id`),
17  KEY `FK6661B195742A56B` (`expression_for_deselect_id`),
18  KEY `idx_qlnk_nswrd` (`answer_id`),
19  KEY `FK6661B19126D878D` (`answer_id`),
20  KEY `FK6661B1975B33071` (`id`),
21  CONSTRAINT `FK6661B19126D878D` FOREIGN KEY (`answer_id`) REFERENCES `ans` (`id`),
22  CONSTRAINT `FK6661B1975B33071` FOREIGN KEY (`id`) REFERENCES `apobj` (`id`)
23) ENGINE=InnoDB DEFAULT CHARSET=latin1;
24/*!40101 SET character_set_client = @saved_cs_client */;
25	
26sed '/s*CONSTRAINT/d' ~/Downloads/dump.sql > ~/ouput.sql
27	
28DROP TABLE IF EXISTS `qalnk`;
29/*!40101 SET @saved_cs_client     = @@character_set_client */;
30/*!40101 SET character_set_client = utf8 */;
31CREATE TABLE `qalnk` (
32  `id` bigint(20) NOT NULL,
33  `answer_id` bigint(20) DEFAULT NULL,
34  `date_deleted` bigint(20) DEFAULT NULL,
35  `deleted_by_user_ap_id` varchar(36) DEFAULT NULL,
36  `expression_id` bigint(20) DEFAULT NULL,
37  `expression_type` varchar(255) DEFAULT NULL,
38  `ordering` int(11) DEFAULT NULL,
39  `question_id` bigint(20) DEFAULT NULL,
40  `expression_for_deselect_id` bigint(20) DEFAULT NULL,
41  PRIMARY KEY (`id`),
42  KEY `FK6661B19F393DFCD` (`expression_id`),
43  KEY `FK6661B195182DDCD` (`question_id`),
44  KEY `FK6661B195742A56B` (`expression_for_deselect_id`),
45  KEY `idx_qlnk_nswrd` (`answer_id`),
46  KEY `FK6661B19126D878D` (`answer_id`),
47  KEY `FK6661B1975B33071` (`id`)
48) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49/*!40101 SET character_set_client = @saved_cs_client */;
50	
51$ awk -v RS='^$' -v ORS= '{gsub(/,s*CONSTRAINT[^n,]+/,"")}1' file
52DROP TABLE IF EXISTS `qalnk`;
53/*!40101 SET @saved_cs_client     = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `qalnk` (
56  `id` bigint(20) NOT NULL,
57  `answer_id` bigint(20) DEFAULT NULL,
58  `date_deleted` bigint(20) DEFAULT NULL,
59  `deleted_by_user_ap_id` varchar(36) DEFAULT NULL,
60  `expression_id` bigint(20) DEFAULT NULL,
61  `expression_type` varchar(255) DEFAULT NULL,
62  `ordering` int(11) DEFAULT NULL,
63  `question_id` bigint(20) DEFAULT NULL,
64  `expression_for_deselect_id` bigint(20) DEFAULT NULL,
65  PRIMARY KEY (`id`),
66  KEY `FK6661B19F393DFCD` (`expression_id`),
67  KEY `FK6661B195182DDCD` (`question_id`),
68  KEY `FK6661B195742A56B` (`expression_for_deselect_id`),
69  KEY `idx_qlnk_nswrd` (`answer_id`),
70  KEY `FK6661B19126D878D` (`answer_id`),
71  KEY `FK6661B1975B33071` (`id`)
72) ENGINE=InnoDB DEFAULT CHARSET=latin1;
73/*!40101 SET character_set_client = @saved_cs_client */;
74	
75awk -v RS=$(printf '3') -v ORS= '{gsub(/,[[:space:]]*CONSTRAINT[^n,]+/,"")}1'
76	
77awk -v RS= '{gsub(/,n/, "n,"); print}'  ~/Downloads/dump.sql | 
78sed '/s*CONSTRAINT/d' > ~/ouput.sql
79	
80DROP TABLE IF EXISTS `qalnk`;
81/*!40101 SET @saved_cs_client     = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `qalnk` (
84  `id` bigint(20) NOT NULL
85,  `answer_id` bigint(20) DEFAULT NULL
86,  `date_deleted` bigint(20) DEFAULT NULL
87,  `deleted_by_user_ap_id` varchar(36) DEFAULT NULL
88,  `expression_id` bigint(20) DEFAULT NULL
89,  `expression_type` varchar(255) DEFAULT NULL
90,  `ordering` int(11) DEFAULT NULL
91,  `question_id` bigint(20) DEFAULT NULL
92,  `expression_for_deselect_id` bigint(20) DEFAULT NULL
93,  PRIMARY KEY (`id`)
94,  KEY `FK6661B19F393DFCD` (`expression_id`)
95,  KEY `FK6661B195182DDCD` (`question_id`)
96,  KEY `FK6661B195742A56B` (`expression_for_deselect_id`)
97,  KEY `idx_qlnk_nswrd` (`answer_id`)
98,  KEY `FK6661B19126D878D` (`answer_id`)
99,  KEY `FK6661B1975B33071` (`id`)
100) ENGINE=InnoDB DEFAULT CHARSET=latin1;
101/*!40101 SET character_set_client = @saved_cs_client */;
102	
103sed -e '/.*/{
104N
105s/,n.*CONSTRAINT//g}' -e '/.*CONSTRAINT.*/d' my_file
106	
107sed -zr 's/,ns*CONSTRAINTs+[^n,]+//g' file
108	
109sed -E ':a
110$!{N;ba
111}
112s/,n([[:blank:]]*CONSTRAINT[[:blank:]]+[[:print:][:blank:]]+n)+/
113/g' file