jeudi 23 avril 2015

writing basic Ruby code to register user in SQLite database

I need some help writing basic Ruby code to register a user in a SQLite database. I'm very new to Ruby, I checked lots of good examples online but my code still doesn't work.

This is my 1st test project using Ruby, so appreciate any help and apologise for making any bad mistakes.

require 'sqlite3'

def register_user(l)
    user = l[1]
    pass = l[2]

    db = SQLite3::Database.new "database.db"

    db.execute("INSERT INTO users (user, pass)
                VALUES (#{user}, #{pass})")
end

def cmd_register(l)
    if register_user(#{@nick}, l[1])
        sv_send 'NOTICE', 'REGISTER', ':*** User created'
    else
        sv_send 'NOTICE', 'REGISTER', ':*** User not created'
    end
end

Aucun commentaire:

Enregistrer un commentaire