<commit_before>#!/usr/bin/python
#
##
# Import PLC records into the SFA database. It is indended that this tool be
# run once to create SFA records that reflect the current state of the
# planetlab database.
#
# The import tool assumes that the existing PLC hierarchy should all be part
# of "planetlab.us" (see the root_auth and level1_auth variables below).
#
# Public keys are extracted from the users' SSH keys automatically and used to
# create GIDs. This is relatively experimental as a custom tool had to be
# written to perform conversion from SSH to OpenSSL format. It only supports
# RSA keys at this time, not DSA keys.
##

import os
import getopt
import sys

from sfa.util.config import Config
from sfa.util.xrn import Xrn, get_leaf, get_authority, hrn_to_urn
from sfa.util.plxrn import hostname_to_hrn, slicename_to_hrn, email_to_hrn, hrn_to_pl_slicename
from sfa.storage.table import SfaTable
from sfa.storage.record import SfaRecord
from sfa.trust.gid import create_uuid    
from sfa.trust.certificate import convert_public_key, Keypair
from sfa.importer.sfaImport import sfaImport, _cleanup_string
from sfa.plc.plshell import PlShell    

def process_options():

   (options, args) = getopt.getopt(sys.argv[1:], '', [])
   for opt in options:
       name = opt[0]
       val = opt[1]


def load_keys(filename):
    keys = {}
    tmp_dict = {}
    try:
        execfile(filename, tmp_dict)
        if 'keys' in tmp_dict:
            keys = tmp_dict['keys']
        return keys
    except:
        return keys

def save_keys(filename, keys):
    f = open(filename, 'w')
    f.write("keys = %s" % str(keys))
    f.close()

def _get_site_hrn(interface_hrn, site):
    # Hardcode 'internet2' into the hrn for sites hosting
    # internet2 nodes. This is a special operation for some vini
    # sites only
    hrn = ".".join([interface_hrn, site['login_base']]) 
    if ".vini" in interface_hrn and interface_hrn.endswith('vini'):
        if site['login_base'].startswith("i2") or site['login_base'].startswith("nlr"):
            hrn = ".".join([interface_hrn, "internet2", site['login_base']])
    return hrn

