[Ruby-DBI-devel] patch for DBD::SQLite

[MoonWolf <moo...@mo...>]

I wrote DBD::SQLite::Database#columns method.

CREATE TABLE TEST (
   KEY    TEXT    NOT NULL PRIMARY KEY,
   FLAG   BOOLEAN,
   DATA   TEXT
);

# BEFORE SQLite.c.patch
dbi => \dt test

Table 'test':
   +------+-----------+-----------+-------+---------+----------+---------+---------+--------+
   | name | type_name | precision | scale | default | nullable | indexed | primary | unique |
   +------+-----------+-----------+-------+---------+----------+---------+---------+--------+
   +------+-----------+-----------+-------+---------+----------+---------+---------+--------+

# AFTER SQLite.c.patch
dbi => \dt test

Table 'test':
   +------+-----------+-----------+-------+---------+----------+---------+---------+--------+
   | name | type_name | precision | scale | default | nullable | indexed | primary | unique |
   +------+-----------+-----------+-------+---------+----------+---------+---------+--------+
   | KEY  | TEXT      | NULL      | NULL  | NULL    | NULL     | NULL    | NULL    | NULL   |
   | FLAG | BOOLEAN   | NULL      | NULL  | NULL    | true     | NULL    | NULL    | NULL   |
   | DATA | TEXT      | NULL      | NULL  | NULL    | true     | NULL    | NULL    | NULL   |
   +------+-----------+-----------+-------+---------+----------+---------+---------+--------+