test/describe_test.rb in oci8_simple-0.4.2 vs test/describe_test.rb in oci8_simple-0.5.0

@@ -5,25 +5,32 @@
       @client = Oci8Simple::Client.new("test")
       @client.run "DROP TABLE OCI8_SIMPLE_TEST CASCADE CONSTRAINTS" rescue nil
       @client.run <<-SQL
         CREATE TABLE "OCI8_SIMPLE_TEST"
           (
-            "NAME"           VARCHAR2(400 CHAR) NOT NULL ENABLE,
-            "ID"             NUMBER(38,0) NOT NULL ENABLE,
+            "NAME"           VARCHAR2(400 CHAR) DEFAULT 'FOO' NOT NULL ENABLE,
+            "ID"             NUMBER(38,0) DEFAULT 7 NOT NULL ENABLE,
+            "LONG_THING"     VARCHAR(2000 CHAR) DEFAULT '#{"a " * 50}' NOT NULL ENABLE,
             "TEXTS"          CLOB
           )
       SQL
       @describe = Oci8Simple::Describe.new("test")
     end
     context "describing a table" do
       setup do
       end
       should "format results for the command line" do
         expected=<<-STR
-"ID"    NUMBER(38)         NOT NULL
-"NAME"  VARCHAR2(400 CHAR) NOT NULL
-"TEXTS" CLOB               
+Required  Name        Type      Size  Char?  Char_size  Precision  Scale  Default   
+------------------------------------------------------------------------------------
+       *  id          number    22                      38         0      7         
+       *  long_thing  varchar2  4000  *      2000                         a a a a a ...
+       *  name        varchar2  1600  *      400                          FOO       
+          texts       clob                                                          
 STR
+        # puts
+        # puts expected.chop
+        # puts @describe.run("oci8_simple_test")
         assert_equal(expected.chop, @describe.run("oci8_simple_test"))
       end
     end
   end
 end
\ No newline at end of file