Esempio n. 1
0
  def run(cls, database=DEFAULT_DB_ALIAS, **kwargs):
    import frepple

    if cls.filter:
      filter_and = "and %s " % cls.filter
      filter_where = "where %s " % cls.filter
    else:
      filter_and = ""
      filter_where = ""

    with connections[database].chunked_cursor() as cursor:
      cnt = 0
      starttime = time()
      cursor.execute('''
        SELECT
          name, description, owner_id, category, subcategory, source
        FROM customer %s
        ''' % filter_where)
      for i in cursor:
        cnt += 1
        try:
          x = frepple.customer(name=i[0], description=i[1], category=i[3], subcategory=i[4], source=i[5])
          if i[2]:
            x.owner = frepple.customer(name=i[2])
        except Exception as e:
          logger.error("**** %s ****" % e)
      logger.info('Loaded %d customers in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 2
0
def loadCustomers(cursor):
  print('Importing customers...')
  cnt = 0
  starttime = time()
  cursor.execute("SELECT name, description, owner_id, category, subcategory FROM customer")
  for i, j, k, l, m in cursor.fetchall():
    cnt += 1
    try:
      x = frepple.customer(name=i, description=j, category=l, subcategory=m)
      if k: x.owner = frepple.customer(name=k)
    except Exception as e: print("Error:", e)
  print('Loaded %d customers in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 3
0
 def loadDemand(self):
   print('Importing demands...')
   cnt = 0
   starttime = time()
   self.cursor.execute('''
     SELECT
       name, due, quantity, priority, item_id,
       operation_id, customer_id, owner_id, minshipment, maxlateness,
       category, subcategory, source, location_id, status
     FROM demand
     WHERE (status IS NULL OR status ='open' OR status = 'quote') %s
     ''' % self.filter_and)
   for i in self.cursor.fetchall():
     cnt += 1
     try:
       x = frepple.demand(
         name=i[0], due=i[1], quantity=i[2], priority=i[3], status=i[14],
         item=frepple.item(name=i[4]), category=i[10], subcategory=i[11],
         source=i[12]
         )
       if i[5]:
         x.operation = frepple.operation(name=i[5])
       if i[6]:
         x.customer = frepple.customer(name=i[6])
       if i[7]:
         x.owner = frepple.demand(name=i[7])
       if i[8]:
         x.minshipment = i[8]
       if i[9] is not None:
         x.maxlateness = i[9].total_seconds()
       if i[13]:
         x.location = frepple.location(name=i[13])
     except Exception as e:
       print("Error:", e)
   print('Loaded %d demands in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 4
0
 def loadDemand(self):
   print('Importing demands...')
   cnt = 0
   starttime = time()
   self.cursor.execute('''
     SELECT
       name, due, quantity, priority, item_id,
       operation_id, customer_id, owner_id, minshipment, maxlateness,
       category, subcategory, source, location_id, status
     FROM demand
     WHERE (status IS NULL OR status ='open' OR status = 'quote') %s
     ''' % self.filter_and)
   for i in self.cursor.fetchall():
     cnt += 1
     try:
       x = frepple.demand(
         name=i[0], due=i[1], quantity=i[2], priority=i[3], status=i[14],
         item=frepple.item(name=i[4]), category=i[10], subcategory=i[11],
         source=i[12]
         )
       if i[5]:
         x.operation = frepple.operation(name=i[5])
       if i[6]:
         x.customer = frepple.customer(name=i[6])
       if i[7]:
         x.owner = frepple.demand(name=i[7])
       if i[8]:
         x.minshipment = i[8]
       if i[9] is not None:
         x.maxlateness = i[9]
       if i[13]:
         x.location = frepple.location(name=i[13])
     except Exception as e:
       print("Error:", e)
   print('Loaded %d demands in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 5
0
def loadDemand(cursor):
    print('Importing demands...')
    cnt = 0
    starttime = time()
    cursor.execute('''SELECT name, due, quantity, priority, item_id,
     operation_id, customer_id, owner_id, minshipment, maxlateness,
     category, subcategory
     FROM demand
     where status is null or status ='open' or status = 'quote' ''')
    for i, j, k, l, m, n, o, p, q, r, s, t in cursor.fetchall():
        cnt += 1
        try:
            x = frepple.demand(name=i,
                               due=j,
                               quantity=k,
                               priority=l,
                               item=frepple.item(name=m),
                               category=s,
                               subcategory=t)
            if n: x.operation = frepple.operation(name=n)
            if o: x.customer = frepple.customer(name=o)
            if p: x.owner = frepple.demand(name=p)
            if q: x.minshipment = q
            if r != None: x.maxlateness = r
        except Exception as e:
            print("Error:", e)
    print('Loaded %d demands in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 6
0
 def loadCustomers(self):
   print('Importing customers...')
   cnt = 0
   starttime = time()
   self.cursor.execute('''
     SELECT
       name, description, owner_id, category, subcategory, source
     FROM customer %s
     ''' % self.filter_where)
   for i in self.cursor.fetchall():
     cnt += 1
     try:
       x = frepple.customer(name=i[0], description=i[1], category=i[3], subcategory=i[4], source=i[5])
       if i[2]:
         x.owner = frepple.customer(name=i[2])
     except Exception as e:
       print("Error:", e)
   print('Loaded %d customers in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 7
0
 def loadCustomers(self):
   print('Importing customers...')
   cnt = 0
   starttime = time()
   self.cursor.execute('''
     SELECT
       name, description, owner_id, category, subcategory, source
     FROM customer %s
     ''' % self.filter_where)
   for i in self.cursor.fetchall():
     cnt += 1
     try:
       x = frepple.customer(name=i[0], description=i[1], category=i[3], subcategory=i[4], source=i[5])
       if i[2]:
         x.owner = frepple.customer(name=i[2])
     except Exception as e:
       print("Error:", e)
   print('Loaded %d customers in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 8
0
def loadCustomers(cursor):
    print('Importing customers...')
    cnt = 0
    starttime = time()
    cursor.execute(
        "SELECT name, description, owner_id, category, subcategory FROM customer"
    )
    for i, j, k, l, m in cursor.fetchall():
        cnt += 1
        try:
            x = frepple.customer(name=i,
                                 description=j,
                                 category=l,
                                 subcategory=m)
            if k: x.owner = frepple.customer(name=k)
        except Exception as e:
            print("Error:", e)
    print('Loaded %d customers in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 9
0
  def run(cls, database=DEFAULT_DB_ALIAS, **kwargs):
    import frepple

    if cls.filter:
      filter_and = "and %s " % cls.filter
      filter_where = "where %s " % cls.filter
    else:
      filter_and = ""
      filter_where = ""

    with connections[database].chunked_cursor() as cursor:
      cnt = 0
      starttime = time()
      cursor.execute('''
        SELECT
          name, due, quantity, priority, item_id,
          operation_id, customer_id, owner_id, minshipment, maxlateness,
          category, subcategory, source, location_id, status
        FROM demand
        WHERE (status IS NULL OR status ='open' OR status = 'quote') %s
        ''' % filter_and)
      for i in cursor:
        cnt += 1
        try:
          x = frepple.demand(
            name=i[0], due=i[1], quantity=i[2], priority=i[3], status=i[14],
            item=frepple.item(name=i[4]), category=i[10], subcategory=i[11],
            source=i[12]
            )
          if i[5]:
            x.operation = frepple.operation(name=i[5])
          if i[6]:
            x.customer = frepple.customer(name=i[6])
          if i[7]:
            x.owner = frepple.demand(name=i[7])
          if i[8] is not None:
            x.minshipment = i[8]
          if i[9] is not None:
            x.maxlateness = i[9].total_seconds()
          if i[13]:
            x.location = frepple.location(name=i[13])
        except Exception as e:
          logger.error("**** %s ****" % e)
      logger.info('Loaded %d demands in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 10
0
def loadDemand(cursor):
  print('Importing demands...')
  cnt = 0
  starttime = time()
  cursor.execute('''SELECT name, due, quantity, priority, item_id,
     operation_id, customer_id, owner_id, minshipment, maxlateness,
     category, subcategory
     FROM demand
     where status is null or status ='open' ''')
  for i,j,k,l,m,n,o,p,q,r,s,t in cursor.fetchall():
    cnt += 1
    try:
      x = frepple.demand( name=i, due=j, quantity=k, priority=l, item=frepple.item(name=m),category=s,subcategory=t)
      if n: x.operation = frepple.operation(name=n)
      if o: x.customer = frepple.customer(name=o)
      if p: x.owner = frepple.demand(name=p)
      if q: x.minshipment = q
      if r != None: x.maxlateness = r
    except Exception as e: print("Error:", e)
  print('Loaded %d demands in %.2f seconds' % (cnt, time() - starttime))
Esempio n. 11
0
print("shipoper < makeoper", shipoper < makeoper)
print("shipoper != makeoper", shipoper != makeoper)
print("shipoper == makeoper", shipoper == makeoper)
print("shipoper == shipoper", shipoper == shipoper)
try:
  print("makeoper == item", makeoper == item)
except Exception as e:
  print("Catching exception %s: %s" % (e.__class__.__name__, e))

###
print("\nCreating a resource")
frepple.resource(name="machine", maximum_calendar=frepple.calendar(name="Cal2"))

###
print("\nCreating customers")
mycustomer = frepple.customer(name="client")

###
print("\nCreating locations")
locA = frepple.location(name="locA")
locB = frepple.location(name="locB")

###
print("\nCreating some buffers")

buf = frepple.buffer(name="end item", producing=choice, item=item)

buf1 = frepple.buffer_procure(name="buffer1",
  description="My description",
  category="My category",
  location=locA,
Esempio n. 12
0
    def run(cls, database=DEFAULT_DB_ALIAS, **kwargs):
        import frepple

        # Uncomment the following lines to bypass the connection to odoo and use
        # a XML flat file alternative. This can be useful for debugging.
        # with open("my_path/my_data_file.xml", 'rb') as f:
        #  frepple.readXMLdata(f.read().decode('utf-8'), False, False)
        #  frepple.printsize()
        #  return

        odoo_user = Parameter.getValue("odoo.user", database)
        odoo_password = settings.ODOO_PASSWORDS.get(database, None)
        if not settings.ODOO_PASSWORDS.get(database):
            odoo_password = Parameter.getValue("odoo.password", database)
        odoo_db = Parameter.getValue("odoo.db", database, None)
        odoo_url = Parameter.getValue("odoo.url", database, "").strip()
        if not odoo_url.endswith("/"):
            odoo_url = odoo_url + "/"

        odoo_company = Parameter.getValue("odoo.company", database, None)
        ok = True

        # Set debugFile=PathToXmlFile if you want frePPLe to read that file
        # rather than the data at url
        # else leave it to False
        debugFile = False  # "c:/temp/frepple_data.xml"

        if not odoo_user and not debugFile:
            logger.error("Missing or invalid parameter odoo.user")
            ok = False
        if not odoo_password and not debugFile:
            logger.error("Missing or invalid parameter odoo.password")
            ok = False
        if not odoo_db and not debugFile:
            logger.error("Missing or invalid parameter odoo.db")
            ok = False
        if not odoo_url and not debugFile:
            logger.error("Missing or invalid parameter odoo.url")
            ok = False
        if not odoo_company and not debugFile:
            logger.error("Missing or invalid parameter odoo.company")
            ok = False
        odoo_language = Parameter.getValue("odoo.language", database, "en_US")
        if not ok and not debugFile:
            raise Exception("Odoo connector not configured correctly")

        # Connect to the odoo URL to GET data
        try:
            loglevel = int(Parameter.getValue("odoo.loglevel", database, "0"))
        except Exception:
            loglevel = 0

        if not debugFile:
            url = "%sfrepple/xml?%s" % (
                odoo_url,
                urlencode({
                    "database": odoo_db,
                    "language": odoo_language,
                    "company": odoo_company,
                    "mode": cls.mode,
                }),
            )
            try:
                request = Request(url)
                encoded = base64.encodestring(
                    ("%s:%s" %
                     (odoo_user, odoo_password)).encode("utf-8"))[:-1]
                request.add_header("Authorization",
                                   "Basic %s" % encoded.decode("ascii"))
            except HTTPError as e:
                logger.error("Error connecting to odoo at %s: %s" % (url, e))
                raise e

            # Download and parse XML data
            with urlopen(request) as f:
                frepple.readXMLdata(f.read().decode("utf-8"), False, False,
                                    loglevel)
        else:
            # Download and parse XML data
            with open(debugFile, encoding="utf-8") as f:
                frepple.readXMLdata(f.read(), False, False, loglevel)

        # Hierarchy correction: Count how many items/locations/customers have no owner
        # If we find 2+ then we use All items/All customers/All locations as root
        # otherwise we assume that the hierarchy is correct
        rootItem = None
        for r in frepple.items():
            if r.owner is None:
                if not rootItem:
                    rootItem = r
                else:
                    rootItem = None
                    break
        rootLocation = None
        for r in frepple.locations():
            if r.owner is None:
                if not rootLocation:
                    rootLocation = r
                else:
                    rootLocation = None
                    break
        rootCustomer = None
        for r in frepple.customers():
            if r.owner is None:
                if not rootCustomer:
                    rootCustomer = r
                else:
                    rootCustomer = None
                    break

        if not rootItem:
            rootItem = frepple.item_mts(name="All items",
                                        source="odoo_%s" % cls.mode)
            for r in frepple.items():
                if r.owner is None and r != rootItem:
                    r.owner = rootItem
        if not rootLocation:
            rootLocation = frepple.location(name="All locations",
                                            source="odoo_%s" % cls.mode)

            for r in frepple.locations():
                if r.owner is None and r != rootLocation:
                    r.owner = rootLocation
        if not rootCustomer:
            rootCustomer = frepple.customer(name="All customers",
                                            source="odoo_%s" % cls.mode)
            for r in frepple.customers():
                if r.owner is None and r != rootCustomer:
                    r.owner = rootCustomer
Esempio n. 13
0
print("shipoper != makeoper", shipoper != makeoper)
print("shipoper == makeoper", shipoper == makeoper)
print("shipoper == shipoper", shipoper == shipoper)
try:
    print("makeoper == item", makeoper == item)
except Exception as e:
    print("Catching exception %s: %s" % (e.__class__.__name__, e))

###
print("\nCreating a resource")
frepple.resource(name="machine",
                 maximum_calendar=frepple.calendar(name="Cal2"))

###
print("\nCreating customers")
mycustomer = frepple.customer(name="client")

###
print("\nCreating locations")
locA = frepple.location(name="locA")
locB = frepple.location(name="locB")

###
print("\nCreating some buffers")

buf = frepple.buffer(name="end item", producing=choice, item=item)

buf1 = frepple.buffer_procure(name="buffer1",
                              description="My description",
                              category="My category",
                              location=locA,