-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdb_setter.py
executable file
·219 lines (210 loc) · 63.2 KB
/
db_setter.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
#!/root/.pyenv/shims/python
from models import strg
from models.category import Category
from models.product import Product
from models.user import User
from models.car import Car
import os
import random
cat_1 = Category(name='Tires & Wheels')
cat_1_1 = Category(name='Wheels', parent_id=cat_1.id)
prod_1_1_1 = Product(name='Verde Wheels Contra Gloss Black/Machined Wheel Spoke and Lip (20 x 8.5 inches /5 x 4 inches, 35 mm Offset)', price=157.82, category_id=cat_1_1.id, icon='prod_1_1_1', description='Since 1981, Verde Custom Wheels has committed its team - from research and development through design and production - to excellence. This dedication has resulted in both ISO/TS16949 certification and recognition internationally via certification by the International Standards Organization. Their factory, built in 2002, is a fully integrated production line with R & D, tooling, casting, CNC machining, polishing, chrome plating, painting, packaging and warehouse logistics capabilities.')
prod_1_1_2 = Product(name='Wheel Accessories Parts 2 Pieces Die Cast Fits 5x4.25 5x110 5x112 5x4.5 5x115 5x120 5x4.75 5x5 5x135mm 5x5.5 Bolt Pattern Vehicle 12mm 1/2" Thick 164mm Fits Fits Pass Cars Light Trucks SUVs', price=21.49, category_id=cat_1_1.id, icon='prod_1_1_2', description='Specs: Thickness: 12mm 1/2" | Die Cast A380 Alum | Fits 5x4.25 5x110 5x112 5x4.5 5x115 5x120 5x4.75 5x5 5x135mm 5x5.5 Bolt Pattern | ID : 89mm | OD : 164mm | Finish : Shot Peened | 2 Pcs Widen your vehicle base and give your vehicle a more aggressive stance while improving handling and stability. Increase tire clearance, fix brake caliper clearance issues, allow installation of lift lowering kits and wider, larger, or high traction tires. Our wheel spacers are die cast A380 Aluminum. A380 offers excellent corrosion resistance and rigidity. Each spacer has a shot peened finish. Shot peening, creates a hemisphere of cold-worked material highly stressed in compression beneath the surface, significantly increasing the strength of the part.')
prod_1_1_3 = Product(name='Black Rhino SELKIRK Wheel with Painted Finish (20 x 10. inches /5 x 127 mm, 23 mm Offset)', price=289.52, category_id=cat_1_1.id, icon='prod_1_1_3', description='What happens when you combine a feisty off-road attitude with a hardened aluminum alloy, multi-piece construction and stunning design details? You get Black Rhinos new Selkirk model off-road wheels. Selkirk wheels, with their ten brawny spokes and beefy center cap, in a gloss black finish with bright milled edge detail, punctuated by oversized hex bolts at the lip edge, just exudes a lifted truck temperament. Our manufacturing expertise enables us to combine a one-piece cast spoke and hub array fusion welded to a lightweight forged our barrel, the best of two worlds. Selkirk off-road rims are available17x9, 18x9, 20x9 and 20x10 sizes, with a wide range of offsets to help you achieve the wide off-road footprint youre after')
prod_1_1_4 = Product(name='Touren TR9 3190 Wheel with Hyper Silver Finish (18x8"/5x127mm)', price=204.98, category_id=cat_1_1.id, icon='prod_1_1_4', description='Touren Wheels sees beauty in motion with each wheel we create. We proudly construct only the highest quality wheels that convey your discriminating taste and sense of style. Our engineers scrutinize every detail to ensure that we deliver the most precise products possible. At Touren, we seek perfection and settle for excellence.')
prod_1_1_5 = Product(name='Touren TR9 3190 Wheel with Matte Black Finish (17x7"/5x127mm)', price=181.98, category_id=cat_1_1.id, icon='prod_1_1_5', description='Touren Wheels sees beauty in motion with each wheel we create. We proudly construct only the highest quality wheels that convey your discriminating taste and sense of style. Our engineers scrutinize every detail to ensure that we deliver the most precise products possible. At Touren, we seek perfection and settle for excellence.')
prod_1_1_6 = Product(name='Touren TR9 3190 Black Wheel with Machined Face/Lip (18x8"/5x127mm)', price=181.98, category_id=cat_1_1.id, icon='prod_1_1_6', description='Touren Wheels sees beauty in motion with each wheel we create. We proudly construct only the highest quality wheels that convey your discriminating taste and sense of style. Our engineers scrutinize every detail to ensure that we deliver the most precise products possible. At Touren, we seek perfection and settle for excellence.')
prod_1_1_7 = Product(name='Verde Wheels - V36 Protocol Chrome Wheel with Dual Bolt Pattern 18x7.5"/5x4.5" or 5x5"/+40mm Offset', price=210.90, category_id=cat_1_1.id, icon='prod_1_1_7', description='The V36 - Protocol is a stylish modernization of a split five spoke design. The V36 - Protocol is specifically intended to fit the majority of front-wheel drive passenger applications, and is available in both Chrome and Black with Machined Finish.')
cat_1_2 = Category(name='Accessories & Parts', parent_id=cat_1.id)
cat_1_2_1 = Category(name='Air Compressors & Inflators', parent_id=cat_1_2.id)
prod_1_2_1 = Product(name='DNA MOTORING TOOLS-00270 150 PSI Wireless Portable Air Pump Tire Inflator for Inflating Car, Truck & Motorcycle Tires, Balls', price=36.46, category_id=cat_1_2_1.id, icon='prod_1_2_1', description='HIGH-QUALITY DNA TOOLS - Each item in our collection is the result of significant research and development, as well as rigorous automotive application testing and fitments carried out by our highly qualified specialists. We test the materials strength and durability to guarantee that the tools arrive completely prepared for their intended use at the consumers end.')
prod_1_2_2 = Product(name='DNA Motoring 12 V 125 PSI LED Flash Light Air Pump Portable Air Compressor Inflator for Cars, Bikes and Balls (TOOLS-00083)', price=33.06, category_id=cat_1_2_1.id, icon='prod_1_2_2', description='Built-in LED Flash Light; 125 PSI Max Pressure, digital display makes pressure gauge easy to read, PSI and BAR 1.23 CFM; 12V Cigarette Adapter with 3M Length Cord; 65M Length Air Hose Nozzle Adapters & Ball Needle; Convenient Storage Bag')
prod_1_2_3 = Product(name='AUCELI 2PCS 1/4 inch Lock on All Metal Air Chuck, Inflation Pump with Hose Clamp, Mini Air Compressor Portable Tire Inflator Tire Chuck Nozzle, Hose End with Barb Connector (Hose Clamp)', price=6.99, category_id=cat_1_2_1.id, icon='prod_1_2_3', description='Car inflator pump replacement nozzle quick connect inflation operation is easy, just press the clip to clamp the adapter head on the tire valve, open flow with locking clip makes it easy to carry out hands-free tire inflation. Specific operation steps: 1. cut off the original inflation nozzle with scissors first. 2. then press the tail plug 0.26 inch inflation chuck into tube to finish.')
prod_1_2_4 = Product(name='Air Inflator Hose Adapter, Car Valve Adaptor with Locking Tire Chuck, Tire Inflator Pump Hose Adapter for Twist on Convert to Lock on Connection, Standard Tire Valve Thread for Most Car (23.62'')', price=7.99, category_id=cat_1_2_1.id, icon='prod_1_2_4', description='Advanced tire inflator hose fittings designed to convert tire inflator hoses, it can easily converting the rotary connection of a tire inflator to a locking connection. Place the adapter screw on the hose of the original inflator, press the adapter head to fix the adapter on the tire valve, start the inflator to inflate quickly and without leakage.')
prod_1_2_5 = Product(name='ASUBHA Tire Air Chucks, Tire Inflator Chuck, Air Tire Inflator Nozzle Adapter Accessory, Tire Inflation Nozzle Adapter, Lock-On Air Chuck, Car Pump Accessories for Motorcycles Bike Truck', price=8.59, category_id=cat_1_2_1.id, icon='prod_1_2_5', description='The 8v1 external thread is the same as most tire nozzles on the market, the Air Chuck Quick Connect is suitable for most automotive air pumps, such as cars, bicycle, motorcycle, truck, car tire inflation.')
prod_1_2_6 = Product(name='LivTee Tire Inflator Portable Air Compressor for Car Tires - Car Accessories, 12V DC Air Pump with Digital Tire Pressure Gauge, Max 150PSI with Emergency LED Lights for Car, Camper, RV, Truck', price=17.59, category_id=cat_1_2_1.id, icon='prod_1_2_6', description='LivTee Auto Tire Air inflator can Fully inflate standard car tire in 2 to 4 mins. Simply connect it to 12V power outlet in your car and attach the hose to the tire intended for inflation. You just need to clip the switch and the Air compressor will do all the work for you, and it automatically turns off when it reached the preset pressure.')
prod_1_2_7 = Product(name='Nilight Tire Inflator Portable Air Compressor 12VDC Car Air Pump 150PSI Digital Tire Pressure Gauge Auto Shutoff Tire Pump for Car SUV Motorcycle Bicycle ATV, 2 Year Warranty', price=32.99, category_id=cat_1_2_1.id, icon='prod_1_2_7', description='No More Flat Tires: Nilight Tire Pump can inflate the 195/55/R15 car tires from 0 to 35psi within 5 minutes and capable of providing a maximum pressure of 150 psi and an airflow of 35L/Min. Professionally inflate your flat tires and much more effective and faster than traditional tire pump. A great solution for emergency on the way.')
prod_1_2_8 = Product(name='DNA MOTORING TOOLS-00212 Pink 12V DC Digital Tire Inflator Portable Air Compressor with Pressure Gauge for Cars, Bicycles, Motorcycles,Balls', price=27.37, category_id=cat_1_2_1.id, icon='prod_1_2_8', description='Each product by DNA is a result of deep research and development paired with rigorous testing and fitments. The strength testing and durability of the material ensure that the tools arrive at the consumer’s end perfectly ready for their intended use.')
cat_1_2_2 = Category(name='Stem Caps', parent_id=cat_1_2.id)
prod_1_2_2_1 = Product(name='Alpmosn Aluminum Tire Stem Valve Caps Wheel Valve Covers Car Dustproof Tire Cap Cover Accessories, Universal for SUV, Car, Bike and Motorcycle, Hexagon Shape (4PCS Black)', price=3.99, category_id=cat_1_2_2.id, icon='prod_1_2_2_1', description='The valve cap is made of high quality aluminum alloy, which can effectively protect the tire from damage after long-term use.')
prod_1_2_2_2 = Product(name='SINGARO Car Tire Valve Caps, 4 Pieces of Universal Aluminum Alloy Tire Trim Accessories Dust Tire Covers for Cars, Trucks, SUVs and Motorcycles(Black)', price=4.79, category_id=cat_1_2_2.id, icon='prod_1_2_2_2', description='The tire valve cap is made of high-quality aluminum alloy, wear-resistant and durable, and can effectively protect the tire valve rod cap from being blocked.')
prod_1_2_2_3 = Product(name='JUSTTOP 4 Pack Handmade Crystal Rhinestone Tire Valve Stem Caps, Wheel Tire Valve, Attractive Dustproof Bling Car Accessories, Universal for Cars, Trucks and Motorcycles-White', price=5.59, category_id=cat_1_2_2.id, icon='prod_1_2_2_3', description='Valve caps can protect the valve, prevent the water, dust or sand into the tire; preventing the valve from leaking, ensure the safe driving.')
prod_1_2_2_4 = Product(name='Tire Valve Stem Cap Cover - (5 Pack) Tire Air Cap Metal with Plastic Liner Corrosion Resistant Leak-Proof American Flag for Car Truck Motorcycle Bike Black', price=5.89, category_id=cat_1_2_2.id, icon='prod_1_2_2_4', description='The tire valve stem caps come with metal shell and plastic insert, which will prevent the valve stem from corrosion, special in wet/cold area.')
prod_1_2_2_5 = Product(name='4pcs Tire dust caps, Aluminum Alloy Valve Stem Cap, Anti-Corrosion Leak-Proof Car Tire Accessory Compatible with Tesla Model Y X S 3, Universal for Cars, SUVs, Bike, Trucks Motorcycles (Black)', price=5.98, category_id=cat_1_2_2.id, icon='prod_1_2_2_5', description='The car tyre air caps cover is made of Alloy metal and it will keep the dusts off your car tyres. The materials stand for sturdiness and durability.At any extreme weather, fadeless, rustless, and durable.')
prod_1_2_2_6 = Product(name='SINGARO 60mm Spiked Valve Caps,Aluminum Alloy Dustproof and Waterproof Tire Valve Stem Caps, Suitable for Cars, Trucks and Motorcycles (4PCS Black)', price=4.79, category_id=cat_1_2_2.id, icon='prod_1_2_2_6', description='Made of high-quality aluminum alloy, 100 brand-new and high-quality, anti-oxidation and wear resistance, longer service life, not easy to deform or fracture, so that you can use it at ease.')
prod_1_2_2_7 = Product(name='4 PCS Bears Paw Car Wheel Tire Valve Stem Caps, Airtight Dust Proof Leak Proof Covers, Stainless Steel Corrosion Resistant Tire Decorations, Car Accessories for SUV Motorcycle Bicycle (Black)', price=6.99, category_id=cat_1_2_2.id, icon='prod_1_2_2_7', description='Tire valve cap with cute cat/dog/bear paw design to make your car tire valve more beautiful and stylish. If you are a puppy person, you will definately love this. Replace the cheap plastic ones that came with the car, give your wheel a new look! There are three colors, they all look great and stay very well, when you drive on the road the color will not fade.')
prod_1_2_2_8 = Product(name='Wheel Accessories Parts PDQ Brand TPMS 12 PC OEM Sensor Service Kit Rubber Valve Stems Fits Alfa Romeo Giulia 2017+ Stelvio 2018+ Chrysler 200 Pacifica 2018+ Dodge Dart Durango Jeep Renegade Compass', price=25.99, category_id=cat_1_2_2.id, icon='prod_1_2_2_8', description='Wheel Accessories Parts is a US company. All prodcuts are designed, stocked and distributed in the USA by US employees. Your purchases create opportunites for Americans. Thank you for your support.')
prod_1_2_2_9 = Product(name='Ziciner 8 PCS Car Tire Valve Caps, Aluminum Alloy Wheel Valve Stem Covers with Rubber Ring, Corrosion Resistant Leak-Proof Tire Valve Cap Set, Universal for SUV, Truck, Motorcycle, Bike (Silver)', price=3.99, category_id=cat_1_2_2.id, icon='prod_1_2_2_9', description='This tire valve cap is made of high quality aluminum alloy and plastic lining, stuffed with air leak-proof rubber inner ring, no internal corrosion, and the exterior will not easily crack or fade.')
prod_1_2_2_10 = Product(name='Ziciner 4 PCS Car Tire Valve Caps, Spiked Aluminum Alloy Tire Trim Accessories, Dustproof Tire Wheel Stem Covers, Universal Air Stem Cap for Auto, Trucks, SUVs, Bicycles and Motorcycles (Colorful)', price=4.79, category_id=cat_1_2_2.id, icon='prod_1_2_2_10', description='The car tire valve caps are manufactured using brand new engineering materials aluminum alloy with high quality, made of precision CNC process, very durable and wear-resistant, antioxidant is not easy to deform and fracture, with a long service life, which can effectively protect the tire valve stem cap from being blocked.')
cat_2 = Category(name='Oils & Fluids')
cat_2_1 = Category(name='Oils', parent_id=cat_2.id)
prod_2_1_1 = Product(name='TRIAX Synergy Gear MAX 75W-140 GL-5, PAO Synthetic Long-Drain Axle, Differential Extreme Pressure Oil, Limited Slip Ready, 750,000 Mile Rating on Highway (5 Gal Pail)', price=149, category_id=cat_2_1.id, icon='prod_2_1_1', description='Extreme drain intervals; 500,000 miles for heavy-duty pickup trucks and passenger cars; 750,000 miles for Class 8 highway trucks; Has -60 F pour point')
prod_2_1_2 = Product(name='Valvoline High Mileage with MaxLife Technology SAE 5W-30 Synthetic Blend Motor Oil 5 QT', price=129, category_id=cat_2_1.id, icon='prod_2_1_2', description='MAXLIFE TECHNOLOGY PREVENTS engine breakdown with 40 better wear protection than the industry standard')
prod_2_1_3 = Product(name='Royal Purple 51530 API-Licensed SAE 5W-30 High Performance Synthetic Motor Oil - 5 qt., Model:ROY51530', price=36.56, category_id=cat_2_1.id, icon='prod_2_1_3', description='Better Wear Protection Increased Fuel Efficiency. Royal Purple Motor Oil Is Both Fluid And Lubricant Better Protection Of The Expensive Catalytic Emission System Improved Compatibility With Fuels Containing Ethanol')
prod_2_1_4 = Product(name='Super S Anti-Wear AW32 Hydraulic Oil for Log & Wood Splitters, Gear & Compressor Oil- Rust & Corrosion Protection- 1 Gallon', price=23.05, category_id=cat_2_1.id, icon='prod_2_1_4', description='Brand Super S Item Weight 7.76 pounds Package Dimensions 11.1 x 9.21 x 5.04 inches Manufacturer Part Number agrgfgfa-238')
prod_2_1_5 = Product(name='Kubota Gear Lubricant HD SAE 80W-90', price=21.87, category_id=cat_2_1.id, icon='prod_2_1_5', description='Kubota Gear Lubricant HD for use in Kubota excavators and construction equipment.')
prod_2_1_6 = Product(name='WILDFLOWER Tools 08208-0080 Pro Shaft Drive Oil (Pack of 2) with One Pair of Yellow Gloves', price=20.16, category_id=cat_2_1.id, icon='prod_2_1_6', description='Pack of two 8 Oz bottles of Honda Pro Shaft Drive Oil, with one pair of gloves by WILDFLOWER Tools')
prod_2_1_7 = Product(name='Liqui Moly 20230 Molygen New Generation 5W-40 Motor Oil, 1 Liter', price=16.99, category_id=cat_2_1.id, icon='prod_2_1_7', description='Ensures that the motor oil is of low viscosity with a high shear stability and reliably prevents the formation of deposits')
prod_2_1_8 = Product(name='TSI Supercool A/C Comp PAG Lube, 8 Oz, Flash Point 450 F', price=8.70, category_id=cat_2_1.id, icon='prod_2_1_8', description='Package Dimensions: 5.0 cm (L) X 5.5 cm (W) X 14.5 cm (H)')
prod_2_1_9 = Product(name='TSI Supercool A/C Comp Lube, UV Dye, 8 Oz, Flsh PNT 442 F, red/Yellow Tint (P46-8D)', price=10, category_id=cat_2_1.id, icon='prod_2_1_9', description='package dimensions: 18 l x 21 h x 18 w (inches) package weight : 6.53 pounds country of origin : united states part number: p46-8d Fit type: Universal Fit')
prod_2_1_10 = Product(name='Universal PA', price=10.05, category_id=cat_2_1.id, icon='prod_2_1_10', description='Universal PA')
prod_2_1_11 = Product(name='Valvoline 4-Stroke Motorcycle Full Synthetic 10W-40 Motor Oil 1 QT (Pack of 2)', price=20.16, category_id=cat_2_1.id, icon='prod_2_1_11', description='ANTI-FRICTION FORMULATION is specially designed for the extreme temperatures and high RPMs of 4-stroke motorcycles')
cat_2_2 = Category(name='Transmission Fluids', parent_id=cat_2.id)
prod_2_2_1 = Product(name='Mobil 1 123130 Transmission Fluid, 6 Quart, 1 Pack', price=34.40, category_id=cat_2_2.id, icon='prod_2_2_1', description='Item Package Dimension: 9.649L x 9.209W x 7.829H inches Item Package Weight - 12.850 Pounds Item Package Quantity - 1 Product Type - AUTO OIL')
prod_2_2_2 = Product(name='Toyota 00279-000T4 Automatic Transmission Fluid, 192 Ounces, 6 Pack', price=49.50, category_id=cat_2_2.id, icon='prod_2_2_2', description='Fit type: Universal Fit Package Dimensions: 24.003 H x 19.177 L x 22.86 W (centimetres) Package Weight: 5.488 kilograms Country of Origin : United States')
prod_2_2_3 = Product(name='Smilyeez Listing for BG Transmission Service Flush Kit PN K6600 Includes PM 106 Cleaner & PN 310 Conditioner with Pocket Screw Driver (1 Kit)', price=44.95, category_id=cat_2_2.id, icon='prod_2_2_3', description='Prolongs fluid life Maintains transmission performance Extends transmission life Prevents thermal breakdown of fluid Greatly improves oxidation stability')
prod_2_2_4 = Product(name='Quicksilver V-Twin Primary Chaincase and Transmission Fluid - 1 Qt.', price=15.91, category_id=cat_2_2.id, icon='prod_2_2_4', description='Provides outstanding wear protection in transmissions and primary chaincases')
prod_2_2_5 = Product(name='VISCOSITY Multi G Transmission Hydraulic Fluid - Compatible with Mahindra, McCormick Tractors - 1 Gallon - 77462JX2US', price=44.99, category_id=cat_2_2.id, icon='prod_2_2_5', description='Provides protection for your hydraulic system helping to maintain the efficiency of your equipment')
prod_2_2_6 = Product(name='Mopar 68218057AB Auto Trans Fluid', price=13.12, category_id=cat_2_2.id, icon='prod_2_2_6', description='Mopar 68218057AB Auto Trans Fluid')
prod_2_2_7 = Product(name='Bel-Ray 840-1478 Sport Transmission Fluid 1L', price=19.87, category_id=cat_2_2.id, icon='prod_2_2_7', description='Formulated for the transmission and primary of Sportster motorcycles and Buell Blast motorcycles')
prod_2_2_8 = Product(name='Compatible with Harley Davidson 02-16 FLHTC Electra Glide 2 Quarts V-Twin Synthetic Transmission Fluid', price=22.99, category_id=cat_2_2.id, icon='prod_2_2_8', description='High Performance V-Twin Synthetic Transmission Fluid, Quantity 2 (two) Quarts, Full Synthetic, Exceeds Industry Requirements: API GL-5, Non Corrosive, Handles Severe Load, Maximum Protection for Gears, Harley Davidson')
prod_2_2_9 = Product(name='Pentosin 1038107 FFL-2 Synthetic Double Clutch (DSG) Transmission Fluid, 1 Liter', price=28, category_id=cat_2_2.id, icon='prod_2_2_9', description='Fully synthetic double clutch (DSG) transmission fluid and allows safe transmission operation even at the highest thermal loads')
cat_2_3 = Category(name='Windshield Washer Fluids', parent_id=cat_2.id)
prod_2_3_1 = Product(name='Rain-x 2 Pack 2 in 1 All Season (-25) Washer Fluid Net Wt 255.63 Fl Oz, 255.63 Fluid Ounce', price=23.85, category_id=cat_2_3.id, icon='prod_2_3_1', description='Removes light snow, ice, grime, and bugs. Applies water-beading technology to help keep windshield clear. For use in cold weather')
prod_2_3_2 = Product(name='Rain-X White RX11806D Washer Fluid Additive-16.9 fl. oz, 500. ml', price=6.99, category_id=cat_2_3.id, icon='prod_2_3_2', description='Add to existing washer fluid. Applies water beading technology. Enhances driving visibility. Helps prevent and remove sleet, snow, ice, bugs and road spray from sticking to glass. Improves cleaning')
prod_2_3_3 = Product(name='HOCAR USA Windshield Washer Fluid, Windshield Wiper Fluid, Premium Quality 1 Gal - Free Funnel Included', price=17.99, category_id=cat_2_3.id, icon='prod_2_3_3', description='No need to mixing with water like the windshield washer fluid concentrate, or waiting 20 minutes like windshield washer tablets. Simply pour directly into the windshield fluid reservoir')
prod_2_3_4 = Product(name='nextzett 92100815 Kristall Klar Washer Fluid 1:200 Concentrate - 8.5 fl. oz., Green', price=13.13, category_id=cat_2_3.id, icon='prod_2_3_4', description='With just a few sprays, Kristall Klar easily cuts through road film, cleans bug splatter and sap while leaving a glare-free and streak-free crystal clean finish')
prod_2_3_5 = Product(name='BUGOFF Windshield Washer Fluid Ultra-Concentrated', price=6.99, category_id=cat_2_3.id, icon='prod_2_3_5', description='Save more. Makes 6 Gallons. Reduces landfill waste. Adds Water Beading Properties. Cleans off Bug Grime and Dirt to a Streak Free Shine. Compact and easy to use. Unit count type: Fl Oz')
prod_2_3_6 = Product(name='BUGOFF Windshield Washer Fluid Ultra-Concentrated (Professional 200+ Gallons)', price=34.99, category_id=cat_2_3.id, icon='prod_2_3_6', description='Professional Savings. Makes 200+ Gallons. Reduces landfill waste. Adds Water Beading Properties. Cleans off Bug Grime and Dirt to a Streak Free Shine. Ultra-Concentrated. Industrial Formula')
prod_2_3_7 = Product(name='6 Pack Rain X Green Windshield Washer Fluid With Rain Repellant & Bug Remover 32* F All Weather Fluid 1 Gallon Each', price=74, category_id=cat_2_3.id, icon='prod_2_3_7', description='6 Pack Rain X Green Windshield Washer Fluid With Rain Repellant & Bug Remover 32* F All Weather Fluid 1 Gallon Each')
prod_2_3_8 = Product(name='100 Pieces Car windshield washer fluid Concentrated Clean Tablets,New Formula windshield wiper fluid Solid Effervescent Tablet.Remove glass stains,Clear vision(Use With De-icer or Methanol for Winter)', price=10.24, category_id=cat_2_3.id, icon='prod_2_3_8', description='This windshield washer tablets has strong dirt removing performance,can effectively clean the harmful and stagnant dirt even if it is invisible,greatly reducing the friction of the wiper blade and glass,which can soften the wiper and reduce noise.Clean window and safe driving.')
prod_2_3_9 = Product(name='Qwix Mix Windshield Washer Fluid Concentrate, 1 Bottle Makes 32 Gallons, 1/4 oz. Makes 1 Gallon 100% Biodegradable', price=23.99, category_id=cat_2_3.id, icon='prod_2_3_9', description='Make it like the factory does, consistent quality that wipes to a streak-free shine.')
prod_2_3_10 = Product(name='MDMprint 16 oz. Windshield De-Icer Aerosol can, 1 PK', price=14, category_id=cat_2_3.id, icon='prod_2_3_10', description='16 oz. Windshield De-Icer Aerosol can, 1 PK')
cat_3 = Category(name='Replacement Parts')
cat_3_1 = Category(name='Batteries & Accessories', parent_id=cat_3.id)
cat_3_1_1 = Category(name='Batteries', parent_id=cat_3_1.id)
prod_3_1_1_1 = Product(name='Neptune Power Products 12V Battery Replacement for Verizon FiOS PX12072-HG (12v 7.2ah F1)', price=19.89, category_id=cat_3_1_1.id, icon='prod_3_1_1_1', description='This includes a Neptune 12V 7.2AH-F1 battery. Size: 5.94 in. 2.56 in. 3.94 in. Our 12V 7.2AH-F1 Sealed Lead Acid rechargeable batteries meet or exceed the OEM SLA battery specifications. We supply only brand new, factory fresh, high-quality batteries. We guarantee the best price and 100 compatibility with your 12V-7.2AH-F1 Sealed Lead Acid battery model. The replacement SLA batteries also include a one-year warranty. All replacement batteries are UL listed as well.')
prod_3_1_1_2 = Product(name='Battery Insulation Kit Fits Most Mount Batteries, 40"x7"', price=10.39, category_id=cat_3_1_1.id, icon='prod_3_1_1_2', description='Reliable battery protection. This battery insulation kit can insulate heat, reduce vibration and prevent corrosion, aiming at protecting the battery and engine parts from high temperature, vibration and acid leakage.')
prod_3_1_1_3 = Product(name='84102447710 2447710 Car Battery, TCB Emergency Battery for Car Battery, Universal Car Emergency Battery Replacement, 330mah', price=19.89, category_id=cat_3_1_1.id, icon='prod_3_1_1_3', description='MAIN USE: The battery is mainly used in telematics control unit for better controlling performance!')
prod_3_1_1_4 = Product(name='Powersonic TRIPP LITE RBC51 WERKER WKA12-7.5 F2 TERMINALS 12V 7Ah ONE REPLACEMENT BATTERY', price=15.99, category_id=cat_3_1_1.id, icon='prod_3_1_1_4', description='Original Power Sonic PS-1270 F2 12V 7AH SLA Battery. Dimensions: (L) 5.95 x (W) 2.56 x (H) 3.86. Weight: 4.80 lbs.')
prod_3_1_1_5 = Product(name='QTQ 12v 7ah LiFePO4 Battery Rechargeable Deep Cycle Lithium Battery, Built-in BMS, 5000+ Cycles, Perfect for Fish Finder, Alarm System, Small UPS, Ride on Toys (12V7Ah)', price=29.99, category_id=cat_3_1_1.id, icon='prod_3_1_1_5', description='Enjoy high energy density, long cycle life, and good safety performance with our Lithium iron phosphate battery. Our lifepo4 battery comes with built-in BMS protection to prevent overcharge, over-discharge, over-current, and short circuit. Plus, it has a very low self-discharge rate.')
prod_3_1_1_6 = Product(name='12-Volt Battery Fits Power Wheels Branded Toys: Replacement Part 1001175653, 00801-0638, 00801-1869 All Gray Rechargeable', price=86.21, category_id=cat_3_1_1.id, icon='prod_3_1_1_6', description='Includes Internal, Self-Resetting Fuse and is Non-Spillable / Non-Hazardous Fully Rechargeable. Lasts 25 Longer. Fisher-Prices New 12 Volt 12 Ah All Gray Battery Compared to Old 9.5Ah Battery')
prod_3_1_1_7 = Product(name='DB Electrical 626-01004 Battery Isolator Compatible with/Replacement for EMP PARTS 4-6855', price=53.63, category_id=cat_3_1_1.id, icon='prod_3_1_1_7', description='Unit Type: BATTERY ISOLATOR, Brief: NEGATIVE GROUND, 2-BATTERY SYSTEM, 2 BATTERY STUDS, 1 ALTERNATOR STUD, 1 EXCITATION STUD - FUNCTION TO VOLTAGE REGULATOR, 75A MAX OUTPUT')
prod_3_1_1_8 = Product(name='Motobatt MBYZ16HD AGM Quadflex Battery', price=112.08, category_id=cat_3_1_1.id, icon='prod_3_1_1_8', description='Factory sealed, valve regulated, maintenance-free design eliminates damage from acid spills and corrosion; environmentally safe.')
prod_3_1_1_9 = Product(name='WPS Battery Maint Free Ctx20Ch-Bs - CTX20CH-BS', price=70.90, category_id=cat_3_1_1.id, icon='prod_3_1_1_9', description='C50-N18L-A has almost 100 more cranking amps than any other battery in this size. Dimensions: 6in. x 3 7/16in. x 6 3/8in..')
prod_3_1_1_10 = Product(name='ACDelco silver, calcium Gold 48AGM 36 Month Warranty AGM BCI Group 48 Battery For Truck , Black', price=166.99, category_id=cat_3_1_1.id, icon='prod_3_1_1_10', description='Robust envelope separator with puncture resistant back, allows for increased acid circulation and prevents shorts. Improved acid circulation, helps the battery to remain cool, and extend battery life')
prod_3_1_1_11 = Product(name='Pro 60V 2.0 Ah Battery', price=101, category_id=cat_3_1_1.id, icon='prod_3_1_1_11', description='60-volt Li-ion battery delivers fade-free power with no memory loss after charging')
cat_3_1_2 = Category(name='Accessories', parent_id=cat_3_1.id)
prod_3_1_2_1 = Product(name='NOCO GBC003 Boost HD Precision Battery Clamps for GB20, GB40, GB50, and GBX45 UltraSafe Lithium Jump Starters', price=25.95, category_id=cat_3_1_2.id, icon='prod_3_1_2_1', description='Heavy-duty battery clamps designed for NOCO Boost and Boost X UltraSafe Lithium Jump Starters..Fit Type: Universal Fit')
prod_3_1_2_2 = Product(name='Wyssay 42V 2A Battery Charger 3-Prong Inline Connector Power Supply for Pocket Mod,Dirt Quad,and Sports Mod', price=10.39, category_id=cat_3_1_2.id, icon='prod_3_1_2_2', description='rand New Replacement Product , InPut : 100-240VAC,50-60HZ, 1.5A , Ouput: 42V 2A. Maximum operation temperature <40℃.Mains supply tolerance: 100-240V')
prod_3_1_2_3 = Product(name='Jumper Cable Clamps 2 Pair, Battery Clamps Pure Copper, Jumper Cable Ends 4 Inch, Battery Charger Clamps Heavy Duty with Insulating Sheath for Under 5AWG Battery Cables 12V/24V/36V by XIOGZAXI', price=12.59, category_id=cat_3_1_2.id, icon='prod_3_1_2_3', description='Jumper cable clamps are made of pure copper for optimal contact and conductivity. Battery clamps come with a rubber insulating sleeve to avoid the risk of electric shock and not scratching your hands.')
prod_3_1_2_4 = Product(name='NEW Replacement 32418-RNA-A01 32418RNAA01 & 24340-1CX1A POSITIVE Battery Terminal w NUT for Civic MDX etc.', price=17.18, category_id=cat_3_1_2.id, icon='prod_3_1_2_4', description='NEW Replacement 32418-RNA-A01 Battery Terminal')
prod_3_1_2_5 = Product(name='SINGARO Car Battery Terminal Connector Classification Kit, Pure Copper Negative and Positive Battery Cable Ends with Plastic Cover, Applicable to Automobile, Truck and RV Accessories', price=7.19, category_id=cat_3_1_2.id, icon='prod_3_1_2_5', description='Work Phenomenally: Our battery terminal connector all are made of pure copper, which is connected better than other material and has better corrosion-resistance.')
prod_3_1_2_6 = Product(name='Upgraded Replacement 12V Battery for Peg Perego John Deere Tractor Ride-on-Toy (12V 15 Amp Kit)', price=73.95, category_id=cat_3_1_2.id, icon='prod_3_1_2_6', description='Upgraded Replacement Battery for Kids John Deere, Case, Gaucho, and Gator Ride-On Toys. 12 Volt 15 Amp Peg Perego Battery Replacement - Meaning a 85 longer ride time than the original battery!')
prod_3_1_2_7 = Product(name='JY Performance Steel Battery Tray Replacement Compatible With 1994-2013 EZGO TXT/Medalist Models Hold Down 36V', price=46.39, category_id=cat_3_1_2.id, icon='prod_3_1_2_7', description='Compatible With all 1994-Up TXT and MEDALIST Models. It will also work With other EZGO models with the same 6 x 6-volt battery set.')
prod_3_1_2_8 = Product(name='ApplianPar Positive Battery Fuse Terminal for Nissan Altima Maxima Murano Pathfinder', price=27.99, category_id=cat_3_1_2.id, icon='prod_3_1_2_8', description='Fit for Nissan Altima 2013-2018, Maxima 2016-2019, Murano 2015-2019, Pathfinder 2013-2019.')
prod_3_1_2_9 = Product(name='SEBLAFF 36V 5A Golf Cart Charger with SB50 Flat Style Plug Replacement for 1983-1994 Marathon Golf Carts', price=55.86, category_id=cat_3_1_2.id, icon='prod_3_1_2_9', description='Replacement for - 1983-1994 Marathon Golf Carts')
prod_3_1_2_10 = Product(name='Power Cord 5V Replacement Charger USB adapter is suitable for a variety of electric hairdressers, shavers, beauty instruments, purifiers, table lamps and others 5521 adapter hq8505 charging line', price=7.99, category_id=cat_3_1_2.id, icon='prod_3_1_2_10', description='Built in pure copper conductor, strong conductivity, faster and more stable transmission. Outer layer is wrapped with PVC environmental protection materials, which is safe, environmental friendly and durable.With an additional storage bag, razor and accessories can be stored, so it is easy to carry.')
cat_3_2 = Category(name='Bearings & Seals', parent_id=cat_3.id)
cat_3_2_1 = Category(name='Bearings', parent_id=cat_3_2.id)
prod_3_2_1_1 = Product(name='PHILTOP 512553 Rear Wheel Hub Bearing Assembly for Cadenza 2017-2020, Optima 2016-2020, Sonata 2015-2019, S-p-o-r-t-a-g-e 2017-2021, Tucson 2016-2021, V-e-l-o-s-t-er N 2020-2022 5 Lugs W/ABS 1 PCS', price=38.30, category_id=cat_3_2_1.id, icon='prod_3_2_1_1', description='Fitment: PHILTOP Wheel Hub and Bearing Assembly for Cadenza 2017-2020, Optima 2016-2020, Sonata 2015-2019, S-p-o-r-t-a-g-e 2017-2021, Tucson 2016-2021, V-e-l-o-s-t-er N 2020-2022.')
prod_3_2_1_2 = Product(name='Drive Shaft Center Support Bearing 37230-35130 Replacement for Toyota T100 1993-1998 Toyota Tacoma 1995-2015 Toyota Tundra 2000-2015 3723035130', price=16.95, category_id=cat_3_2_1.id, icon='prod_3_2_1_2', description='[Fitment]: Replacement for Toyota T100 1993-1998 Toyota Tacoma 1995-2015 Toyota Tundra 2000-2015')
prod_3_2_1_3 = Product(name='PHILTOP 513288 Front Wheel Hub Bearing Assembly for CTS 2014-2016, XTS 2013-2017, Terrain 2010-2017, Regal 2011-2017, Malibu Limited 2016-2016, Malibu 2013-2015, Impala 2014-2017 5 Lugs W/ABS 1 PCS', price=43.88, category_id=cat_3_2_1.id, icon='prod_3_2_1_3', description='Fitment: PHILTOP Wheel Hub and Bearing Assembly for CTS 2014-2016 3.6L, XTS 2013-2017, Terrain 2010-2017, Regal 2011-2017, Malibu Limited 2016-2016, Malibu 2013-2015, Impala 2020-2020 3.6L,Impala 2014-2017, Equinox 2010-2017, 9-5 2010-2011, LaCrosse 2010-2016.')
prod_3_2_1_4 = Product(name='TRQ Front Wheel Bearing & Hub Assembly LH RH Kit Pair Set of 2 for Mazda 6 CX-5', price=121.36, category_id=cat_3_2_1.id, icon='prod_3_2_1_4', description='Direct Fit, OE Replacement Wheel Bearing Assembly Kit')
prod_3_2_1_5 = Product(name='SCITOO 518514 Front Wheel Hubs Bearing Assembly Left Right fit For Saturn S Series SC SL SW 4 Lugs No/ABS Hub Assembly Kit 2 Pack', price=55.61, category_id=cat_3_2_1.id, icon='prod_3_2_1_5', description='Hubs Quality: The SCITOO wheel assembly is manufactured with a tightly controlled manufacturing process that ensures precise matching of the bearing raceways and rolling elements, consistently delivering superior performance and For Minimizing noise and vibration.')
prod_3_2_1_6 = Product(name='A-Premium Pair [2] Rear Wheel Bearing Hub Assembly Compatible with Hyundai Elantra 2001-2006 Kia Spectra 2005-2009 Spectra5 2005-2009 Non-ABS Model Only', price=65.99, category_id=cat_3_2_1.id, icon='prod_3_2_1_6', description='1 x Rear Wheel Bearing Hub Assembly for Left, 1 x Rear Wheel Bearing Hub Assembly for Right (with 1-Year Warranty)')
prod_3_2_1_7 = Product(name='A-Premium Wheel Hub and Bearing Assembly Compatible with Lexus IS250 2006-2015 IS300 2016-2019 IS350 2011-2019 GS300 2006 GS350 RC300 RC350 Front Right', price=52.99, category_id=cat_3_2_1.id, icon='prod_3_2_1_7', description='Rigorously controlled manufacturing processes ensure exact matching of bearing and Hub components to consistently Provide superior performance and minimize noise and vibration.')
prod_3_2_1_8 = Product(name='4WD Auto Locking Hub Pair Kits Replacement for 1999-2004 Ford F250 F350 F450 F550 Super Duty 2000-2005 Ford Excursion 2001 2002 Lincoln Navigitor Expedition 1C3Z-3B396-CB 600-203', price=62.99, category_id=cat_3_2_1.id, icon='prod_3_2_1_8', description='4WD AUTO LOCKING - Mud, rust or worn parts inside the hub can prevent the mechanism from sliding in and locking the hub. Anything that binds the internal mechanism can prevent it from sliding and releasing. The most noticeable symptoms may be an increase in fuel consumption, noise on the highway or increased front-tire wear.When locking hub can not work properly, Its time to replace a new 4x4 Locking Hub.')
prod_3_2_1_9 = Product(name='Dorman 600-135 Front Wheel Hub Seal Kit Compatible with Select Ford Models', price=82.40, category_id=cat_3_2_1.id, icon='prod_3_2_1_9', description='Direct replacement -this wheel hub seal kit contains components and consumables that are designed to match the fit and function of the original equipment on specified 4WD Ford Super Duty trucks')
prod_3_2_1_10 = Product(name='TUCAREST 518519 x2 (Pair) Front Wheel Bearing and Hub Assembly Compatible With 2010 11 12 2013 Ford Transit Connect [5 Stud Hub Repair Kit]', price=72.52, category_id=cat_3_2_1.id, icon='prod_3_2_1_10', description='Wheel Stud Bolts:Wheel studs feature a protective coating that helps prevent rust and corrosion, allowing easier removal and proper torquing of the wheel nut,easy to install.')
cat_3_2_2 = Category(name='Seals', parent_id=cat_3_2.id)
prod_3_2_2_1 = Product(name='YQABLE Front Axle Seal Non-Greaseable U Joint Kit 2014835 2023068 2017426 Compatible for Ford F250 F350 Super Duty 2014-2019', price=129.99, category_id=cat_3_2_2.id, icon='prod_3_2_2_1', description='Model Front Axle Seal Non-Greaseable U Joint Kit Item Weight 7.47 pounds Package Dimensions 12.2 x 8.86 x 4.25 inches')
prod_3_2_2_2 = Product(name='Camshaft 84005207 for Briggs & Stratton 793880 793583 792681 791942 795102 Camshaft kit, Cam Replacement Kit with 795387 Oil Seal Ring and 697110 Crankcase Gasket', price=32.56, category_id=cat_3_2_2.id, icon='prod_3_2_2_2', description='New high quality aftermarket replacement Camshaft for Briggs & Stratton 793880 84005207 793583 792681 791942 795102, Gasket replaces for 697110, Oil Seal replaces for 795387.')
prod_3_2_2_3 = Product(name='Fits for Ford Front Axle Oil Seal Replacement Kit: Front Axle Outer Stub Seals & Hub O-Rings & Tube Dust Seals Kit for Ford Super Duty F250 F350 F450 F550 Models 2005-2019', price=68.50, category_id=cat_3_2_2.id, icon='prod_3_2_2_3', description='2pcs Outer Stub Seals (replace: 2023068/2017426/55474), 2 pcs axle spindle seals (replace: 2014835/2005932/53877 ), and 2 pcs wheel hub O-rings (replace: 54983). Each part is two required per axle.')
prod_3_2_2_4 = Product(name='Weonefit Axle Seal And U Joint Kit Replacement for Ford Super Duty F250 F350 2005-2015 丨2014835丨SPL55-3X', price=109.99, category_id=cat_3_2_2.id, icon='prod_3_2_2_4', description='Axle Seal And U Joint Kit can Providing Peace Of Mind For Your Travels. Reduce Your Frequent Breakdowns And Tedious Replacements')
prod_3_2_2_5 = Product(name='Sunsong 8401579 Power Steering Pump Seal Kit', price=21.64, category_id=cat_3_2_2.id, icon='prod_3_2_2_5', description='Contains the quality components required for steering Unit repair Package Dimensions: 23.8 H x 0.6 L x 14.9 W (centimeters)')
prod_3_2_2_6 = Product(name='2014835 Front Axle Seal And U Joint Kit Compatible for 2005-2015 Ford F250 F350 Super Duty Single And Dual Rear Wheel 4x4 Trucks 2017426 spl55-3x', price=119.50, category_id=cat_3_2_2.id, icon='prod_3_2_2_6', description='Front Axle Seal & U Joint Kit replacement for 2005-2015 Ford F250 F350 Super duty single and dual rear wheel 4x4 Trucks with Dana Super 60 Front Axles (Non-Greaseable).')
prod_3_2_2_7 = Product(name='Roykaw Golf Cart Input Shaft Kit Replacement with 18 Teeth for EZGO RXV 2008-up Electric Models, Includes Clasp Spring, Oil/O-Ring Seal, Noise Reducer, OEM# 620329', price=78.79, category_id=cat_3_2_2.id, icon='prod_3_2_2_7', description='Durable Material: Crafted from a durable metal alloy material, this golf cart input shaft features 18 teeth and offers exceptional toughness. Its built to provide you with a long-lasting solution.')
prod_3_2_2_8 = Product(name='WFLNHB 2PCS Front Axle Tube Seal Kit MG21103 Replacement for Cherokee 1984-2001 / Grand Cherokee 1984-2001 / TJ 1997-2006', price=12.99, category_id=cat_3_2_2.id, icon='prod_3_2_2_8', description='Made from high quality Billet Aluminum with anti-corrosion coatings and Double Lip Seal, durable in use')
prod_3_2_2_9 = Product(name='Crankshaft Rear Main Seal - with Housing Cover, Gasket, Bolt Kit Replacement for 4.8 5.3 6.0 6.2 GMC 2020-97, Isuzu 2016-03, Saab 2009-05 635-518 12639250', price=32.55, category_id=cat_3_2_2.id, icon='prod_3_2_2_9', description='Comes with bolts and gaskets, 1 silicon sealant - everything necessary for a complete repair')
prod_3_2_2_10 = Product(name='Crankshaft Rear Seal Install Tool compatible with Volkswagen 1.8 2.0 3.0 3.2 V6 4.2 Replacement for Audi T10122', price=175, category_id=cat_3_2_2.id, icon='prod_3_2_2_10', description='Function: Used when assembling PTFE crankshaft seal, flywheel end. Used for proper installation of rear main seal')
cat_3_3 = Category(name='Engine Parts', parent_id=cat_3.id)
prod_3_3_1 = Product(name='labwork Engine Parts Replacement for EZGO Gas Golf Cart 1976-1987 2 Cycle 14396-G1 15460-G1', price=104.95, category_id=cat_3_3.id, icon='prod_3_3_1', description='Precision cast to make sure its easy installation and perfect fitment, direct replacement, stable performance, high reliability. Premium stainless steel and iron construction with added coating process, high temperature resistant')
prod_3_3_2 = Product(name='FridayParts Return Pipe Assembly 119515-59540 Compatible for Yanmar 3TNV70-AJUV Engine Hitachi Excavator ZX17U-2 ZX17UNA-2 Genuine Replacement', price=85, category_id=cat_3_3.id, icon='prod_3_3_2', description='New aftermarket parts')
prod_3_3_3 = Product(name='TTParts Replacement For John Deere 110 120 310E 410E 450G 455G 550G 555G 6403 6603 7505 450J 550J 650J 4045 4045T 6068 6068T 4.5L 6.8L Power Engine RE66153 RE535728', price=22.17, category_id=cat_3_3.id, icon='prod_3_3_3', description='Tested. Directly replace and easy to install.')
prod_3_3_4 = Product(name='NICECNC Carcasa del termostato Billet Aluminum Compatible with Ford 1999.05-2003 Super Duty Trucks with the 7.3L Powerstroke engine Red', price=19.99, category_id=cat_3_3.id, icon='prod_3_3_4', description=' The housing is made from premium 6061-t6 billet aluminum. Swap out the warped stamped steel flange and upgrade it! Processed by anodizing for added rust and corrosion resistance. Adapt well to any bad weather conditions. Machined by the latest-generation CNC technology that ensures high accuracy for a perfect fit.')
prod_3_3_5 = Product(name='MOFANS 2.4L Motor Assembly Fit for Kia Optima K5 Sorento Sportage Hyundai Santa Fe Tucson ix35 Sonata ix45 2015 2016 2017 2018 Replace for 283232GGA1', price=109.99, category_id=cat_3_3.id, icon='prod_3_3_5', description='Fitment: The motor assembly fit for compatible with Kia Optima K5 Sorento Sportage 2015-2018.')
prod_3_3_6 = Product(name='OTUAYAUTO Front Windshield Washer Nozzles - Replacement for Chrysler, Dodge, Jeep, Ram - Replaces OEM #: 4805742AB, 4805742AC. 5113049AA, 55077460AA, 5303833AA, Premium Spray Jet Kit (pack of 2)', price=5.99, category_id=cat_3_3.id, icon='prod_3_3_6', description='Windshield Washer Nozzles Kit made of premium plastic construction, it is built to long-lasting durability, easy to install, Includes 2 pcs Washer Nozzle and 2 Rubber Gasket')
prod_3_3_7 = Product(name='Koomaha PY01-13-100A Engine Intake Manifold Replacement for 2015-2021 Mazda 3 Mazda 6 Mazda CX-5 2.5L Skyactiv PY0113100A', price=97, category_id=cat_3_3.id, icon='prod_3_3_7', description='Replacement for Mazda 3 Mazda 6 Mazda CX-5 2.5L Intake Manifold')
prod_3_3_8 = Product(name='Handor 25701-38064 911-643 Fits for 2008-2011 2013-2018 Lexus LX570 V8/5.7L, 2008-2009 2017-2019 Land Cruiser, 2008-2020 Sequoia, 2007-2020 Tundra, V8/5.7L.', price=104.99, category_id=cat_3_3.id, icon='prod_3_3_8', description='Handor 25701-38064 911-643 Fits for 2008-2011 2013-2018 Lexus LX570 V8/5.7L, 2008-2009 2017-2019 Land Cruiser, 2008-2020 Sequoia, 2007-2020 Tundra, V8/5.7L.')
cat_3_4 = Category(name='Ignition Parts', parent_id=cat_3.id)
prod_3_4_1 = Product(name='BDFHYK Set of 4 Iridium Spark Plug Compatible with Hyundai Santa Fe Tucson,Kia Forte Koup Sorento Forte Optima, Altima Sentra,Scion tC 1.8L 2.0L 2.4L 2.5L L4 Engine Replacement for XP5325 4469', price=15.19, category_id=cat_3_4.id, icon='prod_3_4_1', description='BDFHYK spark plugs have superior ignition performance, with faster and more sensitive ignition jumps and significantly improved power performance.')
prod_3_4_2 = Product(name='FIREMOTOO Pack of 4 Ignition Coil Pack Compatible with 2007-2015 Mini Cooper/ 2011-2016 Cooper Countryman L4 1.6L Replacement for 12137575010 UF598 UF-598 C1692', price=58.99, category_id=cat_3_4.id, icon='prod_3_4_2', description='Every FIREMOTOO ignition coil is equipped with the highest grade high conductive copper wire, which improve the coils performance. It offers high energy output nut decreases 15 fuel consumption, providing the best performance and reliability, enhancing the engine power up to 10-15% more than OE coils.')
prod_3_4_3 = Product(name='RAWOK UF674 Ignition Coil Pack Compatible with Ford Escape, Fiesta, Fusion, Transit Connect L4 1.6L, 2013 2014 2015 2016 2017 2018 2019 Replace# BM5Z-12029-B, GN10644, 5C1887 (4PCS)', price=55.99, category_id=cat_3_4.id, icon='prod_3_4_3', description='High quality material can withstand extreme conditions. Every ignition coil goes through extensive testing to ensure reliability.')
prod_3_4_4 = Product(name='Ignition Switch Kit Lock Cylinder for Volkswagen VW Golf Jetta 2005-2011 MK5 Audi A3 2003-2013 R8 Replace 1K0905851B 1K0905865 5Q0905865A Ignition Lock Cylinder with Key Ignition Switch', price=35.99, category_id=cat_3_4.id, icon='prod_3_4_4', description='Plug and Play design for direct replacement and ease of installation,Performs as well as or better than OE. Make sure this part fit your vehicle, please enter your vehicle model in the Confirmed fit tool for verification.')
prod_3_4_5 = Product(name='RACOONA LED Headlight Decoder, H13/9008 H1/H3 H11/H8/H9 9006/HB4/9012 Warning Error Decoder Canceller Capacitors Resistor,Car Accessories Anti Flicker Harness for LED Headlight Systems (H11/H8/H9)', price=15.99, category_id=cat_3_4.id, icon='prod_3_4_5', description='The set includes 2 LED headlight decoders. The LED headlight decoder is made of high-quality materials, which are wear-resistant, durable, and can be used for a long time.')
prod_3_4_6 = Product(name='MAS Set of 2 Ignition Coil Pack Compatible with Ford Contour E-150 Escort Explorer Mustang Ranger Town Car Mark VIII Replacement for FD487', price=21.07, category_id=cat_3_4.id, icon='prod_3_4_6', description='Engineered for original equipment and replacement applications')
prod_3_4_7 = Product(name='A-Premium Iridium Platinum Spark Plugs Compatible with Ford Escape 2017-2019, Fusion 2014-2020, 1.5L, Pack of 4', price=19.99, category_id=cat_3_4.id, icon='prod_3_4_7', description='For optimal engine performance and longevity, it is recommended to replace platinum iridium spark plugs at mileage intervals of 80,000 to 100,000 miles')
prod_3_4_8 = Product(name='WAYSKA Diesel Heater Glow Plug Kit with Removal Fitting Tool for 2KW, 3KW, 5KW, 8KW Parking Heater Replacement', price=19.99, category_id=cat_3_4.id, icon='prod_3_4_8', description='The diesel heater glow plug kit is made of ceramic, plastic and metal, which has the characteristics of small volume and light weight.')
prod_3_4_9 = Product(name='NEWHOW 4PCS Ignition Coil Replacement for Johnson Evinrude Outboards 4HP-300HP Models - Replaces 582508, 18-5179, 183-2508', price=49.99, category_id=cat_3_4.id, icon='prod_3_4_9', description='High-quality construction: The coils are constructed with premium materials to ensure durability and longevity.')
prod_3_4_10 = Product(name='JOYOMSTW Ignition Coil Pack Replacement for Toyota Scion Echo Prius Yaris 2001-2009 xA xB 2004-2006 Replace# UF316 C1304 5C1293 Set of 4', price=42.99, category_id=cat_3_4.id, icon='prod_3_4_10', description='JOYOMOTOR coils are produced in accordance with OEM quality standards and have undergone high-temperature and high-pressure impact cycling testing. The magnetic flux is 10 higher than that of similar copper wire manual groups, improving engine performance and reducing fuel consumption.')
cat_3_5 = Category(name='Brake System', parent_id=cat_3.id)
cat_3_5_1 = Category(name='ABS', parent_id=cat_3_5.id)
prod_3_5_1_1 = Product(name='WMPHE 4 Pcs ABS Wheel Speed Sensor Compatible with Ford Fusion 2013 2014 2015 2016 2017 2018 2019, Lincoln MKZ 2013 2014 2015, Replacement for DG9Z2C205A, DG9Z2C204A, JG9Z2C190A', price=48.99, category_id=cat_3_5_1.id, icon='prod_3_5_1_1', description='ABS wheel speed sensor is made of alloy and abs plastic, manufactured according to production standards, durable and not easy to rust and age')
prod_3_5_1_2 = Product(name='0986594508 34526756375 34521165534 34520025723 Front Right/Left ABS Wheel Speed Sensor Compatible with BMW E39 525i 528i 525td 528i 530d 530i 540i M 5 1998 1999 2000 2001 2002 2003', price=13.99, category_id=cat_3_5_1.id, icon='prod_3_5_1_2', description='Meet the professional specification as replacement parts, for stable performance & durable service. Meets or exceeds oem standard, 100% tested before shipping')
prod_3_5_1_3 = Product(name='ABS Brake Control Module, ABS Pump Control Module, Fine Workmanship 0265800534 ABS Brake Module ABS Control Module Compatible with Camry', price=167.65, category_id=cat_3_5_1.id, icon='prod_3_5_1_3', description='ABS brake control module, Each module is thoroughly and professionally tested to ensure reliability, which can provide you with an excellent using effect.')
prod_3_5_1_4 = Product(name='Ynovvo BL3Z2C190D ABS Wheel Speed Sensor Rear Left Driver Side ABS Sensor Replacement for OEM BL3Z2C190D BL3Z2C190F', price=15.19, category_id=cat_3_5_1.id, icon='prod_3_5_1_4', description='With outstanding material and exquisite technology, Ynovvo ABS Wheel Speed Sensor rear left will provide you high performance and long-term use.')
prod_3_5_1_5 = Product(name='Replacement for Minn Kota 1820089 MK-EC-15 Marine Battery Charger Extension Cable, 15 ft Battery Charger Output Extension Cable', price=27.99, category_id=cat_3_5_1.id, icon='prod_3_5_1_5', description='Connecting the two extension cable wires to the Battery Charger Output Cable wires. Place the adhesive heat shrink tubing in the center of the wire connector. Use a heat gun to heat the adhesive heat shrink tubing until it makes a tight connection.')
cat_3_5_2 = Category(name='Rotors', parent_id=cat_3_5.id)
prod_3_5_2_1 = Product(name='A-Premium 12.59 inch (320mm) Front Drilled and Slotted Disc Brake Rotors Compatible with Select Honda and Acura Models - Pilot 2016-2022, Odyssey 2015-2023, Ridgeline, Passport, MDX, 2-PC Set', price=134.99, category_id=cat_3_5_2.id, icon='prod_3_5_2_1', description='①Material: G3000 Metallurgy, ②Mounting Bolt Hole Quantity: 5, ③Outside Diameter (mm): 320, ④Discard Thickness (mm): 26; G3000 metallurgy and metallic coating of brake discs can effectively prevent rust and corrosion, extending the lifespan. Industry low runout and DTV specifications enable smooth disc operation, low dust, noise reduction, and excellent braking power.')
prod_3_5_2_2 = Product(name='ACDelco Gold 18A2451 Black Hat Rear Disc Brake Rotor', price=39.84, category_id=cat_3_5_2.id, icon='prod_3_5_2_2', description='Manufactured to meet specifications for fit, form, and function for General Motors vehicles as well as most makes and models')
prod_3_5_2_3 = Product(name='Raybestos Premium Element3 Replacement Rear Brake Rotor for Select Escalade, Silverado, Suburban, Tahoe, Sierra, and Yukon model years (581032FZN)', price=66.56, category_id=cat_3_5_2.id, icon='prod_3_5_2_3', description='Raybestos Element3 the ultimate coated rotor combines a full Grey Fusion 4.0 coating with Rust Prevention Technology making it able to endure the harshest of weather conditions')
prod_3_5_2_4 = Product(name='Centric Parts 121.65049 C-Tek Standard Brake Rotor', price=46.83, category_id=cat_3_5_2.id, icon='prod_3_5_2_4', description='OE style replacement rotors. Highest quality and value. Highest quality and value. High strength cast iron discs are highly durable and reliable. Mill balanced brake rotors ensures long lasting durability')
prod_3_5_2_5 = Product(name='ACDelco Silver 18A1248A Front Disc Brake Rotor', price=57.26, category_id=cat_3_5_2.id, icon='prod_3_5_2_5', description='Manufactured with multiple alloys for improved heat dissipation and performance')
prod_3_5_2_6 = Product(name='Manufactured with multiple alloys for improved heat dissipation and performance', price=132.28, category_id=cat_3_5_2.id, icon='prod_3_5_2_6', description='Drill holes keep brake rotors up to 180 degrees cooler')
prod_3_5_2_7 = Product(name='SCITOO Front Brake Rotors,2pcs Drilled& Slotted Discs Brakes Kit fit for Ford Explorer,for Ford Explorer Sport, for Ford Explorer Sport Trac, for Ford Ranger, for Mazda B2300 B3000 B4000', price=100.89, category_id=cat_3_5_2.id, icon='prod_3_5_2_7', description='Brake rotors drilled and slotted design provides upgrade effective braking power and heat dissipation while controlling noise,eliminating vibration harshness.')
cat_3_6 = Category(name='Filters', parent_id=cat_3.id)
cat_3_6_1 = Category(name='Air Filters', parent_id=cat_3_6.id)
prod_3_6_1_1 = Product(name='Ynovvo Engine Air Filter Replacement CA10013', price=12.99, category_id=cat_3_6_1.id, icon='prod_3_6_1_1', description='Automotive replacement air filters adopt multiple folded layers design for double holding capacity, efficiently filtering fine particles without hampering airflow, provide clean air for engine and protect it from premature wear')
prod_3_6_1_2 = Product(name='Ynovvo Engine Air Filter Replacement CA12260', price=15.99, category_id=cat_3_6_1.id, icon='prod_3_6_1_2', description='Automotive replacement air filters adopt multiple folded layers design for double holding capacity, efficiently filtering fine particles without hampering airflow, provide clean air for engine and protect it from premature wear')
prod_3_6_1_3 = Product(name='Ynovvo Engine Air Filter Replacement CA10262', price=14.99, category_id=cat_3_6_1.id, icon='prod_3_6_1_3', description='Automotive replacement air filters adopt multiple folded layers design for double holding capacity, efficiently filtering fine particles without hampering airflow, provide clean air for engine and protect it from premature wear')
prod_3_6_1_4 = Product(name='Tesla Model Y Air Filter, Model 3 Cabin Air Filter, N98 HEPA Filter with Activated Carbon, Tesla Replacement Air Filter, Tesla Accessories, 2 Pack', price=27.99, category_id=cat_3_6_1.id, icon='prod_3_6_1_4', description='Premium HEPA Filter: Made of high-quality HEPA material. The cabin air filters for tesla model 3 prevent harmful fine particles, dust,gases effectively from entering vehicle cabin. It remove fine particles above 0.3 microns in 30mins effectively, keeping clean and healthy environment to passengers.')
prod_3_6_1_5 = Product(name='Our Happi Replacement Filter (KJ500)', price=64.96, category_id=cat_3_6_1.id, icon='prod_3_6_1_5', description='ULTRA-FINE FILTER : Bucket-shaped structure that collects 99.95 of dust, hair, dander, large particles & other pollutants')
prod_3_6_1_6 = Product(name='KAX Engine air Filter CA11114 replacement for Focus 2012-2018 Escape 2013-2019 MKC 2015-2019 Transit Connect 2014-2016 Replce#FA-1908 Air Filter', price=13.59, category_id=cat_3_6_1.id, icon='prod_3_6_1_6', description='Excellent filtration medium: Using High-performance cellulose filter media, filter various debris without hampering airflow. The air entering the engine cylinder is finely filtered to prevent and debris, ensuring a sufficient amount of clean air.')
prod_3_6_1_7 = Product(name='FUKANG Special Replaceable Filter for Smokeless Ashtray-VS070 (4 pack)', price=19.06, category_id=cat_3_6_1.id, icon='prod_3_6_1_7', description='FUKANG Special replacement filter for smokeless ashtray-VS-070/ASIN: (B0C33G97MG)')
prod_3_6_1_8 = Product(name='K&N Engine Air Filter: High Performance, Premium, Washable, Replacement Filter: Compatible with 2021-2023 Jeep Wrangler JL, 33-5127', price=56.63, category_id=cat_3_6_1.id, icon='prod_3_6_1_8', description='ENGINEERED POWER: State-of-the-art air filter media is designed to increase horsepower and acceleration as well as improve overall engine performance')
prod_3_6_1_9 = Product(name='RV Air Conditioner Filter - 6" x 14" RV AC Replacement Filters For Coleman Mach Unit MERV 8 Air Filter (2 Pack)', price=21.98, category_id=cat_3_6_1.id, icon='prod_3_6_1_9', description='This polyester filter consists of 2-layer of white and blue polyester filter, that capture lint, dust, hair and pollen. The Filter has moisture resistance up to 100 relative humidity and temperature resistant up to 100 °C. It also does not contain silicone. And the most important feature is that it is non-flammable, also it helps to extend the life of your RV unit.')
prod_3_6_1_10 = Product(name='MEOWAV Tesla Model 3 Model Y Air Filter HEPA12 Activated Carbon Tesla Cabin Air Filter Replacement Accessories 2Pack', price=34.99, category_id=cat_3_6_1.id, icon='prod_3_6_1_10', description='Ultra Tesla Model 3 Model Y Accessories: Equipped with a HEPA Grade 12 air filter, boasting a purification efficiency of over 99.59 for particles as small as 0.3μm. It rapidly and effectively filtering off vehicle exhaust, odors, formaldehyde, PM2.5, particles, and dust.')
prod_3_6_1_11 = Product(name='Puroma 2 Pack Cabin Air Filter with Multiple Fiber Layers, Replacement for CP134, CF10134, Honda Civic, CR-V, Odyssey, Pilot, Accord, Ridgeline, Passport and Acura CSX, ILX, MDX, RDX, TLX, RLX', price=11.88, category_id=cat_3_6_1.id, icon='prod_3_6_1_11', description='Efficient Filtration: Our cabin air filter removes dust, pollen, and other pollutants, providing you and your family with fresh air while driving. It also optimizes air conditioning and heating systems, ensuring high flow capacity. Keeps your vehicle interior clean and ensures a healthier in-car environment.')
cat_3_6_2 = Category(name='Oil Filters', parent_id=cat_3_6.id)
prod_3_6_2_1 = Product(name='Engine Oil Filter Housing Cap Assembly with Plug 15620-0S010 15620-38010 Replacement for 2008-2020 Toyota Land Cruiser, 2008-2020 Toyota Sequoia, 2007-2013 Toyota Tundra, 2008-2011 Lexus LX570', price=28, category_id=cat_3_6_2.id, icon='prod_3_6_2_1', description='【HIGH-QUALITY METAL MATERIALS OIL FILTER COVER CAP】AEM Material Provide Good Sealing Effect to Prevent Cracking and Oil Leakage, Has Stable Performance, High Reliability, Sturdy and Durable.')
prod_3_6_2_2 = Product(name='Engine Oil Filter Cap with Housing Assembly 68507598AA 68498720AA Replacement for Jeep 2020 2021 Wrangler JL,2021 Gladiator,2020 2021 2022 Ram 1500 DT', price=14.88, category_id=cat_3_6_2.id, icon='prod_3_6_2_2', description='【Engine Oil Filter Cap Replacement 】It is usually necessary to replace the engine oil filter cap assembly when replacing the engine oil filter, because the oil filter cap assembly plays an important role in sealing the oil filter. If the oil filter cap assembly is damaged or loose, it will cause oil leakage and affect the normal operation of the engine. The oil filter housing is made of high-strength engineering plastic, and the oil filter uses high-adsorption and high-flow filter paper to ensure fil')
prod_3_6_2_3 = Product(name='250025-526 Suitable for Air Compressor Oil Filter, Replacement Parts Oil Coolant Filter P/N250025-526 P176325', price=50, category_id=cat_3_6_2.id, icon='prod_3_6_2_3', description='Comply with Original Manufacturing Standards, Compatible with Sullair Oil Filter')
prod_3_6_2_4 = Product(name='2 Pcs Oil Filter 84475542 87409203 87415600 Compatible with New Holland T1010 T1110 L150 L160 LX665,Replace Onan 122-0645 1220645', price=19.58, category_id=cat_3_6_2.id, icon='prod_3_6_2_4', description='Aftermarket oil filter with perfect replacement. High quality oil filter offering better filtration and longer engine life')
prod_3_6_2_5 = Product(name='ONER Engine Oil Filter, Compatible With 2020 2021 Ram 1500,2020 2021 Jeep Wrangler,2021 Jeep Gladiator 3.0L V6 Diesel ,Replaces# 68498720AA,68507598AA', price=14.86, category_id=cat_3_6_2.id, icon='prod_3_6_2_5', description='[Advantage]-Oil filter cap, manufactured from high quality ABS plastic and high-performance filter paper, Corrosion Resistance, Heat Resistance, Pressure Resistance, Wear Resistance, Which Will Built To Long Lasting Durability And Performance. The Price Is Only A Small Part Of The Dealer!')
prod_3_6_2_6 = Product(name='WIX Filters - 57746XD Heavy Duty Spin-On Lube Filter, Pack of 1', price=56.57, category_id=cat_3_6_2.id, icon='prod_3_6_2_6', description='Includes gasket, mounting plate, center tube and inner element tube')
prod_3_6_2_7 = Product(name='RE504836 Engine Oil Filter Replacement for John Deere 5076E 5082E 5083E 5085M 5090E Tractor Replaces RE507522 RE541420 RE502513', price=25.99, category_id=cat_3_6_2.id, icon='prod_3_6_2_7', description='Premium Material: Made from high-quality strong materials for high durability and long service life.')
prod_3_6_2_8 = Product(name='A-Premium Oil Filter Housing Cover Cap Compatible with Mercedes-Benz S204 C250 2012-2015 W204 C250 2012-2014 R172 SLK250 2012-2015 1.8L with O-Ring', price=21.99, category_id=cat_3_6_2.id, icon='prod_3_6_2_8', description='【Custom Designed】OE Replacement Oil Filter Housing Cap, Directly Fit')
prod_3_6_2_9 = Product(name='5Pack Engine Oil Filter Kit 04152-YZZA6 Replacement for Toyota Prius Corolla Scion IM XD', price=14.20, category_id=cat_3_6_2.id, icon='prod_3_6_2_9', description='Replaces Part Number: 04152-YZZA6')
prod_3_6_2_10 = Product(name='labwork Diesel Filter Kit 68507598AA Replacement for 2020-2021 1500 JL 3.0L', price=22.95, category_id=cat_3_6_2.id, icon='prod_3_6_2_10', description='The oil filter cover is made of high quality ABS plastic and high performance filter paper, which is not easy to corrosion, can bear pressure, heat, not easy to wear, durable')
strg.save()
user1 = User(username='user1', email='email1', password='password1', fs_uniquifier=1)
# user2 = User(username='user2', email='email2', password='password2')
# user3 = User(username='user3', email='email3', password='password3')
# user4 = User(username='user4', email='email4', password='password4')
# user5 = User(username='user5', email='email5', password='password5')
# user6 = User(username='user6', email='email6', password='password6')
# user7 = User(username='user7', email='email7', password='password7')
# user8 = User(username='user8', email='email8', password='password8')
# user9 = User(username='user9', email='email9', password='password9')
# user10 = User(username='user10', email='email10', password='password10')
# user11 = User(username='user11', email='email11', password='password11')
# user12 = User(username='user12', email='email12', password='password12')
# user13 = User(username='user13', email='email13', password='password13')
# user14 = User(username='user14', email='email14', password='password14')
# user15 = User(username='user15', email='email15', password='password15')
strg.save()
# users = [user1, user2, user3, user4, user5, user6, user7, user8, user9, user10, user11, user12, user13, user14, user15]
products_names = []
image_names = []
for filename in os.listdir('./app/static/images/pics'):
products_names.append(filename.split('.')[0])
products = [globals()[name] for name in products_names]
for i in range(0, 5):
for _ in range(0, 15):
random.choice(products).add_to_cart(user1, random.randint(1, 25))
user1.cart.checkout("COMPLETED")
# vins = ['YV1622FSXC2043336', '1GTHK53629F127465', '1GKKRREDXCJ367618', '2C4GM68404R510793', '1FUJA6CK07LX43602', 'JNKCA31A2YT209235', '1GCVKREH1FZ206466', '5FNRL5H92EB094910', 'WDBNG75J73A366238', '4C3AG42G14E146713', '1FDKF37G7VEB87285', '1GKFK63837J218001', '1LNHL9EK1FG600515', '1FMYU01141KD92514', '3TMJU62N55M002416', '4A4AR3AU7FE008355', 'WDDHF5KB6DA720745', '1FMDU73K95UA41752', '1GC1KVE8XFF118069', '3VWDX7AJ3CM342263', '2G1WG5E32D1241972', '1FMCU9J93DUA77183', '2G4WS52M2W1486966', 'JTEEP21A960159267', '1FBNE3BL2EDA25664', 'JHLRD1842XC024854', '5XXGN4A71DG153445', 'WBAKF9C58BE620116', 'JN8AZ1MW1EW529304']
# for user in users[1:-1]:
# for i in range(1, random.randint(1, 5)):
# Car(user_id=user.id, vin=random.choice(vins), name='car' + str(i))