design – Finding/determining future data for pricing

I’m honestly not even sure how to go about how to ask what I’m looking for/need. lol.

I’m currently using Sql Server for my database and the ‘new.net 5. There are multiple pricing tables that each have their own purpose for pricing lineitems on an order. These pricings get updated quite often, ranging from either monthly to once a year.

In the system they’re currently using(super old), when a new pricing system comes out they create an entirely new table with those values, everytime. They do this because when an order is placed, it needs to get what the price would be on it’s due date.

For example:

‘orderA’ is placed December 20th with a due date of December 30th. ‘orderA’ uses the current pricing data that’s in effect.

‘orderB’ is placed on the same day, December 20th, but it has a due date of Jan 1st. ‘orderB’ would use the future data for pricing.

The example above is why they currently just create an entirely new table every time any pricing gets updated. I obviously do not want to do that, for a multitude of reasons.

I currently have functionality in place where users can schedule updates to different tables. This is basically just a stored procedure that creates a Sql Agent Job that gets triggered to execute an update query on a specific date.

Now this handles the ability to schedule updates, but it does not handle the ability to view if or what future data may be, which is the problem I’m running into.

I’ve looked into time-series data a bit, but I’m not entirely sure if that’s the best course of action.

I’m also not entirely sure what kind of information can be pulled from a specific scheduled job.
I feel that if I am able to get the jobs command, I’d need to essentially execute that query against current data without actually updating it to get the future data values or parse the query into a usable format I can use. Plus doing this, would probably cause big performance issues as it’d need to get ran multiple times for each line item in an order, depending on various pricing conditions.

So, what is the best course of action I should take? Whether it’s something I have mentioned or there’s something I haven’t mentioned, please let me know.

uk – My date of birth has been corrected in my new passport. Would this cause issues for future visa applications?

Apply for your new visa, and attach commentary on your circumstances (along with a copy of any supporting documentation). I would think that since you’re voluntarily disclosing the information, you should have no problem.

This assumes that there is no information available that matches your name and correct birthdate, that would have precluded you from getting a visa previously. Chances are, if your birthdate was just a few days or months out (as opposed to many years), they would already have figured that out, if it were the case.

❕NEWS – Jack Dorsey Says Bitcoin Will Become Major Part Of Twitter’s Future | Proxies123.com

Yeah, it may be. After many comanies like tesla and others now Twitter has also invested in crypto. I think it will help them a lot. Recently they lose one quatar of their ad revenue and now they are trying to back it up by investing in crypto, making a plan of ad free paid membership etc. Good luck Twitter!!!

generate future dates for multiple entries based on start and end date of each row

i have an issue figuring out the below approach, would appreciate f you can give me a hand with a SQL query to generate the required result (basically i want to generate dates that semi annually Greater than start date and less than or equal end date)

Table

ID Start Date End Date
X 1 Jan 2021 1 Jan 2023
Y 1 Mar 2021 1 Mar 2023
Z 1 Jun 2021 1 Jun 2023

results needed

ID Date
X 1 Jun 2021
X 31 Dec 2021
X 1 Jun 2022
X 1 Jan 2023
y 31 Sep 2021
y 1 Mar 2022
y 31 Sep 2022
Y 1 Mar 2023
z 1 Jan 2022
z 1 Jun 2022
z 1 Jan 2023
z 1 Jun 2023

thanks in advanced

Good design for an interface function that returns ‘attributes’ that might change in the future for different implementations

I’m developing a driver in C. As you know, generally these drivers have a common *.h interface file with generic functions and then a struct api with function pointers which point to different driver implementations, depending on the underlying device to be handled.

My specific driver implementation can now return several little attributes, and I’m aware this can change dramatically depending on the underlying hardware.

I have seen in the past drivers that have functions like int driver_attr_get(handle, attribute, value) instead of a ton of getter functions. However, different attributes might have different lengths, therefore I have though that a good design for this function would be to make value an array with a preset maximum length, and return the length of the attribute apart from its value. Still, this would force the API user to know the length of each attribute, to provide a long-enough array, which to me seems a design flaw.

Is there any design pattern or equivalent I can use to handle this problem in a ‘industry-standard’ way?

❕NEWS – Cryptocurrency traders look toward big gains in the near future | Proxies123.com

The predictions that are made in the cryptocurrency world are often divided between people, as this is a decentralized network, and therefore it will be highly unpredictable moving forward as well. In order to predict the price of crypto you have to predict the price of human behaviour and that is just not possible. In a recent news article however, it seems that there are many traders that are under the impression that bitcoin may soon text the 40k USD region and that the altcoin will see more than double increase in price, with raises of as much as 150%. This was seen in a tweet by Keith Wareing. Do you agree with such predictions and do you think that the conference yesterday could be a driving force for these predictions?

