def METHOD_NAME(connection: MagicMock, sql_writer: FireboltSQLWriter) -> None:
    sql_writer.flush_interval = 2
    sql_writer.queue_write_data("dummy", "id1", 20200101, '{"key": "value"}')
    connection.cursor.return_value.executemany.assert_not_called()
    assert sql_writer._values == 1
    sql_writer.queue_write_data("dummy", "id1", 20200101, '{"key": "value"}')
    connection.cursor.return_value.executemany.assert_called_once()
    assert len(sql_writer._buffer.keys()) == 0
    assert sql_writer._values == 0
    sql_writer.queue_write_data("dummy", "id1", 20200101, '{"key": "value"}')
    assert len(sql_writer._buffer.keys()) == 1