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

How to define a save method in ruby for sql 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 vote316 views1 answer
Oracle synonym procedure dblink
SQL
0 vote305 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote340 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote325 views1 answer
Oracle shrink table
SQL
1 vote377 views1 answer
Sql random sampling per group
SQL
8 votes363 views3 answers
Postgres database sizes
SQL
0 vote318 views1 answer
Groupby error in mysql
SQL
1 vote335 views1 answer
Add multiple row table pl sql
SQL
2 votes338 views3 answers
Current setting postgres timezone
SQL
4 votes326 views1 answer
T-sql get duplicate rows
SQL