Name

Dump AltSQL Plugin

Synopsis

Usage:

            

              
              
.dump <file>.[csv|html|json|pl|pm|sql|xls|xml|yaml|yml] <query>;
            
          

Description

This plugin will allow you to dump out results from a sql query into one of many data formats.

Examples

Given:

            

              
              
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
);
            
          

CSV:

            

              
              
.dump out.csv select * from users;
            
          

out.csv:

            

              
              
"id","name"
"1","Moo"
"2","Pie"
"3","Cow"
            
          

HTML:

            

              
              
.dump out.html select * from users;
            
          

out.html:

id	name
1	Moo
2	Pie
3	Cow

JSON:

            

              
              
.dump out.json select * from users;
            
          

out.json:

            

              
              
[{"name":"Moo","id":"1"},{"name":"Pie","id":"2"},{"name":"Cow","id":"3"}]
            
          

PERL:

            

              
              
.dump out.[pl|pm] select * from users;
            
          

out.[pl|pm]:

            

              
              
$VAR1 = [
  {
    'id' => '1',
    'name' => 'Moo'
  },
  {
    'id' => '2',
    'name' => 'Pie'
  },
  {
    'id' => '3',
    'name' => 'Cow'
  },
];
            
          

SQL:

            

              
              
.dump out.sql select * from users;
            
          

out.sql:

            

              
              
INSERT INTO table (`id`,`name`) VALUES('1','Moo'),('2','Pie'),('3','Cow');
            
          

XLS:

            

              
              
.dump out.xls select * from users;
            
          

out.xls:

            

              
              
You just get a excel spreadsheet...
            
          

XML:

            

              
              
.dump out.xml select * from users;
            
          

out.xml:

            

              
              
<table>
  <row>
    <field name="id">1</field>
    <field name="name">Moo</field>
  </row>
  <row>
    <field name="id">2</field>
    <field name="name">Pie</field>
  </row>
  <row>
    <field name="id">3</field>
    <field name="name">Cow</field>
  </row>
</table>
            
          

YAML:

            

              
              
.dump out.[yaml|yml] select * from users;
            
          

out.[yaml|yml]:

            

              
              
---
- id: 1
  name: Moo
- id: 2
  name: Pie
- id: 3
  name: Cow
            
          

cpanm App::AltSQL

perl -MCPAN -e shell
install App::AltSQL