require 'rubygems' 
require 'dm-core' 
require 'dm-validations' 

DataMapper.setup(:default, "sqlite3://#{Dir.pwd}/dmphoner.db") 

DataObjects::Sqlite3.logger = DataObjects::Logger.new(STDOUT, 0) 

class User 
  include DataMapper::Resource 
  #properties. 
  property  :id, Serial 
  property  :name, String, :nullable => false, :unique => true 
  property  :phone, Integer, :nullable => false 

  #validations. 
  validates_length :name,  :minimum => 4 
  validates_length :phone, :is => 5 
end 

User.auto_migrate! 

def add_user(uname, uphone=12345) 
   u=User.new 
   u.attributes={:name => uname, :phone => uphone} 
   u.save! 
end  

def get_user(uname) 
    return User.first(:name => uname) 
end 
 

def delete_user(uname) 
    begin 
        user=get_user(uname) 
        user.destroy 
    rescue Exception => ex 
        puts ex # undefiend method 'destroy' for nil:NilClass. 
    end 
end  

 def update_user(uname, new_phone) 
    begin 
        user=get_user(uname) 
        user.attributes={:phone => new_phone} 
        user.save! 
    rescue 
    	
    end 
end 

def view_all 
    puts "---------Users--------" 
    User.all.each do |u| 
        puts u.name + " => " + u.phone.to_s 
    end 
  #p User.all 
end  

def fake_list 
    recs=[['mido', 12323], ['john', 63874], ['ahmed adel', 14785] ] 
    recs.each do |name, phone| 
        add_user(name, phone) 
    end 
end 
 

class Topic
  include DataMapper::Resource

  property :id, Serial
  property :title, String
  property :body, Text

  belongs_to :user 
  
  #validations.

end

class User
  include DataMapper::Resource

  property :id, Serial
  property :screen_name, String,  :nullable => false
  property :email, String
  
  has n, :topics

  #validations...
end 

DataMapper.auto_migrate! 

def add_user(name, email)
  begin
    u=User.new
    u.attributes={:screen_name => name, :email => email}
    topicsarr=[ ["hello",'hello world from dm!'], ['test', 'this is a test!'], ['new tutorial!', 'this is a DM tut'] ]
    rndtopic1=topicsarr.choice
    rndtopic2=topicsarr.choice
    t1=u.topics.build(:title => rndtopic1[0], :body => rndtopic1[1])
    t2=u.topics.build(:title => rndtopic2[0], :body => rndtopic2[1])
    #puts t
    t1.save!
    u.topics << t1
    t2.save!
    u.topics << t2
    u.save!
  rescue Exception => ex
     puts ex
  end
end 

    rndtopic1=topicsarr.choice 

    t1=u.topics.build(:title => rndtopic1[0], :body => rndtopic1[1]) 

u.topics << t1 

    u.save! 

def create_users
  recs=[ ['ahmed', 'mido@yahoo.com'], ['wael', 'wael@gamil.com'], ['smsm', 'smsm@live.com'], ['jack', 'jacko@live.com'] ]
  recs.each do |name, email|
    add_user(name, email)
  end
end 

def view_all
    puts "---------Users--------"
    User.all(:order => [:screen_name.asc]).each do |u|
        puts u.screen_name + " => " + u.email
        #puts "\tTopics: #{u.topics}"
        topics = Topic.all('user.screen_name' => u.screen_name)
        puts "\tTopics:"
        topics.each do |topic|
          puts "\t\t#{topic.title} => #{topic.body}"
        end
    end
end 

        topics = Topic.all('user.screen_name' => u.screen_name) 

        topics.each do |topic|
          puts "\t\t#{topic.title} => #{topic.body}"
        end