spacewalk :: satellite_tools :: exporter :: exportLib :: _ChannelDumper :: Class _ChannelDumper
[hide private]
[frames] | no frames]

Class _ChannelDumper


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)
 
set_attributes(self)
 
set_iterator(self)
 
_get_package_ids(self)
 
_get_ids(self, query_with_limit, query_with_rhnlimit, query_no_limits)
 
_get_cursor_source_packages(self)
 
_get_errata_ids(self)
 
_get_kickstartable_trees(self)
 
_get_channel_product_details(self)
Export rhnChannelProduct table content through ChannelDumper
 
_channel_comps_last_modified(self)
 
_channel_modules_last_modified(self)

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)

 
Overrides: BaseDumper.__init__

set_attributes(self)

 
Overrides: BaseDumper.set_attributes

set_iterator(self)

 
Overrides: BaseDumper.set_iterator

_get_channel_product_details(self)

 

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 13998082439543\
2; 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 13998082439550\
4; 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 13998082439557\
6; 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 13998082439564\
8; 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 13998082439572\
0; 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 13998082450644\
8; 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 13998082450652\
0; 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 13998082450659\
2; 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 13998082450666\
4; 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 13998082450673\
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
           and ce.errata_id = e.id
...

_query__get_errata_ids_by_limits

Value:
<spacewalk.server.rhnSQL.sql_base.Statement instance at 13998082450680\
8; 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 13998082450688\
0; 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 13998082450695\
2; 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 13998082450702\
4; 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 13998082450709\
6; 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 13998082450716\
8; 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 13998082450724\
0; 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 13998082450731\
2; 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
...