1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
|
DBIx::Easy - Easy to Use DBI Interface
**************************************
* The homepage of `DBIx::Easy' is http://www.linuxia.de/DBIx/Easy/.
* The latest version (currently 0.15) is always available as
http://www.linuxia.de/DBIx/Easy/DBIx-Easy.tar.gz.
* See the manual page for more informations.
Requirements
************
* DBI (URL: http://www.symbolstone.org/technology/perl/DBI/index.html)
* `DBD::Pg', `DBD::mysql', `DBD::mSQL', `DBD::ODBC' or `DBD::sybase'
(ask for other database drivers)
Installation
************
tar -xzf DBIx-Easy.tar.gz
cd DBIx-Easy-0.15
perl Makefile.PL
make
make install
Scripts
*******
The `DBIx::Easy' package contains the following scripts:
Name Description Remarks
`dbs_dumptabdata' creates file set with SQL table data Manual page
`dbs_dumptabstruct' creates file set with SQL table schemas Manual page
`dbs_empty' erases all data from a SQL database Manual page
`dbs_printtab' prints data from SQL table New in 0.07 Manual page
`dbs_update' update SQL database from text file Manual page
Debian Package
**************
This software is also available as Debian package, maintained by Dennis Schn
<dennis@cobolt.net>. The download address is
http://www.linuxia.de/DBIx/Easy/libdbix-easy-perl_0.15-1_all.deb.
Changes
*******
0.15
****
`Easy.pm'
=========
* support for ODBC and Sybase added
0.14
****
`Easy.pm'
=========
* implemented the optional `map' parameter in the `random_row' method
which was already documented
0.13
****
`Easy.pm'
=========
* don't use password from `~/.my.cnf' for databases on other hosts
* database port is configurable now
* new method `is_auth_error'
`dbs_dumptabdata'
=================
* `--cleanse' failed in some case if one of the keys was '`0''
`dbs_printtab'
==============
* new option `--sort'
`dbs_update'
============
* `dbs_printtab' is emulated instead called as program
* `--headline' and `--format=CSV' weren't fully compatible
0.12
****
`Easy.pm'
=========
* new method `random_row'
0.11
****
* several warnings fixed (most introduced in conjunction with Perl 5.6)
`Easy.pm'
=========
* new method `delete'
`dbs_update'
============
* new option `--match-sql'
0.10
****
`dbs_dumptabdata'
=================
* pass the `user' parameter to `dbs_printtab'
0.09
****
`Easy.pm'
=========
* escape tabulator in `view' method
* caches table structures
* new methods `columns', `types', `sizes', `typemap', `sizemap'
`dbs_dumptabdata', `dbs_dumptabstruct'
======================================
* pass options first to `mysqldump', needed for compatibility with older
MySQL versions
`dbs_update'
============
* return values of user-defined filters indicate if record is valid
* inclusion mode of `--columns' fixed
* expand tabulators
* apply user-defined filter specified by `--routine' only once
* choosed comma as default field separator for CSV format
* insert an empty string instead of NULL for string columns
* new option `--rows'
* option `--keys' accepts key names too
* issue warning on missing type information
0.08
****
`dbs_update'
============
* brown paper bug fixed that kept --cleanse from working by growing the
SQL statement which each record to be cleansed
* bug fixed that may be triggered by the combination of `--headline' and `
--map'
* strip whitespace from column names found in the headline of the input
* field separator for CSV format can selected from the commandline now
* `--columns' can be used to exclude columns explicitly
* strip blanks from parameter list for `--columns'
* first field may contain table name and start column instead of table
name only
* example for `--routine' added to documentation
0.07
****
* new script `dbs_printtab'
* made more verbose if connection cannot be established
* method `view' fixed in respect to `limit' option, option `separator'
added, separator defaults to the tabulator now, escape newlines
* new option `--exclude-matching-tables' for `dbs_dumptabdata', `
dbs_dumptabstruct' and `dbs_empty'
* new option `--tables' for `dbs_empty', `dbs_dumptabstruct' and `
dbs_dumptabdata'
* new options `--cleanse', `--columns', `--format', `--keys', `--map', `
--skipbadlines' and `--update-only' for `dbs_update'
* new option `--use-printtab' for `dbs_dumptabdata'
* new option `--pipe' for `dbs_dumptabstruct'
* `dbs_dumptabstruct' dumps sequences too
* optional parameter CONDITION added to method `makemap'
* optional parameter COLUMNS added to method `view'
* made `dbs_update' more verbose on errors, ensure commit, newlines will
be regenerated, remembers table name if specified with `--table', carriage
returns are removed from input
* don't call `rollback' within error handler if `AutoCommit' is enabled
* new methods `is_table', `sequences'
Authors
*******
Stefan Hornburg <racke@linuxia.de>
Dennis Schn <dennis@cobolt.net>
Support for Sybase and ODBC provided by David B. Bitton
<david@codenoevil.com>.
|
