/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 vote114 views1 answer
Soql more than today
SQL
0 vote115 views1 answer
How to drop columns with constraint from a table in sql script
SQL
3 votes122 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote114 views1 answer
Insert or update cassandra
SQL
19 votes122 views6 answers
Sql server drop table if exists
SQL
11 votes122 views1 answer
How to get ddl for materialized view
SQL
0 vote125 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote136 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote137 views2 answers
Getting customers with no orders sql
SQL
0 vote121 views1 answer
Python mysqlclient library not found for -lssl
SQL