pgloader/test
2022-06-26 23:32:55 +02:00
..
citus Finish implementation of CAST rules for PostgreSQL source databases. 2018-11-19 19:33:37 +01:00
data Improve DBF support. 2019-05-11 20:50:52 +02:00
mysql Add a MySQL use case. 2020-03-22 15:20:19 +01:00
parse Allow package prefix in CAST ... USING clause. 2016-02-04 16:09:22 +01:00
regress Improve sexp parser and standard symbols support. 2019-05-14 15:49:24 +02:00
sqlite Add support for DATETIME() function call as a SQLite default values. 2020-07-03 18:39:37 +02:00
allcols.load Review field to column projection code emitted. 2018-11-10 20:22:04 +01:00
archive.load Add support for PostgreSQL as a source database. 2018-08-20 11:09:52 +02:00
bossa-all.load Improve tests and add test cases. 2013-11-26 16:48:45 +01:00
bossa.load Update an old archive test case. 2016-08-28 20:29:30 +02:00
bossa.sql Improve tests and add test cases. 2013-11-26 16:48:45 +01:00
census-places.load Fix census-places URL location of the source file. 2015-04-17 21:58:19 +02:00
copy-hex.load Implement more COPY options, fix #218. 2015-04-30 14:30:16 +02:00
copy.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
csv-before-after.load Fix quoting of TRUNCATE command, fix #84. 2014-06-20 13:10:39 +02:00
csv-districts-env.load Add a new test case for {{ENVVAR}} template support. 2018-02-20 14:45:07 +01:00
csv-districts-stdin.load Fix loading data from stdin: fix #53. 2014-04-27 23:38:02 +02:00
csv-districts.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
csv-error.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
csv-escape-mode.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
csv-filename-pattern.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
csv-guess.load Fix test/csv-guess.load for old PostgreSQL. 2017-09-09 00:59:39 +02:00
csv-header.load Allow fields/columns projections when parsing header. 2019-01-15 22:39:08 +01:00
csv-hstore.load Don't double-quote identifiers in catalog queries. 2017-01-10 21:12:34 +01:00
csv-json.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
csv-keep-extra-blanks.load Switch to the newer cl-csv API. 2014-01-11 18:28:24 +01:00
csv-missing-col.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
csv-newline.load Implement new CSV option "lines terminated by", fixes #23. 2014-02-04 20:58:46 +01:00
csv-non-printable.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
csv-null-if.load Implement null if support as a WITH option. 2018-11-13 21:41:27 +01:00
csv-nulls.load Square brackets around source field options are now mandatory. 2014-10-02 01:17:24 +02:00
csv-parse-date.load Accept even more ragged date format input. 2018-09-10 19:37:36 +02:00
csv-temp.load Improve user code parsing, fix #297. 2015-09-21 13:23:21 +02:00
csv-trim-extra-blanks.load Switch to the newer cl-csv API. 2014-01-11 18:28:24 +01:00
csv-using-sexp.load Improve sexp parser and standard symbols support. 2019-05-14 15:49:24 +02:00
csv.load Handle camelCase column names for CSV, fix #79 again. 2014-06-16 17:33:14 +02:00
dbf-8b.load Add the new DBF tests in the test suite. 2019-05-11 22:13:18 +02:00
dbf-31.load Add the new DBF tests in the test suite. 2019-05-11 22:13:18 +02:00
dbf-memo.load Add the new DBF tests in the test suite. 2019-05-11 22:13:18 +02:00
dbf-zip.load Add the new DBF tests in the test suite. 2019-05-11 22:13:18 +02:00
dbf.load Refrain from using fancy schema names in the regression tests. 2019-05-12 00:10:28 +02:00
errors.load Travis: adapt to PostgreSQL 9.1, again. 2015-11-23 22:09:08 +01:00
fields-with-periods.load Accept periods in CSV field names 2015-05-15 07:22:07 -07:00
fixed-guess.dat Implement header parsing for fixed file formats. 2019-05-07 22:57:55 +02:00
fixed-guess.load Implement header parsing for fixed file formats. 2019-05-07 22:57:55 +02:00
fixed.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
geolite.sql Implement BEFORE/AFTER LOAD EXECUTE 'filename'. 2014-05-04 23:04:45 +02:00
ixf.load Add support for explicit TARGET TABLE clause in load commands. 2017-08-25 01:57:54 +02:00
Makefile Remove regression output on clean 2022-06-26 23:32:55 +02:00
nofile.load Improve tests and add test cases. 2013-11-26 16:48:45 +01:00
overflow.load Add automated regression tests. 2014-06-03 12:19:23 +02:00
partial.load test: Create csv schema in partial.load 2022-06-24 10:39:15 +02:00
pgsql-source.load Fix bugs in the recent extended support for materialized views. 2018-12-28 10:53:01 +01:00
pkey.load Reproduce a test case from issue #795. 2018-06-15 22:14:04 +02:00
README.md All included test data has been verified as free, stop building a +dfsg tarball. 2018-07-03 16:37:43 +02:00
reformat.load Improve database connection parsing to use sensible defaults. 2013-10-19 22:39:09 +02:00
sakila-data.load Allow ALTER SCHEMA command for MySQL. 2016-12-18 19:31:21 +01:00
sakila.load Implement sslmode for MySQL connections. 2017-08-24 14:56:59 +02:00
serial.load Improve database connection parsing to use sensible defaults. 2013-10-19 22:39:09 +02:00
simple.load Add sample data for fields escaped by double-quote. 2018-04-29 19:05:52 +02:00
sqlite-base64.load Fix "drop default" casting rules for all databases. 2018-02-08 23:33:51 +01:00
sqlite-chinook-noseq.load Assorted fixes for SQLite. 2018-02-08 22:55:15 +01:00
sqlite-chinook.load Add support for preserving index names in SQLite. 2017-07-17 11:04:12 +02:00
sqlite-env.load Implement a template system for pgloader commands. 2017-08-16 01:33:11 +02:00
sqlite-testpk.load Refactor error handling in complete-pgsql-database. 2017-06-08 12:09:11 +02:00
sqlite.ini Implement a template system for pgloader commands. 2017-08-16 01:33:11 +02:00
sqlite.load Implement a new “snake_case” quoting rule. 2017-09-13 22:55:10 +02:00
udc.load Improve parsing of list separating commas wrt to whitespacing. 2013-11-23 21:49:08 +01:00
xzero.load Square brackets around source field options are now mandatory. 2014-10-02 01:17:24 +02:00

pgloader tests

In the parser directory are tests for the parser only, in the current directory are tests that can be run to import data.

Licenses

Chinook Database

Copyright (c) 2008-2017 Luis Rocha

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

2013_Gaz_113CDs_national

All U.S. Census Bureau materials, regardless of the media, are entirely in the public domain. There are no user fees, site licenses, or any special agreements etc for the public or private use, and or reuse of any census title. As tax funded product, it's all in the public record.

reg2013.dbf

https://www.insee.fr/fr/information/2008466

Les publications et données mises à disposition sur le présent site sont consultables et téléchargeables gratuitement. Sauf spécification contraire, elles peuvent être réutilisées, y compris à des fins commerciales, sans licence et sans versement de redevances autres que celles collectées par les sociétés de perception et de répartition des droits d'auteur régies par le titre II du livre III du code de la propriété intellectuelle. La réutilisation est toutefois subordonnée au respect de l'intégrité de l'information et des données et à la mention précise des sources.

Sakila Sample Database

The contents of the sakila-schema.sql and sakila-data.sql files are licensed under the New BSD license.

Information on the New BSD license can be found at http://www.opensource.org/licenses/bsd-license.php and http://en.wikipedia.org/wiki/BSD_License.

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

  1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.

  2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.