Sinatra document

[raingxm]

www.rubydoc.info/gems/sinatra

[kkkkkxiaofei]

小伙伴们，和你们确定一下具体的数据库设计,我最终的购物结算涉及items表，该表的schema如下： CREATE TABLE "items" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "price" float, "unit" varchar(255), "num" integer , "total_money" float, "promoted" varchar(20), "saving_money" float, "created_at" datetime, "updated_at" datetime ); CREATE TABLE "products" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "price" float, "unit" varchar(255), "promoted" varchar(10), "number" integer, "information" varchar(255), "created_at" datetime, "updated_at" datetime ); CREATE TABLE "promotions" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "item_name" varchar(255), "item_id" integer, "created_at" datetime, "updated_at" datetime ); 这样所的好处是： 当向购物车内添加某物品时，只需在后台find一下，若存在则更新num，这样我在结算的时候不必要去再次统计了，如有问题请及时联系。

[raingxm]

哦，看到了

[raingxm]

sinatra中文文档：http://www.sinatrarb.com/intro-zh.html