[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [shell-script] Gerar JSON via Shell Script
From: |
Ultimo de Miranda |
Subject: |
Re: [shell-script] Gerar JSON via Shell Script |
Date: |
Tue, 19 May 2015 10:53:20 -0300 |
A abordagem que tomei me gerou um impasse :
como trocar a ultima virgula por "]}" ?
[root@guitar tmp]# cat blah
SYSAUX
SYSTEM
TEMP1
UNDOTBS1
USERS
[root@guitar tmp]# awk 'BEGIN{printf("%s\n","{\"data
\":")}{printf("{\"{#TABLESPACE}\":\"%s\"},\n",$1)}' blah
{"data":
{"{#TABLESPACE}":"SYSAUX"},
{"{#TABLESPACE}":"SYSTEM"},
{"{#TABLESPACE}":"TEMP1"},
{"{#TABLESPACE}":"UNDOTBS1"},
{"{#TABLESPACE}":"USERS"},
On Tue, 2015-05-19 at 06:21 -0700, address@hidden
[shell-script] wrote:
>
> Pessoal,
>
>
> Preciso gerar um resultado em formato JSON a partir de um select em
> uma base de dados Oracle.
>
>
> A parte de gerar o result set via Oracle eu toco ...
>
>
> sql = "SELECT tablespace_name FROM dba_tablespaces ORDER BY 1";
>
>
>
> SYSAUX
>
>
> SYSTEM
>
>
> TEMP1
>
>
> UNDOTBS1
>
>
> USERS
>
>
>
> A partir dos dados acima .. preciso gerar o seguinte formato ...
>
>
>
> {"data":
>
> {"{#TABLESPACE}": "SYSAUX"},
>
> {"{#TABLESPACE}": "SYSTEM"},
>
> {"{#TABLESPACE}": "TEMP1"},
>
> {"{#TABLESPACE}": "UNDOTBS1"},
>
> {"{#TABLESPACE}": "USERS"}]}
>
>
> Alguém pode me ajudar ?
>
>
> Obrigado !
>
>
>
- Gerar JSON via Shell Script, thiagozerbinato, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script, MrBiTs, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script,
Ultimo de Miranda <=
- Re: [shell-script] Gerar JSON via Shell Script, Julio C. Neves, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script, Jonathan Lessa, 2015/05/19
- Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Sidney Souza, 2015/05/19
- Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Julio C. Neves, 2015/05/19
- Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Jonathan Lessa, 2015/05/19
- Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Julio C. Neves, 2015/05/19
- Re: [Bulk] Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Sidney Souza, 2015/05/19
- Re: [Bulk] Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Julio C. Neves, 2015/05/19