Changeset 10951 for trunk/psLib/src/db/psDB.c

Timestamp:

Jan 5, 2007, 6:38:29 PM (19 years ago)

Author:

jhoblitt

Message:

add "NOT NULL" field attribute support to psDBGenerateCreateTable()
convert from strstr() -> strcasestr() where appropriate

File:

• trunk/psLib/src/db/psDB.c (modified) (6 diffs)

trunk/psLib/src/db/psDB.c

@@ -12 +12 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.123 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-12-14 23:03:40 $
+ *  @version $Revision: 1.124 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2007-01-06 04:38:29 $
  *
  *  Copyright (C) 2005-2006  Joshua Hoblitt, University of Hawaii
  */
+
+#ifdef HAVE_CONFIG_H
+#include <config.h>
+#endif
 
 #ifdef HAVE_PSDB
@@ -1507 +1511 @@
         }
 
-        if (strstr(item->comment, "AUTO_INCREMENT")) {
+        if (strcasestr(item->comment, "AUTO_INCREMENT")) {
             psStringAppend(&query, " %s", "AUTO_INCREMENT");
         }
-        if (strstr(item->comment, "Unique")) {
+        if (strcasestr(item->comment, "Unique")) {
             psStringAppend(&query, " %s", "UNIQUE");
+        }
+        if (strcasestr(item->comment, "NOT NULL")) {
+            psStringAppend(&query, " %s", "NOT NULL");
         }
 
@@ -1528 +1535 @@
     psArray *pKeys = psArrayAllocEmpty(1);
     while ((item = psListGetAndIncrement(cursor))) {
-        if (strstr(item->comment, "Primary Key")) {
+        if (strcasestr(item->comment, "Primary Key")) {
             psArrayAdd(pKeys, 0, item->name);
         }
@@ -1550 +1557 @@
     while ((item = psListGetAndIncrement(cursor))) {
         // it's just a regular key if it matchs "Key" but not "Primary Key"
-        if (strstr(item->comment, "Key")
-                && (strstr(item->comment, "Primary Key") == NULL)) {
+        if (strcasestr(item->comment, "Key")
+                && (strcasestr(item->comment, "Primary Key") == NULL)) {
             psStringAppend(&query, ", KEY(%s)", item->name);
-        } else if (strstr(item->comment, "AUTO_INCREMENT")) {
+        } else if (strcasestr(item->comment, "AUTO_INCREMENT")) {
             // this needs to be recognized as a key if it wasn't already
             psStringAppend(&query, ", KEY(%s)", item->name);
@@ -1775 +1782 @@
             psMetadataItem *mItem = NULL;
             while ((mItem = psListGetAndIncrement(mCursor))) {
-                if (mItem->comment && strstr(mItem->comment, "==")) {
+                if (mItem->comment && strcasestr(mItem->comment, "==")) {
                     logicalOp = "OR";
                     break;
@@ -1984 +1991 @@
             psStringAppend(&query, "%s IS NULL", itemName);
         } else {
-            if (item->comment && strstr(item->comment, "LIKE")) {
+            if (item->comment && strcasestr(item->comment, "LIKE")) {
                 // XXX ASC NOTE: we should have a better match for
                 // char & varchar columns than this.  LIKE is OK for