This repository has been archived by the owner on Jun 3, 2020. It is now read-only.
PgIter2Breakdown
This assumes:
- The entire schema exits.
- That all of the stored procedures (not within a package) are common and need to be converted.
The goal of the first iteration is to have a "bare bones" system that is sane and can be tested.
| Function | Tables | Viewes | Packages | Java Queries | Perl Queries | Python Queries | Notes |
|---|---|---|---|---|---|---|---|
| Infrastructure | PXTSESSIONS, RHNSATELLITECERT, RHNSERVERGROUP, RHNSERVERGROUPTYPE, WEB_USER_PERSONAL_INFO, RHN_SAT_CLUSTER, RHNCRYPTOKEY, RHNCRYPTOKEYTYPE, RHN_CONFIG_MACRO, VALID_COUNTRIES, VALID_COUNTRIES_TL, RHNTEMPLATESTRING, RHNTEMPLATECATEGORY, RHN_DB_ENVIRONMENT, | rhn_entitlements | spacewalk-setup, Setup.pm | satCerts.py | Notes | ||
| Users | WEB_CONTACT, WEB_CUSTOMER_NOTIFICATION, WEB_USER_CONTACT_PERMISSION, WEB_USER_PERSONAL_INFO, WEB_USER_PREFIX, WEB_USER_SITE_INFO, WEB_USER_SITE_TYPE, RHNUSERDEFAULTSYSTEMGROUPS, RHNUSERGROUP, RHNUSERGROUPMEMBERS, RHNUSERGROUPTYPE, RHNUSERINFO, RHNUSERINFOPANE, RHNUSERMESSAGE, RHNUSERMESSAGESTATUS, RHNUSERMESSAGETYPE, RHNUSERRESERVED, RHNUSERSERVERGROUPPERMS, RHNUSERSERVERPERMS, RHNUSERSERVERPREFS, | RHNUSERACTIONOVERVIEW, RHNUSERAPPLETOVERVIEW, RHNUSERAVAILABLECHANNELS, RHNUSERCHANNEL, RHNUSERCHANNELFAMILYPERMS, RHNUSERCHANNELTREEVIEW, RHNUSERGROUPMEMBERSHIP, RHNUSERMANAGEDSERVERGROUPS, RHNUSERSERVERPERMSDUPES, RHNUSERSINORGOVERVIEW, RHNUSERTYPEARRAY, RHNUSERTYPEBASE, RHNUSERTYPECOMMAVIEW, | rhn_user | User_queries.xml | UserActions.pm, UserGroup.pm, User.pm |
rhnUser.py | Notes |
| Orgs | WEB_CUSTOMER,RHNREGTOKENORGDEFAULT, RHNMONITORGRANULARITY, RHNORGCHANNELSETTINGS, RHNORGCHANNELSETTINGSTYPE, RHNORGENTITLEMENTS, RHNORGENTITLEMENTTYPE, RHNORGERRATACACHEQUEUE, RHNORGINFO, RHNORGQUOTA, RHNTRUSTEDORGS, | RHNDEMOORGS, RHNORGCHANNELFAMILYPERMISSIONS, RHNORGCHANNELTREEVIEW, RHNORGERRATA, RHNORGPACKAGEOVERVIEW, RHNPAIDORGS, RHNUSERSINORGOVERVIEW, | rhn_org, rhn_quota, rhn_bel | User_queries.xml, CustomDataKey_legacyUser.hbm.xml, OrgEntitlementType.hbm.xml, OrgImpl.hbm.xml, SystemMigration.hbm.xml, TemplateString.hbm.xml
|
Org.pm | rhnUser.py,rhnServerGroup.py | Notes |
| Servers | RHNSERVERPRESERVEFILELIST, RHNSERVERDMI, RHNSERVERCHANNELARCHCOMPAT, RHNSERVERCONFIGCHANNEL, RHNSERVERCUSTOMDATAVALUE, RHNSERVERACTION, RHNSERVERACTIONPACKAGERESULT, RHNSERVERACTIONSCRIPTRESULT, RHNSERVERACTIONVERIFYMISSING, RHNSERVERACTIONVERIFYRESULT, RHNSERVERARCH, RHNSERVERCACHEINFO, RHNSERVERCHANNEL, RHNSATELLITESERVERGROUP, RHNSERVER, RHNSERVERPROFILE, RHNSERVERPROFILEPACKAGE, RHNSERVERPROFILETYPE, RHNSERVERSERVERGROUPARCHCOMPAT, RHNSERVERTOKENREGS, RHNSERVERUUID, RHNSNAPSHOTSERVERGROUP, RHNSNPSERVERQUEUE, RHN_NOTIFSERVERS, RHN_SERVER_MONITORING_INFO, RHNUSERSERVERGROUPPERMS, RHNUSERSERVERPERMS, RHNUSERSERVERPREFS, RHNSERVEREVENT, RHNSERVERGROUP, RHNSERVERGROUPMEMBERS, RHNSERVERGROUPNOTES, RHNSERVERGROUPTYPE, RHNSERVERGROUPTYPEFEATURE, RHNSERVERHISTORY, RHNSERVERINFO, RHNSERVERINSTALLINFO, RHNSERVERLOCATION, RHNSERVERLOCK, RHNSERVERMESSAGE, RHNSERVERNEEDEDERRATACACHE, RHNSERVERNEEDEDPACKAGECACHE, RHNSERVERNETINTERFACE, RHNSERVERNETWORK, RHNSERVERNOTES, RHNSERVERPACKAGE, RHNSERVERPACKAGEARCHCOMPAT, RHNSERVERPATH, RHNSYSTEMMIGRATIONS, RHNUSERDEFAULTSYSTEMGROUPS | RHNCHANNELFAMILYSERVERPHYSICAL, RHNCHANNELFAMILYSERVERS, RHNCHANNELFAMILYSERVERVIRTUAL, RHNENTITLEDSERVERS, RHNSERVERENTITLEMENTPHYSICAL, RHNSERVERENTITLEMENTVIEW, RHNSERVERENTITLEMENTVIRTUAL, RHNSERVERERRATATYPEVIEW, RHNSERVERFEATURESVIEW, RHNSERVERGROUPMEMBERSHIP, RHNSERVERGROUPOVERVIEW, RHNSERVERGROUPOVLITEHELPER, RHNSERVERNEEDEDPACKAGEVIEW, RHNSERVEROUTDATEDPACKAGES, RHNSERVEROVERVIEW, RHNUSERMANAGEDSERVERGROUPS, RHNUSERSERVERPERMSDUPES, RHNVISIBLESERVERGROUP, RHNVISIBLESERVERGROUPMEMBERS, RHNVISSERVERGROUPMEMBERSHIP, RHNVISSERVERGROUPOVERVIEW, RHNVISSERVERGROUPOVERVIEWLITE | rhn_server, rhn_cache, | System_queries.xml, SystemGroup_queries.xml, system_search.xml, CPUArch.hbm.xml, CustomDataValue_legacyUser.hbm.xml, InstalledPackage.hbm.xml, Location.hbm.xml, Network.hbm.xml, NetworkInterface.hbm.xml, Note_legacyUser.hbm.xml, PushClientState.hbm.xml, ServerArch.hbm.xml, ServerGroup.hbm.xml, ServerGroupType.hbm.xml, Server_legacyUser.hbm.xml, ServerSnapshot.hbm.xml, VirtualInstance.hbm.xml, VirtualInstanceState.hbm.xml, VirtualInstanceType.hbm.xml
|
CdDevice.pm, HwDevice.pm, NetInfo.pm, NetInterface.pm, StorageDevice.pm
|
rhnServer.py, rhnServer/* | Notes |
| Channels | RHNACTIONCONFIGCHANNEL, RHNCHANNEL, RHNCHANNELARCH, RHNCHANNELCLONED, RHNCHANNELCOMPS, RHNCHANNELDOWNLOADS, RHNCHANNELERRATA, RHNCHANNELFAMILY, RHNCHANNELFAMILYLICENSE, RHNCHANNELFAMILYLICENSECONSENT, RHNCHANNELFAMILYMEMBERS, RHNCHANNELFAMILYVIRTSUBLEVEL, RHNCHANNELNEWESTPACKAGE, RHNCHANNELNEWESTPACKAGEAUDIT, RHNCHANNELPACKAGE, RHNCHANNELPACKAGEARCHCOMPAT, RHNCHANNELPARENT, RHNCHANNELPERMISSION, RHNCHANNELPERMISSIONROLE, RHNCHANNELPRODUCT, RHNCHANNELTRUST, RHNREGTOKENCHANNELS, RHNREGTOKENCONFIGCHANNELS, RHNCONFIGCHANNEL, RHNCONFIGCHANNELTYPE, RHNDISTCHANNELMAP, RHNSERVERCHANNELARCHCOMPAT, RHNSERVERCONFIGCHANNEL, RHNSERVERCHANNEL, RHNRELEASECHANNELMAP, RHNSATELLITECHANNELFAMILY, RHNSNAPSHOTCHANNEL, RHNSNAPSHOTCONFIGCHANNEL, RHNERRATAFILECHANNEL, RHNERRATAFILECHANNELTMP, RHNKICKSTARTCHILDCHANNEL, RHNORGCHANNELSETTINGS, RHNORGCHANNELSETTINGSTYPE, RHNPATHCHANNELMAP, RHNPRIVATECHANNELFAMILY, RHNPRODUCTCHANNEL, RHNPUBLICCHANNELFAMILY | RHNAVAILABLECHANNELS, RHNCHANNELFAMILYOVERVIEW, RHNCHANNELFAMILYPERMISSIONS, RHNCHANNELFAMILYSERVERPHYSICAL, RHNCHANNELFAMILYSERVERS, RHNCHANNELFAMILYSERVERVIRTUAL, RHNCHANNELNEWESTPACKAGEVIEW, RHNCHANNELPACKAGEOVERVIEW, RHNCHANNELPERMISSIONS, RHNCHANNELTREEVIEW, RHNORGCHANNELFAMILYPERMISSIONS, RHNORGCHANNELTREEVIEW, RHNSHAREDCHANNELTREEVIEW, RHNSHAREDCHANNELVIEW, RHNUSERAVAILABLECHANNELS, RHNUSERCHANNEL, RHNUSERCHANNELFAMILYPERMS, RHNUSERCHANNELTREEVIEW | rhn_channel | Channel_queries.xml, ChannelArch.hbm.xml, ChannelFamily.hbm.xml, Channel.hbm.xml, DistChannelMap.hbm.xml, ProductName.hbm.xml, ReleaseChannelMap.hbm.xml
|
Channel.pm | rhnChannel.py, importlib/backend.py,handlers/app/channel.py, rhnRepository.py, importlib/packageUpload.py | Notes |
| Packages | RHNACTIONPACKAGEREMOVALFAILURE, RHNACTIONPACKAGE, RHNACTIONPACKAGEANSWERFILE, RHNACTIONPACKAGEDELTA, RHNACTIONPACKAGEORDER, RHNCHANNELNEWESTPACKAGE, RHNCHANNELNEWESTPACKAGEAUDIT, RHNCHANNELPACKAGE, RHNCHANNELPACKAGEARCHCOMPAT, RHNSERVERACTIONPACKAGERESULT, RHNREGTOKENPACKAGES, RHNSERVERPROFILEPACKAGE, RHNERRATAFILEPACKAGE, RHNSNAPSHOTPACKAGE, RHNSOLARISPACKAGE, RHNSOLARISPATCHEDPACKAGE, RHNSOLARISPATCHPACKAGES, RHNERRATAFILEPACKAGESOURCE, RHNERRATAFILEPACKAGETMP, RHNERRATAPACKAGE, RHNERRATAPACKAGETMP, RHNKICKSTARTPACKAGE, RHNPACKAGEARCH, RHNPACKAGECONFLICTS, RHNPACKAGEDELTA, RHNPACKAGEDELTAELEMENT, RHNPACKAGEEVR, RHNTRANSACTIONPACKAGE, RHNSERVERNEEDEDPACKAGECACHE, RHNSERVERPACKAGE, RHNSERVERPACKAGEARCHCOMPAT, RHNPACKAGE, RHNPACKAGECAPABILITY, RHNPACKAGECHANGELOG, RHNPACKAGEFILE, RHNPACKAGEFILEDELETEQUEUE, RHNPACKAGEGROUP, RHNPACKAGEKEY, RHNPACKAGEKEYASSOCIATION, RHNPACKAGEKEYTYPE, RHNPACKAGENAME, RHNPACKAGENEVRA, RHNPACKAGEOBSOLETES, RHNPACKAGEPROVIDER, RHNPACKAGEPROVIDES, RHNPACKAGEREQUIRES, RHNPACKAGESENSE, RHNPACKAGESENSEMAP, RHNPACKAGESOURCE, RHNPACKAGESYNCBLACKLIST | RHNCHANNELNEWESTPACKAGEVIEW, RHNCHANNELPACKAGEOVERVIEW, RHNHISTORYVIEW_PACKAGES, RHNORGPACKAGEOVERVIEW, RHNSERVERNEEDEDPACKAGEVIEW, RHNSERVEROUTDATEDPACKAGES | rhn_package, rhn_rpm | Package_queries.xml, package_search_elaborators.xml, package_search_setbuilder.xml, PackageArch.hbm.xml, PackageCapability.hbm.xml, PackageDelta.hbm.xml, PackageEvr.hbm.xml, PackageKey.hbm.xml, PackageKeyType.hbm.xml, PackageName.hbm.xml, PackageProvider.hbm.xml, Package_satellite.hbm.xml, PackageSource.hbm.xml
|
SolarisPackage.pm, SolarisPatch.pm, SolarisPatchSet.pm
|
rhnPackage.py, /action/packages.py, /action/solarispkgs.py, /action/rhnsd.py, importlib/backend.py, rhnDependency.py , handlers/applet/applet.py, handlers/xmlrpc/up2date.py, handlers/xmlrpc/queue.py, handlers/app/packages.py,rhnRepository.py | Notes |
| Errata | RHNACTIONERRATAUPDATE, RHNCHANNELERRATA, RHNERRATABUGLIST, RHNERRATABUGLISTTMP, RHNERRATACLONED, RHNERRATACLONEDTMP, RHNERRATACVE, RHNERRATAFILECHANNEL, RHNERRATAFILECHANNELTMP, RHNERRATAFILEPACKAGE, RHNSNPERRATAQUEUE, RHNERRATAFILEPACKAGESOURCE, RHNERRATAFILEPACKAGETMP, RHNERRATAFILETMP, RHNERRATAFILETYPE, RHNERRATAKEYWORD, RHNERRATAKEYWORDTMP, RHNERRATANOTIFICATIONQUEUE, RHNERRATAPACKAGE, RHNERRATAPACKAGETMP, RHNERRATAQUEUE, RHNERRATASEVERITY, RHNERRATATMP, RHNORGERRATACACHEQUEUE, RHNSERVERNEEDEDERRATACACHE, RHNERRATA, RHNERRATAFILE, RHNPAIDERRATATEMPCACHE | RHNHISTORYVIEW_ERRATA, RHNORGERRATA, RHNPRIVATEERRATAMAIL, RHNSERVERERRATATYPEVIEW | none |
ErrataCache_queries.xml, Errata_queries.xml, errata_search_elaborators.xml, errata_search_setbuilder.xml, ErrataFileType.hbm.xml, Severity.hbm.xml
|
none | handlers/xmlrpc/errata.py, rhnChannel.py, handlers/applet/applet.py, importlib/backend.py, importlib/importLib.py, importlib/errataImport.py | Notes |
| Registration | handlers/xmlrpc/registration.py, ChannelPackage.py, rhnServer/*, rhnUser, rhnLib.py, rhnVirtualization.py, rhnAction.py, rhnActivationKey.py, configFilesHandler.py, rhnAction.py, rhn | Notes | |||||
| Activation | N/A | N/A | satCerts.py, rhn_satellite_activate.py, sync_handlers.py | Notes | |||
| RHN Sync Import/Export | N/A | N/A | satsync.py, sync_handlers.py, satComputePkgHeaders.py, exporter/exportLib.py, disk_dumper/dumper.py, ./disk_dumper/iss.py, importLib/channelImport.py, importLib/blacklistImport.py, importLib/backend.py, importLib/errataCache.py, importLib/backendOracle.py, importLib/packageUpload.py, rhn_ssl_dbstore.py | Notes | |||
| rhnPush | rhnPackageUpload.py, handlers/app/packages.py, handlers/app/channel.py, handlers/app/comps.py, handlers/package_push/package_push.py | Notes |
