regex_question.py

# how to change this:
    pid = Column(Integer, primary_key=True)
    SOFTWARE_VERSION = Column('software_version',Float)
    SPACECRAFT_CLOCK_START_COUNT = Column('spacecraft_clock_start_count',Float)
    ALONG_TRACK_FOOTPRINT_SIZE = Column('along_track_footprint_size',Float)
    PACKET_SUBSECONDS = Column('packet_subseconds',Integer)
    Partial_Data = Column('partial_data',Integer)
    Temperature_2 = Column('temperature_2',Integer)
    TEMP_2 = Column('temp_2',Float)
    SPICE_Version_Epoch = Column('spice_version_epoch',Integer)
    STANDARD_DATA_PRODUCT_ID = Column('standard_data_product_id',String)
    SPACECRAFT_CLOCK_STOP_COUNT = Column('spacecraft_clock_stop_count',Float)
    Saturation = Column('saturation',Integer)
    START_TIME = Column('start_time',DateTime)
    ACROSS_TRACK_FOOTPRINT_SIZE = Column('across_track_footprint_size',Float)
    Temperature_1 = Column('temperature_1',Integer)
    photom_iof_sp_2nm = Column('photom_iof_sp_2nm', postgresql.ARRAY(Float))
    Low_VIS_Wavelength_Uncertainty = Column('low_vis_wavelength_uncertainty',Integer)
    INCIDENCE_ANGLE = Column('incidence_angle',Float)
    PHASE_ANGLE = Column('phase_angle',Float)
    iof_sp_2nm = Column('iof_sp_2nm', postgresql.ARRAY(Float))
    Anomalous_Pixels = Column('anomalous_pixels',Integer)
    STOP_TIME = Column('stop_time',DateTime)
    Dark_Saturation = Column('dark_saturation',Integer)
    SC_TIME = Column('sc_time',Float)
    UVVS_Noise_Spike = Column('uvvs_noise_spike',Integer)
    SPECTRUM_MET = Column('spectrum_met',Float)
    PRODUCT_ID = Column('product_id',String)
    SPECTRUM_SUBSECONDS = Column('spectrum_subseconds',Integer)
    SPECTRUM_NUMBER = Column('spectrum_number',Integer)
    PRODUCT_CREATION_TIME = Column('product_creation_time',DateTime)
    EMISSION_ANGLE = Column('emission_angle',Float)
    SITE_ID = Column('site_id',String)
    INT_COUNT = Column('int_count',Integer)
    UVVS_Operating = Column('uvvs_operating',Integer)
    DETECTOR_ID = Column('detector_id',String)
    High_VIS_Wavelength_Uncertainty = Column('high_vis_wavelength_uncertainty',Integer)
    SPECTRUM_UTC_TIME = Column('spectrum_utc_time',DateTime)
    SOLAR_DISTANCE = Column('solar_distance',Float)
    TARGET_NAME = Column('target_name',String)
    Low_Signal_Level = Column('low_signal_level',Integer)
    MISSION_PHASE_NAME = Column('mission_phase_name',String)
    PRODUCT_VERSION_ID = Column('product_version_id',String)
    Dark_Scan = Column('dark_scan',Integer)
    DATA_QUALITY_INDEX = Column('data_quality_index',String)
    Grating_Temperature = Column('grating_temperature',Integer)
    fov = Column('fov',Geometry(geometry_type='POLYGON', srid=4326))
    center = Column('center',Geometry(geometry_type='POINT', srid=4326))

# to this (first word lowcase)
    pid = Column(Integer, primary_key=True)
    software_version = Column('software_version',Float)
    spacecraft_clock_start_count = Column('spacecraft_clock_start_count',Float)
    along_track_footprint_size = Column('along_track_footprint_size',Float)
    packet_subseconds = Column('packet_subseconds',Integer)
    partial_data = Column('partial_data',Integer)
    temperature_2 = Column('temperature_2',Integer)
    temp_2 = Column('temp_2',Float)
    spice_version_epoch = Column('spice_version_epoch',Integer)
    standard_data_product_id = Column('standard_data_product_id',String)
    spacecraft_clock_stop_count = Column('spacecraft_clock_stop_count',Float)
    saturation = Column('saturation',Integer)
    start_time = Column('start_time',DateTime)
    across_track_footprint_size = Column('across_track_footprint_size',Float)
    temperature_1 = Column('temperature_1',Integer)
    photom_iof_sp_2nm = Column('photom_iof_sp_2nm', postgresql.ARRAY(Float))
    low_vis_wavelength_uncertainty = Column('low_vis_wavelength_uncertainty',Integer)
    incidence_angle = Column('incidence_angle',Float)
    phase_angle = Column('phase_angle',Float)
    iof_sp_2nm = Column('iof_sp_2nm', postgresql.ARRAY(Float))
    anomalous_pixels = Column('anomalous_pixels',Integer)
    stop_time = Column('stop_time',DateTime)
    dark_saturation = Column('dark_saturation',Integer)
    sc_time = Column('sc_time',Float)
    uvvs_noise_spike = Column('uvvs_noise_spike',Integer)
    spectrum_met = Column('spectrum_met',Float)
    product_id = Column('product_id',String)
    spectrum_subseconds = Column('spectrum_subseconds',Integer)
    spectrum_number = Column('spectrum_number',Integer)
    product_creation_time = Column('product_creation_time',DateTime)
    emission_angle = Column('emission_angle',Float)
    site_id = Column('site_id',String)
    int_count = Column('int_count',Integer)
    uvvs_operating = Column('uvvs_operating',Integer)
    detector_id = Column('detector_id',String)
    high_vis_wavelength_uncertainty = Column('high_vis_wavelength_uncertainty',Integer)
    spectrum_utc_time = Column('spectrum_utc_time',DateTime)
    solar_distance = Column('solar_distance',Float)
    target_name = Column('target_name',String)
    low_signal_level = Column('low_signal_level',Integer)
    mission_phase_name = Column('mission_phase_name',String)
    product_version_id = Column('product_version_id',String)
    dark_scan = Column('dark_scan',Integer)
    data_quality_index = Column('data_quality_index',String)
    grating_temperature = Column('grating_temperature',Integer)
    fov = Column('fov',Geometry(geometry_type='POLYGON', srid=4326))
    center = Column('center',Geometry(geometry_type='POINT', srid=4326))
   
# vim command:
# :%s/^\v([^=]*)/\L\1/