Package backend :: Package satellite_tools :: Package exporter :: Module exportLib :: Class _ChannelDumper
[hide private]
[frames] | no frames]

Class _ChannelDumper

source code


The most base type

Instance Methods [hide private]
 
__init__(self, writer, row, start_date=None, end_date=None, use_rhn_date=True, whole_errata=False) source code
 
set_attributes(self) source code
 
set_iterator(self) source code
 
_get_package_ids(self) source code
 
_get_ids(self, query_with_limit, query_with_rhnlimit, query_no_limits) source code
 
_get_cursor_source_packages(self) source code
 
_get_errata_ids(self) source code
 
_get_kickstartable_trees(self) source code
 
_get_channel_product_details(self)
Export rhnChannelProduct table content through ChannelDumper
source code
 
_channel_comps_last_modified(self) source code
 
_channel_modules_last_modified(self) source code

Inherited from BaseDumper: dump, dump_subelement, get_writer, set_writer

Static Methods [hide private]

Inherited from BaseDumper: timer

Class Variables [hide private]
  tag_name = 'rhn-channel'
  _query_channel_families = <spacewalk.server.rhnSQL.sql_base.St...
  _query_dist_channel_map = <spacewalk.server.rhnSQL.sql_base.St...
  _query_get_channel_trusts = <spacewalk.server.rhnSQL.sql_base....
  _query_get_package_ids = <spacewalk.server.rhnSQL.sql_base.Sta...
  _query_get_package_ids_by_date_limits = <spacewalk.server.rhnS...
  _query_get_package_ids_by_rhndate_limits = <spacewalk.server.r...
  _query_pkgids_by_date_whole_errata = <spacewalk.server.rhnSQL....
  _query_get_pkgids_by_rhndate_whole_errata = <spacewalk.server....
  _query_get_source_package_ids = <spacewalk.server.rhnSQL.sql_b...
  _query__get_errata_ids = <spacewalk.server.rhnSQL.sql_base.Sta...
  _query__get_errata_ids_by_limits = <spacewalk.server.rhnSQL.sq...
  _query__get_errata_ids_by_rhnlimits = <spacewalk.server.rhnSQL...
  _query_get_kickstartable_trees = <spacewalk.server.rhnSQL.sql_...
  _query_get_kickstartable_trees_by_rhnlimits = <spacewalk.serve...
  _query_get_kickstartable_trees_by_limits = <spacewalk.server.r...
  _query_get_channel_product_details = <spacewalk.server.rhnSQL....
  _query_channel_comps_last_modified = <spacewalk.server.rhnSQL....
  _query_channel_modules_last_modified = <spacewalk.server.rhnSQ...
Method Details [hide private]

__init__(self, writer, row, start_date=None, end_date=None, use_rhn_date=True, whole_errata=False)
(Constructor)

source code 
Overrides: BaseDumper.__init__

set_attributes(self)

source code 
Overrides: BaseDumper.set_attributes

set_iterator(self)

source code 
Overrides: BaseDumper.set_iterator

_get_channel_product_details(self)

source code 

Export rhnChannelProduct table content through ChannelDumper

return a tuple containing (product name, product version, beta status) or (None, None, None) if the information is missing


Class Variable Details [hide private]

_query_channel_families

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051694\
4; statement=
        select cf.id, cf.label
          from rhnChannelFamily cf, rhnChannelFamilyMembers cfm
         where cfm.channel_family_id = cf.id
           and cfm.channel_id = :channel_id
    

_query_dist_channel_map

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051701\
6; statement=
        select dcm.os, dcm.release, ca.label channel_arch
          from rhnDistChannelMap dcm, rhnChannelArch ca
         where dcm.channel_id = :channel_id
           and dcm.channel_arch_id = ca.id
           and dcm.org_id is null
    

_query_get_channel_trusts

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051708\
8; statement=
        select org_trust_id
          from rhnChannelTrust
         where channel_id = :channel_id
    

_query_get_package_ids

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051716\
0; statement=
        select package_id as id
          from rhnChannelPackage
         where channel_id = :channel_id
    

