уторак, 24. април 2018.

Promena naziva kolona i tabela u postgres sa velikim slovima

Da bi se izbeglo stalno navođenje kolona i tabela poput:
select "ID", "Glupava_kolona" form public."GlupavaTabela" ;
Kolone:
SELECT  'ALTER TABLE ' || quote_ident(c.table_schema) || '.'
  || quote_ident(c.table_name) || ' RENAME "' || c.column_name || '" TO ' || quote_ident(lower(c.column_name)) || ';' As ddlsql
  FROM information_schema.columns As c
  WHERE c.table_schema IN('public')
      AND c.column_name <> lower(c.column_name)
  ORDER BY c.table_schema, c.table_name, c.column_name;

Tabele:

SELECT 'ALTER TABLE ' || quote_ident(t.table_schema) || '.'
  || quote_ident(t.table_name) || ' RENAME TO ' || quote_ident(lower(t.table_name)) || ';' As ddlsql
  FROM information_schema.tables As t
  WHERE t.table_schema NOT IN('information_schema', 'pg_catalog') 
      AND t.table_name <> lower(t.table_name) 
  ORDER BY t.table_schema, t.table_name;


уторак, 17. април 2018.

Yii2 prikaz slike iz tabele baze u DetailView

Ukoliko je u tabeli baze sačuvana slika u base64 formatu onda se može lako prikazati u DetailView klasi na sledeći način:
...
            [
                'label' => 'Image',
                'value' => Html::img("data:image/png;base64,". $model->image, ['width' => 200, 'alt' => 'no image']),
                'format' => 'raw'
            ],

...