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
<?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 {
@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