/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 vote320 views1 answer
Mysql enter ubuntu
SQL
0 vote336 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote378 views1 answer
Generate a random otp in sql server
SQL
0 vote309 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote329 views1 answer
SAP Return
SQL
1 vote346 views1 answer
Get current date in pyspark sql
SQL
2 votes336 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote311 views1 answer
Commit transaction sql
SQL
4 votes317 views1 answer
Add constraint fk
SQL
0 vote342 views1 answer
Postgres meta command to show all rows in table
SQL