/SQL/How to define a save method in ruby for sqlite3 databases

How to define a save method in ruby for sqlite3 databases

def save
    sql = <<-SQL
      INSERT INTO songs (name, album) 
      VALUES (?, ?)
    SQL
 
    DB[:conn].execute(sql, self.name, self.album)
 
    @id = DB[:conn].execute("SELECT last_insert_rowid() FROM songs")[0][0]
 
  end

Similar codes

0 vote140 views1 answer
Grepper sql workbench download
SQL
1 vote139 views3 answers
Getdate function in postgresql
SQL
0 vote134 views1 answer
Oracle free up space in tablespace
SQL
0 vote143 views1 answer
Oracle drop default value
SQL
0 vote152 views1 answer
How to select an index in oracle sql
SQL
1 vote127 views3 answers
Grant syntax in sql
SQL
0 vote150 views1 answer
Mysql select where field is a value
SQL
3 votes163 views2 answers
How to open postgresql in windows
SQL
0 vote185 views1 answer
Opensuse start MySQL
SQL
-1 vote148 views1 answer
How to dump .csv file into mysql
SQL