TypeError: conn.query is not a function

[abubakarakram167]

I am using the custom migration with mysql-migration but it is giving me this issue.My connection configuration is already correct and working with other migrations but i am facing this issue while using custom migration.

var countries = [
    [1, 93, 'AF', 'Afghanistan'],
    [2, 358, 'AX', 'Aland Islands'],
    [3, 355, 'AL', 'Albania'],
    [4, 213, 'DZ', 'Algeria'],
    [5, 1684, 'AS', 'American Samoa'],
    [6, 376, 'AD', 'Andorra'],
    [7, 244, 'AO', 'Angola'],
    [8, 1264, 'AI', 'Anguilla'],
    [9, 672, 'AQ', 'Antarctica'],
    [10, 1268, 'AG', 'Antigua and Barbuda'],
    [11, 54, 'AR', 'Argentina'],
    [12, 374, 'AM', 'Armenia'],
    [13, 297, 'AW', 'Aruba'],
    [14, 61, 'AU', 'Australia'],
    [15, 43, 'AT', 'Austria'],
    [16, 994, 'AZ', 'Azerbaijan'],
    [17, 1242, 'BS', 'Bahamas'],
    [18, 973, 'BH', 'Bahrain'],
    [19, 880, 'BD', 'Bangladesh'],
    [20, 1246, 'BB', 'Barbados'],
    [21, 375, 'BY', 'Belarus'],
    [22, 32, 'BE', 'Belgium'],
    [23, 501, 'BZ', 'Belize'],
    [24, 229, 'BJ', 'Benin'],
    [25, 1441, 'BM', 'Bermuda'],
    [26, 975, 'BT', 'Bhutan'],
    [27, 591, 'BO', 'Bolivia'],
    [28, 599, 'BQ', 'Bonaire, Sint Eustatius and Saba'],
    [29, 387, 'BA', 'Bosnia and Herzegovina'],
    [30, 267, 'BW', 'Botswana'],
    [31, 55, 'BV', 'Bouvet Island'],
    [32, 55, 'BR', 'Brazil'],
    [33, 246, 'IO', 'British Indian Ocean Territory'],
    [34, 673, 'BN', 'Brunei Darussalam'],
    [35, 359, 'BG', 'Bulgaria'],
    [36, 226, 'BF', 'Burkina Faso'],
    [37, 257, 'BI', 'Burundi'],
    [38, 855, 'KH', 'Cambodia'],
    [39, 237, 'CM', 'Cameroon'],
    [40, 1, 'CA', 'Canada'],
    [41, 238, 'CV', 'Cape Verde'],
    [42, 1345, 'KY', 'Cayman Islands'],
    [43, 236, 'CF', 'Central African Republic'],
    [44, 235, 'TD', 'Chad'],
    [45, 56, 'CL', 'Chile'],
    [46, 86, 'CN', 'China'],
    [47, 61, 'CX', 'Christmas Island'],
    [48, 672, 'CC', 'Cocos (Keeling) Islands'],
    [49, 57, 'CO', 'Colombia'],
    [50, 269, 'KM', 'Comoros'],
    [51, 242, 'CG', 'Congo'],
    [52, 242, 'CD', 'Congo, Democratic Republic of the Congo'],
    [53, 682, 'CK', 'Cook Islands'],
    [54, 506, 'CR', 'Costa Rica'],
    [55, 225, 'CI', "Cote D'Ivoire"],
    [56, 385, 'HR', 'Croatia'],
    [57, 53, 'CU', 'Cuba'],
    [58, 599, 'CW', 'Curacao'],
    [59, 357, 'CY', 'Cyprus'],
    [60, 420, 'CZ', 'Czech Republic'],
    [61, 45, 'DK', 'Denmark'],
    [62, 253, 'DJ', 'Djibouti'],
    [63, 1767, 'DM', 'Dominica'],
    [64, 1809, 'DO', 'Dominican Republic'],
    [65, 593, 'EC', 'Ecuador'],
    [66, 20, 'EG', 'Egypt'],
    [67, 503, 'SV', 'El Salvador'],
    [68, 240, 'GQ', 'Equatorial Guinea'],
    [69, 291, 'ER', 'Eritrea'],
    [70, 372, 'EE', 'Estonia'],
    [71, 251, 'ET', 'Ethiopia'],
    [72, 500, 'FK', 'Falkland Islands (Malvinas)'],
    [73, 298, 'FO', 'Faroe Islands'],
    [74, 679, 'FJ', 'Fiji'],
    [75, 358, 'FI', 'Finland'],
    [76, 33, 'FR', 'France'],
    [77, 594, 'GF', 'French Guiana'],
    [78, 689, 'PF', 'French Polynesia'],
    [79, 262, 'TF', 'French Southern Territories'],
    [80, 241, 'GA', 'Gabon'],
    [81, 220, 'GM', 'Gambia'],
    [82, 995, 'GE', 'Georgia'],
    [83, 49, 'DE', 'Germany'],
    [84, 233, 'GH', 'Ghana'],
    [85, 350, 'GI', 'Gibraltar'],
    [86, 30, 'GR', 'Greece'],
    [87, 299, 'GL', 'Greenland'],
    [88, 1473, 'GD', 'Grenada'],
    [89, 590, 'GP', 'Guadeloupe'],
    [90, 1671, 'GU', 'Guam'],
    [91, 502, 'GT', 'Guatemala'],
    [92, 44, 'GG', 'Guernsey'],
    [93, 224, 'GN', 'Guinea'],
    [94, 245, 'GW', 'Guinea-Bissau'],
    [95, 592, 'GY', 'Guyana'],
    [96, 509, 'HT', 'Haiti'],
    [97, 0, 'HM', 'Heard Island and Mcdonald Islands'],
    [98, 39, 'VA', 'Holy See (Vatican City State)'],
    [99, 504, 'HN', 'Honduras'],
    [100, 852, 'HK', 'Hong Kong'],
    [101, 36, 'HU', 'Hungary'],
    [102, 354, 'IS', 'Iceland'],
    [103, 91, 'IN', 'India'],
    [104, 62, 'ID', 'Indonesia'],
    [105, 98, 'IR', 'Iran, Islamic Republic of'],
    [106, 964, 'IQ', 'Iraq'],
    [107, 353, 'IE', 'Ireland'],
    [108, 44, 'IM', 'Isle of Man'],
    [109, 972, 'IL', 'Israel'],
    [110, 39, 'IT', 'Italy'],
    [111, 1876, 'JM', 'Jamaica'],
    [112, 81, 'JP', 'Japan'],
    [113, 44, 'JE', 'Jersey'],
    [114, 962, 'JO', 'Jordan'],
    [115, 7, 'KZ', 'Kazakhstan'],
    [116, 254, 'KE', 'Kenya'],
    [117, 686, 'KI', 'Kiribati'],
    [118, 850, 'KP', "Korea, Democratic People's Republic of"],
    [119, 82, 'KR', 'Korea, Republic of'],
    [120, 381, 'XK', 'Kosovo'],
    [121, 965, 'KW', 'Kuwait'],
    [122, 996, 'KG', 'Kyrgyzstan'],
    [123, 856, 'LA', "Lao People's Democratic Republic"],
    [124, 371, 'LV', 'Latvia'],
    [125, 961, 'LB', 'Lebanon'],
    [126, 266, 'LS', 'Lesotho'],
    [127, 231, 'LR', 'Liberia'],
    [128, 218, 'LY', 'Libyan Arab Jamahiriya'],
    [129, 423, 'LI', 'Liechtenstein'],
    [130, 370, 'LT', 'Lithuania'],
    [131, 352, 'LU', 'Luxembourg'],
    [132, 853, 'MO', 'Macao'],
    [133, 389, 'MK', 'Macedonia, the Former Yugoslav Republic of'],
    [134, 261, 'MG', 'Madagascar'],
    [135, 265, 'MW', 'Malawi'],
    [136, 60, 'MY', 'Malaysia'],
    [137, 960, 'MV', 'Maldives'],
    [138, 223, 'ML', 'Mali'],
    [139, 356, 'MT', 'Malta'],
    [140, 692, 'MH', 'Marshall Islands'],
    [141, 596, 'MQ', 'Martinique'],
    [142, 222, 'MR', 'Mauritania'],
    [143, 230, 'MU', 'Mauritius'],
    [144, 269, 'YT', 'Mayotte'],
    [145, 52, 'MX', 'Mexico'],
    [146, 691, 'FM', 'Micronesia, Federated States of'],
    [147, 373, 'MD', 'Moldova, Republic of'],
    [148, 377, 'MC', 'Monaco'],
    [149, 976, 'MN', 'Mongolia'],
    [150, 382, 'ME', 'Montenegro'],
    [151, 1664, 'MS', 'Montserrat'],
    [152, 212, 'MA', 'Morocco'],
    [153, 258, 'MZ', 'Mozambique'],
    [154, 95, 'MM', 'Myanmar'],
    [155, 264, 'NA', 'Namibia'],
    [156, 674, 'NR', 'Nauru'],
    [157, 977, 'NP', 'Nepal'],
    [158, 31, 'NL', 'Netherlands'],
    [159, 599, 'AN', 'Netherlands Antilles'],
    [160, 687, 'NC', 'New Caledonia'],
    [161, 64, 'NZ', 'New Zealand'],
    [162, 505, 'NI', 'Nicaragua'],
    [163, 227, 'NE', 'Niger'],
    [164, 234, 'NG', 'Nigeria'],
    [165, 683, 'NU', 'Niue'],
    [166, 672, 'NF', 'Norfolk Island'],
    [167, 1670, 'MP', 'Northern Mariana Islands'],
    [168, 47, 'NO', 'Norway'],
    [169, 968, 'OM', 'Oman'],
    [170, 92, 'PK', 'Pakistan'],
    [171, 680, 'PW', 'Palau'],
    [172, 970, 'PS', 'Palestinian Territory, Occupied'],
    [173, 507, 'PA', 'Panama'],
    [174, 675, 'PG', 'Papua New Guinea'],
    [175, 595, 'PY', 'Paraguay'],
    [176, 51, 'PE', 'Peru'],
    [177, 63, 'PH', 'Philippines'],
    [178, 64, 'PN', 'Pitcairn'],
    [179, 48, 'PL', 'Poland'],
    [180, 351, 'PT', 'Portugal'],
    [181, 1787, 'PR', 'Puerto Rico'],
    [182, 974, 'QA', 'Qatar'],
    [183, 262, 'RE', 'Reunion'],
    [184, 40, 'RO', 'Romania'],
    [185, 70, 'RU', 'Russian Federation'],
    [186, 250, 'RW', 'Rwanda'],
    [187, 590, 'BL', 'Saint Barthelemy'],
    [188, 290, 'SH', 'Saint Helena'],
    [189, 1869, 'KN', 'Saint Kitts and Nevis'],
    [190, 1758, 'LC', 'Saint Lucia'],
    [191, 590, 'MF', 'Saint Martin'],
    [192, 508, 'PM', 'Saint Pierre and Miquelon'],
    [193, 1784, 'VC', 'Saint Vincent and the Grenadines'],
    [194, 684, 'WS', 'Samoa'],
    [195, 378, 'SM', 'San Marino'],
    [196, 239, 'ST', 'Sao Tome and Principe'],
    [197, 966, 'SA', 'Saudi Arabia'],
    [198, 221, 'SN', 'Senegal'],
    [199, 381, 'RS', 'Serbia'],
    [200, 381, 'CS', 'Serbia and Montenegro'],
    [201, 248, 'SC', 'Seychelles'],
    [202, 232, 'SL', 'Sierra Leone'],
    [203, 65, 'SG', 'Singapore'],
    [204, 1, 'SX', 'Sint Maarten'],
    [205, 421, 'SK', 'Slovakia'],
    [206, 386, 'SI', 'Slovenia'],
    [207, 677, 'SB', 'Solomon Islands'],
    [208, 252, 'SO', 'Somalia'],
    [209, 27, 'ZA', 'South Africa'],
    [210, 500, 'GS', 'South Georgia and the South Sandwich Islands'],
    [211, 211, 'SS', 'South Sudan'],
    [212, 34, 'ES', 'Spain'],
    [213, 94, 'LK', 'Sri Lanka'],
    [214, 249, 'SD', 'Sudan'],
    [215, 597, 'SR', 'Suriname'],
    [216, 47, 'SJ', 'Svalbard and Jan Mayen'],
    [217, 268, 'SZ', 'Swaziland'],
    [218, 46, 'SE', 'Sweden'],
    [219, 41, 'CH', 'Switzerland'],
    [220, 963, 'SY', 'Syrian Arab Republic'],
    [221, 886, 'TW', 'Taiwan, Province of China'],
    [222, 992, 'TJ', 'Tajikistan'],
    [223, 255, 'TZ', 'Tanzania, United Republic of'],
    [224, 66, 'TH', 'Thailand'],
    [225, 670, 'TL', 'Timor-Leste'],
    [226, 228, 'TG', 'Togo'],
    [227, 690, 'TK', 'Tokelau'],
    [228, 676, 'TO', 'Tonga'],
    [229, 1868, 'TT', 'Trinidad and Tobago'],
    [230, 216, 'TN', 'Tunisia'],
    [231, 90, 'TR', 'Turkey'],
    [232, 7370, 'TM', 'Turkmenistan'],
    [233, 1649, 'TC', 'Turks and Caicos Islands'],
    [234, 688, 'TV', 'Tuvalu'],
    [235, 256, 'UG', 'Uganda'],
    [236, 380, 'UA', 'Ukraine'],
    [237, 971, 'AE', 'United Arab Emirates'],
    [238, 44, 'GB', 'United Kingdom'],
    [239, 1, 'US', 'United States'],
    [240, 1, 'UM', 'United States Minor Outlying Islands'],
    [241, 598, 'UY', 'Uruguay'],
    [242, 998, 'UZ', 'Uzbekistan'],
    [243, 678, 'VU', 'Vanuatu'],
    [244, 58, 'VE', 'Venezuela'],
    [245, 84, 'VN', 'Viet Nam'],
    [246, 1284, 'VG', 'Virgin Islands, British'],
    [247, 1340, 'VI', 'Virgin Islands, U.s.'],
    [248, 681, 'WF', 'Wallis and Futuna'],
    [249, 212, 'EH', 'Western Sahara'],
    [250, 967, 'YE', 'Yemen'],
    [251, 260, 'ZM', 'Zambia'],
    [252, 263, 'ZW', 'Zimbabwe']
];

module.exports = {
    up: function (conn, cb) {
        conn.query('INSERT INTO country (id,phone_code,country_code, country_name) VALUES ?', [countries], function (
            err,
            res
        ) {
            cb();
        });
    },
    down: 'drop table country'
};