Python insert_all Examples

Example #1

File: manage.py Project: cdmb/gastos_abertos

def _importcontratos():
    """Import contratos data to the database"""
    from utils import import_contrato, import_contrato_urls

    # Contratos
    import_contrato.insert_all(db, csv_file='data/contratos-2014.xls')
    import_contrato_urls.insert_all(db, csv_file='data/urls.csv')

Example #2

File: manage.py Project: VitorPizzuto/gastos_abertos

def _importcontratos():
    """Import contratos data to the database"""
    from utils import import_contrato, import_contrato_urls

    # Contratos
    import_contrato.insert_all(db, csv_file='data/contratos-2014.xls')
    import_contrato_urls.insert_all(db, csv_file='data/urls.csv')

Example #3

def importdata():
    """Import the data to the database"""
    from utils.import_revenue_codes import import_codes
    from utils import (import_revenue, import_contrato, import_execucao,
                       geocode_execucao)

    # Revenue
    import_codes(db)
    import_revenue.insert_all(db, csv_file='data/receitas_min.csv')
    # insert_all(db, csv_file='data/receitas_min.csv', lines_per_insert=80)

    # Contratos
    import_contrato.insert_all(db, csv_file='data/contratos-2014.xls')

    # Execucao
    folder = '../gastos_abertos_dados/Orcamento/execucao/'
    import_execucao.insert_all(db, folder=folder)
    data_folder = 'utils/geocoder/data'
    terms_folder = 'utils/geocoder/terms'
    geocode_execucao.geocode_all(db, data_folder, terms_folder)

Example #4

File: manage.py Project: chrmorais/gastos_abertos

def importdata():
    """Import the data to the database"""
    from utils.import_revenue_codes import import_codes
    from utils import (import_revenue, import_contrato,
                       import_execucao, geocode_execucao)

    # Revenue
    import_codes(db)
    import_revenue.insert_all(db, csv_file='data/receitas_min.csv')
    # insert_all(db, csv_file='data/receitas_min.csv', lines_per_insert=80)

    # Contratos
    import_contrato.insert_all(db, csv_file='data/contratos-2014.xls')

    # Execucao
    folder = '../gastos_abertos_dados/Orcamento/execucao/'
    import_execucao.insert_all(db, path=folder)
    data_folder = 'utils/geocoder/data'
    terms_folder = 'utils/geocoder/terms'
    geocode_execucao.geocode_all(db, data_folder, terms_folder)