samsonasik

namespace Application\Migration;

use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160704163301 extends AbstractMigration

samsonasik

{
    "require": {
        "guzzlehttp/guzzle": "4.*"
    }
}

samsonasik

IF (NOT EXISTS(SELECT * FROM QSYS2.SYSTABLES WHERE TABLE_SCHEMA = 'BACKUP' AND TABLE_NAME='MYTABLE')) THEN
    CREATE TABLE BACKUP.MYTABLE 
    AS (SELECT * FROM MYLIB.MYTABLE)
    WITH DATA;
ELSE
    INSERT INTO BACKUP.MYTABLE 
        SELECT * FROM MYLIB.MYTABLE;
END IF;

samsonasik

Verifying that +samsonasik is my blockchain ID. https://onename.com/samsonasik

samsonasik

-- CREATE EXTENSION "uuid-ossp";

--insert into album(id, artist, title) --values((select uuid_generate_v4()), 'Foo', 'Foox');

-- for example: on this case, uuid generate return: f316f033-87a8-450e-a4df-94ac6e32f87d

insert into album(id, artist, title) values('f316f033-87a8-450e-a4df-94ac6e32f87d', 'Foo', 'Foo2') ON CONFLICT(id) DO UPDATE SET title=excluded.title;

samsonasik

class Foo
{
    private function bar($languageId)
    {
        // like http call...
        
        // some heavy task
    }
 

samsonasik

<phpunit bootstrap="Bootstrap.php" colors="true">
    <testsuite name="MyTest" >
        <directory>./MyModuleTest</directory>
    </testsuite>
    <filter>
        <whitelist>
            <directory>./../../../../module/MyModule/src</directory>
            <file>./../../../../module/MyModule/Module.php</file>
        </whitelist>
        <blacklist>

samsonasik

config
  autoload
data
  cache
module
    Application
public_html
     js
 css

samsonasik

CREATE OR REPLACE FUNCTION public.json_append(data json, insert_data json)
RETURNS json
IMMUTABLE
LANGUAGE sql
AS $$
    SELECT ('{'||string_agg(to_json(key)||':'||value, ',')||'}')::json
    FROM (
        SELECT * FROM json_each(data)
        UNION ALL
        SELECT * FROM json_each(insert_data)

samsonasik

<?php
/**
 * @author Marco Pivetta <[email protected]>
 */

use Zend\ServiceManager\ServiceManager;
use Zend\Mvc\Service\ServiceManagerConfig;
use DoctrineORMModuleTest\Framework\TestCase;
use ContentTest\Util\ServiceManagerFactory;
use Zend\Loader\StandardAutoloader;