From e9256c44727941ec5d7611249356b2bfb6019ae5 Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Wed, 25 Jun 2025 13:01:55 -0400 Subject: [PATCH] Improving the datetest set --- sql/datatest.def | 15 +++++++++++++++ sql/datatest.mardb.sql | 6 ++++++ sql/datatest.posdb.sql | 6 ++++++ sql/datatest.sql | 15 ++------------- 4 files changed, 29 insertions(+), 13 deletions(-) create mode 100644 sql/datatest.def create mode 100644 sql/datatest.mardb.sql create mode 100644 sql/datatest.posdb.sql diff --git a/sql/datatest.def b/sql/datatest.def new file mode 100644 index 0000000..c2f751c --- /dev/null +++ b/sql/datatest.def @@ -0,0 +1,15 @@ +//------------------------------------------------------------------ +//include file to ajuste result according database +//------------------------------------------------------------------ +#ifdef POSTGRESQL +#define ADDTIME(adding) 'adding' +#define CONCAT(A,B) A||B +#define INET_ATON(A) A +#define ENCRYPT(A,B) encrypt(A,B,'aes') +#endif +#ifdef MYSQL +#define ADDTIME(adding) INTERVAL adding +#define CONCAT(A,B) concat(A,B) +#define INET_ATON(A) inet_aton(A) +#define ENCRYPT(A,B) encrypt(A,B) +#endif diff --git a/sql/datatest.mardb.sql b/sql/datatest.mardb.sql new file mode 100644 index 0000000..888154e --- /dev/null +++ b/sql/datatest.mardb.sql @@ -0,0 +1,6 @@ + +#include "datatest.def" + +//adding a list of local email +INSERT INTO emails (email) values ('user1@mardb.example.com'); +INSERT INTO emails (email) values ('user2@mardb.example.com'); diff --git a/sql/datatest.posdb.sql b/sql/datatest.posdb.sql new file mode 100644 index 0000000..0f56876 --- /dev/null +++ b/sql/datatest.posdb.sql @@ -0,0 +1,6 @@ + +#include "datatest.def" + +//adding a list of local email +INSERT INTO emails (email) values ('user1@posdb.example.com'); +INSERT INTO emails (email) values ('user2@posdb.example.com'); diff --git a/sql/datatest.sql b/sql/datatest.sql index be869a5..8e8c244 100644 --- a/sql/datatest.sql +++ b/sql/datatest.sql @@ -1,16 +1,5 @@ -/*addon for test purpose only */ -#ifdef POSTGRESQL -#define ADDTIME(adding) 'adding' -#define CONCAT(A,B) A||B -#define INET_ATON(A) A -#define ENCRYPT(A,B) encrypt(A,B,'aes') -#endif -#ifdef MYSQL -#define ADDTIME(adding) INTERVAL adding -#define CONCAT(A,B) concat(A,B) -#define INET_ATON(A) inet_aton(A) -#define ENCRYPT(A,B) encrypt(A,B) -#endif + +#include "datatest.def" //adding a list of local email INSERT INTO emails (email) values ('postmaster@example.com'); -- 2.47.3