const { Pool } = require('pg');
const pool = new Pool();
const allowedSortDirections = ['ASC', 'DESC'];
async function sortByField(field, direction) {
if (!allowedSortDirections.includes(direction)) {
throw new Error(`Недопустимое направление сортировки: ${direction}. Допустимыми значениями являются: ${allowedSortDirections.join(', ')}`);
}
const result = await pool.query(`SELECT id, updated_at FROM mail_providers ORDER BY $1 ${direction}`, [field]);
return result.rows;
}
sortByField('updated_at', 'DESC')
Должно выдать ошибку на наличия поля id
interface ITestA {
id: number
name: string
}
interface ITestB {
name: string
}
const test = {
id: 1,
name: "test"
};
[{"1":"1","2":"}2"}, {"2":"2","3":"3"},{{"1":"1","2":"}2"}
const line = '1, "221,21", "dssds", 555, "dfgfdgfdg, dd"';
const row = JSON.parse(`[${line}]`);
// Array(5) [ 1, "221,21", "dssds", 555, "dfgfdgfdg, dd" ]
<button id="btn">
Start
</button>
<div id="wrapper"></div>
<br />
<canvas id="canvas" style="background:black;width:512px;height:255px;"></canvas>document.getElementById("btn").addEventListener("click", function() {
var canvas = document.getElementById('canvas');
var canvasCtx = canvas.getContext("2d");
var audioContext = new (window.AudioContext || window.webkitAudioContext)();
var player = document.getElementById('audio_player');
var analyser = audioContext.createAnalyser();
var data = new Uint8Array(analyser.frequencyBinCount);
function render() {
analyser.getByteFrequencyData(data);
canvasCtx.clearRect(0, 0, canvas.width, canvas.height);
for (var i = 0, l = data.length; i < l; i++) {
canvasCtx.fillStyle = "#ffffff";
canvasCtx.fillRect(i, -(canvas.height/255) * data[i], 1, canvas.height);
}
requestAnimationFrame(render);
}
requestAnimationFrame(render);
var audio = new Audio();
audio.loop = true;
audio.autoplay = false;
audio.crossOrigin = "anonymous";
audio.addEventListener('error', function(e) {
console.log(e);
});
audio.src = "https://greggman.github.io/doodles/sounds/DOCTOR VOX - Level Up.mp3";
//audio.play();
audio.controls = true;
document.getElementById("wrapper").append(audio);
audio.addEventListener('canplay', function() {
var audioSourceNode = audioContext.createMediaElementSource(audio);
audioSourceNode.connect(analyser);
analyser.connect(audioContext.destination);
});
});ports:
- "127.0.0.1:3306:3306"
res.setHeader('Access-Control-Allow-Origin', '*');
res.setHeader('Access-Control-Allow-Headers', 'origin, content-type, accept');
Может неправильно плагин babel подключаю.
SELECT CONCAT('[', GROUP_CONCAT(i ORDER BY i), ']') FROM t group by c;
SELECT `p`.`product_id`, `pi`.`images`, ...
FROM (
SELECT `product_id`,
GROUP_CONCAT(`image` ORDER BY `sort_order`) AS `images`
FROM `oc_product_image`
GROUP BY `product_id`
) AS `pi`
JOIN `oc_product` AS `p`
ON `p`.`product_id` = `pi`.`product_id`
AND `p`.`status` = 1
On systems with more than one mouse button, :active applies only to the primary or primary activation button (typically the "left" mouse button), and any aliases thereof.
