README

six-ddc · six-ddc · commit b2acc9ace05d · 2016-08-06T10:41:21.000+08:00
diff --git a/README.md b/README.md
@@ -7,12 +7,14 @@
 ## Examples:
 
 ``` c++
+    using namespace sql;
+
     InsertModel i;
     i.insert("score", 100)
-        .insert("name", std::string("six"))
-                "age", (unsigned char)20,
-                "address", "beijing",
-                "create_time", time(NULL))
+        ("name", std::string("six"))
+        ("age", (unsigned char)20)
+        ("address", "beijing")
+        ("create_time", nullptr)
         .into("user");
     std::cout<<i.str()<<std::endl;
     // insert into user(score, name, age, address, create_time) values(100, 'six', 20, 'beijing', '2016-03-25 10:15:59')
@@ -33,9 +35,9 @@
     UpdateModel u;
     u.update("user")
         .set("name", "ddc")
-        .set("age", 18,
-                "score", 18)
-        .set("address", "beijing")
+        ("age", 18)
+        ("score", nullptr)
+        ("address", "beijing")
         .where(column("id").in(a));
     std::cout<<u<<std::endl;
     // update user set name = 'ddc', age = 18, score = 18, address = 'beijing' where id in (1, 2, 3)
@@ -46,23 +48,4 @@
         .where(column("id") == 1);
     std::cout<<d<<std::endl;
     // delete from user where id = 1
-
-    DataModel m;
-    m["address"] = "chengdu";
-    m["age"] = 18;
-    m.set("age", 20,
-            "score", 80,
-            "create_time", time(NULL));
-
-    u.reset();
-    u.update("user")
-        .set(m);
-    std::cout<<u<<std::endl;
-    // update user set address = 'chengdu', age = 20, create_time = '2016-03-25 23:06:25', score = 80
-
-    i.reset();
-    i.insert(m)
-        .into("user");
-    std::cout<<i<<std::endl;
-    // insert into user(address, age, create_time, score) values('chengdu', 20, '2016-03-25 23:06:25', 80)
 ```