def main():

    process_options()
    config = Config()
    if not config.SFA_REGISTRY_ENABLED:
        sys.exit(0)
    root_auth = config.SFA_REGISTRY_ROOT_AUTH
    interface_hrn = config.SFA_INTERFACE_HRN
    keys_filename = config.config_path + os.sep + 'person_keys.py' 
    sfaImporter = sfaImport()
    sfaImporter.create_top_level_records()
    logger=sfaImporter.logger
    logger.setLevelFromOptVerbose(config.SFA_API_LOGLEVEL)
    shell = PlShell (config)
    
    # create dict of all existing sfa records
    existing_records = {}
    existing_hrns = []
    key_ids = []
    person_keys = {} 
    table = SfaTable()
    results = table.find()
    for result in results:
        existing_records[(result['hrn'], result['type'])] = result
        existing_hrns.append(result['hrn']) 
            
    # Get all plc sites
    sites = shell.GetSites({'peer_id': None})
    sites_dict = {}
    for site in sites:
        sites_dict[site['login_base']] = site 
    
    # Get all plc users
    persons = shell.GetPersons({'peer_id': None, 'enabled': True}, 
                               ['person_id', 'email', 'key_ids', 'site_ids'])
    persons_dict = {}
    for person in persons:
        persons_dict[person['person_id']] = person
        key_ids.extend(person['key_ids'])

    # Get all public keys
    keys = shell.GetKeys( {'peer_id': None, 'key_id': key_ids})
    keys_dict = {}
    for key in keys:
        keys_dict[key['key_id']] = key['key']

    # create a dict of person keys keyed on key_id 
    old_person_keys = load_keys(keys_filename)
    for person in persons:
        pubkeys = []
        for key_id in person['key_ids']:
            pubkeys.append(keys_dict[key_id])
        person_keys[person['person_id']] = pubkeys

    # Get all plc nodes  
    nodes = shell.GetNodes( {'peer_id': None}, ['node_id', 'hostname', 'site_id'])
    nodes_dict = {}
    for node in nodes:
        nodes_dict[node['node_id']] = node

    # Get all plc slices
    slices = shell.GetSlices( {'peer_id': None}, ['slice_id', 'name'])
    slices_dict = {}
    for slice in slices:
        slices_dict[slice['slice_id']] = slice

    # special case for vini
    if ".vini" in interface_hrn and interface_hrn.endswith('vini'):
        # create a fake internet2 site first
        i2site = {'name': 'Internet2', 'abbreviated_name': 'I2',
                    'login_base': 'internet2', 'site_id': -1}
        site_hrn = _get_site_hrn(interface_hrn, i2site)
        logger.info("Importing site: %s" % site_hrn)
        # import if hrn is not in list of existing hrns or if the hrn exists
        # but its not a site record
        if site_hrn not in existing_hrns or \
           (site_hrn, 'authority') not in existing_records:
            logger.info("Import: site %s " % site_hrn)
            urn = hrn_to_urn(site_hrn, 'authority')
            if not sfaImporter.AuthHierarchy.auth_exists(urn):
                sfaImporter.AuthHierarchy.create_auth(urn)
            auth_info = sfaImporter.AuthHierarchy.get_auth_info(urn)
            auth_record = SfaRecord(hrn=site_hrn, gid=auth_info.get_gid_object(), type="authority", pointer=site['site_id'])
            auth_record.sync(verbose=True)

    # start importing 
    for site in sites:
        site_hrn = _get_site_hrn(interface_hrn, site)
        logger.info("Importing site: %s" % site_hrn)

        # import if hrn is not in list of existing hrns or if the hrn exists
        # but its not a site record
        if site_hrn not in existing_hrns or \
           (site_hrn, 'authority') not in existing_records:
            try:
                logger.info("Import: site %s " % site_hrn)
                urn = hrn_to_urn(site_hrn, 'authority')
                if not sfaImporter.AuthHierarchy.auth_exists(urn):
                    sfaImporter.AuthHierarchy.create_auth(urn)
                auth_info = sfaImporter.AuthHierarchy.get_auth_info(urn)
                auth_record = SfaRecord(hrn=site_hrn, gid=auth_info.get_gid_object(), \
                                        type="authority", pointer=site['site_id'])
                logger.info("Import: importing site: %s" % auth_record.summary_string())  
                auth_record.sync()
            except:
                # if the site import fails then there is no point in trying to import the
                # site's child records (node, slices, persons), so skip them.
                logger.log_exc("Import: failed to import site. Skipping child records") 
                continue 
             
        # import node records
        for node_id in site['node_ids']:
            if node_id not in nodes_dict:
                continue 
            node = nodes_dict[node_id]
            site_auth = get_authority(site_hrn)
            site_name = get_leaf(site_hrn)
            hrn =  hostname_to_hrn(site_auth, site_name, node['hostname'])
            if len(hrn) > 64:
                hrn = hrn[:64]
            if hrn not in existing_hrns or \
               (hrn, 'node') not in existing_records:
                try:
                    pkey = Keypair(create=True)
                    urn = hrn_to_urn(hrn, 'node')
                    node_gid = sfaImporter.AuthHierarchy.create_gid(urn, create_uuid(), pkey)
                    node_record = SfaRecord(hrn=hrn, gid=node_gid, type="node", pointer=node['node_id'], authority=get_authority(hrn))    
                    logger.info("Import: importing node: %s" % node_record.summary_string())  
                    node_record.sync()
                except:
                    logger.log_exc("Import: failed to import node") 
                    
