lib/ezframe/database.rb in ezframe-0.0.4 vs lib/ezframe/database.rb in ezframe-0.1.0

@@ -10,11 +10,11 @@
       connect
     end  
 
     def connect
       @dbfile ||= ENV["EZFRAME_DB"] || Config[:database] || "sqlite://db/devel.sqlite"
-      puts "Database.connect: dbfile=#{@dbfile}"
+      # puts "Database.connect: dbfile=#{@dbfile}"
       @sequel = Sequel.connect(@dbfile, loggers: [Logger.new($stdout)])
     end  
 
     def exec(sql)
       @sequel.run(sql)  
@@ -29,10 +29,10 @@
         dbtype_h.delete(key.to_sym)
       end
       # puts "create_table: #{table_name}"
       if @dbfile.index("postgres")
         @sequel.create_table(table_name) do 
-          serial :id
+          primary_key :id, identity: true
           dbtype_h.each do |key, dbtype|
             column(key, dbtype)
           end
           column(:created_at, :timestamp, default: Sequel::CURRENT_TIMESTAMP)
           column(:updated_at, :timestamp, default: Sequel::CURRENT_TIMESTAMP)