_query_get_package_ids_by_date_limits

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051723\
2; statement=
        select package_id as id
          from rhnChannelPackage rcp
         where rcp.channel_id = :channel_id
           and rcp.modified >= TO_TIMESTAMP(:lower_limit, 'YYYYMMDDHH2\
4MISS')
           and rcp.modified <= TO_TIMESTAMP(:upper_limit, 'YYYYMMDDHH2\
...

_query_get_package_ids_by_rhndate_limits

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051730\
4; statement=
        select package_id as id
          from rhnPackage rp, rhnChannelPackage rcp
         where rcp.channel_id = :channel_id
           and rcp.package_id = rp.id
           and rp.last_modified >= TO_TIMESTAMP(:lower_limit, 'YYYYMMD\
DHH24MISS')
...

_query_pkgids_by_date_whole_errata

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051737\
6; statement=
        select rcp.package_id as id
          from rhnChannelPackage rcp, rhnPackage rp
            left join rhnErrataPackage rep on rp.id = rep.package_id
            left join rhnErrata re on rep.errata_id = re.id
         where rcp.channel_id = :channel_id
           and rcp.package_id = rp.id
...

_query_get_pkgids_by_rhndate_whole_errata

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051744\
8; statement=
        select rcp.package_id as id
          from rhnChannelPackage rcp, rhnPackage rp
            left join rhnErrataPackage rep on rp.id = rep.package_id
            left join rhnErrata re on rep.errata_id = re.id
         where rcp.channel_id = :channel_id
           and rcp.package_id = rp.id
...

_query_get_source_package_ids

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051752\
0; statement=
        select distinct ps.id, sr.name source_rpm,
               TO_CHAR(ps.last_modified, 'YYYYMMDDHH24MISS') last_modi\
fied
          from rhnChannelPackage cp, rhnPackage p, rhnPackageSource ps\
,
               rhnSourceRPM sr
...

_query__get_errata_ids

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051759\
2; statement=
        select ce.errata_id as id, e.advisory_name,
              TO_CHAR(e.last_modified, 'YYYYMMDDHH24MISS') last_modifi\
ed
          from rhnChannelErrata ce, rhnErrata e
         where ce.channel_id = :channel_id
           and ce.errata_id = e.id
...

_query__get_errata_ids_by_limits

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051766\
4; statement=
         
        select ce.errata_id as id, e.advisory_name,
              TO_CHAR(e.last_modified, 'YYYYMMDDHH24MISS') last_modifi\
ed
          from rhnChannelErrata ce, rhnErrata e
         where ce.channel_id = :channel_id
...

_query__get_errata_ids_by_rhnlimits

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051773\
6; statement=
         
        select ce.errata_id as id, e.advisory_name,
              TO_CHAR(e.last_modified, 'YYYYMMDDHH24MISS') last_modifi\
ed
          from rhnChannelErrata ce, rhnErrata e
         where ce.channel_id = :channel_id
...

_query_get_kickstartable_trees

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051780\
8; statement=
        select kt.label as id
          from rhnKickstartableTree kt
         where kt.channel_id = :channel_id
           and kt.org_id is null
    

_query_get_kickstartable_trees_by_rhnlimits

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051788\
0; statement=
         
        select kt.label as id
          from rhnKickstartableTree kt
         where kt.channel_id = :channel_id
           and kt.org_id is null
    
...

_query_get_kickstartable_trees_by_limits

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051795\
2; statement=
         
        select kt.label as id
          from rhnKickstartableTree kt
         where kt.channel_id = :channel_id
           and kt.org_id is null
    
...

_query_get_channel_product_details

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051802\
4; statement=
        select cp.product as name,
               cp.version as version,
               cp.beta
        from rhnChannel c,
             rhnChannelProduct cp
        where c.id = :channel_id
...

_query_channel_comps_last_modified

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051809\
6; statement=
        select to_char(last_modified, 'YYYYMMDDHH24MISS') as comps_las\
t_modified
        from rhnChannelComps
        where channel_id = :channel_id
        and comps_type_id = 1
        order by id desc
...

_query_channel_modules_last_modified

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082051816\
8; statement=
        select to_char(last_modified, 'YYYYMMDDHH24MISS') as modules_l\
ast_modified
        from rhnChannelComps
        where channel_id = :channel_id
        and comps_type_id = 2
        order by id desc
...