This code snippet is a unit test that verifies the functionality of a function responsible for adding a new row of data to a specified Google Sheet. It asserts that the function successfully adds a row by checking if a row is returned after the function is called.

Run example

npm run import -- "test google sheet add row"

test google sheet add row

var assert = require('assert');
var importer = require('../Core');
var addRow = importer.import("add row data google sheet");

var docsId = '16b1Z0sQkYhtMUfP7qMRL3vRBPWQsRbSlntURkMqWGX0';

describe('add row data to google sheet', () => {
    
    it('should add a row', () => {
        return addRow(docsId, {
            timestamp: Date.now(),
            name: 'Test Name',
            email: 'test@test.com',
            subject: 'This is a test subject',
            message: 'This is a new message',
            responded: 0
        })
            .then(rows => {
                assert(typeof rows != 'undefined', 'should have added a row to the sheet');
            })
    })
    
    
})

// Import required modules
const { assert } = require('assert');
const Core = require('../Core');
const { addRowDataGoogleSheet } = require('../Core/importers');

describe('add row data to google sheet', () => {
    const docsId = '16b1Z0sQkYhtMUfP7qMRL3vRBPWQsRbSlntURkMqWGX0';

    it('should add a row', () => {
        // Create sample data
        const rowData = {
            timestamp: Date.now(),
            name: 'Test Name',
            email: 'test@test.com',
            subject: 'This is a test subject',
            message: 'This is a new message',
            responded: 0
        };

        // Call the addRow function
        return addRowDataGoogleSheet(docsId, rowData)
           .then(rows => {
                // Assert that a row was added
                assert(rows!== undefined,'should have added a row to the sheet');
            })
           .catch(error => {
                // Log any errors
                console.error('Error adding row:', error);
            });
    });
});

This code snippet is a unit test for a function that adds a new row of data to a Google Sheet.

Here's a breakdown:

1. Setup:

   • It imports the assert module for making assertions (checking if conditions are true) and the addRow function from a local file (../Core).
   • It defines the docsId which is the ID of the Google Sheet to modify.

2. Test Case:

   • It uses describe to group related tests under the heading "add row data to google sheet".
   • Inside, it defines a specific test case: "should add a row".
   • The test calls the addRow function with the docsId and a sample row of data.

3. Assertion:

   • The then block after the addRow call checks if the returned rows value is not undefined, asserting that a row was successfully added.