Skip to content

Instantly share code, notes, and snippets.

CREATE OR REPLACE FUNCTION public.get_data_jsonb(prod_t product_template)
RETURNS jsonb
LANGUAGE sql
STABLE
AS $function$
SELECT convert_from(prod_t.data, 'UTF-8')::jsonb
$function$
@4t4nner
4t4nner / dynamicClassImport.ts
Created October 19, 2022 03:32
dynamic class import definition in typescrypt
import type Test1 from './Test1' // export default class
import type Test2 from './Test2' // export default class
type TValueOf<T> = T[keyof T]
type ClassRecord = {
Test1: typeof Test1
Test2: typeof Test2
}
type ClassInstanceRecord = {
@4t4nner
4t4nner / js_fetch_non-utf-8_response.js
Created September 19, 2022 06:30
js: fetch with non-utf-8 response
function transformWindows1251ToUTF8(response) {
const transformedBody = response.body
.pipeThrough(new TextDecoderStream("windows-1251"))
.pipeThrough(new TextEncoderStream("utf-8"));
return new Response(transformedBody);
}
fetch('https://vk.com/al_im.php', {
credentials: 'include',
method: 'POST',
@4t4nner
4t4nner / getServerSideProps_vs_getServerSideProps.tsx
Created March 17, 2021 09:15
getServerSideProps vs getServerSideProps
import React, {FunctionComponent} from "react";
import MainLayout from "../components/layouts/MainLayout";
import {IComponentProps} from "../components/declarations";
import { GetStaticProps, GetServerSideProps } from 'next'
import {randomInt} from "crypto";
export default function Login({children, rand}: IComponentProps) {
console.log(arguments,rand);
return (
<>
@4t4nner
4t4nner / Validator.php
Created August 14, 2019 03:39
unknown property error
<?php
/**
* @link http://www.yiiframework.com/
* @copyright Copyright (c) 2008 Yii Software LLC
* @license http://www.yiiframework.com/license/
*/
namespace yii\validators;
use Yii;
@4t4nner
4t4nner / composer.json
Created August 14, 2019 03:30
unknown property error
{
"name": "yiisoft/yii2-app-advanced",
"description": "Yii 2 Advanced Project Template",
"keywords": ["yii2", "framework", "advanced", "project template"],
"homepage": "http://www.yiiframework.com/",
"type": "project",
"license": "BSD-3-Clause",
"support": {
"issues": "https://github.com/yiisoft/yii2/issues?state=open",
"forum": "http://www.yiiframework.com/forum/",
@4t4nner
4t4nner / NewsSearch.php
Created August 14, 2019 03:30
unknown property error
<?php
namespace common\modules\news\models;
use Yii;
use yii\base\Model;
use yii\data\ActiveDataProvider;
/**
* NewsSearch represents the model behind the search form of `common\modules\news\models\News`.
@4t4nner
4t4nner / News.php
Created August 14, 2019 03:29
unknown property error
<?php
namespace common\modules\news\models;
use common\modules\backend\components\behaviors\UploadImageBehavior;
use himiklab\sortablegrid\SortableGridBehavior;
use Yii;
use common\modules\user\models\User;
use common\modules\category\models\Category;
use yii\behaviors\TimestampBehavior;
@4t4nner
4t4nner / bitrix_d7_multi_update.php
Last active March 26, 2019 05:29
bitrix d7 multi update
<?php
use Bitrix\Main;
use Proj\EventEmitter;
use Proj\Utils\Log;
class DataManager extends Main\Entity\DataManager {
/**
*
* send onAfterBeforeEvent