/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 vote338 views1 answer
Sqlalchemy case insensitive like
SQL
-3 votes322 views1 answer
Remove spaces sql 2008
SQL
0 vote334 views1 answer
2020 new year
SQL
0 vote362 views1 answer
Typeorm raw sql
SQL
2 votes374 views3 answers
Sql function
SQL
0 vote324 views1 answer
Get duplicate entry sql
SQL
6 votes402 views3 answers
Check if string contains substring sql
SQL
0 vote328 views1 answer
Mysql command prompt date insert format
SQL
4 votes349 views2 answers
How to insert ip address in mysql using php
SQL
1 vote390 views1 answer
Floor function in sql oracle
SQL