newdevs:code:import_csv_into_db
This is an old revision of the document!
Import Data from a CSV file into database tables
The Concerto database isn't very large, and sometimes you need to test things with more data. If you can pull and anonymize production-level data (but not too much to crash your test server), you can copy it into place with a CSV file.
1. Log into the database as the root user.
2. Create a placeholder schema for your project.
CREATE SCHEMA tlittle;
3. Create a placeholder table for your data to start in, and name the columns–including their datatype–for your table.
create table tlittle.acqprolist (name text, owner integer, currency_type text, code text, active boolean, prepayment_required boolean, default_copy_count integer);
Make sure to include, at minimum, any required fields in your final table. This example is based on acq.provider, so these are the required fields in acq.provider.
newdevs/code/import_csv_into_db.1677521355.txt.gz · Last modified: 2023/02/27 13:09 by tlittle