This gist are moved to the repository here. I will leave this gist and will update new notes directly to the repository. You can easily contribute if you want!
Welcome to OCA (Odoo Cheatsheet Akhmad 😛). Here are my notes and some useful links that i usually face them on my day-to-day working with Odoo.
| from django.db import ProgrammingError, models | |
| from django.db.models.constants import LOOKUP_SEP | |
| from django.db.models.query import normalize_prefetch_lookups | |
| from rest_framework import serializers | |
| from rest_framework.utils import model_meta | |
| class OptimizeModelViewSetMetaclass(type): | |
| """ | |
| This metaclass optimizes the REST API view queryset using `prefetch_related` and `select_related` | |
| if the `serializer_class` is an instance of `serializers.ModelSerializer`. |
| # example reading two serial devices using pyserial, asyncio and coroutines | |
| import serial_asyncio | |
| import asyncio | |
| @asyncio.coroutine | |
| def serial_read(device, **kwargs): | |
| reader, writer = yield from serial_asyncio.open_serial_connection(url=device, **kwargs) | |
| while True: | |
| line = yield from reader.readline() |
| import Unauthorised from './Unauthorised' | |
| export default function() { | |
| return { | |
| response: function(response) { | |
| switch (response.status) { | |
| case 401: return Unauthorised.handle(); | |
| } | |
| return response; |
| #!/usr/bin/env bash | |
| # install mdbtools first! | |
| # mdbtools: https://github.com/brianb/mdbtools | |
| # ref: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL | |
| DBMS=postgres | |
| for MDB in `ls | grep .mdb$` |
| #!/usr/bin/env bash | |
| # install mdbtools first! | |
| # mdbtools: https://github.com/brianb/mdbtools | |
| # ref: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL | |
| DBMS=postgres | |
| for MDB in `ls | grep .mdb$` |