<commit_msg>set the 'authority' field when importing sites<commit_after>#!/usr/bin/python
#
##
# Import PLC records into the SFA database. It is indended that this tool be
# run once to create SFA records that reflect the current state of the
# planetlab database.
#
# The import tool assumes that the existing PLC hierarchy should all be part
# of "planetlab.us" (see the root_auth and level1_auth variables below).
#
# Public keys are extracted from the users' SSH keys automatically and used to
# create GIDs. This is relatively experimental as a custom tool had to be
# written to perform conversion from SSH to OpenSSL format. It only supports
# RSA keys at this time, not DSA keys.
##

import os
import getopt
import sys

from sfa.util.config import Config
from sfa.util.xrn import Xrn, get_leaf, get_authority, hrn_to_urn
from sfa.util.plxrn import hostname_to_hrn, slicename_to_hrn, email_to_hrn, hrn_to_pl_slicename
from sfa.storage.table import SfaTable
from sfa.storage.record import SfaRecord
from sfa.trust.gid import create_uuid    
from sfa.trust.certificate import convert_public_key, Keypair
from sfa.importer.sfaImport import sfaImport, _cleanup_string
from sfa.plc.plshell import PlShell    

def process_options():

   (options, args) = getopt.getopt(sys.argv[1:], '', [])
   for opt in options:
       name = opt[0]
       val = opt[1]


def load_keys(filename):
    keys = {}
    tmp_dict = {}
    try:
        execfile(filename, tmp_dict)
        if 'keys' in tmp_dict:
            keys = tmp_dict['keys']
        return keys
    except:
        return keys

def save_keys(filename, keys):
    f = open(filename, 'w')
    f.write("keys = %s" % str(keys))
    f.close()

def _get_site_hrn(interface_hrn, site):
    # Hardcode 'internet2' into the hrn for sites hosting
    # internet2 nodes. This is a special operation for some vini
    # sites only
    hrn = ".".join([interface_hrn, site['login_base']]) 
    if ".vini" in interface_hrn and interface_hrn.endswith('vini'):
        if site['login_base'].startswith("i2") or site['login_base'].startswith("nlr"):
            hrn = ".".join([interface_hrn, "internet2", site['login_base']])
    return hrn

