recursivecodes

implementation("io.micronaut.email:micronaut-email-javamail")
implementation("io.micronaut.email:micronaut-email-template")
implementation("io.micronaut.views:micronaut-views-thymeleaf")

recursivecodes

 void loop(){
  mqttClient.loop();
  
  if( brain.update() ) {
    unsigned long now = millis();

    StaticJsonDocument<250> doc;
    char readingsJson[500];
    uint8_t signalQuality = brain.readSignalQuality();
    doc["signalStrength"] = map(signalQuality, 200, 1, 1, 100);

recursivecodes

 void loop(){
  mqttClient.loop();
  
  if( brain.update() ) {
    unsigned long now = millis();

    StaticJsonDocument<250> doc;
    char readingsJson[500];
    uint8_t signalQuality = brain.readSignalQuality();
    doc["signalStrength"] = map(signalQuality, 200, 1, 1, 100);

recursivecodes

EspMQTTClient mqttClient(
  ssid,
  password,
  mqtt_url,
  mqtt_username,
  mqtt_password,
  mqtt_client_id
);

recursivecodes

datasources:
  default:
    dialect: ORACLE
    username: ${DB_USERNAME}
    password: ${DB_PASSWORD}
    ocid: ${DB_OCID}
    walletPassword: ${DB_WALLET_PASSWORD}
    connection-factory-class-name: oracle.jdbc.pool.OracleDataSource

recursivecodes

select 
    case 
        when avgAttention >= 1 and avgAttention <= 10 then '1-10'
        when avgAttention > 10 and avgAttention <= 20 then '11-20'
        when avgAttention > 20 and avgAttention <= 30 then '21-30'
        when avgAttention > 30 and avgAttention <= 40 then '31-40'
        when avgAttention > 40 and avgAttention <= 50 then '41-50'
        when avgAttention > 50 and avgAttention <= 60 then '51-60'
        when avgAttention > 60 and avgAttention <= 70 then '61-70'
        when avgAttention > 70 and avgAttention <= 80 then '71-80'

recursivecodes

oraclecloud:
  vault:
    config:
      enabled: true
    vaults:
      - ocid: ${VAULT_OCID}
        compartment-ocid: ${VAULT_COMPARTMENT_OCID}
    use-instance-principal: true
    region: US-PHOENIX-1

recursivecodes

create or replace function summaryByRange(factor in varchar2) return varchar2 sql_macro is
begin
    return q'{
        select
            case
                when summaryByRange.factor = 'meditation' and avgMeditation >= 1 and avgMeditation <= 10 then '1-10'
                when summaryByRange.factor = 'meditation' and avgMeditation > 10 and avgMeditation <= 20 then '11-20'
                when summaryByRange.factor = 'meditation' and avgMeditation > 20 and avgMeditation <= 30 then '21-30'
                when summaryByRange.factor = 'meditation' and avgMeditation > 30 and avgMeditation <= 40 then '31-40'
                when summaryByRange.factor = 'meditation' and avgMeditation > 40 and avgMeditation <= 50 then '41-50'

recursivecodes

@Query(
        value = "select * from mv_game_details_with_brain where brainRecords > 0 order by matchStart desc",
        nativeQuery = true,
        countQuery = "select count(1) from mv_game_details_with_brain where brainRecords > 0"
)
Page<GameDetailDTO> listGameDetailsWithBrain(Pageable pageable);

recursivecodes

select *
from game g
order by created_on desc;