Subversion Repositories SmartDukaan

Rev

Rev 2815 | Rev 3187 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2815 Rev 2981
Line 186... Line 186...
186 
 
 186 
 
187 
#===============================================================================
 187 
#===============================================================================
188 
# Different entities for the Widget service
 188 
# Different entities for the Widget service
189 
#===============================================================================
 189 
#===============================================================================
190 
 
 190 
 
191 
class Widget(Entity):
 191 
class UserWidgetItem(Entity):
192 
    id = Field(Integer, primary_key=True, autoincrement=True)
 192 
    userId = Field(Integer, primary_key=True)
193 
    type = Field(Integer)
 - 
 
194 
    user_id = Field(Integer)
 193 
    widgetId = Field(Integer, primary_key=True)
195 
    name = Field(String(100))
 - 
 
196 
    enabled = Field(Boolean)
 - 
 
197 
    items = OneToMany("WidgetItem")
 - 
 
198 
    using_options(shortnames=True)
 - 
 
199 
    using_table_options(mysql_engine="InnoDB")
 - 
 
200
- 
 
201 
class WidgetItem(Entity):
 - 
 
202 
    id = Field(Integer, primary_key=True, autoincrement=True)
 194 
    itemId = Field(Integer, primary_key=True)
203 
    added_on = Field(DateTime)
 195 
    addedOn = Field(DateTime)
204 
    item = ManyToOne("Item")
 - 
 
205 
    widget = ManyToOne("Widget")
 - 
 
206 
    using_options(shortnames=True)
196 
    using_options(shortnames=True)
207 
    using_table_options(mysql_engine="InnoDB")
 197 
    using_table_options(mysql_engine="InnoDB")
208 
 
 198 
 
209 
class Item(Entity):
 - 
 
210 
    id = Field(Integer, primary_key=True, autoincrement=True)
 - 
 
211 
    item_id = Field(Integer)
 - 
 
212 
    enabled = Field(Boolean)
 - 
 
213 
    widget_items=OneToMany("WidgetItem")
 - 
 
214 
    using_options(shortnames=True)
 - 
 
215 
    using_table_options(mysql_engine="InnoDB")
 - 
 
216 
 
 - 
 
217 
class MasterAffiliate(Entity):
 199 
class MasterAffiliate(Entity):
218 
    id = Field(Integer, primary_key=True, autoincrement=True)
 200 
    id = Field(Integer, primary_key=True, autoincrement=True)
219 
    name = Field(String(100), unique=True)
 201 
    name = Field(String(100), unique=True)
220 
    added_on = Field(DateTime)
 202 
    added_on = Field(DateTime)
221 
    affiliates = OneToMany("Affiliate")
 203 
    affiliates = OneToMany("Affiliate")
Line 265... Line 247...
265 
    metadata.bind.echo = True
 247 
    metadata.bind.echo = True
266 
    setup_all(True)
 248 
    setup_all(True)
267 
 
 249 
 
268 
if __name__=="__main__":
 250 
if __name__=="__main__":
269 
    initialize()
 251 
    initialize()
270
- 
 
271
- 
 
272 
'''
 - 
 
273 
class Ratings(Entity):
 - 
 
274 
    id = Field(Integer, primary_key=True, autoincrement=True)
 - 
 
275 
    item_id = Field(Integer)
 - 
 
276 
    type = Field(Integer)
 - 
 
277 
    rating = Field(Float)
 - 
 
278 
    using_options(shortnames=True)
 - 
 
279 
    using_table_options(mysql_engine="InnoDB")
 - 
 
280 
 
 - 
 
281 
class UserRatings(Entity):
 - 
 
282 
    id = Field(Integer, primary_key=True, autoincrement=True)
 - 
 
283 
    item_id = Field(Integer)
 - 
 
284 
    rating = Field(Float)
 - 
 
285 
    user_id = Field(Integer)
 - 
 
286 
    using_options(shortnames=True)
 - 
 
287 
    using_table_options(mysql_engine="InnoDB")
 - 
 
288 
'''
-