/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

1 vote246 views1 answer
ORA-01950
SQL
0 vote245 views1 answer
Mysql extract day from date leading zero
SQL
5 votes239 views1 answer
JBDC
SQL
0 vote250 views1 answer
Postgres grep entire database
SQL
2 votes217 views1 answer
Sql find missing values between two tables
SQL
0 vote230 views1 answer
Sql get month and year from date
SQL
1 vote269 views1 answer
Default
SQL
1 vote247 views1 answer
Mysql show queries running
SQL
4 votes270 views1 answer
Sql select limit range
SQL
0 vote234 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL