Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const faker = require('faker');
- const mysql = require('mysql');
- let fakeArray = [];
- let connection = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- port: '3306',
- password: 'supapassword',
- database: 'qtip'
- });
- function randomDate(start, end) {
- return new Date(start.getTime() + Math.random() * (end.getTime() - start.getTime()));
- }
- for (let i = 0; i < 1000; i++) {
- fakeArray.push(
- [
- faker.internet.email(),
- faker.name.firstName(),
- faker.name.lastName(),
- faker.phone.phoneNumber(),
- randomDate(new Date(2012, 0, 1), new Date()).getTime() / 1000
- ]
- );
- }
- let acc = '';
- let reducer = (acc, curr) => acc += `("${curr[0]}","${curr[1]}","${curr[2]}","${curr[3]}",${curr[4]}),`;
- let insertValues = fakeArray.reduce(reducer, acc).slice(0, -1);
- connection.connect();
- connection.query(`INSERT INTO customers (email, firstname, lastname, phone, regtime)
- VALUES ${insertValues}`, function (error, results, fields) {
- if (error) throw error;
- console.log(results);
- });
- connection.end();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement