From: Michael Linfield <globyy3000@...>
Date: 2007-11-16T18:14:27+09:00
Subject: Re: sql managing

Well, i came up with a solution for myself, but i do have one 
question...I've always been hazy on this subject and i really need to 
improve on it, but how would i generate an STDIN for this.. IE: run the 
script from command line as the following: 
Invite.event("foo","Event_2") | sqlrun.rb

obviously that would never work but hopefully you get the general idea 
of what im going after, full command line control rather than doing a 
while true loop for a gets.chomp lol.

Here is the script none-the-less

require 'rubygems'
require 'postgres'

#def create_user
#  puts "####Create a New Account####"
#   print "Desired Username: \n"
#   newuser = gets.chomp
#   print "Desired Password: \n"
#   newpass = gets.chomp
#
#base.exec("insert into USERS(name) values ('#{newuser}')")
#base.exec("insert into USERS(pass) values ('#{newpass}')")

#end
#Commenting this user creation out for now, implementing later


def login
  puts "##Login Information Please##"
  print "Username: \n"
  @@client = gets.chomp
  print "Password : \n"
  clientpass = gets.chomp
end


@@base = PGconn.connect("localhost",5432,"","","base","god","letmein")

class User
  class << self

def join_group(newgroup)
  @@base = PGconn.connect("localhost",5432,"","","base","god","letmein")
if newgroup == "Group_1"
   @@base.exec("insert into GROUP_1(members) values ('#{@@client}')")
elsif newgroup == "Group_2"
   @@base.exec("insert into GROUP_2(members) values ('#{@@client}')")
elsif newgroup == "Group_3"
   @@base.exec("insert into GROUP_3(members) values ('#{@@client}')")
else
  puts "Error: Non-Existance Group. Check Spelling."
  end
 end

def join_event(newevent)

if newevent == "Event_1"
   @@base.exec("insert into EVENT_1(members) values ('#{@@client}')")
elsif newevent == "Event_2"
   @@base.exec("insert into EVENT_2(members) values ('#{@@client}')")
elsif newevent == "Event_3"
   @@base.exec("insert into EVENT_3(members) values ('#{@@client}')")
else
   puts "Error: Non-Existance Event. Check Spelling."
  end
 end

def join_project(newproj)

if newproj == "Project_1"
   @@base.exec("insert into PROJECT_1(members) values ('#{@@client}')")
elsif newproj == "Project_2"
   @@base.exec("insert into PROJECT_2(members) values ('#{@@client}')")
elsif newproj == "Project_3"
   @@base.exec("insert into PROJECT_3(members) values ('#{@@client}')")
else
   puts "Error: Non-Existance Project. Check Spelling."
  end
 end
end
end

class Invite
  class << self

def project(user,projectid)
  @@base = PGconn.connect("localhost",5432,"","","base","god","letmein")
  @@base.exec("insert into #{projectid}(members) values ('#{user}')")
  print "Message: "
  msg = gets.chomp
   puts "#{user} has been invited to #{projectid} by #{@@client} -- 
\"#{msg}\""
 end

def group(user,groupid)
  @@base.exec("insert into #{groupid}(members) values ('#{user}')")
  print "Message: "
  msg = gets.chomp
   puts "#{user} has been invited to #{groupid} by #{@@client} -- 
\"#{msg}\""
 end

def event(user,eventid)
  @@base.exec("insert into #{eventid}(members) values ('#{user}')")
  print "Message: "
  msg = gets.chomp
   puts "#{user} has been invited to #{eventid} by #{@@client} -- 
\"#{msg}\""
  end
 end
end





-- 
Posted via http://www.ruby-forum.com/.