❓ASK – Previous work experience helps in future or not? | Proxies123.com

Many people start business but they cannot sustain for long time. Unfortunately they have to quit the business and move to another. There are so many examples where people keep on trying to find a suitable business, and for that have to quit so Many other jobs.

When we quit a previous job or business, there might be some problem within ourselves, which led our business to collapse. Learnings from our own mistake will surely help, but do that help in future prospect? Does the past experience really helps in deciding our future prospects?

❓ASK – The future of Chinese (small) investors | Proxies123.com

The narative of the future of Chinese investors hasnt been to optimistic during the last weeks, since the Chinese government announced their plans to ban free, decentralized crypto in favor to their own digital renminbi. Now when the announced plans are executed, on the surface we can see there are many big mining coprs leaving the country, exchanges switch location or reshaping their business model. What we are not seeing are small investors!
They can not run, but liquidating their crypto assets. What do you think is their future? A digital renminbi will not have the growth potentials by design and the profit promise that comes from mining or staking.
What could be business models based on the new digital currency in China? Or do investors move back to traditional stock investments? Moving money out of China to invest into crypto from there?

sqlite – Exibir variável do Future em um ElevatedButton

Estou fazendo a chamada no meu banco de dados do número do embarque, preciso colocar esse número dentro de um botão, porém minha variável “num_embarque” aparece como indefinida dentro do ElevatedButton

import 'package:flutter/material.dart';
import 'package:sqflite/sqflite.dart';
import 'Embarque.dart';
import 'Settings.dart';
import 'database/sqlite/connection.dart';

class menu extends StatefulWidget {
  const menu({Key? key}) : super(key: key);

  @override
  _menuState createState() => _menuState();
}

class _menuState extends State<menu> {
  @override
  Widget build(BuildContext context) {
    Future<List<Map<String, void>>> chamaemb() async {
      Database db = await Connection.get;
      String url = 'SELECT nr_embarque FROM embarque';

      List nr_embarque = await db.rawQuery(url);
      String num_embarque = nr_embarque.first("nr_embarque");

      return db.query('num_embarque');
    }

    
    new Container();
    return Scaffold(
        appBar: AppBar(
          brightness: Brightness.dark,
          automaticallyImplyLeading: false,
          title: Text("Embarques"),
          backgroundColor: Color(0xffb0000CD),
        ),
        body: Container(
          padding: EdgeInsets.all(32),
          decoration: BoxDecoration(color: Colors.grey(400)),
          child: Column(
            crossAxisAlignment: CrossAxisAlignment.center,
            children: (
              ConstrainedBox(
                constraints: BoxConstraints.tightFor(width: 1000, height: 50),
                child: ElevatedButton(
                  child: Text(
                    "Embarque: $num_embarque",
                    //AQUI, esta é a variável que aparece indefinida


                    textAlign: TextAlign.center,
                    style: TextStyle(fontWeight: FontWeight.bold, fontSize: 16),
                  ),
                  style: ElevatedButton.styleFrom(
                    primary: Color(0xffbDCDCDC),
                    onPrimary: Colors.black,
                  ),
                  onPressed: () {
                    Navigator.push(
                      context,
                      MaterialPageRoute(
                        builder: (context) => Embarque(),
                      ),
                    );
                  },
                ),
              ),
              SizedBox(
                height: 32,
              ),
            ),
          ),
        ),
        floatingActionButton: FloatingActionButton(
          onPressed: () {
            Navigator.push(
              context,
              MaterialPageRoute(
                builder: (context) => Settings(),
              ),
            );
          },
          child: const Icon(Icons.settings),
          backgroundColor: Color(0xffb0000CD),
        ));
  }
}
´´´

Best Binance Future Bybit Coindcx Coinswitch Signals Provider On Telegram

Binance Future Signals – https://binancefuturessignals.com/

FREE automated Bots for Binance future, CoinDCX, WazirX, Coinswitch, HitBTC, BitFinex, Huobi, Bitmex, Upbit, Okex exchange and thus are the best in this business

The Bot follows the Auto Signals and trades as per take profit and stop loss automatically. The Bot also has a special feature of making spontaneous trades, these are the trades which are made by the Bot according to the Trend of the market.

We too provide good quality signals for Binance future, CoinDCX, WazirX, Coinswitch, HitBTC, BitFinex, Huobi, Bitmex, Upbit & Okex. These signals are provided by our Experts who are in Crypto Industry for more than 5 years. The signals are given with proper take profit and proper stop loss including leverage.