Skip to content

Instantly share code, notes, and snippets.

@jasir
jasir / save_restore_dependencies.sql
Last active January 6, 2021 10:52 — forked from mateuszwenus/save_restore_dependencies.sql
PostgreSQL: How to handle table and view dependencies
create table deps_saved_ddl (
deps_id serial primary key,
deps_view_schema varchar(255),
deps_view_name varchar(255),
deps_ddl_to_run text
);
create or replace function deps_save_and_drop_dependencies(p_view_schema varchar, p_view_name varchar) returns void as
$$
declare
@jasir
jasir / machine.js
Last active May 6, 2020 04:07
Generated by XState Viz: https://xstate.js.org/viz
// Available variables:
// - Machine
// - interpret
// - assign
// - send
// - sendParent
// - spawn
// - raise
// - actions
import { BaseModel } from './BaseModel'
import Dvere from './Dvere'
import KategoriePristupu from './KategoriePristupu'
import Osoba from './Osoba'
import PristupovyBod from './PristupovyBod'
export default class Log extends BaseModel {
// This is the name used as module name of the Vuex Store.
static entity = 'Log'
<?php
use LeanMapper\IMapper;
class SchemaGenerator
{
private $mapper;
$schemaGenerator = new SchemaGenerator(...);
$platform = new Doctrine\DBAL\Platforms\MySqlPlatform();
$schema = $schemaGenerator->createSchema(...);
$sqls = [];
if (file_exists(__DIR__ . '/schema.log')) {
$fromSchema = unserialize(file_get_contents(__DIR__ . '/schema.log'));
$sqls = $schema->getMigrateFromSql($fromSchema, $platform);
} else {
We couldn’t find that file to show.
@jasir
jasir / gist:3645037
Created September 5, 2012 21:23 — forked from dg/gist:3644321
Texy on nette.org
<?php
/**
* Texy parser for wiki page.
*/
class Parser extends Nette\Object
{
/**
* @return void