[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 53/73: Code Rewriting : rename Noalyss_SQL cl
|
From: |
Dany De Bontridder |
|
Subject: |
[Noalyss-commit] [noalyss] 53/73: Code Rewriting : rename Noalyss_SQL class by Table_Data_SQL |
|
Date: |
Fri, 28 May 2021 05:26:42 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 769634cf9db96082b189ee6e962c2cba6dbccd01
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Fri May 7 15:43:37 2021 +0200
Code Rewriting : rename Noalyss_SQL class by Table_Data_SQL
---
.../database/action_gestion_comment_sql.class.php | 4 +-
include/database/action_gestion_sql.class.php | 4 +-
include/database/anc_key_sql.class.php | 10 +-
include/database/attr_def_sql.class.php | 4 +-
include/database/contact_option_ref_sql.class.php | 4 +-
include/database/currency_history_sql.class.php | 4 +-
include/database/default_menu_sql.class.php | 4 +-
include/database/document_state_sql.class.php | 4 +-
include/database/document_type_sql.class.php | 4 +-
include/database/fiche_def_ref_sql.class.php | 4 +-
include/database/forecast_category_sql.class.php | 4 +-
include/database/forecast_item_sql.class.php | 4 +-
include/database/forecast_sql.class.php | 4 +-
include/database/jrn_def_sql.class.php | 4 +-
include/database/jrn_periode_sql.class.php | 4 +-
include/database/menu_ref_sql.class.php | 4 +-
include/database/op_predef_sql.class.php | 4 +-
include/database/operation_currency_sql.class.php | 4 +-
include/database/parameter_extra_sql.class.php | 4 +-
include/database/parm_periode_sql.class.php | 4 +-
include/database/payment_method_sql.class.php | 4 +-
include/database/poste_analytique_sql.class.php | 4 +-
include/database/profile_menu_sql.class.php | 4 +-
include/database/profile_sql.class.php | 4 +-
include/database/stock_goods_sql.class.php | 6 +-
include/database/stock_sql.class.php | 4 +-
include/database/tag_group_sql.class.php | 4 +-
include/database/tag_sql.class.php | 4 +-
include/database/tmp_pcmn_sql.class.php | 4 +-
include/database/tva_rate_sql.class.php | 4 +-
include/database/user_filter_sql.class.php | 4 +-
.../database/v_currency_last_value_sql.class.php | 2 +-
include/database/v_tva_rate_sql.class.php | 4 +-
include/lib/impress.class.php | 20 +-
include/lib/noalyss_sql.class.php | 291 +---------
...lyss_sql.class.php => table_data_sql.class.php} | 6 +-
scenario/test_parse_formula.php | 15 +-
unit-test/include/lib/databaseTest.class.php | 620 ---------------------
...LTest.class.php => table_sql_sqlTest.class.php} | 0
39 files changed, 108 insertions(+), 982 deletions(-)
diff --git a/include/database/action_gestion_comment_sql.class.php
b/include/database/action_gestion_comment_sql.class.php
index 532acb9..2a734ae 100644
--- a/include/database/action_gestion_comment_sql.class.php
+++ b/include/database/action_gestion_comment_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -26,7 +26,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
* @file
* @brief abstract of the table public.action_gestion_comment */
-class Action_Gestion_Comment_SQL extends Noalyss_SQL
+class Action_Gestion_Comment_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/action_gestion_sql.class.php
b/include/database/action_gestion_sql.class.php
index 97d51b3..99833ca 100644
--- a/include/database/action_gestion_sql.class.php
+++ b/include/database/action_gestion_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -26,7 +26,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
* @file
* @brief abstract of the table public.action_gestion */
-class Action_gestion_SQL extends Noalyss_SQL
+class Action_gestion_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/anc_key_sql.class.php
b/include/database/anc_key_sql.class.php
index 5a2bc2d..0a6a539 100644
--- a/include/database/anc_key_sql.class.php
+++ b/include/database/anc_key_sql.class.php
@@ -23,13 +23,13 @@
* @brief Class to manage distribution keys for SQL.
*
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
/**
* @brief Manage the table key_distribution.
*/
-class Anc_Key_SQL extends Noalyss_SQL
+class Anc_Key_SQL extends Table_Data_SQL
{
function __construct($p_cn, $p_id = -1)
@@ -62,7 +62,7 @@ class Anc_Key_SQL extends Noalyss_SQL
/**
* @brief manage table key_distribution_ledger
*/
-class Anc_Key_Ledger_SQL extends Noalyss_SQL
+class Anc_Key_Ledger_SQL extends Table_Data_SQL
{
function __construct(&$p_cn, $p_id = -1)
{
@@ -93,7 +93,7 @@ class Anc_Key_Ledger_SQL extends Noalyss_SQL
/**
* @brief manage table key_distribution_detail
*/
-class Anc_Key_Detail_SQL extends Noalyss_SQL
+class Anc_Key_Detail_SQL extends Table_Data_SQL
{
function __construct(&$p_cn, $p_id = -1)
{
@@ -128,7 +128,7 @@ class Anc_Key_Detail_SQL extends Noalyss_SQL
/**
* @brief manage table key_distribution_activity
*/
-class Anc_Key_Activity_SQL extends Noalyss_SQL
+class Anc_Key_Activity_SQL extends Table_Data_SQL
{
function __construct($p_cn, $p_id = -1)
{
diff --git a/include/database/attr_def_sql.class.php
b/include/database/attr_def_sql.class.php
index c4160b6..9327f5d 100644
--- a/include/database/attr_def_sql.class.php
+++ b/include/database/attr_def_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -26,7 +26,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
* @file
* @brief abstract of the table public.attr_def */
-class Attr_def_SQL extends Noalyss_SQL
+class Attr_def_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/contact_option_ref_sql.class.php
b/include/database/contact_option_ref_sql.class.php
index 969235f..a431e2b 100644
--- a/include/database/contact_option_ref_sql.class.php
+++ b/include/database/contact_option_ref_sql.class.php
@@ -20,7 +20,7 @@
*/
// Copyright (2002-2020) Author Dany De Bontridder <danydb@noalyss.eu>
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -28,7 +28,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
* @file
* @brief abstract of the table public.contact_option_ref */
-class Contact_option_ref_SQL extends Noalyss_SQL
+class Contact_option_ref_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/currency_history_sql.class.php
b/include/database/currency_history_sql.class.php
index 5bc95e0..5d217e8 100644
--- a/include/database/currency_history_sql.class.php
+++ b/include/database/currency_history_sql.class.php
@@ -19,7 +19,7 @@
*/
// Copyright (2018) Author Dany De Bontridder <dany@alchimerys.be>
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -27,7 +27,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
* @file
* @brief abstract of the table public.currency_history */
-class Currency_history_SQL extends Noalyss_SQL
+class Currency_history_SQL extends Table_Data_SQL
{
function __construct(Database $p_cn, $p_id=-1)
diff --git a/include/database/default_menu_sql.class.php
b/include/database/default_menu_sql.class.php
index 4f3f5ca..e885bce 100644
--- a/include/database/default_menu_sql.class.php
+++ b/include/database/default_menu_sql.class.php
@@ -23,9 +23,9 @@
*
* @author dany
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
-class Default_Menu_SQL extends Noalyss_SQL
+class Default_Menu_SQL extends Table_Data_SQL
{
var $md_id;
var $md_code;
diff --git a/include/database/document_state_sql.class.php
b/include/database/document_state_sql.class.php
index a4fbef9..50d04df 100644
--- a/include/database/document_state_sql.class.php
+++ b/include/database/document_state_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -26,7 +26,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
* @file
* @brief abstract of the table public.document_state */
-class Document_State_SQL extends Noalyss_SQL
+class Document_State_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/document_type_sql.class.php
b/include/database/document_type_sql.class.php
index 36e2d5b..d9ebc41 100644
--- a/include/database/document_type_sql.class.php
+++ b/include/database/document_type_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -32,7 +32,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
* @class
* @brief abstract of the table public.document_type
*/
-class Document_type_SQL extends Noalyss_SQL
+class Document_type_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/fiche_def_ref_sql.class.php
b/include/database/fiche_def_ref_sql.class.php
index c895dde..7088dbd 100644
--- a/include/database/fiche_def_ref_sql.class.php
+++ b/include/database/fiche_def_ref_sql.class.php
@@ -23,7 +23,7 @@
* @brief Manage the table public.fiche_def_ref , which concerns the template
of
* category of card
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -31,7 +31,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
* @file Manage the table public.fiche_def_ref , which concerns the template of
* category of card
*/
-class Fiche_def_ref_SQL extends Noalyss_SQL
+class Fiche_def_ref_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/forecast_category_sql.class.php
b/include/database/forecast_category_sql.class.php
index f35594f..35e9a41 100644
--- a/include/database/forecast_category_sql.class.php
+++ b/include/database/forecast_category_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE . '/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE . '/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE . '/class/database.class.php';
@@ -28,7 +28,7 @@ require_once NOALYSS_INCLUDE . '/class/database.class.php';
* @file
* @brief abstract of the table public.forecast_category
*/
-class Forecast_Category_SQL extends Noalyss_SQL
+class Forecast_Category_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id = -1)
diff --git a/include/database/forecast_item_sql.class.php
b/include/database/forecast_item_sql.class.php
index 0bafd8c..4af85ae 100644
--- a/include/database/forecast_item_sql.class.php
+++ b/include/database/forecast_item_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -27,7 +27,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
* @file
* @brief abstract of the table public.forecast_item
*/
-class Forecast_Item_SQL extends Noalyss_SQL
+class Forecast_Item_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/forecast_sql.class.php
b/include/database/forecast_sql.class.php
index 31e5153..d4fcebe 100644
--- a/include/database/forecast_sql.class.php
+++ b/include/database/forecast_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE . '/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE . '/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE . '/class/database.class.php';
@@ -28,7 +28,7 @@ require_once NOALYSS_INCLUDE . '/class/database.class.php';
* @file
* @brief abstract of the table public.forecast
*/
-class Forecast_SQL extends Noalyss_SQL
+class Forecast_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id = -1)
diff --git a/include/database/jrn_def_sql.class.php
b/include/database/jrn_def_sql.class.php
index 0057e8e..d3c3208 100644
--- a/include/database/jrn_def_sql.class.php
+++ b/include/database/jrn_def_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -26,7 +26,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
* @file
* @brief abstract of the table public.jrn_def */
-class Jrn_def_SQL extends Noalyss_SQL
+class Jrn_def_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/jrn_periode_sql.class.php
b/include/database/jrn_periode_sql.class.php
index 4dfe905..4beed61 100644
--- a/include/database/jrn_periode_sql.class.php
+++ b/include/database/jrn_periode_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
@@ -31,7 +31,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
* @brief abstract of the table public.jrn_periode
*/
-class Jrn_periode_SQL extends Noalyss_SQL
+class Jrn_periode_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/menu_ref_sql.class.php
b/include/database/menu_ref_sql.class.php
index c597c9c..3c2eb81 100644
--- a/include/database/menu_ref_sql.class.php
+++ b/include/database/menu_ref_sql.class.php
@@ -27,12 +27,12 @@
*/
require_once NOALYSS_INCLUDE.'/class/database.class.php';
require_once NOALYSS_INCLUDE.'/lib/ac_common.php';
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
/**
* @brief Manage the table public.menu_ref
*/
-class Menu_Ref_SQL extends Noalyss_SQL
+class Menu_Ref_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore &$p_cn, $p_id=-1)
diff --git a/include/database/op_predef_sql.class.php
b/include/database/op_predef_sql.class.php
index 3bf2c80..3c19e49 100644
--- a/include/database/op_predef_sql.class.php
+++ b/include/database/op_predef_sql.class.php
@@ -17,7 +17,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
@@ -26,7 +26,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
*@file
*@brief abstract of the table public.op_predef */
-class Op_predef_SQL extends Noalyss_SQL
+class Op_predef_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn,$p_id=-1)
diff --git a/include/database/operation_currency_sql.class.php
b/include/database/operation_currency_sql.class.php
index 2aaaf43..2fd69ef 100644
--- a/include/database/operation_currency_sql.class.php
+++ b/include/database/operation_currency_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -27,7 +27,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
* @file
* @brief abstract of the table public.operation_currency
*/
-class Operation_currency_SQL extends Noalyss_SQL
+class Operation_currency_SQL extends Table_Data_SQL
{
function __construct(Database $p_cn, $p_id=-1)
diff --git a/include/database/parameter_extra_sql.class.php
b/include/database/parameter_extra_sql.class.php
index 91c1ab1..d92a5f2 100644
--- a/include/database/parameter_extra_sql.class.php
+++ b/include/database/parameter_extra_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
@@ -27,7 +27,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
*@file
*@brief abstract of the table public.parameter_extra */
-class Parameter_Extra_SQL extends Noalyss_SQL
+class Parameter_Extra_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn,$p_id=-1)
diff --git a/include/database/parm_periode_sql.class.php
b/include/database/parm_periode_sql.class.php
index c9fc7ac..4cb10ec 100644
--- a/include/database/parm_periode_sql.class.php
+++ b/include/database/parm_periode_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
@@ -32,7 +32,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
* *@brief Manage the table public.parm_periode
*/
-class Parm_periode_SQL extends Noalyss_SQL
+class Parm_periode_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn,$p_id=-1)
diff --git a/include/database/payment_method_sql.class.php
b/include/database/payment_method_sql.class.php
index 52adfa7..95fd645 100644
--- a/include/database/payment_method_sql.class.php
+++ b/include/database/payment_method_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -29,7 +29,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
* @brief abstract of the table public.payment_method
*/
-class Payment_method_SQL extends Noalyss_SQL
+class Payment_method_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/poste_analytique_sql.class.php
b/include/database/poste_analytique_sql.class.php
index ed17f4d..d3d883e 100644
--- a/include/database/poste_analytique_sql.class.php
+++ b/include/database/poste_analytique_sql.class.php
@@ -30,9 +30,9 @@
* @brief abstract of the table public.poste_analytique */
require_once NOALYSS_INCLUDE.'/class/database.class.php';
require_once NOALYSS_INCLUDE.'/lib/ac_common.php';
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
-class Poste_analytique_SQL extends Noalyss_SQL
+class Poste_analytique_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/profile_menu_sql.class.php
b/include/database/profile_menu_sql.class.php
index 6189fb9..cfd92d9 100644
--- a/include/database/profile_menu_sql.class.php
+++ b/include/database/profile_menu_sql.class.php
@@ -30,12 +30,12 @@
*/
require_once NOALYSS_INCLUDE.'/class/database.class.php';
require_once NOALYSS_INCLUDE.'/lib/ac_common.php';
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
/**
* @brief Manage the table public.profile_menu
*/
-class Profile_Menu_sql extends Noalyss_SQL
+class Profile_Menu_sql extends Table_Data_SQL
{
function __construct(&$p_cn,$p_id=-1)
diff --git a/include/database/profile_sql.class.php
b/include/database/profile_sql.class.php
index 33ecc49..358bc22 100644
--- a/include/database/profile_sql.class.php
+++ b/include/database/profile_sql.class.php
@@ -30,12 +30,12 @@
*/
require_once NOALYSS_INCLUDE.'/class/database.class.php';
require_once NOALYSS_INCLUDE.'/lib/ac_common.php';
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
/**
* @brief Manage the table public.profile
*/
-class Profile_sql extends Noalyss_SQL
+class Profile_sql extends Table_Data_SQL
{
/* example private
$variable=array("easy_name"=>column_name,"email"=>"column_name_email","val3"=>0);
*/
diff --git a/include/database/stock_goods_sql.class.php
b/include/database/stock_goods_sql.class.php
index 9fae500..5122ade 100644
--- a/include/database/stock_goods_sql.class.php
+++ b/include/database/stock_goods_sql.class.php
@@ -25,9 +25,9 @@
* @brief
*
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
-class Stock_Goods_Sql extends Noalyss_SQL
+class Stock_Goods_Sql extends Table_Data_SQL
{
function __construct($cn,$p_id = -1)
@@ -81,7 +81,7 @@ class Stock_Goods_Sql extends Noalyss_SQL
}
-class Stock_Change_Sql extends Noalyss_SQL
+class Stock_Change_Sql extends Table_Data_SQL
{
function __construct($cn,$p_id = -1)
diff --git a/include/database/stock_sql.class.php
b/include/database/stock_sql.class.php
index 2e56828..ad23de2 100644
--- a/include/database/stock_sql.class.php
+++ b/include/database/stock_sql.class.php
@@ -25,9 +25,9 @@
* @brief
*
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
-class Stock_Sql extends Noalyss_SQL {
+class Stock_Sql extends Table_Data_SQL {
function __construct($cn,$p_id=-1)
{
$this->table = "public.stock_repository";
diff --git a/include/database/tag_group_sql.class.php
b/include/database/tag_group_sql.class.php
index ec82ded..f3103a5 100644
--- a/include/database/tag_group_sql.class.php
+++ b/include/database/tag_group_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
@@ -27,7 +27,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
*
*@file
*@brief abstract of the table public.tag_group */
-class Tag_group_SQL extends Noalyss_SQL
+class Tag_group_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn,$p_id=-1)
diff --git a/include/database/tag_sql.class.php
b/include/database/tag_sql.class.php
index 9876b9c..1f21324 100644
--- a/include/database/tag_sql.class.php
+++ b/include/database/tag_sql.class.php
@@ -1,7 +1,7 @@
<?php
require_once NOALYSS_INCLUDE.'/class/database.class.php';
require_once NOALYSS_INCLUDE.'/lib/ac_common.php';
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
/*
* This file is part of NOALYSS.
*
@@ -23,7 +23,7 @@ require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
/**
* @brief Manage the table public.tag
*/
-class Tag_SQL extends Noalyss_SQL
+class Tag_SQL extends Table_Data_SQL
{
/* example private
$variable=array("easy_name"=>column_name,"email"=>"column_name_email","val3"=>0);
*/
diff --git a/include/database/tmp_pcmn_sql.class.php
b/include/database/tmp_pcmn_sql.class.php
index ed77c7f..c39ebb8 100644
--- a/include/database/tmp_pcmn_sql.class.php
+++ b/include/database/tmp_pcmn_sql.class.php
@@ -24,8 +24,8 @@
* @brief
*
*/
-require_once NOALYSS_INCLUDE."/lib/noalyss_sql.class.php";
-class Tmp_Pcmn_SQL extends Noalyss_SQL
+require_once NOALYSS_INCLUDE."/lib/table_data_sql.class.php";
+class Tmp_Pcmn_SQL extends Table_Data_SQL
{
/**
diff --git a/include/database/tva_rate_sql.class.php
b/include/database/tva_rate_sql.class.php
index 9ad5d69..27f018e 100644
--- a/include/database/tva_rate_sql.class.php
+++ b/include/database/tva_rate_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -28,7 +28,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
* @brief abstract of the table public.tva_rate
*
*/
-class Tva_rate_SQL extends Noalyss_SQL
+class Tva_rate_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/user_filter_sql.class.php
b/include/database/user_filter_sql.class.php
index d43e3c5..b647533 100644
--- a/include/database/user_filter_sql.class.php
+++ b/include/database/user_filter_sql.class.php
@@ -19,7 +19,7 @@
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
* author : Dec 2017 , Dany De Bontridder (danydb@noalyss.eu)
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -28,7 +28,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
* @file
* @brief abstract of the table public.user_filter
*/
-class User_filter_SQL extends Noalyss_SQL
+class User_filter_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/database/v_currency_last_value_sql.class.php
b/include/database/v_currency_last_value_sql.class.php
index 1b2387c..4694927 100644
--- a/include/database/v_currency_last_value_sql.class.php
+++ b/include/database/v_currency_last_value_sql.class.php
@@ -19,7 +19,7 @@
*/
// Copyright (2018) Author Dany De Bontridder <dany@alchimerys.be>
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
diff --git a/include/database/v_tva_rate_sql.class.php
b/include/database/v_tva_rate_sql.class.php
index 0b3de4c..1af81da 100644
--- a/include/database/v_tva_rate_sql.class.php
+++ b/include/database/v_tva_rate_sql.class.php
@@ -18,7 +18,7 @@
* along with NOALYSS; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
-require_once NOALYSS_INCLUDE.'/lib/noalyss_sql.class.php';
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
require_once NOALYSS_INCLUDE.'/class/database.class.php';
/**
@@ -28,7 +28,7 @@ require_once NOALYSS_INCLUDE.'/class/database.class.php';
* @brief abstract of the view public.v_tva_rate
*
*/
-class V_Tva_Rate_SQL extends Noalyss_SQL
+class V_Tva_Rate_SQL extends Table_Data_SQL
{
function __construct(DatabaseCore $p_cn, $p_id=-1)
diff --git a/include/lib/impress.class.php b/include/lib/impress.class.php
index e03a1a4..81505e5 100644
--- a/include/lib/impress.class.php
+++ b/include/lib/impress.class.php
@@ -18,16 +18,22 @@
*/
// Copyright Author Dany De Bontridder danydb@aevalys.eu
-/*!\file
- * \brief contains function for the printing
-*/
+/*!
+ * \file
+ * \brief contains function for the parsing and computing formulae. Test are
in scenario/test_parse_formula.php
+ */
require_once NOALYSS_INCLUDE.'/class/periode.class.php';
require_once NOALYSS_INCLUDE.'/lib/noalyss_csv.class.php';
-
+/**
+ * @class
+ * @brief contains function for the parsing and computing formulae . Test are
in scenario/test_parse_formula.php
+ */
class Impress
{
- /*! \brief Purpose Parse a formula
+ /*!
+ *
+ * \brief Purpose Parse a formula
*
* \param $p_cn connexion
* \param $p_label
@@ -238,10 +244,10 @@ class Impress
$p_string= preg_replace("/\+|-|\/|\*/", "", $p_string);
$p_string= preg_replace("/[0-9]*\.*[0-9]/", "", $p_string);
-
//********************************************************************************************************************
+
//************************************************************************************************************
// If the string is empty then formula should be good
//
-
//********************************************************************************************************************
+
//************************************************************************************************************
if ($p_string == '')
{
return true;
diff --git a/include/lib/noalyss_sql.class.php
b/include/lib/noalyss_sql.class.php
index 3c79b41..4926b7a 100644
--- a/include/lib/noalyss_sql.class.php
+++ b/include/lib/noalyss_sql.class.php
@@ -1,5 +1,4 @@
<?php
-
/*
* This file is part of NOALYSS.
*
@@ -20,286 +19,22 @@
// Copyright Author Dany De Bontridder danydb@aevalys.eu
+require_once NOALYSS_INCLUDE.'/lib/table_data_sql.class.php';
+
/**
- * @file
- * @brief this wrapper is used to created easily a wrapper to a table
- * You must create a class extending this one, in the constructor
- * these variables have to be defined
+ * @file
+ * @brief deprecated Noalyss_SQL class
*
- * - table = name of the view or empty
- * - select = name of the select
- * - name = array of column name, match between logic and actual name
- * - type = array , match between column and type of data
- * - default = array of column with a default value
- * - date_format = format of the date
- *
- * After you call the parent constructor
- * @note the view or the table must include an unique key, otherwise the load
- * doesn't work.
- *
- * @class Noalyss_SQL
- * Match a table or a view into an object, you need to add the code for each
table
- * @note : the primary key must be an integer
- *
- * @code
- class table_name_sql extends Noalyss_SQL
- {
-
- function __construct($p_id=-1)
- {
- $this->table = "schema.table";
- $this->primary_key = "o_id";
-
- $this->name=array(
- "id"=>"o_id",
- "program"=>"o_prog",
- "date"=>"o_date",
- "qcode"=>"o_qcode",
- "fiche"=>"f_id",
-
-
- );
-
- $this->type = array(
- "o_id"=>"numeric",
- "o_prog"=>"numeric",
- "o_date"=>"date",
- "o_qcode"=>"text",
- "f_id"=>"numeric",
-
- );
-
- $this->default = array(
- "o_id" => "auto",
- );
- $this->date_format = "DD.MM.YYYY";
- global $cn;
-
- parent::__construct($cn,$p_id);
- }
-
- }
- * @endcode
- *
*/
-require NOALYSS_INCLUDE."/lib/data_sql.class.php";
-abstract class Noalyss_SQL extends Data_SQL
+/**
+ * @class
+ * @brief this class is deprecated and inherits from Table_Data_SQL. It
remains only for compatibility
+ * purpose
+ * @see Table_Data_SQL
+ * @deprecated since version 9.0
+ */
+class Noalyss_SQL extends Table_Data_SQL
{
-
- function __construct($p_cn, $p_id=-1)
- {
- parent::__construct($p_cn, $p_id);
-
- }
-
-
- public function insert()
- {
- $this->verify();
- $sql="insert into ".$this->table." ( ";
- $sep="";
- $par="";
- $idx=1;
- $array=array();
- foreach ($this->name as $key=> $value)
- {
- if
(isset($this->default[$value])&&$this->default[$value]=="auto"&&$this->$value==null)
- continue;
- if ($value==$this->primary_key&&$this->$value==-1)
- continue;
- $sql.=$sep.$value;
- switch ($this->type[$value])
- {
- case "date":
- if ($this->date_format=="")
- throw new Exception('Format Date invalide');
- $par
.=$sep.'to_timestamp($'.$idx.",'".$this->date_format."')";
- break;
- default:
- $par .= $sep."$".$idx;
- }
-
- $array[]=$this->$value;
- $sep=",";
- $idx++;
- }
- $sql.=") values (".$par.") returning ".$this->primary_key;
- $pk=$this->primary_key;
- $returning=$this->cn->get_value($sql, $array);
- $this->$pk=$returning;
- }
-
- public function delete()
- {
- $pk=$this->primary_key;
- $sql=" delete from ".$this->table." where ".$this->primary_key."= $1";
- $this->cn->exec_sql($sql,array($this->$pk));
- }
-
- public function update()
- {
- $this->verify();
- $pk=$this->primary_key;
- $sql="update ".$this->table." ";
- $sep="";
- $idx=1;
- $array=array();
- $set=" set ";
- foreach ($this->name as $key=> $value) {
- if (isset($this->default[$value])&&$this->default[$value]=="auto")
- continue;
- switch ($this->type[$value])
- {
- case "date":
-
$par=$value.'=to_timestamp($'.$idx.",'".$this->date_format."')";
- break;
- default:
- $par=$value."= $".$idx;
- }
- $sql.=$sep." $set ".$par;
- $array[]=$this->$value;
- $sep=",";
- $set="";
- $idx++;
- }
- $array[]=$this->$pk;
- $sql.=" where ".$this->primary_key." = $".$idx;
- $this->cn->exec_sql($sql, $array);
- }
- /***
- * @brief load a row , corresponding to the primary key
- */
- public function load()
- {
- $sql=$this->build_query();
- $pk=$this->primary_key;
-
- $result=$this->cn->get_array($sql,array ($this->$pk));
- if ($this->cn->count()==0)
- {
- $this->$pk=-1;
- return;
- }
-
- foreach ($result[0] as $key=> $value)
- {
- $this->$key=$value;
- }
- }
-
-
- /**
- * @brief retrieve array of object thanks a condition
- * @param $cond condition (where clause) (optional by default all the rows
are fetched)
- * you can use this parameter for the order or subselect
- * @param $p_array array for the SQL stmt
- * @see Database::exec_sql get_object Database::num_row
- * @return the return value of exec_sql
- */
- function seek($cond='', $p_array=null)
- {
- $sql="select * from ".$this->table." $cond";
- $ret=$this->cn->exec_sql($sql, $p_array);
- return $ret;
- }
-
-
- /**
- * return the number of count in the table corresponding to the where
condition
- * @param string $p_where the condition appended to the SQL select query ,
where must be given
- * @param array $p_array variable from the $p_where condition
- * @return type
- */
- public function count($p_where="",$p_array=null) {
- $count=$this->cn->get_value("select count(*) from $this->table
".$p_where,$p_array);
- return $count;
- }
- /**
- * Count the number of record with the id ,
- * @return integer 0 doesn't exist , 1 exists
- */
- public function exist() {
- $pk=$this->primary_key;
- $count=$this->cn->get_value("select count(*) from ".$this->table."
where ".$this->primary_key."=$1",array($this->$pk));
- return $count;
- }
-
- /**
- * Build the SQL select statement for querying the object and returns it
- * @return string Query of the object
- */
- public function build_query()
- {
- $sql=" select ";
- $sep="";
- foreach ($this->name as $key) {
- switch ($this->type[$key])
- {
- case "date":
- $sql .= $sep.'to_char('.$key.",'".$this->date_format."')
as ".$key;
- break;
- default:
- $sql.=$sep.$key;
- }
- $sep=",";
- }
- $pk=$this->primary_key;
- $sql.=" from ".$this->table;
-
- $sql.=" where ".$this->primary_key." = $1";
-
- return $sql;
- }
- /**
- * @brief Get all the row and use the p_key_code are the key value of
array.
- * The key column is usually the primary key or any unique key.
- * the returns looks like
- * @code
- [ID1]=>array( ["PRIMARYKEY"=>"ID1"
- , "VALUE" => 2]);
- [ID2]=>array( ["PRIMARYKEY"=>"ID2"
- , "VALUE" => 2]);
- @endcode
- * @note It should be used only for small tables: the array is build row
by row
- * @param string $p_key_col existing and unique key
- * @param string $p_cond sql cond
- * @param array $p_array array of value for the SQL condition
- */
- public function get_all_to_array($p_key_col,$p_cond="",$p_array=NULL)
- {
- $ret=$this->seek($p_cond, $p_array);
- if ($ret==FALSE)
- return array();
- $a_array=Database::fetch_all($ret);
- $nb_array=count($a_array);
- $a_result=array();
- try
- {
- for ($i=0; $i<$nb_array; $i++)
- {
- if (!isset($a_array[$i][$p_key_col]))
- {
- throw new Exception("col not found ".$p_key_col);
- }
- $key=$a_array[$i][$p_key_col];
- if ( isset ($a_result[$key]) ){
- throw new Exception ("duplicate found col : $key");
- }
- $a_result[$key]=$a_array[$i];
- }
- }
- catch (Exception $exc)
- {
- echo $exc->getMessage();
- record_log($exc->getMessage());
- record_log($exc->getTraceAsString());
- throw $exc;
- }
- return $a_result;
- }
-
-}
-
-?>
+}
\ No newline at end of file
diff --git a/include/lib/noalyss_sql.class.php
b/include/lib/table_data_sql.class.php
similarity index 98%
copy from include/lib/noalyss_sql.class.php
copy to include/lib/table_data_sql.class.php
index 3c79b41..66578de 100644
--- a/include/lib/noalyss_sql.class.php
+++ b/include/lib/table_data_sql.class.php
@@ -37,12 +37,12 @@
* @note the view or the table must include an unique key, otherwise the load
* doesn't work.
*
- * @class Noalyss_SQL
+ * @class Table_Data_SQL
* Match a table or a view into an object, you need to add the code for each
table
* @note : the primary key must be an integer
*
* @code
- class table_name_sql extends Noalyss_SQL
+ class table_name_sql extends Table_Data_SQL
{
function __construct($p_id=-1)
@@ -84,7 +84,7 @@
*/
require NOALYSS_INCLUDE."/lib/data_sql.class.php";
-abstract class Noalyss_SQL extends Data_SQL
+abstract class Table_Data_SQL extends Data_SQL
{
diff --git a/scenario/test_parse_formula.php b/scenario/test_parse_formula.php
index 4d8f2c1..52663b1 100644
--- a/scenario/test_parse_formula.php
+++ b/scenario/test_parse_formula.php
@@ -3,7 +3,7 @@
/*
# check the Impress::check_formula and the parse_formula
# This file is a part of NOALYSS under GPL
-# Author D. DE BONTRIDDER danydb@aevalys.eu
+# Author Dany WM DE BONTRIDDER danydb@aevalys.eu
*/
include_once NOALYSS_INCLUDE.'/lib/impress.class.php';
@@ -29,23 +29,28 @@ foreach ( array('1',
'[50%]*9.0FROM=01.2004',
'system',
'unlink',
- 'ls -1')
+ 'ls -1',
+ '<script>document.location="https://yahoo.fr";;</script>',
+ "[45ABC]*1",
+
+
+ )
as $a ) {
- echo "Testing :".$a;
+ echo "Testing :".h($a);
echo (Impress::check_formula($a)==false)?'Non valide ':'ok';
echo '<br>';
foreach (array('+','-','/') as $b ) {
$ee=str_replace('*',$b,$a);
- echo "Testing :".$ee;
+ echo "Testing :".h($ee);
echo (Impress::check_formula($ee)==false)?'Non valide ':'ok';
echo '<br>';
}
for($e=0;$e<3;$e++) {
$a.="*".$a;
- echo "Testing :".$a;
+ echo "Testing :".h($a);
echo (Impress::check_formula($a)==false)?'Non valide ':'ok';
echo '<br>';
diff --git a/unit-test/include/lib/databaseTest.class.php
b/unit-test/include/lib/databaseTest.class.php
deleted file mode 100644
index f25b1a6..0000000
--- a/unit-test/include/lib/databaseTest.class.php
+++ /dev/null
@@ -1,620 +0,0 @@
-<?php
-
-/**
- * Generated by PHPUnit_SkeletonGenerator on 2016-02-11 at 15:41:40.
- */
-class DatabaseTest extends PHPUnit_Framework_TestCase
-{
-
- /**
- * @var Database
- */
- protected $object;
-
- /**
- * Sets up the fixture, for example, opens a network connection.
- * This method is called before a test is executed.
- */
- protected function setUp()
- {
- $this->object=new Database;
- }
-
- /**
- * Tears down the fixture, for example, closes a network connection.
- * This method is called after a test is executed.
- */
- protected function tearDown()
- {
-
- }
-
- /**
- * @covers Database::connect
- * @todo Implement testConnect().
- */
- public function testConnect()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::verify
- * @todo Implement testVerify().
- */
- public function testVerify()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::set_encoding
- * @todo Implement testSet_encoding().
- */
- public function testSet_encoding()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::exec_sql
- * @todo Implement testExec_sql().
- */
- public function testExec_sql()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::count_sql
- * @todo Implement testCount_sql().
- */
- public function testCount_sql()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::get_current_seq
- * @todo Implement testGet_current_seq().
- */
- public function testGet_current_seq()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::get_next_seq
- * @todo Implement testGet_next_seq().
- */
- public function testGet_next_seq()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::start
- * @todo Implement testStart().
- */
- public function testStart()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::commit
- * @todo Implement testCommit().
- */
- public function testCommit()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::rollback
- * @todo Implement testRollback().
- */
- public function testRollback()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::alter_seq
- * @todo Implement testAlter_seq().
- */
- public function testAlter_seq()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::execute_script
- * @todo Implement testExecute_script().
- */
- public function testExecute_script()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::get_version
- * @todo Implement testGet_version().
- */
- public function testGet_version()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::fetch
- * @todo Implement testFetch().
- */
- public function testFetch()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::size
- * @todo Implement testSize().
- */
- public function testSize()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::count
- * @todo Implement testCount().
- */
- public function testCount()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::apply_patch
- * @todo Implement testApply_patch().
- */
- public function testApply_patch()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::get_value
- * @todo Implement testGet_value().
- */
- public function testGet_value()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::get_affected
- * @todo Implement testGet_affected().
- */
- public function testGet_affected()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::get_array
- * @todo Implement testGet_array().
- */
- public function testGet_array()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::create_sequence
- * @todo Implement testCreate_sequence().
- */
- public function testCreate_sequence()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::exist_sequence
- * @todo Implement testExist_sequence().
- */
- public function testExist_sequence()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::exist_table
- * @todo Implement testExist_table().
- */
- public function testExist_table()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::exist_column
- * @todo Implement testExist_column().
- */
- public function testExist_column()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::format_name
- * @todo Implement testFormat_name().
- */
- public function testFormat_name()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::exist_database
- * @todo Implement testExist_database().
- */
- public function testExist_database()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::exist_blob
- * @todo Implement testExist_blob().
- */
- public function testExist_blob()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::exist_view
- * @todo Implement testExist_view().
- */
- public function testExist_view()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::exist_schema
- * @todo Implement testExist_schema().
- */
- public function testExist_schema()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::make_list
- * @todo Implement testMake_list().
- */
- public function testMake_list()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::make_array
- * @todo Implement testMake_array().
- */
- public function testMake_array()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::save_receipt
- * @todo Implement testSave_receipt().
- */
- public function testSave_receipt()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::upload
- * @todo Implement testUpload().
- */
- public function testUpload()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::num_row
- * @todo Implement testNum_row().
- */
- public function testNum_row()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::fetch_array
- * @todo Implement testFetch_array().
- */
- public function testFetch_array()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::fetch_all
- * @todo Implement testFetch_all().
- */
- public function testFetch_all()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::fetch_result
- * @todo Implement testFetch_result().
- */
- public function testFetch_result()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::fetch_row
- * @todo Implement testFetch_row().
- */
- public function testFetch_row()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::lo_unlink
- * @todo Implement testLo_unlink().
- */
- public function testLo_unlink()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::prepare
- * @todo Implement testPrepare().
- */
- public function testPrepare()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::execute
- * @todo Implement testExecute().
- */
- public function testExecute()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::lo_export
- * @todo Implement testLo_export().
- */
- public function testLo_export()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::lo_import
- * @todo Implement testLo_import().
- */
- public function testLo_import()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::escape_string
- * @todo Implement testEscape_string().
- */
- public function testEscape_string()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::close
- * @todo Implement testClose().
- */
- public function testClose()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::__toString
- * @todo Implement test__toString().
- */
- public function test__toString()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::test_me
- * @todo Implement testTest_me().
- */
- public function testTest_me()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::status
- * @todo Implement testStatus().
- */
- public function testStatus()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
- /**
- * @covers Database::query_to_csv
- * @todo Implement testQuery_to_csv().
- */
- public function testQuery_to_csv()
- {
- // Remove the following lines when you implement this test.
- $this->markTestIncomplete(
- 'This test has not been implemented yet.'
- );
- }
-
-}
diff --git a/unit-test/include/lib/Noalyss_SQLTest.class.php
b/unit-test/include/lib/table_sql_sqlTest.class.php
similarity index 100%
rename from unit-test/include/lib/Noalyss_SQLTest.class.php
rename to unit-test/include/lib/table_sql_sqlTest.class.php
- [Noalyss-commit] [noalyss] 49/73: Improve function display_row_custom for the custom sort key see Sorttable.js, (continued)
- [Noalyss-commit] [noalyss] 49/73: Improve function display_row_custom for the custom sort key see Sorttable.js, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 50/73: Improve Manage_Table_SQL, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 55/73: Manage_Table_SQL : typo, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 56/73: Output_HTML adapt to bootstrap navbar, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 57/73: Task #1807: Boutons indistincts – thème 7 classic, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 44/73: Cosmetic : width to large if recover passwd enable and icon trash not available for document (in operation detail), Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 28/73: Task #0001961: Devise : faciliter les calculs d'écarts de conversion, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 38/73: Task #1961 : Currency remove default currency, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 40/73: Cosmetic : add button_magnifier for searching, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 52/73: Code Rewriting : rename Noalyss_SQL class by Table_Data_SQL, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 53/73: Code Rewriting : rename Noalyss_SQL class by Table_Data_SQL,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 45/73: Cosmetic : button with HREF, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 60/73: Cosmetic : navigator on small device, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 62/73: Remove dead code, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 63/73: Unit test : update, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 65/73: Task #0001992: Prévision, calcul avec comptabilité analytique, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 54/73: Security : Check the folder, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 05/73: comptability version 7.4 warning null is not a countable, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 48/73: PLpgSQL function , format properly the accounting before inserting fiche_detail and tmp_pcmn tables, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 51/73: Code rewriting : doc and remove duplicated function, Dany De Bontridder, 2021/05/28
- [Noalyss-commit] [noalyss] 58/73: Improve Manage_Table_SQL : missing param for execute-query, Dany De Bontridder, 2021/05/28