def main():

    process_options()
    config = Config()
    if not config.SFA_REGISTRY_ENABLED:
        sys.exit(0)
    root_auth = config.SFA_REGISTRY_ROOT_AUTH
    interface_hrn = config.SFA_INTERFACE_HRN
    keys_filename = config.config_path + os.sep + 'person_keys.py' 
    sfaImporter = sfaImport()
    sfaImporter.create_top_level_records()
    logger=sfaImporter.logger
    logger.setLevelFromOptVerbose(config.SFA_API_LOGLEVEL)
    shell = PlShell (config)
    
    # create dict of all existing sfa records
    existing_records = {}
    existing_hrns = []
    key_ids = []
    person_keys = {} 
    table = SfaTable()
    results = table.find()
    for result in results:
        existing_records[(result['hrn'], result['type'])] = result
        existing_hrns.append(result['hrn']) 
            
    # Get all plc sites
    sites = shell.GetSites({'peer_id': None})
    sites_dict = {}
    for site in sites:
        sites_dict[site['login_base']] = site 
    
    # Get all plc users
    persons = shell.GetPersons({'peer_id': None, 'enabled': True}, 
                               ['person_id', 'email', 'key_ids', 'site_ids'])
    persons_dict = {}
    for person in persons:
        persons_dict[person['person_id']] = person
        key_ids.extend(person['key_ids'])

    # Get all public keys
    keys = shell.GetKeys( {'peer_id': None, 'key_id': key_ids})
    keys_dict = {}
    for key in keys:
        keys_dict[key['key_id']] = key['key']

    # create a dict of person keys keyed on key_id 
    old_person_keys = load_keys(keys_filename)
    for person in persons:
        pubkeys = []
        for key_id in person['key_ids']:
            pubkeys.append(keys_dict[key_id])
        person_keys[person['person_id']] = pubkeys

    # Get all plc nodes  
    nodes = shell.GetNodes( {'peer_id': None}, ['node_id', 'hostname', 'site_id'])
    nodes_dict = {}
    for node in nodes:
        nodes_dict[node['node_id']] = node

    # Get all plc slices
    slices = shell.GetSlices( {'peer_id': None}, ['slice_id', 'name'])
    slices_dict = {}
    for slice in slices:
        slices_dict[slice['slice_id']] = slice

    # special case for vini
    if ".vini" in interface_hrn and interface_hrn.endswith('vini'):
        # create a fake internet2 site first
        i2site = {'name': 'Internet2', 'abbreviated_name': 'I2',
                    'login_base': 'internet2', 'site_id': -1}
        site_hrn = _get_site_hrn(interface_hrn, i2site)
        logger.info("Importing site: %s" % site_hrn)
        # import if hrn is not in list of existing hrns or if the hrn exists
        # but its not a site record
        if site_hrn not in existing_hrns or \
           (site_hrn, 'authority') not in existing_records:
            logger.info("Import: site %s " % site_hrn)
            urn = hrn_to_urn(site_hrn, 'authority')
            if not sfaImporter.AuthHierarchy.auth_exists(urn):
                sfaImporter.AuthHierarchy.create_auth(urn)
            auth_info = sfaImporter.AuthHierarchy.get_auth_info(urn)
            auth_record = SfaRecord(hrn=site_hrn, gid=auth_info.get_gid_object(), \
                                    type="authority", pointer=site['site_id'], 
                                    authority=get_authority(site_hrn))
            auth_record.sync(verbose=True)

    # start importing 
    for site in sites:
        site_hrn = _get_site_hrn(interface_hrn, site)
        logger.info("Importing site: %s" % site_hrn)

        # import if hrn is not in list of existing hrns or if the hrn exists
        # but its not a site record
        if site_hrn not in existing_hrns or \
           (site_hrn, 'authority') not in existing_records:
            try:
                logger.info("Import: site %s " % site_hrn)
                urn = hrn_to_urn(site_hrn, 'authority')
                if not sfaImporter.AuthHierarchy.auth_exists(urn):
                    sfaImporter.AuthHierarchy.create_auth(urn)
                auth_info = sfaImporter.AuthHierarchy.get_auth_info(urn)
                auth_record = SfaRecord(hrn=site_hrn, gid=auth_info.get_gid_object(), \
                                        type="authority", pointer=site['site_id'], 
                                        authority=get_authority(site_hrn))
                logger.info("Import: importing site: %s" % auth_record.summary_string())  
                auth_record.sync()
            except:
                # if the site import fails then there is no point in trying to import the
                # site's child records (node, slices, persons), so skip them.
                logger.log_exc("Import: failed to import site. Skipping child records") 
                continue 
             
        # import node records
        for node_id in site['node_ids']:
            if node_id not in nodes_dict:
                continue 
            node = nodes_dict[node_id]
            site_auth = get_authority(site_hrn)
            site_name = get_leaf(site_hrn)
            hrn =  hostname_to_hrn(site_auth, site_name, node['hostname'])
            if len(hrn) > 64:
                hrn = hrn[:64]
            if hrn not in existing_hrns or \
               (hrn, 'node') not in existing_records:
                try:
                    pkey = Keypair(create=True)
                    urn = hrn_to_urn(hrn, 'node')
                    node_gid = sfaImporter.AuthHierarchy.create_gid(urn, create_uuid(), pkey)
                    node_record = SfaRecord(hrn=hrn, gid=node_gid, type="node", pointer=node['node_id'], authority=get_authority(hrn))    
                    logger.info("Import: importing node: %s" % node_record.summary_string())  
                    node_record.sync()
                except:
                    logger.log_exc("Import: failed to import node") 
                    

{'fraction_non_alphanumeric': 0.10009532888465204, 'fraction_numerical': 0.002542103590721322, 'mean_word_length': 2.4245919477693145, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 5, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4415809', 'n_tokens_mistral': 5019, 'n_tokens_neox': 4874, 'n_words': 1294}