Subversion Repositories SmartDukaan

Rev

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

Rev 746 Rev 772
Line 135... Line 135...
135 
#===============================================================================
 135 
#===============================================================================
136 
 
 136 
 
137 
class Widget(Entity):
 137 
class Widget(Entity):
138 
    id = Field(Integer, primary_key=True, autoincrement=True)
 138 
    id = Field(Integer, primary_key=True, autoincrement=True)
139 
    type = Field(Integer)
 139 
    type = Field(Integer)
140 
    customer_id = Field(Integer)
 140 
    user_id = Field(Integer)
141 
    name = Field(String(100))
 141 
    name = Field(String(100))
142 
    enabled = Field(Integer)
 142 
    enabled = Field(Boolean)
143 
    session_id = Field(Integer)
 - 
 
144 
    items = OneToMany("WidgetItem")
 143 
    items = OneToMany("WidgetItem")
145 
    using_options(shortnames=True)
 144 
    using_options(shortnames=True)
146 
    using_table_options(mysql_engine="InnoDB")
 145 
    using_table_options(mysql_engine="InnoDB")
147
146
148 
class WidgetItem(Entity):
 147 
class WidgetItem(Entity):
Line 154... Line 153...
154 
    using_table_options(mysql_engine="InnoDB")
 153 
    using_table_options(mysql_engine="InnoDB")
155 
 
 154 
 
156 
class Item(Entity):
 155 
class Item(Entity):
157 
    id = Field(Integer, primary_key=True, autoincrement=True)
 156 
    id = Field(Integer, primary_key=True, autoincrement=True)
158 
    item_id = Field(Integer)
 157 
    item_id = Field(Integer)
159 
    snippet = Field(Integer)
 - 
 
160 
    enabled = Field(Integer)
 158 
    enabled = Field(Boolean)
161 
    widget_items=OneToMany("WidgetItem")
 159 
    widget_items=OneToMany("WidgetItem")
162 
    using_options(shortnames=True)
 160 
    using_options(shortnames=True)
163 
    using_table_options(mysql_engine="InnoDB")
 161 
    using_table_options(mysql_engine="InnoDB")
164 
 
 162 
 
- 
 
 163 
def initialize():
- 
 
 164 
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
- 
 
 165 
    metadata.bind = 'mysql://root:shop2020@localhost/user'
- 
 
 166 
    metadata.bind.echo = True
- 
 
 167 
    setup_all(True)
- 
 
 168 
 
- 
 
 169 
if __name__=="__main__":
- 
 
 170 
    initialize()
- 
 
 171
- 
 
 172
- 
 
 173 
'''
165 
class Ratings(Entity):
 174 
class Ratings(Entity):
166 
    id = Field(Integer, primary_key=True, autoincrement=True)
 175 
    id = Field(Integer, primary_key=True, autoincrement=True)
167 
    item_id = Field(Integer)
 176 
    item_id = Field(Integer)
168 
    type = Field(Integer)
 177 
    type = Field(Integer)
169 
    rating = Field(Float)
 178 
    rating = Field(Float)
Line 175... Line 184...
175 
    item_id = Field(Integer)
 184 
    item_id = Field(Integer)
176 
    rating = Field(Float)
 185 
    rating = Field(Float)
177 
    user_id = Field(Integer)
 186 
    user_id = Field(Integer)
178 
    using_options(shortnames=True)
 187 
    using_options(shortnames=True)
179 
    using_table_options(mysql_engine="InnoDB")
 188 
    using_table_options(mysql_engine="InnoDB")
180
- 
 
181 
def initialize():
 - 
 
182 
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
 - 
 
183 
    metadata.bind = 'mysql://root:shop2020@localhost/user'
 - 
 
184 
    metadata.bind.echo = True
 - 
 
185 
    setup_all(True)
 - 
 
186 
 
 - 
 
187 
if __name__=="__main__":
 - 
 
188 
    initialize()
 - 
 
189
- 
 
190 

            189
            
'''    

          

          

            -
            
 

            190