class VhostUser
  include DataMapper::Resource

  property :id, Serial
  property :username, String, :nullable => false, :length => 8, :key => true
  property :password, String, :nullable => false, :length => 32
  property :quota, Integer, :nullable => false, :default => 0
  property :ssl, Boolean, :default => false
  property :mysql, Boolean, :default => false
  property :pgsql, Boolean, :default => false
  property :statistics, Boolean, :default => false
  property :suspended, Boolean, :default => true

  has n, :domains

  has n, :mysql_databases
  has n, :pgsql_databases

  validates_is_unique :username


  before :update, :create_default_db
  before :save, :create_default_db

  def create_default_db
    if self.suspended == false
      if self.mysql == true and self.mysql_databases.count == 0
        @mysql_database = self.mysql_databases.build(:name => self.username)
        @mysql_database.save

        @mysql_database_user = @mysql_database.mysql_database_users.build(:username => self.username, :password => self.password)
        @mysql_database_user.save
      end

      if self.pgsql == true and self.pgsql_databases.count == 0
        @pgsql_database = self.pgsql_databases.build(:name => self.username)
        @pgsql_database.save

        @pgsql_database_user = @pgsql_database.pgsql_database_users.build(:username => self.username, :password => self.password)
        @pgsql_database_user.save
      end
    end
  end

end