1 /* $Id: filter_sru_to_z3950.cpp,v 1.10 2006-09-21 11:43:41 marc Exp $
2 Copyright (c) 2005-2006, Index Data.
4 See the LICENSE file for details
11 #include "gduutil.hpp"
12 #include "filter_sru_to_z3950.hpp"
15 #include <yaz/z-core.h>
17 #include <yaz/pquery.h>
19 #include <boost/thread/mutex.hpp>
26 namespace mp = metaproxy_1;
27 namespace yf = mp::filter;
33 std::string to_string(const T& t)
42 std::string http_header_value(const Z_HTTP_Header* header,
43 const std::string name)
45 while (header && header->name
46 && std::string(header->name) != name)
47 header = header->next;
49 if (header && header->name && std::string(header->name) == name
51 return std::string(header->value);
60 namespace metaproxy_1 {
62 class SRUtoZ3950::Rep {
63 //friend class SRUtoZ3950;
65 union SRW_query {char * cql; char * xcql; char * pqf;};
66 typedef const int& SRW_query_type;
68 void configure(const xmlNode *xmlnode);
69 void process(metaproxy_1::Package &package) const;
71 std::string sru_protocol(const Z_HTTP_Request &http_req) const;
72 std::string debug_http(const Z_HTTP_Request &http_req) const;
73 void http_response(mp::Package &package,
74 const std::string &content,
75 int http_code = 200) const;
76 bool build_sru_debug_package(mp::Package &package) const;
77 bool build_sru_response(mp::Package &package,
80 const Z_SRW_PDU *sru_pdu_res,
82 const char *stylesheet) const;
83 Z_SRW_PDU * decode_sru_request(mp::Package &package,
86 Z_SRW_PDU *&sru_pdu_res,
89 const char *stylesheet) const;
90 bool z3950_build_query(mp::odr &odr_en, Z_Query *z_query,
91 const SRW_query &query,
92 SRW_query_type query_type) const;
93 bool z3950_init_request(mp::Package &package,
95 &database = "Default") const;
96 bool z3950_close_request(mp::Package &package) const;
97 bool z3950_search_request(mp::Package &package,
99 Z_SRW_PDU *sru_pdu_res,
100 Z_SRW_searchRetrieveRequest
101 const *sr_req) const;
102 //const std::string &database,
103 //const std::string &query,
104 //int query_type) const;
105 bool z3950_present_request(mp::Package &package,
107 Z_SRW_PDU *sru_pdu_res,
108 Z_SRW_searchRetrieveRequest
109 const *sr_req) const;
110 //unsigned int start_position,
111 //unsigned int records_requested) const;
112 bool z3950_scan_request(mp::Package &package,
114 Z_SRW_PDU *sru_pdu_res,
116 const *sr_req) const;
117 //const std::string &database,
118 //const std::string &query,
119 //int query_type) const;
124 yf::SRUtoZ3950::SRUtoZ3950() : m_p(new Rep)
128 yf::SRUtoZ3950::~SRUtoZ3950()
129 { // must have a destructor because of boost::scoped_ptr
132 void yf::SRUtoZ3950::configure(const xmlNode *xmlnode)
134 m_p->configure(xmlnode);
137 void yf::SRUtoZ3950::process(mp::Package &package) const
139 m_p->process(package);
142 void yf::SRUtoZ3950::Rep::configure(const xmlNode *xmlnode)
146 void yf::SRUtoZ3950::Rep::process(mp::Package &package) const
148 Z_GDU *zgdu_req = package.request().get();
150 // ignoring all non HTTP_Request packages
151 if (!zgdu_req || !(zgdu_req->which == Z_GDU_HTTP_Request)){
156 // only working on HTTP_Request packages now
159 // TODO: Z3950 response parsing and translation to SRU package
162 Z_SRW_PDU *sru_pdu_req = 0;
163 mp::odr odr_de(ODR_DECODE);
165 Z_SRW_PDU *sru_pdu_res = 0;
166 mp::odr odr_en(ODR_ENCODE);
170 const char *stylesheet = 0;
172 if (! (sru_pdu_req = decode_sru_request(package, odr_de, odr_en,
174 charset, stylesheet)))
176 //build_sru_debug_package(package);
177 build_sru_response(package, odr_en, soap,
178 sru_pdu_res, charset, stylesheet);
183 // SRU request package translation to Z3950 package
185 std::cout << *sru_pdu_req << "\n";
187 std::cout << "SRU empty\n";
191 if (sru_pdu_req && sru_pdu_req->which == Z_SRW_explain_request)
193 //Z_SRW_searchRetrieveRequest *sr_req = sru_pdu_req->u.request;
194 sru_pdu_res = yaz_srw_get(odr_en, Z_SRW_explain_response);
195 std::cout << "TODO: implement explain response";
201 if (sru_pdu_req && sru_pdu_req->which == Z_SRW_searchRetrieve_request)
203 Z_SRW_searchRetrieveRequest *sr_req = sru_pdu_req->u.request;
205 sru_pdu_res = yaz_srw_get(odr_en, Z_SRW_searchRetrieve_response);
207 if (z3950_init_request(package))
210 ok = z3950_search_request(package, odr_en,
211 sru_pdu_res, sr_req);
214 && sru_pdu_res->u.response->numberOfRecords
215 && *(sru_pdu_res->u.response->numberOfRecords)
216 && sr_req->maximumRecords
217 && *(sr_req->maximumRecords))
219 ok = z3950_present_request(package, odr_en,
222 z3950_close_request(package);
228 else if (sru_pdu_req && sru_pdu_req->which == Z_SRW_scan_request)
230 Z_SRW_scanRequest *sr_req = sru_pdu_req->u.scan_request;
232 sru_pdu_res = yaz_srw_get(odr_en, Z_SRW_scan_response);
234 if (z3950_init_request(package))
236 z3950_scan_request(package, odr_en, sru_pdu_res, sr_req);
237 z3950_close_request(package);
242 std::cout << "SRU OPERATION NOT SUPPORTED \n";
243 sru_pdu_res = yaz_srw_get(odr_en, Z_SRW_explain_response);
245 // TODO: make nice diagnostic return package
246 package.session().close();
250 //build_sru_debug_package(package);
251 build_sru_response(package, odr_en, soap,
252 sru_pdu_res, charset, stylesheet);
263 bool yf::SRUtoZ3950::Rep::build_sru_debug_package(mp::Package &package) const
265 Z_GDU *zgdu_req = package.request().get();
266 if (zgdu_req && zgdu_req->which == Z_GDU_HTTP_Request)
268 Z_HTTP_Request* http_req = zgdu_req->u.HTTP_Request;
269 std::string content = debug_http(*http_req);
271 http_response(package, content, http_code);
274 package.session().close();
279 bool yf::SRUtoZ3950::Rep::build_sru_response(mp::Package &package,
282 const Z_SRW_PDU *sru_pdu_res,
284 const char *stylesheet)
288 // SRU request package translation to Z3950 package
290 std::cout << *(const_cast<Z_SRW_PDU *>(sru_pdu_res)) << "\n";
292 std::cout << "SRU empty\n";
295 Z_GDU *zgdu_req = package.request().get();
296 if (zgdu_req && zgdu_req->which == Z_GDU_HTTP_Request)
298 Z_GDU *zgdu_res //= z_get_HTTP_Response(odr_en, 200);
299 = odr_en.create_HTTP_Response(package.session(),
300 zgdu_req->u.HTTP_Request,
303 // adding HTTP response code and headers
304 Z_HTTP_Response * http_res = zgdu_res->u.HTTP_Response;
305 //http_res->code = http_code;
307 std::string ctype("text/xml");
309 ctype += "; charset=";
313 z_HTTP_header_add(odr_en,
314 &http_res->headers, "Content-Type", ctype.c_str());
316 // packaging Z_SOAP into HTML response
317 static Z_SOAP_Handler soap_handlers[4] = {
318 {"http://www.loc.gov/zing/srw/", 0,
319 (Z_SOAP_fun) yaz_srw_codec},
320 {"http://www.loc.gov/zing/srw/v1.0/", 0,
321 (Z_SOAP_fun) yaz_srw_codec},
322 {"http://www.loc.gov/zing/srw/update/", 0,
323 (Z_SOAP_fun) yaz_ucp_codec},
328 // empty stylesheet means NO stylesheet
329 if (stylesheet && *stylesheet == '\0')
332 // encoding SRU package
334 soap->u.generic->p = (void*) sru_pdu_res;
336 z_soap_codec_enc_xsl(odr_en, &soap,
337 &http_res->content_buf, &http_res->content_len,
338 soap_handlers, charset, stylesheet);
341 package.response() = zgdu_res;
344 package.session().close();
350 Z_SRW_PDU * yf::SRUtoZ3950::Rep::decode_sru_request(mp::Package &package,
353 Z_SRW_PDU *&sru_pdu_res,
356 const char *stylesheet)
359 Z_GDU *zgdu_req = package.request().get();
360 Z_SRW_PDU *sru_pdu_req = 0;
362 assert((zgdu_req->which == Z_GDU_HTTP_Request));
364 //ignoring all non HTTP_Request packages
365 //if (!zgdu_req || !(zgdu_req->which == Z_GDU_HTTP_Request)){
369 Z_HTTP_Request* http_req = zgdu_req->u.HTTP_Request;
373 Z_SRW_PDU *sru_pdu_res_exp = yaz_srw_get(odr_en, Z_SRW_explain_response);
375 if (0 == yaz_sru_decode(http_req, &sru_pdu_req, &soap,
377 &(sru_pdu_res_exp->u.response->diagnostics),
378 &(sru_pdu_res_exp->u.response->num_diagnostics)))
380 if (sru_pdu_res_exp->u.response->num_diagnostics)
382 sru_pdu_res = sru_pdu_res_exp;
383 package.session().close();
388 else if (0 == yaz_srw_decode(http_req, &sru_pdu_req, &soap,
393 sru_pdu_res = sru_pdu_res_exp;
394 package.session().close();
401 yf::SRUtoZ3950::Rep::z3950_init_request(mp::Package &package,
402 const std::string &database) const
404 // prepare Z3950 package
406 //Package z3950_package(s, package.origin());
407 Package z3950_package(package.session(), package.origin());
408 z3950_package.copy_filter(package);
410 // set initRequest APDU
411 mp::odr odr_en(ODR_ENCODE);
412 Z_APDU *apdu = zget_APDU(odr_en, Z_APDU_initRequest);
413 Z_InitRequest *init_req = apdu->u.initRequest;
414 //TODO: add user name in apdu
415 //TODO: add user passwd in apdu
416 //init_req->idAuthentication = org_init->idAuthentication;
417 //init_req->implementationId = "IDxyz";
418 //init_req->implementationName = "NAMExyz";
419 //init_req->implementationVersion = "VERSIONxyz";
421 ODR_MASK_SET(init_req->options, Z_Options_search);
422 ODR_MASK_SET(init_req->options, Z_Options_present);
423 ODR_MASK_SET(init_req->options, Z_Options_namedResultSets);
424 ODR_MASK_SET(init_req->options, Z_Options_scan);
426 ODR_MASK_SET(init_req->protocolVersion, Z_ProtocolVersion_1);
427 ODR_MASK_SET(init_req->protocolVersion, Z_ProtocolVersion_2);
428 ODR_MASK_SET(init_req->protocolVersion, Z_ProtocolVersion_3);
430 z3950_package.request() = apdu;
432 // send Z3950 package
433 // std::cout << "z3950_init_request " << *apdu <<"\n";
434 z3950_package.move();
436 // dead Z3950 backend detection
437 if (z3950_package.session().is_closed()){
438 package.session().close();
442 // check successful initResponse
443 Z_GDU *z3950_gdu = z3950_package.response().get();
445 if (z3950_gdu && z3950_gdu->which == Z_GDU_Z3950
446 && z3950_gdu->u.z3950->which == Z_APDU_initResponse)
453 yf::SRUtoZ3950::Rep::z3950_close_request(mp::Package &package) const
455 // prepare Z3950 package
456 Package z3950_package(package.session(), package.origin());
457 z3950_package.copy_filter(package);
458 z3950_package.session().close();
461 //mp::odr odr_en(ODR_ENCODE);
462 //Z_APDU *apdu = zget_APDU(odr_en, Z_APDU_close);
463 //z3950_package.request() = apdu;
465 z3950_package.move();
467 // check successful close response
468 //Z_GDU *z3950_gdu = z3950_package.response().get();
469 //if (z3950_gdu && z3950_gdu->which == Z_GDU_Z3950
470 // && z3950_gdu->u.z3950->which == Z_APDU_close)
473 if (z3950_package.session().is_closed()){
474 //package.session().close();
481 yf::SRUtoZ3950::Rep::z3950_search_request(mp::Package &package,
483 Z_SRW_PDU *sru_pdu_res,
484 Z_SRW_searchRetrieveRequest
487 Package z3950_package(package.session(), package.origin());
488 z3950_package.copy_filter(package);
489 //mp::odr odr_en(ODR_ENCODE);
490 Z_APDU *apdu = zget_APDU(odr_en, Z_APDU_searchRequest);
492 //add stuff in z3950 apdu
493 Z_SearchRequest *z_searchRequest = apdu->u.searchRequest;
496 z_searchRequest->num_databaseNames = 1;
497 z_searchRequest->databaseNames = (char**)
498 odr_malloc(odr_en, sizeof(char *));
499 if (sr_req->database)
500 z_searchRequest->databaseNames[0]
501 = odr_strdup(odr_en, const_cast<char *>(sr_req->database));
503 z_searchRequest->databaseNames[0]
504 = odr_strdup(odr_en, "Default");
508 Z_Query *z_query = (Z_Query *) odr_malloc(odr_en, sizeof(Z_Query));
509 z_searchRequest->query = z_query;
511 if (!z3950_build_query(odr_en, z_query,
512 (const SRW_query&)sr_req->query,
515 //send_to_srw_client_error(7, "query");
519 z3950_package.request() = apdu;
520 //std::cout << "z3950_search_request " << *apdu << "\n";
522 z3950_package.move();
524 //TODO: check success condition
526 //int yaz_diag_bib1_to_srw (int bib1_code);
527 //int yaz_diag_srw_to_bib1(int srw_code);
528 //Se kode i src/seshigh.c (srw_bend_search, srw_bend_init).
530 Z_GDU *z3950_gdu = z3950_package.response().get();
531 //std::cout << "z3950_search_request " << *z3950_gdu << "\n";
533 if (z3950_gdu && z3950_gdu->which == Z_GDU_Z3950
534 && z3950_gdu->u.z3950->which == Z_APDU_searchResponse
535 && z3950_gdu->u.z3950->u.searchResponse->searchStatus)
538 Z_SearchResponse *sr = z3950_gdu->u.z3950->u.searchResponse;
541 // srw'fy number of records
542 sru_pdu_res->u.response->numberOfRecords
543 = (int *) odr_malloc(odr_en, sizeof(int *));
544 *(sru_pdu_res->u.response->numberOfRecords) = *(sr->resultCount);
546 // srw'fy nextRecordPosition
547 //sru_pdu_res->u.response->nextRecordPosition
548 // = (int *) odr_malloc(odr_en, sizeof(int *));
549 //*(sru_pdu_res->u.response->nextRecordPosition) = 1;
560 yf::SRUtoZ3950::Rep::z3950_present_request(mp::Package &package,
562 Z_SRW_PDU *sru_pdu_res,
563 Z_SRW_searchRetrieveRequest
572 // no need to work if nobody wants records seen ..
573 if (!(sr_req->maximumRecords) || 0 == *(sr_req->maximumRecords))
576 // creating Z3950 package
577 Package z3950_package(package.session(), package.origin());
578 z3950_package.copy_filter(package);
579 //mp::odr odr_en(ODR_ENCODE);
580 Z_APDU *apdu = zget_APDU(odr_en, Z_APDU_presentRequest);
582 //TODO: add stuff in apdu
583 assert(apdu->u.presentRequest);
585 bool send_z3950_present = true;
587 // recordXPath unsupported.
588 if (sr_req->recordXPath)
590 send_z3950_present = false;
591 yaz_add_srw_diagnostic(odr_en,
592 &(sru_pdu_res->u.response->diagnostics),
593 &(sru_pdu_res->u.response->num_diagnostics),
597 // resultSetTTL unsupported.
598 // resultSetIdleTime in response
599 if (sr_req->resultSetTTL)
601 send_z3950_present = false;
602 yaz_add_srw_diagnostic(odr_en,
603 &(sru_pdu_res->u.response->diagnostics),
604 &(sru_pdu_res->u.response->num_diagnostics),
609 if (sr_req->sort_type != Z_SRW_sort_type_none)
611 send_z3950_present = false;
612 yaz_add_srw_diagnostic(odr_en,
613 &(sru_pdu_res->u.response->diagnostics),
614 &(sru_pdu_res->u.response->num_diagnostics),
618 // exit on all these above diagnostics
619 if (!send_z3950_present)
623 // z3950'fy start record position
624 if (sr_req->startRecord)
625 *(apdu->u.presentRequest->resultSetStartPoint)
626 = *(sr_req->startRecord);
628 *(apdu->u.presentRequest->resultSetStartPoint) = 1;
630 // z3950'fy number of records requested
631 if (sr_req->maximumRecords)
632 *(apdu->u.presentRequest->numberOfRecordsRequested)
633 = *(sr_req->maximumRecords);
635 // TODO: recordPacking
637 // TODO: z3950'fy record schema
638 //if (sr_req->recordSchema)
639 // *(apdu->u.presentRequest->preferredRecordSyntax)
640 // = *(sr_req->recordSchema);
642 // TODO: z3950'fy time to live
643 //if (sr_req->resultSetTTL)
648 z3950_package.request() = apdu;
650 //std::cout << "z3950_present_request " << *apdu << "\n";
651 z3950_package.move();
653 //TODO: check success condition
654 Z_GDU *z3950_gdu = z3950_package.response().get();
655 if (z3950_gdu && z3950_gdu->which == Z_GDU_Z3950
656 && z3950_gdu->u.z3950->which == Z_APDU_presentResponse)
659 //std::cout << "z3950_present_request OK\n";
661 Z_PresentResponse *pr = z3950_gdu->u.z3950->u.presentResponse;
665 // srw'fy number of returned records
666 //sru_pdu_res->u.response->num_records
667 // = *(pr->numberOfRecordsReturned);
668 //= (int *) odr_malloc(odr_en, sizeof(int *));
669 //*(sru_pdu_res->u.response->num_records)
670 // = *(pr->numberOfRecordsReturned);
672 // srw'fy nextRecordPosition
673 //if (! sru_pdu_res->u.response->nextRecordPosition)
674 sru_pdu_res->u.response->nextRecordPosition
675 = (int *) odr_malloc(odr_en, sizeof(int *));
676 *(sru_pdu_res->u.response->nextRecordPosition)
677 = *(pr->nextResultSetPosition);
686 yf::SRUtoZ3950::Rep::z3950_scan_request(mp::Package &package,
688 Z_SRW_PDU *sru_pdu_res,
689 Z_SRW_scanRequest const *sr_req) const
691 Package z3950_package(package.session(), package.origin());
692 z3950_package.copy_filter(package);
693 //mp::odr odr_en(ODR_ENCODE);
694 Z_APDU *apdu = zget_APDU(odr_en, Z_APDU_scanRequest);
696 //TODO: add stuff in apdu
697 Z_ScanRequest *z_scanRequest = apdu->u.scanRequest;
699 // database repackaging
700 z_scanRequest->num_databaseNames = 1;
701 z_scanRequest->databaseNames = (char**)
702 odr_malloc(odr_en, sizeof(char *));
703 if (sr_req->database)
704 z_scanRequest->databaseNames[0]
705 = odr_strdup(odr_en, const_cast<char *>(sr_req->database));
707 z_scanRequest->databaseNames[0]
708 = odr_strdup(odr_en, "Default");
712 // CQL or XCQL scan is not possible in Z3950, flagging a diagnostic
713 if (sr_req->query_type != Z_SRW_query_type_pqf)
715 //send_to_srw_client_error(7, "query");
719 // PQF query repackaging
720 // need to use Z_AttributesPlusTerm structure, not Z_Query
721 // this can be digget out of a
722 // Z_query->type1(Z_RPNQuery)->RPNStructure(Z_RPNStructure)
723 // ->u.simple(Z_Operand)->u.attributesPlusTerm(Z_AttributesPlusTerm )
725 //Z_Query *z_query = (Z_Query *) odr_malloc(odr_en, sizeof(Z_Query));
726 //z_searchRequest->query = z_query;
728 //if (!z3950_build_query(odr_en, z_query,
729 // (const SRW_query&)sr_req->query,
730 // sr_req->query_type))
732 //send_to_srw_client_error(7, "query");
738 z3950_package.request() = apdu;
739 std::cout << "z3950_scan_request " << *apdu << "\n";
741 z3950_package.move();
742 //TODO: check success condition
747 bool yf::SRUtoZ3950::Rep::z3950_build_query(mp::odr &odr_en, Z_Query *z_query,
748 const SRW_query &query,
749 SRW_query_type query_type) const
751 if (query_type == Z_SRW_query_type_cql)
753 Z_External *ext = (Z_External *)
754 odr_malloc(odr_en, sizeof(*ext));
755 ext->direct_reference =
756 odr_getoidbystr(odr_en, "1.2.840.10003.16.2");
757 ext->indirect_reference = 0;
759 ext->which = Z_External_CQL;
760 ext->u.cql = const_cast<char *>(query.cql);
762 z_query->which = Z_Query_type_104;
763 z_query->u.type_104 = ext;
767 if (query_type == Z_SRW_query_type_pqf)
769 Z_RPNQuery *RPNquery;
770 YAZ_PQF_Parser pqf_parser;
772 pqf_parser = yaz_pqf_create ();
774 RPNquery = yaz_pqf_parse (pqf_parser, odr_en, query.pqf);
777 std::cout << "TODO: Handeling of bad PQF\n";
778 std::cout << "TODO: Diagnostic to be send\n";
780 z_query->which = Z_Query_type_1;
781 z_query->u.type_1 = RPNquery;
783 yaz_pqf_destroy(pqf_parser);
791 yf::SRUtoZ3950::Rep::sru_protocol(const Z_HTTP_Request &http_req) const
793 const std::string mime_urlencoded("application/x-www-form-urlencoded");
794 const std::string mime_text_xml("text/xml");
795 const std::string mime_soap_xml("application/soap+xml");
797 const std::string http_method(http_req.method);
798 const std::string http_type
799 = http_header_value(http_req.headers, "Content-Type");
801 if (http_method == "GET")
804 if (http_method == "POST"
805 && http_type == mime_urlencoded)
808 if ( http_method == "POST"
809 && (http_type == mime_text_xml
810 || http_type == mime_soap_xml))
817 yf::SRUtoZ3950::Rep::debug_http(const Z_HTTP_Request &http_req) const
819 std::string message("<html>\n<body>\n<h1>"
820 "Metaproxy SRUtoZ3950 filter"
823 message += "<h3>HTTP Info</h3><br/>\n";
825 message += "<b>Method: </b> " + std::string(http_req.method) + "<br/>\n";
826 message += "<b>Version:</b> " + std::string(http_req.version) + "<br/>\n";
827 message += "<b>Path: </b> " + std::string(http_req.path) + "<br/>\n";
829 message += "<b>Content-Type:</b>"
830 + http_header_value(http_req.headers, "Content-Type")
832 message += "<b>Content-Length:</b>"
833 + http_header_value(http_req.headers, "Content-Length")
837 message += "<h3>Headers</h3><br/>\n";
839 Z_HTTP_Header* header = http_req.headers;
841 message += "<b>Header: </b> <i>"
842 + std::string(header->name) + ":</i> "
843 + std::string(header->value) + "<br/>\n";
844 header = header->next;
847 message += "</body>\n</html>\n";
851 void yf::SRUtoZ3950::Rep::http_response(metaproxy_1::Package &package,
852 const std::string &content,
856 Z_GDU *zgdu_req = package.request().get();
860 = odr.create_HTTP_Response(package.session(),
861 zgdu_req->u.HTTP_Request,
864 zgdu_res->u.HTTP_Response->content_len = content.size();
865 zgdu_res->u.HTTP_Response->content_buf
866 = (char*) odr_malloc(odr, zgdu_res->u.HTTP_Response->content_len);
868 strncpy(zgdu_res->u.HTTP_Response->content_buf,
869 content.c_str(), zgdu_res->u.HTTP_Response->content_len);
871 //z_HTTP_header_add(odr, &hres->headers,
872 // "Content-Type", content_type.c_str());
873 package.response() = zgdu_res;
879 static mp::filter::Base* filter_creator()
881 return new mp::filter::SRUtoZ3950;
885 struct metaproxy_1_filter_struct metaproxy_1_filter_sru_to_z3950 = {
896 * indent-tabs-mode: nil
897 * c-file-style: "stroustrup"
899 * vim: shiftwidth=4 tabstop=8 expandtab