./setup-x86_64 -q -L -l "D:\cygwin-packages" -R "d:\cygwin64" -s "file:///D:/cygwin-packages" -P cron

参数解释
-q：静默模式（无需用户交互）。
-L：强制使用本地包目录中的文件，而不是从网络上下载。
-l "D:\cygwin-packages"：指定本地包目录路径（注意这里使用的是Windows路径格式）。
-R "C:\cygwin64"：指定Cygwin的安装路径。
-s "file:///D:/cygwin-packages"：指定包的本地源（URI格式）。 
-P cron：指定要安装的包名称，这里是cron。
其他注意事项
确保本地源目录（例如D:\cygwin-packages）中包含cron包的相关文件及所有依赖。
如果安装过程中遇到依赖问题，请确保本地源中包含这些依赖包，或将依赖包也一并添加到安装命令中。
运行上述命令后，setup-x86_64.exe将从本地源安装cron包并确保其依赖项满足。

cygrunsrv --install cron --path /usr/sbin/cron --args -n
*** There are a lot of web posts that say you should use cygrunsrv -I cron -p /usr/sbin/cron -a -D (See Errors #1 & #2).

# rm bg color
color=$( convert filename.png -format "%[pixel:p{0,0}]" info:- )
convert filename.png -alpha off -bordercolor $color -border 1 \
    \( +clone -fuzz 30% -fill none -floodfill +0+0 $color \
       -alpha extract -geometry 200% -blur 0x0.5 \
       -morphology erode square:1 -geometry 50% \) \
    -compose CopyOpacity -composite -shave 1 outputfilename.png

static void Main(string[] args)
{
    CcdImgClient currInstance = CcdImgClient.Instance;
    currInstance.InitPythonEnv();

    // This delegate will be called when the thread is done executing.obj/Program.cs
    Bitmap image1 = new Bitmap(@"E:\Cnt_1_相机2_平台30_原始_时间码2023082115410830.0.bmp", true);

    byte[] img_buff = ImageToByteArray(image1);
    // byte[] img_buff = GetRGBValues(image1);
    Console.WriteLine(img_buff.Length);
    string ret = pythonModule.evaluate_bin_img(img_buff);

    Console.WriteLine(ret);

}

public static byte[] ImageToByteArray(Bitmap bmap)
{
        using (var ms = new MemoryStream())
        {
            bmap.Save(ms, bmap.RawFormat);
            return ms.ToArray();
        }
}

insert into ac_ods.appliance_domain select  regexp_replace('2020-03-01', '-', '')  as domoy, count(1) dicnt, speech_source, category_no, nlu_l1, nlu_l2 from aipdc.intent where year_month=202003 and to_date(time)  =  '2020-03-01' group by speech_source, category_no, nlu_l1, nlu_l2 ;
insert into aipdc.speaker_domain select 20200501, count(1), 'speaker', '1C', get_json_object(action_vod, '$.domain') as domain from tmp.ods_smart_speaker_reportdata_state where part_dt = '2020-05-01' group by get_json_object(action_vod, '$.domain') ;

insert into ac_ods.slient60 select regexp_replace('2020-05-01', '-', '') as domoy, count(distinct sn) c60_silent, case when speech_source is null then 'Total' else speech_source end as speech_source from aipdc.intent t where to_date(t.time) < date_sub('2020-05-01', 60) and not exists ( select 1 from aipdc.intent n where to_date(n.time) > date_sub('2020-05-01', 60) and to_date(n.time) <= '2020-05-01' and n.sn = t.sn) group by speech_source with rollup ;

insert into aipdc.device_domain_stage partition(year_month=202008) select 20200802, sum(i_cnt),  speech_source, category_no, classifier, domain from ac_ods.appliance_domain where domoy <= 20200802 group by speech_source, category_no, classifier, domain order by speech_source , category_no, classifier, domain;
insert into aipdc.device_domain_stage partition(year_month=202008) select 20200802, sum(i_cnt), speech_source, category_no, 'publicDomain', domain from ac_ods.speaker_domain where domoy <= 20200802 group by speech_source, category_no, domain order by speech_source , category_no, domain;

``


-- curr
insert overwrite table ac_ods.device_base
select domoy, new_cnt, accumulate_cnt , active_cnt, active2_cnt, speech_source , category_no  from (
select *, row_number() over (partition by domoy,speech_source, category_no order by domoy) rn from  aipdc.device_base_stage 
) t where rn = 1;
insert overwrite table aipdc.device_base_stage select * from  ac_ods.device_base;

insert overwrite table ac_ods.speaker_domain
select domoy, i_cnt, speech_source , category_no, domain from (
select *, row_number() over (partition by domoy,speech_source, category_no, domain order by domoy) rn from  aipdc.speaker_domain
) t where rn = 1;
insert overwrite table aipdc.speaker_domain select * from ac_ods.speaker_domain;

-- alter table  aipdc.device_domain_stage drop if exists partition(year_month=202008);
insert overwrite table ac_ods.device_domain
select domoy, i_cnt, speech_source , category_no, classifier, domain from (
  select *, row_number() over (partition by domoy,speech_source, category_no, classifier, domain order by domoy) rn from aipdc.device_domain_stage
  where i_cnt is not null and year_month=202008 
) t where rn = 1;
insert overwrite table aipdc.device_domain_stage partition(year_month=202008) select * from ac_ods.device_domain where domoy >=20200801

-- insert into table aipdc.device_domain_stage partition(year_month=202008) select domoy, i_cnt, speech_source , category_no, classifier, domain from ac_ods.device_domain where domoy >=20200801 and domoy < 20200824


insert overwrite table ac_ods.device_accumulate 
select domoy, newdevice_cnt, device_cnt, speech_source, province, city  from (
select domoy, newdevice_cnt, device_cnt, speech_source, province, city , row_number() over (partition by domoy, speech_source order by domoy) rn from aipdc.device_accumulate_stage
) t where t.rn = 1;
insert overwrite table aipdc.device_accumulate_stage  select * from  ac_ods.device_accumulate;

insert overwrite table ac_ods.device_retention
select domoy, cnt1d, cnt2d_excluding_end, cnt3d_excluding_end, cnt7d_excluding_end, c60_silent, speech_source, province, city from (
select domoy, cnt1d, cnt2d_excluding_end, cnt3d_excluding_end, cnt7d_excluding_end, c60_silent, speech_source, province, city, row_number() over (partition by domoy, speech_source order by domoy) rn from aipdc.device_retention_stage) t where  t.rn = 1;
insert overwrite table  aipdc.device_retention_stage select * from  ac_ods.device_retention;

{
    // Use IntelliSense to learn about possible attributes.
    // Hover to view descriptions of existing attributes.
    // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
    "version": "0.2.0",
    "configurations": [
        {
            //配置名称，将会在启动配置的下拉菜单中显示
            "name": "Python: Current File",
            //配置类型
            "type": "python",
            //请求配置类型，可以为launch（启动）或attach（附加）
            //launch: VSCode 会打开这个程序然后进入调试
            //attach:你已经打开了程序，然后接通内部调试协议进行调试
            "request": "launch",
            "stopOnEntry": false,
            "justMyCode": true,
            "python": "/data/datasets/stable-diffusion21-webui/stable-diffusion-webui/venv/bin/python",
            //将要进行调试的程序的路径
            "program": "${file}",
            //调试程序时的工作目录，一般为${workspaceRoot}即代码所在目录
            "cwd": "${workspaceRoot}",
            "console": "internalConsole",
            "env": {"CUDA_VISIBLE_DEVICES": "1"},
            "envFile": "${workspaceRoot}/.env",
            "debugOptions": [
                // "WaitOnAbnormalExit",
                // "WaitOnNormalExit",
                "RedirectOutput"
            ],
            "args": [
                "--xformers",
                "--api-log",
                "--nowebui"
            ]
        }
    ]
}

...
[DEBUG] -- end configuration --
[INFO] Generating project in Interactive mode
[DEBUG] Searching for remote catalog: http://repo1.maven.org/maven2/archetype-catalog.xml
... 

<dependency> 
    <groupId>org.apache</groupId> 
    <artifactId>common</artifactId> 
    <version>3.1</version> 
    <scope>system</scope> 
    <systemPath>d:/apacheXXX-common.jar</systemPath> 
</dependency>

for p in "${1:-noble}"{,-{security,updates,backports}}
do
echo $p;
# -np 与 -nH --cut-dirs一起使用时， -np貌似不生效， GNU Wget 1.21.4(@ubuntu24.04)
wget -c -r -e robots=off -np -R "index.htm*" "https://mirrors.tuna.tsinghua.edu.cn/ubuntu/dists/$p/"
done