import with proteus

#!/usr/bin/env python
import csv
import sys
from decimal import Decimal
from proteus import config, Model, Wizard

products = csv.reader(open('products.csv', 'r'))
config = config.set_trytond('Toteko', database_type='postgresql', config_file='/opt/tryton/28/trytond.conf')

ProductCategory = Model.get('product.category')
category, = ProductCategory.find([('name', '=', 'OTROS')])

ProductUom = Model.get('product.uom')
unit, = ProductUom.find([('symbol', '=', 'u')])


def LoadProducts ():
  header=True
  for line in products:
    # Skip the header
    if not header:
      Product = Model.get('product.product')
      product = Product()
      product.name = 'HEIDELBERG'
      product.category = category
      product.default_uom = unit
      product.type = 'service'
      product.purchasable = False
      product.salable = True
      product.list_price = Decimal('55')
      product.cost_price = Decimal('55')
      product.cost_price_method = 'fixed'
      product.account_category = True
      product.save()

    header=False

if __name__ == "__main__":
  LoadProducts()