/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 vote162 views1 answer
Search In the Database using Text
SQL
0 vote174 views1 answer
Mysql trim characters
SQL
0 vote173 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote168 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote177 views1 answer
Mysql update even / odd rows
SQL
10 votes167 views4 answers
Primary key in sql
SQL
4 votes189 views1 answer
Oracle nls_date_format
SQL
58 votes525 views6 answers
Create new user in postgres
SQL
-1 vote173 views5 answers
Online sql to linq generator
SQL
0 vote174 views1 answer
How to generate ids in sql
SQL