SF.net SVN: ledger-smb:[5261] trunk/sql/modules

[..hidden..]

Revision: 5261
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5261&view=rev
Author:   einhverfr
Date:     2012-11-25 03:20:59 +0000 (Sun, 25 Nov 2012)
Log Message:
-----------
Moving more modules to transactions, merging Defaults.sql with Settings.sql

Modified Paths:
--------------
    trunk/sql/modules/Business_type.sql
    trunk/sql/modules/Date.sql
    trunk/sql/modules/LOADORDER
    trunk/sql/modules/Session.sql
    trunk/sql/modules/Settings.sql

Removed Paths:
-------------
    trunk/sql/modules/Defaults.sql

Modified: trunk/sql/modules/Business_type.sql
===================================================================
--- trunk/sql/modules/Business_type.sql	2012-11-25 03:05:07 UTC (rev 5260)
+++ trunk/sql/modules/Business_type.sql	2012-11-25 03:20:59 UTC (rev 5261)
@@ -1,3 +1,5 @@
+BEGIN;
+
 CREATE OR REPLACE FUNCTION business_type__list() RETURNS SETOF business AS
 $$
 DECLARE out_row business%ROWTYPE;
@@ -10,3 +12,5 @@
 
 COMMENT ON function business_type__list() IS 
 $$Returns a list of all business types. Ordered by description by default.$$;
+
+COMMIT;

Modified: trunk/sql/modules/Date.sql
===================================================================
--- trunk/sql/modules/Date.sql	2012-11-25 03:05:07 UTC (rev 5260)
+++ trunk/sql/modules/Date.sql	2012-11-25 03:20:59 UTC (rev 5261)
@@ -1,4 +1,4 @@
-
+BEGIN;
 -- Copyright (C) 2011 LedgerSMB Core Team.  Licensed under the GNU General 
 -- Public License v 2 or at your option any later version.
 
@@ -146,3 +146,4 @@
 COMMENT ON FUNCTION periods_get() IS
 $$ Returns dates for year to date, and last year.$$;
 
+COMMIT;

Deleted: trunk/sql/modules/Defaults.sql
===================================================================
--- trunk/sql/modules/Defaults.sql	2012-11-25 03:05:07 UTC (rev 5260)
+++ trunk/sql/modules/Defaults.sql	2012-11-25 03:20:59 UTC (rev 5261)
@@ -1,21 +0,0 @@
-
--- Copyright (C) 2011 LedgerSMB Core Team.  Licensed under the GNU General 
--- Public License v 2 or at your option any later version.
-
--- Docstrings already added to this file.
-
--- Probably want to move this to the Settings module -CT
-
-CREATE OR REPLACE FUNCTION defaults_get_defaultcurrency() 
-RETURNS SETOF char(3) AS
-$$
-DECLARE defaultcurrency defaults.value%TYPE;
-      BEGIN   
-           SELECT INTO defaultcurrency substr(value,1,3)
-           FROM defaults
-           WHERE setting_key = 'curr';
-           RETURN NEXT defaultcurrency;
-      END;
-$$ language plpgsql;                                                                  
-COMMENT ON FUNCTION defaults_get_defaultcurrency() IS
-$$ This function return the default currency asigned by the program. $$;

Modified: trunk/sql/modules/LOADORDER
===================================================================
--- trunk/sql/modules/LOADORDER	2012-11-25 03:05:07 UTC (rev 5260)
+++ trunk/sql/modules/LOADORDER	2012-11-25 03:20:59 UTC (rev 5261)
@@ -12,7 +12,6 @@
 Company.sql
 Customer.sql 
 Date.sql
-Defaults.sql
 Settings.sql
 Employee.sql
 Entity.sql

Modified: trunk/sql/modules/Session.sql
===================================================================
--- trunk/sql/modules/Session.sql	2012-11-25 03:05:07 UTC (rev 5260)
+++ trunk/sql/modules/Session.sql	2012-11-25 03:20:59 UTC (rev 5261)
@@ -1,3 +1,5 @@
+BEGIN;
+
 CREATE OR REPLACE FUNCTION form_check(in_session_id int, in_form_id int)
 RETURNS BOOL AS
 $$
@@ -176,3 +178,5 @@
 
 Returns true if the transaction was unlocked by this routine, false 
 otherwise.$$;
+
+COMMIT;

Modified: trunk/sql/modules/Settings.sql
===================================================================
--- trunk/sql/modules/Settings.sql	2012-11-25 03:05:07 UTC (rev 5260)
+++ trunk/sql/modules/Settings.sql	2012-11-25 03:20:59 UTC (rev 5261)
@@ -7,6 +7,20 @@
 
 BEGIN;
 
+CREATE OR REPLACE FUNCTION defaults_get_defaultcurrency() 
+RETURNS SETOF char(3) AS
+$$
+DECLARE defaultcurrency defaults.value%TYPE;
+      BEGIN   
+           SELECT INTO defaultcurrency substr(value,1,3)
+           FROM defaults
+           WHERE setting_key = 'curr';
+           RETURN NEXT defaultcurrency;
+      END;
+$$ language plpgsql;                                                                  
+COMMENT ON FUNCTION defaults_get_defaultcurrency() IS
+$$ This function return the default currency asigned by the program. $$;
+
 DROP FUNCTION IF EXISTS setting__set(varchar, varchar);
 CREATE OR REPLACE FUNCTION setting__set (in_setting_key varchar, in_value varchar) 
 RETURNS BOOL AS

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.