;ò
> ÄDc @ sÓ d k Z d k Z d k Z d k Z d k i Z d k i Z d k i Z d k
Td k i Z d k
i Z d k i Z d k i Z d e f d „ ƒ YZ e i d h d e <ƒ Z d e i f d „ ƒ YZ e Z d S( N( s *s SqliteLookupDBc B sk t Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z e
i d d
ƒ Z d „ Z
RS( Nc C s‘ y
d k } Wn t j
o t i d ‚ n X| | _ y | i | i ƒ | _ Wn9 | i j
o* } t
i | ƒ } | i | _ | ‚ n Xd S( Ns^ You need to have PySQLite installed to use this plugin. Download it at ( s sqlites ImportErrors callbackss Errors filenames selfs connects dbs
DatabaseErrors es dbis InvalidDBError( s selfs filenames sqlites e( ( s ./Lookup/plugin.pys __init__. s
c C s | i i ƒ d S( N( s selfs dbs close( s self( ( s ./Lookup/plugin.pys close= s c C sX | i i ƒ } | i d | ƒ t | i ƒ d ƒ } | d j o
t i ‚ n | Sd S( Ns SELECT COUNT(*) FROM %si (
s selfs dbs cursors executes tableNames ints fetchones rowss dbis
NoRecordError( s selfs tableNames rowss cursor( ( s ./Lookup/plugin.pys getRecordCount@ s
c C sF | i i ƒ } d | } | i | ƒ | i d j o t Sn t Sd S( Ns_ SELECT name FROM sqlite_master WHERE type='table' AND name='%s'i ( s selfs dbs cursors names sqls executes rowcounts Falses True( s selfs names cursors sql( ( s ./Lookup/plugin.pys checkLookupH s
c
C s | i i ƒ } | i d | ƒ d | } x² t i i | ƒ D]ž } | i d ƒ } y. | i
| d ƒ \ } } | i d d ƒ } WnE t j
o9 | i d | ƒ t d | i | ƒ } t i | ‚ n X| i | | | ƒ q= W| i d | | f ƒ | i i ƒ d S(
Ns& CREATE TABLE %s (key TEXT, value TEXT)s INSERT INTO %s VALUES (%%s, %%s)s
i s \:s :s
DROP TABLE %ss Invalid line in %s: %qs CREATE INDEX %s_keys ON %s (key)( s selfs dbs cursors executes names sqls utilss files nonCommentNonEmptyLiness fds lines rstrips splitRes splits keys values replaces
ValueErrors formats ss callbackss Errors commit(
s selfs names fds splitRes values cursors ss keys sqls line( ( s ./Lookup/plugin.pys addLookupS s
c C sN | i i ƒ } | i | ƒ o" | i d | ƒ | i i ƒ n
t i ‚ d S( Ns
DROP TABLE %s( s selfs dbs cursors checkLookups names executes commits dbis
NoRecordError( s selfs names cursor( ( s ./Lookup/plugin.pys
dropLookupd s
c C sT | i i ƒ } d | } | i | | ƒ | i d j o
t i ‚ n | i
ƒ Sd S( Ns' SELECT value FROM %s WHERE key LIKE %%si ( s selfs dbs cursors names sqls executes keys rowcounts dbis
NoRecordErrors fetchall( s selfs names keys cursors sql( ( s ./Lookup/plugin.pys
getResultsl s
c C sQ | i i ƒ } d | } | i | ƒ | i d j o
t i ‚ n | i ƒ Sd S( NsD SELECT key, value FROM %s
ORDER BY random() LIMIT 1i (
s selfs dbs cursors names sqls executes rowcounts dbis
NoRecordErrors fetchone( s selfs names keys cursors sql( ( s ./Lookup/plugin.pys getRandomResultu s
s *?s %_c C s0 | i i ƒ } g } g } d }
xh | D]` \ }
} |
d j oG | i d |
| f ƒ | d „ } | i i |
d | ƒ |
d 7}
q( q( Wx8 | D]0 } | i d | ƒ | i | i | i ƒ ƒ q“ W| o
t i ‚ n d | d i | ƒ f } | i | | ƒ | i d j o
t i ‚ n | i ƒ Sd S(
Ns ps regexps %s(%s)c C s t t | i | ƒ ƒ ƒ Sd S( N( s ints bools rs searchs s( s ss r( ( s ./Lookup/plugin.pys pˆ s i s %s LIKE %%ss" SELECT key, value FROM %s WHERE %ss AND i ( s selfs dbs cursors criterias formatss
predicateNames optionss options args appends columns ps create_functions globss globs translates _sqlTranss callbackss
ArgumentErrors names joins sqls executes rowcounts dbis
NoRecordErrors fetchall( s selfs names optionss globss columns args globs formatss cursors ps
predicateNames sqls criterias option( ( s ./Lookup/plugin.pys
searchResults€ s,
( s __name__s
__module__s __init__s closes getRecordCounts checkLookups addLookups
dropLookups
getResultss getRandomResults strings maketranss _sqlTranss
searchResults( ( ( s ./Lookup/plugin.pys SqliteLookupDB- s
s Lookups sqlitec B s4 t Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z e e d d f d
g ƒ Z e
i d ƒ Z d „ Z
e e
d d f e h d
d <ƒ d
d g ƒ Z
e d „ Z d „ Z d „ Z d „ Z d „ Z e e e h d d <d d <ƒ d e d ƒ g ƒ Z d „ Z e e d e d ƒ g ƒ Z RS( Nc C s§ t t | ƒ | _ | i i | ƒ t i ƒ | _ y t ƒ | _
Wn: t i j
o+ } | i i d | i t | ƒ ƒ ‚ n Xxq t i i ƒ D]` \ } } | i ƒ } | i d ƒ o8 | t d ƒ } d | j o qŽ n | i | | ƒ qŽ qŽ Wt i i i i } xœ | i d t! ƒ D]ˆ \ } } | i ƒ } | ƒ } y9 | i
i" | ƒ o | i# | | ƒ n | i$ | ƒ Wqt% j
o } | i i& d | | ƒ qXqWd S( Ns Error loading %s: %ss supybot.plugins.lookup.lookups.s .s fullNamess Couldn't add lookup %s: %s(' s supers Lookups selfs _Lookup__parents __init__s ircs callbackss CanonicalNameDicts
lookupDomainss LookupDBs dbs dbis InvalidDBErrors es logs exceptions filenames strs registrys _caches iteritemss names values lowers
startswiths lens addRegistryValues confs supybots pluginss lookupss groups getValuess Falses checkLookups addDatabases
addCommands Exceptions warning( s selfs ircs es names values filenames group( ( s ./Lookup/plugin.pys __init__Ÿ s6
c C s< | i i | ƒ o | | i j o t Sq8 t Sn t Sd S( N( s selfs _Lookup__parents isCommandMethods names
lookupDomainss Trues False( s selfs name( ( s ./Lookup/plugin.pys isCommandMethodº s
c C s7 | i i ƒ } | i | i i ƒ ƒ | i ƒ | Sd S( N( s selfs _Lookup__parents listCommandss commandss extends
lookupDomainss keyss sort( s selfs commands( ( s ./Lookup/plugin.pys listCommandsà s
c C s= y | i i | ƒ SWn" t j
o | i | d Sn Xd S( Ni ( s selfs _Lookup__parents getCommandMethods commands AttributeErrors
lookupDomains( s selfs command( ( s ./Lookup/plugin.pys getCommandMethodÉ s c C s t i i | d ƒ Sd S( Ni2 ( s utilss strs ellipsisifys s( s selfs s( ( s ./Lookup/plugin.pys _shrinkÏ s c C s | i i ƒ d S( N( s selfs dbs close( s self( ( s ./Lookup/plugin.pys dieÒ s c C s„ | | i j o | i d ƒ d Sn y5 | i i | ƒ | i | =| i | ƒ | i ƒ Wn# t i
j
o | i d ƒ n Xd S( s7
Removes the lookup for .
s$ That's not a valid lookup to remove.Ns No such lookup exists.( s names selfs
lookupDomainss ircs errors dbs
dropLookups delRegistryValuess replySuccesss dbis
NoRecordError( s selfs ircs msgs argss name( ( s ./Lookup/plugin.pys removeÕ s
s checkCapabilitys admins commandNames (?
Adds a lookup for with the key/value pairs specified in the
colon-delimited file specified by . is searched
for in conf.supybot.directories.data. If is not singular, we
try to make it singular before creating the command. If the --nokey
option is specified, the new lookup will display only the value when
queried, and will omit the key from the response.
s nokeys0 I already have a command in this plugin named %sNs Could not open %s: %si s Lookup %s added.( s Falses nokeys optlists options arguments Trues utilss strs depluralizes names selfs isCommandMethods ss ircs errors dbs checkLookups addDatabases filenames EnvironmentErrors es argss
addCommands addRegistryValues replySuccess( s selfs ircs msgs argss optlists names filenames nokeys arguments ss es option( ( s ./Lookup/plugin.pys addç s(
s nokeys s filenamec C s] t i i i i } t i | | t i | d ƒ ƒ t i | i | ƒ d t i | d ƒ ƒ d S( Ns s nokey( s confs supybots pluginss Lookups lookupss groups registerGlobalValues names registrys Strings filenames gets Booleans nokey( s selfs names filenames nokeys group( ( s ./Lookup/plugin.pys addRegistryValue s c C s# t i i i i } | i | ƒ d S( N( s confs supybots pluginss Lookups lookupss groups
unregisters name( s selfs names group( ( s ./Lookup/plugin.pys delRegistryValues
s c C sK t i i i i | ƒ } t | ƒ } | i i
| | | i ƒ | i
ƒ d S( N( s confs supybots directoriess datas dirizes filenames files fds selfs dbs addLookups names _splitRes close( s selfs names filenames fd( ( s ./Lookup/plugin.pys addDatabase s c s{ ‡ d † } | i i ˆ ƒ } d ˆ t i i | ˆ ƒ f } t i
i | ˆ | ƒ } t i
| | t ƒ } | | i ˆ ]
If is given, looks up in the %s database. Otherwise,
returns a random key: value pair from the database. There are
%s in the database.
( s fs selfs dbs getRecordCounts names rowss utilss strs nItemss docstrings pythons changeFunctionNames news instancemethods Lookups
lookupDomains( s selfs names rowss fs docstring( ( s names ./Lookup/plugin.pys
addCommand s c C s d } x+ | D]# \ }
} |
d j o
d } q
q
W| i i | ƒ o¥ yw | i i | | | | ƒ }
g i } |
D]+ } | d | d | i | d ƒ f ƒ qs ~ } | i t d | ƒ ƒ Wqý t i j
o | i d | ƒ qý Xn | i d | ƒ d
S( s6 [--{regexp} ] [--values] [ ...]
Searches the domain for lookups matching . If --regexp
is given, its associated value is taken as a regexp and matched
against the lookups. If --values is given, search the values rather
than the keys.
s keys valuess values %s: %si i s %Ls$ No entries in %s matched that query.s I don't have a domain %sN( s columns optlists options args selfs dbs checkLookups names
searchResultss globss resultss appends _[1]s items _shrinks lookupss ircs replys formats dbis
NoRecordErrors error( s selfs ircs msgs argss optlists names globss _[1]s lookupss columns resultss items args option( ( s ./Lookup/plugin.pys search& s
Bs valuess regexps
regexpMatchers somethings globc C sc | i i | ƒ o;g } | oÈ y | i i | | ƒ } Wn1 t i j
o" | i
d | | f ƒ d Sn Xt | ƒ d j o | i | d d ƒ qJg i
} | D] }
| |
d ƒ q§ ~ } | i d | d i | ƒ f ƒ q_| i i | | ƒ \ } } d | } | i | ƒ o | i d | | f ƒ q_| i d | ƒ n | i
d
| ƒ d S( sP
Looks up the value of in the domain .
s I couldn't find %s in %s.Ni i s %s could be %ss , or s lookups.%s.nokeys %s: %ss %ss I don't have a domain %s( s selfs dbs checkLookups names resultss keys
getResultss dbis
NoRecordErrors ircs errors lens replys appends _[1]s ts valuess joins getRandomResults values nokeyRegKeys
registryValue( s selfs ircs msgs argss names keys values resultss _[1]s valuess ts nokeyRegKey( ( s ./Lookup/plugin.pys _lookup? s& +$
s text( s __name__s
__module__s __init__s isCommandMethods listCommandss getCommandMethods _shrinks dies removes wraps res compiles _splitRes adds getoptss Falses addRegistryValues delRegistryValuess addDatabases
addCommands searchs anys _lookups
additional( ( ( s ./Lookup/plugin.pys Lookupž s& 0 6 ( s res news getopts strings supybot.dbis dbis supybot.confs confs
supybot.utilss utilss supybot.commandss supybot.pluginss pluginss supybot.ircutilss ircutilss supybot.registrys registrys supybot.callbackss callbackss objects SqliteLookupDBs DBs LookupDBs Plugins Lookups Class( s dbis strings callbackss utilss pluginss SqliteLookupDBs res Lookups registrys confs news getopts LookupDBs Classs ircutils( ( s ./Lookup/plugin.pys ? s o¿