Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
> cbq -u Administrator -p password --script "select * from `travel-sample` limit 10" -q | from-json | get results.travel-sample | sort-by name
━━━━━━━━━━┯━━━━━━━━━━━━━━━┯━━━━━━┯━━━━━━┯━━━━┯━━━━━━━━━━━━━┯━━━━━━━━━
callsign │ country │ iata │ icao │ id │ name │ type
──────────┼───────────────┼──────┼──────┼────┼─────────────┼─────────
MILE-AIR │ United States │ Q5 │ MLA │ 10 │ 40-Mile Air │ airline
━━━━━━━━━━┷━━━━━━━━━━━━━━━┷━━━━━━┷━━━━━━┷━━━━┷━━━━━━━━━━━━━┷━━━━━━━━━
> cbq -u Administrator -p password --script "select * from `travel-sample` limit 10" -q | from-json | get results | get travel-sample | sort-by name
━━━┯━━━━━━━━━━━┯━━━━━━━━━━━━━━━━┯━━━━━━┯━━━━━━┯━━━━━━━┯━━━━━━━━━━━━━━━━━━━━━━━━┯━━━━━━━━━
# │ callsign │ country │ iata │ icao │ id │ name │ type
───┼───────────┼────────────────┼──────┼──────┼───────┼────────────────────────┼─────────
0 │ MILE-AIR │ United States │ Q5 │ MLA │ 10 │ 40-Mile Air │ airline
1 │ REUNION │ France │ UU │ REU │ 1191 │ Air Austral │ airline
2 │ AIRLINAIR │ France │ A5 │ RLA │ 1203 │ Airlinair │ airline
3 │ ACE AIR │ United States │ KO │ AER │ 109 │ Alaska Central Express │ airline
4 │ FLYSTAR │ United Kingdom │ 5W │ AEU │ 112 │ Astraeus │ airline
5 │ atifly │ United States │ A1 │ A1F │ 10226 │ Atifly │ airline
6 │ │ United Kingdom │ │ JRB │ 10642 │ Jc royal.britannica │ airline
7 │ LOCAIR │ United States │ ZQ │ LOC │ 10748 │ Locair │ airline
8 │ SASQUATCH │ United States │ K5 │ SQH │ 10765 │ SeaPort Airlines │ airline
9 │ TXW │ United States │ TQ │ TXW │ 10123 │ Texas Wings │ airline
━━━┷━━━━━━━━━━━┷━━━━━━━━━━━━━━━━┷━━━━━━┷━━━━━━┷━━━━━━━┷━━━━━━━━━━━━━━━━━━━━━━━━┷━━━━━━━━━
> cbq -u Administrator -p password --script "select * from `travel-sample` limit 10" -q
{
"requestID": "17b6efa4-a9f9-4949-b706-21a0d7f94610",
"signature": {
"*": "*"
},
"results": [
{
"travel-sample": {
"callsign": "MILE-AIR",
"country": "United States",
"iata": "Q5",
"icao": "MLA",
"id": 10,
"name": "40-Mile Air",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": "TXW",
"country": "United States",
"iata": "TQ",
"icao": "TXW",
"id": 10123,
"name": "Texas Wings",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": "atifly",
"country": "United States",
"iata": "A1",
"icao": "A1F",
"id": 10226,
"name": "Atifly",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": null,
"country": "United Kingdom",
"iata": null,
"icao": "JRB",
"id": 10642,
"name": "Jc royal.britannica",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": "LOCAIR",
"country": "United States",
"iata": "ZQ",
"icao": "LOC",
"id": 10748,
"name": "Locair",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": "SASQUATCH",
"country": "United States",
"iata": "K5",
"icao": "SQH",
"id": 10765,
"name": "SeaPort Airlines",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": "ACE AIR",
"country": "United States",
"iata": "KO",
"icao": "AER",
"id": 109,
"name": "Alaska Central Express",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": "FLYSTAR",
"country": "United Kingdom",
"iata": "5W",
"icao": "AEU",
"id": 112,
"name": "Astraeus",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": "REUNION",
"country": "France",
"iata": "UU",
"icao": "REU",
"id": 1191,
"name": "Air Austral",
"type": "airline"
}
},
{
"travel-sample": {
"callsign": "AIRLINAIR",
"country": "France",
"iata": "A5",
"icao": "RLA",
"id": 1203,
"name": "Airlinair",
"type": "airline"
}
}
],
"status": "success",
"metrics": {
"elapsedTime": "2.12109ms",
"executionTime": "2.034246ms",
"resultCount": 10,
"resultSize": 3002
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.