Changeset: 9c01631ead5c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9c01631ead5c Removed Files: sql/backends/monet5/timetrails/70_timetrails.mal sql/backends/monet5/timetrails/70_timetrails.sql sql/backends/monet5/timetrails/Makefile.ag sql/backends/monet5/timetrails/timetrails.c sql/backends/monet5/timetrails/timetrails.h sql/backends/monet5/timetrails/timetrails.mal Branch: timetrails Log Message:
Remove old code diffs (224 lines): diff --git a/sql/backends/monet5/timetrails/70_timetrails.mal b/sql/backends/monet5/timetrails/70_timetrails.mal deleted file mode 100644 --- a/sql/backends/monet5/timetrails/70_timetrails.mal +++ /dev/null @@ -1,10 +0,0 @@ -# This Source Code Form is subject to the terms of the Mozilla Public -# License, v. 2.0. If a copy of the MPL was not distributed with this -# file, You can obtain one at http://mozilla.org/MPL/2.0/. -# -# Copyright 1997 - July 2008 CWI, August 2008 - 2017 MonetDB B.V. - -# This announces the UDF module to the MAL interpreter - -include timetrails; - diff --git a/sql/backends/monet5/timetrails/70_timetrails.sql b/sql/backends/monet5/timetrails/70_timetrails.sql deleted file mode 100644 --- a/sql/backends/monet5/timetrails/70_timetrails.sql +++ /dev/null @@ -1,85 +0,0 @@ -# This Source Code Form is subject to the terms of the Mozilla Public -# License, v. 2.0. If a copy of the MPL was not distributed with this -# file, You can obtain one at http://mozilla.org/MPL/2.0/. -# -# Copyright 1997 - July 2008 CWI, August 2008 - 2017 MonetDB B.V. - - -CREATE SCHEMA timetrails; - -CREATE TABLE timetrails.metrics ( - name string PRIMARY KEY, - auth string, --(for later) The owner ticket for this metric - credit integer, --(for later)The volume of data allowed for this metric - precision string , --time stamp precision {millisecond,second,minute,hour,day,month,year, null} - retention string, --time stamp interval {millisecond,second,minute,hour,day,month,year, null} - threshold integer, --max rows delayed in the Guardian cache - heartbeat integer, -- maximum delay (in ms) before forwarding - frozen boolean, --once defined its structure can not be changed - title string, --informative title - description string --short explanation -); - - ---Return the names of all known metric relations -CREATE FUNCTION timetrails.metrics() -RETURNS TABLE (metric string) -BEGIN - RETURN SELECT m.name FROM timetrails.metrics m ORDER BY m.name; -END; - ---Return the tags associated with a metric relation -CREATE FUNCTION timetrails.tags(metric string) -RETURNS TABLE (colname string) -BEGIN - RETURN SELECT o.name AS colname - FROM sys.objects o, sys.tables t, sys.keys k - WHERE o.id = k.id AND k.table_id = t.id AND t.name = metric ORDER BY o.nr; -END; - ---Return the measure names for a metric relation -CREATE FUNCTION timetrails.fields(metric string) -RETURNS TABLE (colname string) -BEGIN - RETURN SELECT c.name - FROM sys.columns c, sys.tables t - WHERE t.name= metric AND t.id = c.table_id AND - c.name NOT IN (SELECT o.name AS colname - FROM sys.objects o, sys.tables tt, sys.keys k WHERE o.id = k.id AND k.table_id = tt.id AND tt.name = metric ); -END; - ---Return the preferred message layout and their type -CREATE FUNCTION timetrails.getLayout(metric string) -RETURNS TABLE( name string, type string) -BEGIN - RETURN SELECT c.name, c.type FROM timetrails.metrics m, sys.tables t, sys.columns c WHERE m.name = metric AND t.name = m.name and c.table_id= t.id; -END; - ---Return the time precision for a metric relation -CREATE FUNCTION timetrails.getPrecision(metric string) -RETURNS string -BEGIN - RETURN SELECT m.precision FROM timetrails.metrics m WHERE m.name = metric; -END; - ---Return the retention period of a metric relation -CREATE FUNCTION timetrails.getRetention(metric string) -RETURNS string -BEGIN - RETURN SELECT m.retention FROM timetrails.metrics m WHERE m.name = metric; -END; - ---Return the title annotation -CREATE FUNCTION timetrails.getTitle(metric string) -RETURNS string -BEGIN - RETURN SELECT m.title FROM timetrails.metrics m WHERE m.name = metric; -END; - ---Return the short help on a metric relation -CREATE FUNCTION timetrails.getDescription(metric string) -RETURNS string -BEGIN - RETURN SELECT m.description FROM timetrails.metrics m WHERE m.name = metric; -END; - diff --git a/sql/backends/monet5/timetrails/Makefile.ag b/sql/backends/monet5/timetrails/Makefile.ag deleted file mode 100644 --- a/sql/backends/monet5/timetrails/Makefile.ag +++ /dev/null @@ -1,46 +0,0 @@ -# This Source Code Form is subject to the terms of the Mozilla Public -# License, v. 2.0. If a copy of the MPL was not distributed with this -# file, You can obtain one at http://mozilla.org/MPL/2.0/. -# -# Copyright 1997 - July 2008 CWI, August 2008 - 2017 MonetDB B.V. - -INCLUDES = .. \ - ../../../include \ - ../../../common \ - ../../../storage \ - ../../../server \ - ../../../../monetdb5/modules/atoms \ - ../../../../monetdb5/modules/kernel \ - ../../../../monetdb5/mal \ - ../../../../monetdb5/modules/mal \ - ../../../../monetdb5/optimizer \ - ../../../../common/options \ - ../../../../common/stream \ - ../../../../gdk - -lib__timetrails = { - MODULE - DIR = libdir/monetdb5 - SOURCES = timetrails.c timetrails.h - LIBS = ../../../../monetdb5/tools/libmonetdb5 \ - ../../../../gdk/libbat -} - -headers_mal = { - HEADERS = mal - DIR = libdir/monetdb5 - SOURCES = timetrails.mal -} - -headers_sql = { - HEADERS = sql - DIR = libdir/monetdb5/createdb - SOURCES = 70_timetrails.sql -} - -headers_autoload = { - HEADERS = mal - DIR = libdir/monetdb5/autoload - SOURCES = 70_timetrails.mal -} - diff --git a/sql/backends/monet5/timetrails/timetrails.c b/sql/backends/monet5/timetrails/timetrails.c deleted file mode 100644 --- a/sql/backends/monet5/timetrails/timetrails.c +++ /dev/null @@ -1,12 +0,0 @@ -/* - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * Copyright 1997 - July 2008 CWI, August 2008 - 2017 MonetDB B.V. - */ - -/* monetdb_config.h must be the first include in each .c file */ -#include "monetdb_config.h" -#include "timetrails.h" - diff --git a/sql/backends/monet5/timetrails/timetrails.h b/sql/backends/monet5/timetrails/timetrails.h deleted file mode 100644 --- a/sql/backends/monet5/timetrails/timetrails.h +++ /dev/null @@ -1,32 +0,0 @@ -/* - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * Copyright 1997 - July 2008 CWI, August 2008 - 2017 MonetDB B.V. - */ - -/* In your own module, replace "timetrails" & "udf" by your module's name */ - -#ifndef _SQL_TIMETRAILS_H_ -#define _SQL_TIMETRAILS_H_ -#include "sql.h" -#include <string.h> - -/* This is required as-is (except from renaming "timetrails" & "udf" as suggested - * above) for all modules for correctly exporting function on Unix-like and - * Windows systems. */ - -#ifdef WIN32 -#ifndef LIBtimetrails -#define udf_export extern __declspec(dllimport) -#else -#define udf_export extern __declspec(dllexport) -#endif -#else -#define udf_export extern -#endif - -/* export MAL wrapper functions */ - -#endif /* _SQL_TIMETRAILS_H_ */ diff --git a/sql/backends/monet5/timetrails/timetrails.mal b/sql/backends/monet5/timetrails/timetrails.mal deleted file mode 100644 --- a/sql/backends/monet5/timetrails/timetrails.mal +++ /dev/null @@ -1,9 +0,0 @@ -# This Source Code Form is subject to the terms of the Mozilla Public -# License, v. 2.0. If a copy of the MPL was not distributed with this -# file, You can obtain one at http://mozilla.org/MPL/2.0/. -# -# Copyright 1997 - July 2008 CWI, August 2008 - 2017 MonetDB B.V. - -# scalar MAL signatures -module timetrails; - _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
