[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



Revision: 6150
          http://sourceforge.net/p/ledger-smb/code/6150
Author:   einhverfr
Date:     2013-10-22 14:42:45 +0000 (Tue, 22 Oct 2013)
Log Message:
-----------
Fixing sql api to add an accept_input bool.

Modified Paths:
--------------
    trunk/sql/modules/Settings.sql

Modified: trunk/sql/modules/Settings.sql
===================================================================
--- trunk/sql/modules/Settings.sql	2013-10-22 14:41:24 UTC (rev 6149)
+++ trunk/sql/modules/Settings.sql	2013-10-22 14:42:45 UTC (rev 6150)
@@ -168,24 +168,27 @@
 
 CREATE OR REPLACE FUNCTION sequence__save
 (in_label text, in_setting_key text, in_prefix text, in_suffix text,
- in_sequence text)
+ in_sequence text, in_accept_input bool)
 RETURNS lsmb_sequence LANGUAGE sql AS
 $$
 UPDATE lsmb_sequence 
    SET prefix = coalesce(in_prefix, DEFAULT),
        suffix = coalecce(in_suffix, DEFAULT),
        sequence = coalesce(in_sequence, DEFAULT),
-       setting_ley = in_setting_key
+       setting_ley = in_setting_key,
+       accept_input = in_accept_input
  WHERE label = in_label;
 
 IF FOUND THEN RETURN sequence__get(in_label);
 END IF;
 
-INSERT INTO lsmb_sequence(label, setting_key, prefix, suffix, sequence)
+INSERT INTO lsmb_sequence(label, setting_key, prefix, suffix, sequence, 
+                          accept_input)
 VALUES (in_label, in_setting_ley, 
         coalesce(prefix, default), 
         coalesce(suffix, default), 
-        coalesce(sequence, default)
+        coalesce(sequence, default),
+        in_accept_input
 );
 
 return sequence__get(in_label);

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


------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits