this.query("""
SELECT
- id,
- DATE_FORMAT(created,"%%Y/%%m/%%d") as create_date,
- msgid
- FROM
- Attachment
- WHERE
- checksum = '%s'
- AND
- filesize = %d
- LIMIT
- 1
+
+ attachment_init(
+ '%s', -- in_msgid VARCHAR(32),
+ '%s', -- in_checksum VARCHAR(64),
+ '%s' -- in_mime_filename varchar(255)
+ ) as id ;
""".printf( chksum, file_size)
);
var file_id = "0";