You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
#!/bin/bash
|
|
|
|
cd # write directory for sqlitedb file
|
|
DATABASE=$( ls -t *_apc-metric.db | head -1 )
|
|
du -sh $DATABASE
|
|
|
|
sqlreadtable(){
|
|
cat << FEO | sqlite3 $DATABASE
|
|
.timeout 2000
|
|
SELECT * FROM ( \
|
|
SELECT * FROM mainmetric0 \
|
|
ORDER BY id DESC LIMIT 10 )\
|
|
ORDER BY id ;
|
|
FEO
|
|
}
|
|
|
|
sqlreadtable
|
|
|
|
|
