1 files changed, 91 insertions, 0 deletions
diff --git a/odb-tests/README.md b/odb-tests/README.md
new file mode 100644
index 0000000..0dd2417
--- /dev/null
+++ b/odb-tests/README.md
@@ -0,0 +1,91 @@
+# odb-tests - ODB tests
+
+ODB is an open-source, cross-platform, and cross-database object-relational
+mapping (ORM) system for C++. It allows you to persist C++ classes to a
+relational database without having to deal with tables, columns, or SQL and
+without manually writing any mapping code.
+
+For further information, including licensing conditions, documentation, and
+binary packages, refer to the [ODB project
+page](https://codesynthesis.com/products/odb/).
+
+This package contains tests for the ODB compiler as well as runtime and
+profile libraries.
+
+## Setting up PostgreSQL for running tests
+
+1. Install the PostgreSQL server. On Linux this is normally done using
+   distribution packages.
+
+2. In `/etc/postgresql/N/main/pg_hba.conf` add the following line after the
+   `local all postgres ...` line:
+
+   ```
+   local   odb_test        odb_test                                trust
+   ```
+
+   If you want to be able to run tests on a different host and access
+   PostgreSQL via TCP/IP, also add the following line (adjusting the IP
+   network to match your setup -- never specify a public IP network here since
+   the access is unauthenticated):
+
+   ```
+   host    odb_test        odb_test        192.168.0.0/24          trust
+   ```
+
+   You will also need to edit `/etc/postgresql/N/main/postgresql.conf` and
+   change `listen_address` to `*`. You may also need to open port `5432` in
+   your firewall.
+
+   Restart the PostgreSQL server.
+
+3. Add the `odb_test` user and the `odb_test` database.
+
+   First login:
+
+   ```
+   sudo -u postgres psql
+   ```
+
+   Then execute the following statements:
+
+   ```
+   CREATE USER odb_test;
+   CREATE DATABASE odb_test;
+   GRANT ALL PRIVILEGES ON DATABASE odb_test TO odb_test;
+   \c odb_test
+   GRANT ALL PRIVILEGES ON SCHEMA public TO odb_test;
+   ```
+
+## Setting up MySQL for running tests
+
+1. Install the MySQL server. On Linux this is normally done using distribution
+   packages.
+
+2. Setup remote access (optional).
+
+   If you want to be able to run tests on a different host and access MySQL
+   via TCP/IP (never do this on a public server since the access is
+   unauthenticated), then edit `/etc/mysql/.../mysqld.cnf`, the `[mysqld]`
+   section, and change `bind-address` to `0.0.0.0`. You may also need to open
+   port `3306` in your firewall.
+
+   Restart the MySQL server.
+
+3. Add the `odb_test` user and the `odb_test` database.
+
+   First login:
+
+   ```
+   sudo mysql
+   ```
+
+   Then execute the following statements:
+
+   ```
+   CREATE USER odb_test@'%';
+   CREATE USER odb_test@'localhost';
+   CREATE DATABASE odb_test;
+   GRANT ALL PRIVILEGES ON odb_test.* TO odb_test@'%';
+   FLUSH PRIVILEGES;
+   ```