[otrs-cvs] FAQ/Kernel/System/FAQ State.pm,1.2,1.3

Comments:
Update of /home/cvs/FAQ/Kernel/System/FAQ
In directory lancelot:/tmp/cvs-serv12492/Kernel/System/FAQ

Modified Files:
	State.pm 
Log Message:
Updated SQL style.

Author: cr

Index: State.pm
===================================================================
RCS file: /home/cvs/FAQ/Kernel/System/FAQ/State.pm,v
retrieving revision 1.2
retrieving revision 1.3
diff -2 -u -d -r1.2 -r1.3
--- State.pm	30 Jun 2013 00:36:56 -0000	1.2
+++ State.pm	30 Jun 2013 00:45:04 -0000	1.3
@@ -60,5 +60,7 @@
 
     return if !$Self->{DBObject}->Do(
-        SQL => 'INSERT INTO faq_state (name, type_id) VALUES ( ?, ? )',
+        SQL => '
+            INSERT INTO faq_state (name, type_id)
+            VALUES ( ?, ? )',
         Bind => [ \$Param{Name}, \$Param{TypeID} ],
     );
@@ -102,5 +104,8 @@
     # sql
     return if !$Self->{DBObject}->Prepare(
-        SQL   => 'SELECT id, name, type_id FROM faq_state WHERE id = ?',
+        SQL => '
+            SELECT id, name, type_id
+            FROM faq_state
+            WHERE id = ?',
         Bind  => [ \$Param{StateID} ],
         Limit => 1,
@@ -150,5 +155,9 @@
 
     # sql
-    return if !$Self->{DBObject}->Prepare( SQL => 'SELECT id, name FROM faq_state' );
+    return if !$Self->{DBObject}->Prepare(
+        SQL => '
+            SELECT id, name
+            FROM faq_state'
+    );
 
     my %List;
@@ -193,5 +202,8 @@
     # sql
     return if !$Self->{DBObject}->Do(
-        SQL => 'UPDATE faq_state SET name = ?, type_id = ?, WHERE id = ?',
+        SQL => '
+            UPDATE faq_state
+            SET name = ?, type_id = ?,
+            WHERE id = ?',
         Bind => [ \$Param{Name}, \$Param{TypeID}, \$Param{StateID} ],
     );
@@ -237,14 +249,17 @@
     }
 
-    my $SQL = 'SELECT id, name FROM faq_state_type WHERE ';
+    my $SQL = '
+        SELECT id, name
+        FROM faq_state_type
+        WHERE';
     my @Bind;
     my $CacheKey = 'StateTypeGet::';
     if ( defined $Param{StateID} ) {
-        $SQL .= 'id = ?';
+        $SQL .= ' id = ?';
         push @Bind, \$Param{StateID};
         $CacheKey .= 'ID::' . $Param{StateID};
     }
     elsif ( defined $Param{Name} ) {
-        $SQL .= 'name = ?';
+        $SQL .= ' name = ?';
         push @Bind, \$Param{Name};
         $CacheKey .= 'Name::' . $Param{Name};
@@ -314,5 +329,7 @@
 
     # build SQL
-    my $SQL = 'SELECT id, name FROM faq_state_type';
+    my $SQL = '
+        SELECT id, name
+        FROM faq_state_type';
 
     # types are given
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log