Contents

module Wlog
# The sql for attachments
# @author Simon Symeonidis
module AttachmentSql
  # The table name 
  TableName = "attachments"

  # Insert the file data into the database (NOTE wondering if small/big endian
  # will be affecting this...)
  InsertSql = "INSERT INTO #{TableName} (filename, given_name, data) "\
    "values (?, ?, ?); "

  # Delete by id
  DeleteSql = "DELETE FROM #{TableName} WHERE discriminator = ? AND "\
    "discriminator_id = ?;" 

  # Select an attachment given an id
  SelectSql = "SELECT * FROM #{TableName} WHERE id = ? "
end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
wlog-1.1.1	lib/wlog/domain/sql_modules/attachment_sql.rb
wlog-1.0.5	lib/wlog/domain/sql_modules/attachment_sql.rb
wlog-1.0.0	lib/wlog/domain/sql_modules/attachment_sql.rb