DybDbi::ilookup Namespace Reference

Classes
class	IEntry
class	ILookup
class	IRunLookup
Functions
def	args_
def	main
def	check_irunlookup
Variables
tuple	log = logging.getLogger(__name__)
tuple	il = main()

---

Detailed Description

Perform multiple DBI lookups with a single DBI query...
Made possible by restrictions on the nature of the lookups. 

The canonical example is looking up entries in GDaqRunInfo based on the 
runNo field (RunNo attribute)

---

Function Documentation

def DybDbi::ilookup::args_

(

)

Definition at line 79 of file ilookup.py.

           :
    import argparse

    cls = IRunLookup

    ap = argparse.ArgumentParser(description=__doc__)
    ap.add_argument( 'iargs', nargs="+" , type=int,                help='One or more integer arguments to lookup ')
    ap.add_argument( '-k', '--kls',        default=cls.kls,        help='Name of DybDbi class. Default %(default)s ')
    ap.add_argument( '-d', '--ifield',     default=cls.ifield,     help='Payload integer fieldname corresponding to positional argument values. Default %(default)s ')
    ap.add_argument( '-s', '--sqlcontext', default=cls.sqlcontext, help='Extended query SQL context. Default %(default)s ')
    ap.add_argument( '-i', '--iattr',      default=cls.iattr,      help='DybDbi integer attribute name, used for the in memory lookup to arrange entries by argument. Default %(default)s ') 

    ap.add_argument(       '--dbconf',     default=None   ,       help='Name of section of ~/.my.cnf with DB connection parameters. Default %(default)s ')
    args = ap.parse_args()
    return args

def DybDbi::ilookup::main

(

)

Definition at line 95 of file ilookup.py.

          :
    import os
    args = args_()
    if args.dbconf:
        os.environ['DBCONF'] = args.dbconf 
    il = ILookup( *args.iargs , kls=args.kls , ifield=args.ifield , iattr=args.iattr, sqlcontext=args.sqlcontext )
    for iarg in args.iargs:
        print iarg, il[iarg]
    return il

def DybDbi::ilookup::check_irunlookup

(

)

Definition at line 105 of file ilookup.py.

                      :
    iargs = (10,100,1000)
    irl = IRunLookup( *iargs )
    for ia in iargs:
        print ia, irl[ia]

---

Variable Documentation

tuple DybDbi::ilookup::log = logging.getLogger(__name__)

Definition at line 10 of file ilookup.py.

tuple DybDbi::ilookup::il = main()

Definition at line 113 of file ilookup.py.