techandstream

There are plenty of great data mocking libraries available for almost every language and platform. But not everyone is a programmer or has time to learn a new framework. Mockaroo allows you to quickly and easily to download large amounts of randomly generated test data based on your own specs which you can then load directly into your test environment using SQL or CSV formats. No programming is required.

<button onclick="ajouterLigne()">Ajouter un mec</button>

<script>

// ... le reste du script d'avant

function ajouterLigne() {

const tbody = document.querySelector("#myTable tbody");

const id = tbody.children.length + 1;

const name = prompt("Nom ?");

const age = prompt("Âge ?");

const city = prompt("Ville ?");

if (name && age && city) { // juste un petit check

const row = document.createElement("tr");

row.innerHTML = `<td>${id}</td><td>${name}</td><td>${age}</td><td>${city}</td>`;

tbody.appendChild(row);

}

}

</script>

RANK() OVER (ORDER BY gasto_total DESC) AS position

\copy (

SELECT u.nom, u.age, c.produit, c.precio

FROM usuarios u

LEFT JOIN commandes c ON u.id = c.usuario_id

) TO 'rapport_complet.csv' CSV HEADER;

\copy (SELECT * FROM commandes) TO 'commandes_export.csv' CSV HEADER;