def import_old_contracts(filepath): ''' Takes a csv of old contracts and imports them into the DB ''' from purchasing.data.importer.old_contracts import main print 'Importing data from {filepath}\n'.format(filepath=filepath) main(filepath) print 'Import finished!' return
def import_old_contracts(filepath): ''' Takes a csv of old contracts and imports them into the DB ''' from purchasing.data.importer.old_contracts import main print 'Importing data from {filepath}\n'.format(filepath=filepath) main(filepath) print 'Import finished!' return
def scrape(_all): print 'Disabling triggers...' turn_off_sqlalchemy_events() from purchasing.data.importer.scrape_county import main print 'Scraping County' main(_all) print 'Scraping Finished' print 'Enabling triggers...' turn_on_sqlalchemy_events() return
def import_nigp(filepath, replace=False): if replace: print 'Deleting current categories...' db.session.execute('DELETE FROM category') db.session.commit from purchasing.data.importer.nigp import main print 'Importing data from {filepath}\n'.format(filepath=filepath) main(filepath) print 'Import finished!' return
def import_nigp(filepath, replace=False): if replace: print "Deleting current categories..." db.session.execute("DELETE FROM category") db.session.commit from purchasing.data.importer.nigp import main print "Importing data from {filepath}\n".format(filepath=filepath) main(filepath) print "Import finished!" return
def import_costars(user=None, secret=None, bucket=None, directory=None): ''' Takes a directory which contains a number of csv files with the costars data, and then important them into the DB ''' from purchasing.data.importer.costars import main for file in os.listdir(directory): if file.endswith('.csv'): print 'Importing data from {file}'.format(file=file) main(os.path.join(directory, file), file, user, secret, bucket) print 'Import finished!' return
def import_state(filepath): ''' Takes a csv of state contracts and imports them into the DB ''' from purchasing.data.importer.state import main print 'Importing data from {filepath}\n'.format(filepath=filepath) main(filepath) print 'Import finished!' print 'Refreshing search_view...' refresh_search_view() print 'Done!' return
def import_costars(user=None, secret=None, bucket=None, directory=None): ''' Takes a directory which contains a number of csv files with the costars data, and then important them into the DB ''' from purchasing.data.importer.costars import main for file in os.listdir(directory): if file.endswith('.csv'): print 'Importing data from {file}'.format(file=file) main(os.path.join(directory, file), file, user, secret, bucket) print 'Import finished!' return
def import_old_contracts(filepath): """ Takes a csv of old contracts and imports them into the DB """ print "Disabling triggers..." turn_off_sqlalchemy_events() from purchasing.data.importer.old_contracts import main print "Importing data from {filepath}\n".format(filepath=filepath) main(filepath) print "Import finished!" print "Enabling triggers..." turn_on_sqlalchemy_events() print "Refreshing search_view..." print "Done!" return
def test_old_contracts_import(self): main(current_app.config.get('PROJECT_ROOT') + '/purchasing_test/mock/old_contracts.csv') # assert we get all contracts and companies contracts = ContractBase.query.all() self.assertEquals(len(contracts), 3) companies = Company.query.all() self.assertEquals(len(companies), 3) controller_nums = ['49020', '49011', '49189'] for contract in contracts: self.assertTrue(contract.financial_id in controller_nums) controller_nums.remove(contract.financial_id) self.assertEquals(len(controller_nums), 0)
def import_costars(user=None, secret=None, bucket=None, directory=None): """ Takes a directory which contains a number of csv files with the costars data, and then important them into the DB """ print "Disabling triggers..." turn_off_sqlalchemy_events() from purchasing.data.importer.costars import main for file in os.listdir(directory): if file.endswith(".csv"): print "Importing data from {file}".format(file=file) main(os.path.join(directory, file), file, user, secret, bucket) print "Import finished!" print "Enabling triggers..." turn_on_sqlalchemy_events() return
def test_old_contracts_import(self): main( current_app.config.get('PROJECT_ROOT') + '/purchasing_test/mock/old_contracts.csv') # assert we get all contracts and companies contracts = get_all_contracts() self.assertEquals(len(contracts), 3) companies = get_all_companies() self.assertEquals(len(companies), 3) controller_nums = [49020, 49011, 49189] for contract in contracts: self.assertTrue(contract.financial_id in controller_nums) controller_nums.remove(contract.financial_id) self.assertEquals(len(controller_nums), 0)
def import_nigp(filepath): from purchasing.data.importer.nigp import main print 'Importing data from {filepath}\n'.format(filepath=filepath) main(filepath) print 'Import finished!' return
def scrape(_all): from purchasing.data.importer.scrape_county import main print 'Scraping County' main(_all) print 'Scraping Finished' return
def scrape(_all): from purchasing.data.importer.scrape_county import main print 'Scraping County' main(_all) print 'Scraping Finished' return
def import_nigp(filepath): from purchasing.data.importer.nigp import main print 'Importing data from {filepath}\n'.format(filepath=filepath) main(filepath) print 'Import finished!' return