2 * Copyright (C) 2007 Internet Software Consortium.
4 * Permission to use, copy, modify, and distribute this software for any
5 * purpose with or without fee is hereby granted, provided that the above
6 * copyright notice and this permission notice appear in all copies.
8 * THE SOFTWARE IS PROVIDED "AS IS" AND INTERNET SOFTWARE CONSORTIUM
9 * DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL
10 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL
11 * INTERNET SOFTWARE CONSORTIUM BE LIABLE FOR ANY SPECIAL, DIRECT,
12 * INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING
13 * FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT,
14 * NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION
15 * WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
18 /* $Id: zone2sqlite.c,v 1.2 2008/09/24 02:46:21 marka Exp $ */
23 #include <isc/buffer.h>
25 #include <isc/print.h>
26 #include <isc/result.h>
29 #include <dns/dbiterator.h>
30 #include <dns/fixedname.h>
32 #include <dns/rdata.h>
33 #include <dns/rdataset.h>
34 #include <dns/rdatasetiter.h>
35 #include <dns/rdatatype.h>
36 #include <dns/result.h>
41 #define UNUSED(x) (x) = (x)
45 * Generate an SQLite table from a zone.
48 typedef struct _dbinfo {
54 dbinfo_t dbi = { NULL, NULL, NULL };
58 closeandexit(int status)
61 sqlite3_close(dbi.db);
68 check_result(isc_result_t result, const char *message)
70 if (result != ISC_R_SUCCESS) {
71 fprintf(stderr, "%s: %s\n", message,
72 isc_result_totext(result));
78 db_connect(dbinfo_t *dbi)
80 if (sqlite3_open(dbi->filename, &dbi->db) == SQLITE_OK) {
81 return (ISC_R_SUCCESS);
83 /* a connection is returned even if the open fails */
84 sqlite3_close(dbi->db);
86 return (ISC_R_FAILURE);
91 add_rdata_cb(void *parm, int cc, char **cv, char **cn)
103 addrdata(dns_name_t *name, dns_ttl_t ttl, dns_rdata_t *rdata)
105 unsigned char namearray[DNS_NAME_MAXTEXT + 1];
106 unsigned char typearray[20];
107 unsigned char dataarray[2048];
114 isc_buffer_init(&b, namearray, sizeof(namearray) - 1);
115 result = dns_name_totext(name, ISC_TRUE, &b);
116 check_result(result, "dns_name_totext");
117 namearray[isc_buffer_usedlength(&b)] = 0;
119 isc_buffer_init(&b, typearray, sizeof(typearray) - 1);
120 result = dns_rdatatype_totext(rdata->type, &b);
121 check_result(result, "dns_rdatatype_totext");
122 typearray[isc_buffer_usedlength(&b)] = 0;
124 isc_buffer_init(&b, dataarray, sizeof(dataarray) - 1);
125 result = dns_rdata_totext(rdata, NULL, &b);
126 check_result(result, "dns_rdata_totext");
127 dataarray[isc_buffer_usedlength(&b)] = 0;
129 sql = sqlite3_mprintf(
130 "INSERT INTO %q (NAME, TTL, RDTYPE, RDATA)"
131 " VALUES ('%q', %d, '%q', '%q') ",
133 namearray, ttl, typearray, dataarray);
135 res = sqlite3_exec(dbi.db, sql, add_rdata_cb, NULL, &errmsg);
138 if (result != SQLITE_OK) {
139 fprintf(stderr, "INSERT failed: %s\n", errmsg);
145 main(int argc, char *argv[])
150 char *porigin, *zonefile;
151 dns_fixedname_t forigin, fname;
152 dns_name_t *origin, *name;
154 dns_dbiterator_t *dbiter;
156 dns_rdatasetiter_t *rdsiter;
157 dns_rdataset_t rdataset;
158 dns_rdata_t rdata = DNS_RDATA_INIT;
159 isc_mem_t *mctx = NULL;
164 printf("usage: %s <zone> <zonefile> <dbfile> <dbtable>\n", argv[0]);
171 dbi.filename = argv[3];
174 dns_result_register();
177 result = isc_mem_create(0, 0, &mctx);
178 check_result(result, "isc_mem_create");
180 isc_buffer_init(&b, porigin, strlen(porigin));
181 isc_buffer_add(&b, strlen(porigin));
182 dns_fixedname_init(&forigin);
183 origin = dns_fixedname_name(&forigin);
184 result = dns_name_fromtext(origin, &b, dns_rootname, ISC_FALSE, NULL);
185 check_result(result, "dns_name_fromtext");
188 result = dns_db_create(mctx, "rbt", origin, dns_dbtype_zone,
189 dns_rdataclass_in, 0, NULL, &db);
190 check_result(result, "dns_db_create");
192 result = dns_db_load(db, zonefile);
193 if (result == DNS_R_SEENINCLUDE)
194 result = ISC_R_SUCCESS;
195 check_result(result, "dns_db_load");
197 printf("Connecting to '%s'\n", dbi.filename);
199 if ((result = db_connect(&dbi)) != ISC_R_SUCCESS) {
200 fprintf(stderr, "Connection to database '%s' failed\n",
205 sql = sqlite3_mprintf("DROP TABLE %q ", dbi.table);
207 res = sqlite3_exec(dbi.db, sql, NULL, NULL, &errmsg);
210 if (res != SQLITE_OK) {
211 fprintf(stderr, "DROP TABLE %s failed: %s\n",
217 sql = sqlite3_mprintf(sql, "BEGIN TRANSACTION");
219 res = sqlite3_exec(dbi.db, sql, NULL, NULL, &errmsg);
221 if (res != SQLITE_OK) {
222 fprintf(stderr, "BEGIN TRANSACTION failed: %s\n", errmsg);
227 sql = sqlite3_mprintf(
229 "(NAME TEXT, TTL INTEGER, RDTYPE TEXT, RDATA TEXT) ",
232 res = sqlite3_exec(dbi.db, sql, NULL, NULL, &errmsg);
234 if (res != SQLITE_OK) {
235 fprintf(stderr, "CREATE TABLE %s failed: %s\n",
241 result = dns_db_createiterator(db, 0, &dbiter);
242 check_result(result, "dns_db_createiterator()");
244 result = dns_dbiterator_first(dbiter);
245 check_result(result, "dns_dbiterator_first");
247 dns_fixedname_init(&fname);
248 name = dns_fixedname_name(&fname);
249 dns_rdataset_init(&rdataset);
250 dns_rdata_init(&rdata);
252 while (result == ISC_R_SUCCESS) {
254 result = dns_dbiterator_current(dbiter, &node, name);
255 if (result == ISC_R_NOMORE)
257 check_result(result, "dns_dbiterator_current");
260 result = dns_db_allrdatasets(db, node, NULL, 0, &rdsiter);
261 check_result(result, "dns_db_allrdatasets");
263 result = dns_rdatasetiter_first(rdsiter);
265 while (result == ISC_R_SUCCESS) {
266 dns_rdatasetiter_current(rdsiter, &rdataset);
267 result = dns_rdataset_first(&rdataset);
268 check_result(result, "dns_rdataset_first");
269 while (result == ISC_R_SUCCESS) {
270 dns_rdataset_current(&rdataset, &rdata);
271 addrdata(name, rdataset.ttl, &rdata);
272 dns_rdata_reset(&rdata);
273 result = dns_rdataset_next(&rdataset);
275 dns_rdataset_disassociate(&rdataset);
276 result = dns_rdatasetiter_next(rdsiter);
278 dns_rdatasetiter_destroy(&rdsiter);
279 dns_db_detachnode(db, &node);
280 result = dns_dbiterator_next(dbiter);
284 sql = sqlite3_mprintf(sql, "COMMIT TRANSACTION ");
286 res = sqlite3_exec(dbi.db, sql, NULL, NULL, &errmsg);
288 if (res != SQLITE_OK) {
289 fprintf(stderr, "COMMIT TRANSACTION failed: %s\n", errmsg);
294 dns_dbiterator_destroy(&dbiter);
296 isc_mem_destroy(&mctx);