[DBTNG + BLOB] remap {comments}.comment

hswong3i - August 27, 2008 - 21:04
Project:Drupal
Version:7.x-dev
Component:comment.module
Category:feature request
Priority:critical
Assigned:hswong3i
Status:duplicate
Description

As case mentioned in http://drupal.org/node/147947, this patch remap {comments}.comment as BLOB type. Also merge with http://drupal.org/node/300219 for correct schema definition.

MySQL:

  • update.php: pass.
  • INSERT/UPDATE: pass.

PostgreSQL:

  • update.php: FAILED. Seems PostgreSQL schema don't handle change field correctly.
  • INSERT/UPDATE: FAILED. Seems db_insert() of PostgreSQL don't handle correctly.

AttachmentSizeStatusTest resultOperations
comments-comment.patch4.73 KBIdleFailed: Failed to apply patch.View details | Re-test

#1

hswong3i - September 24, 2008 - 16:19

Revamp with drupal_write_record() for simpler handling.

When combine with simplify drupal_write_record() with db_insert() and db_update(), it can prevent the incorrect input type for pid and uid when compare with using db_insert() directly.

Tested with MySQL and PostgreSQL. Stand alone simpletetest, pass; simpletest when combine with http://drupal.org/node/299088, also pass.

#2

hswong3i - September 24, 2008 - 16:19

Revamp with drupal_write_record() for simpler handling.

When combine with simplify drupal_write_record() with db_insert() and db_update(), it can prevent the incorrect input type for pid and uid when compare with using db_insert() directly.

Tested with MySQL and PostgreSQL. Stand alone simpletetest, pass; simpletest when combine with http://drupal.org/node/299088, also pass.

AttachmentSizeStatusTest resultOperations
comments-comment.patch3.93 KBIdleFailed: Failed to apply patch.View details | Re-test

#3

hswong3i - October 8, 2008 - 17:41

Update based on http://drupal.org/node/316095 founding. Revamp BLOB field with nullable.

Tested with MySQL and PostgreSQL. Stand alone simpletest, pass; simpletest when combine with http://drupal.org/node/299088, also pass.

AttachmentSizeStatusTest resultOperations
comments-comment-1223485861.patch3.21 KBIdleFailed: Failed to apply patch.View details | Re-test

#4

Anonymous (not verified) - November 12, 2008 - 10:10
Status:needs review» needs work

The last submitted patch failed testing.

#5

hswong3i - November 13, 2008 - 04:53
Title:Remap field as BLOB: {comments}.comment» [DBTNG + BLOB] remap {comments}.comment
Status:needs work» needs review

Patch reroll after DBTNG syntax revamp #314532: DBTNG comment.module. Only change schema as BLOB type. Pass all comment's simpletest.

AttachmentSizeStatusTest resultOperations
dbtng-comments-comment-1226549584.patch1.14 KBIdlePassed: 7431 passes, 0 fails, 0 exceptionsView details | Re-test

#6

System Message - November 16, 2008 - 22:05
Status:needs review» needs work

The last submitted patch failed testing.

#7

lilou - November 17, 2008 - 14:25

#8

hswong3i - November 24, 2008 - 18:59
Status:needs review» duplicate

duplicate with #147947: [DBTNG + XDB] Replace some TEXT:BIG with BLOB

 
 

Drupal is a registered trademark of Dries Buytaert.