jcaillon / oetools.sakoe

SAKOE - Swiss army knife for openedge, provides various tools useful for any openedge developer such as database manipulation, compiling a project, linting source files, etc...

Sakoe

The Swiss army knife for openedge, provides various tools useful for any openedge developer such as database manipulation, compiling a project, linting source files, etc...

Status	Info
	Windows CI Provided By AppVeyor
	Latest github release
	Total download
	GPLv3 License
	Targets .NET framework 4.6.1+
	Targets .NET core 2.1+

About

Please refer to the documentation here.

Build information

Details/help on how to build this project.

Submodules

• Oetools.Builder.
• GithubUpdater.
• CommandLineUtilsPlus.
• Oetools.Utilities.
• CabinetManager.
• DotUtilities.

Thanks

This project was developped using an opensource license of the rider by jetbrains.

The logo is provided by the icons8.

oetools.sakoe's Issues

Replace all the Encoding.Default. Option to set the encoding used by the openedge side and mirror it in C#

Add "condition" nodes to build step/tasks!

zipstorer

https://github.com/jaime-olivares/zipstorer/blob/master/src/ZipStorer.cs

Add check last database update

FIND FIRST _DbStatus NO-LOCK.
MESSAGE _DbStatus._dbstatus-cachestamp VIEW-AS ALERT-BOX.

Include documentation in the xsd

https://stackoverflow.com/questions/2211546/how-to-include-the-xsddocumentation-in-the-c-sharp-class-generated-with-xsd-exe

  <xs:element name="Project" nillable="true" type="OeProject">
    <xs:annotation>
      <xs:documentation>This is the root element, project</xs:documentation>
    </xs:annotation>
  </xs:element>

Update oeproj.xml after an update

bulk load

https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmadm%2Floading-table-contents-with-the-bulk-loader-qual.html%23wwID0E6FLU

Append $DLC/gui, $DLC/tty and $DLC/src to the propath

prendre en compte le .gitignore dans l'exclusion des sources

Automated tasks

    [Serializable]
    [XmlRoot("AutomatedTasks")]
    public class OeAutomatedTasks {
        
        [XmlAttribute("Label")]
        public string Label { get; set; }
        
        [XmlArray("Variables")]
        [XmlArrayItem("Variable", typeof(OeVariable))]
        public List<OeVariable> Variables { get; set; }
        
        [XmlArray("Tasks")]
        [XmlArrayItem("Execute", typeof(OeTaskExec))]
        [XmlArrayItem("RemoveDirectory", typeof(OeTaskDirectoryDelete))]
        [XmlArrayItem("Delete", typeof(OeTaskFileDelete))]
        [XmlArrayItem("Cab", typeof(OeTaskFileArchiverArchiveCab))]
        public List<AOeTask> Tasks { get; set; }
    }

Replace taskvar in each property of each task

location of the project.xsd file

OeDataOperator -> make xtra param for internationalization a prop to use for the cmds that need it

option -logo to show the sakoe logo and version at the beggining of a command

on a file, store a reason why it was built

Alias DICTB for the first database connected

end tree log

In the results, display the execution time of post compile analysis

to compile a source at its dir location, we just need the include to be ((**))((*)) get rid of the SOURCE DIR bullshit

Webclient : Add something to allow to configure several "components" and their mode (Eager/Lazy..)

It would actually be more accurate to try to parse the compilation error message and guess the file/line

Filter properties XmlIgnore in AoeFilter to be able to have XmlElement for source filter

Add http archiver

        ASSIGN
            /* curl.exe -v --stderr - -X DELETE -u rawdeploy:rawdeploy http://192.168.213.143/repository/raw-ressources/progress/snapshot/cnaf/pc/sac/18062.0001-SNAPSHOT/sac-18062.0001.dar --proxy http://192.168.213.137:3128 */
            lc_out = DYNAMIC-FUNCTION('btUseCurl', INPUT "-v --stderr - -X DELETE -u " + gb_confignexus.nexusUser + ":" + gb_confignexus.nexusPwd + " " + gc_url + "/" + gc_darName, INPUT lc_targetPath, INPUT TRUE)
            .
        RUN pi_stopWait.
        IF NOT lc_out MATCHES "*HTTP/1.1 204*" THEN
            DYNAMIC-FUNCTION('btDisplayError', INPUT "Erreur lors de la suppression du fichier .dar sur nexus : " + QUOTER(lc_out)).

    /* Upload to xldeploy */
    /* curl -u<username>:<password> -X POST -H "content-type:multipart/form-data" http://<xl-deploy-server>:<xl-deploy-port>/deployit/package/upload/Test.dar -F fileData=@/tmp/test1-1.0.dar */

    ASSIGN
        lc_out = DYNAMIC-FUNCTION('btUseCurl', INPUT "-v -H " + QUOTER("Expect:") + " --stderr - -u " + gb_confignexus.nexusUser + ":" + gb_confignexus.nexusPwd + " --upload-file " + QUOTER(lc_targetPath + gc_darName) + " " + gc_url + "/" + gc_darName, INPUT lc_targetPath, INPUT TRUE)
        .

    RUN pi_stopWait.

    IF NOT lc_out MATCHES "*HTTP/1.1 201*" THEN
        RETURN ERROR "Erreur lors de l'upload du fichier .dar sur nexus : " + QUOTER(lc_out).
    DYNAMIC-FUNCTION('btDisplayInfo', INPUT "Le paquet au format .dar a été correctement uploadé sur Nexus").

private static void SendFileToServer(string fileFullPath)
        {
            FileInfo fi = new FileInfo(fileFullPath);
            string fileName = fi.Name;
            byte[] fileContents = File.ReadAllBytes(fi.FullName);
            Uri webService = new Uri(@"http://avalidwebservice.com");
            HttpRequestMessage requestMessage = new HttpRequestMessage(HttpMethod.Post, webService);
            requestMessage.Headers.ExpectContinue = false;
 
            MultipartFormDataContent multiPartContent = new MultipartFormDataContent("----MyGreatBoundary");
            ByteArrayContent byteArrayContent = new ByteArrayContent(fileContents);
            byteArrayContent.Headers.Add("Content-Type", "application/octet-stream");
            multiPartContent.Add(byteArrayContent, "this is the name of the content", fileName);
            requestMessage.Content = multiPartContent;
 
            HttpClient httpClient = new HttpClient();
            try
            {
                Task<HttpResponseMessage> httpRequest = httpClient.SendAsync(requestMessage, HttpCompletionOption.ResponseContentRead, CancellationToken.None);
                HttpResponseMessage httpResponse = httpRequest.Result;
                HttpStatusCode statusCode = httpResponse.StatusCode;
                HttpContent responseContent = httpResponse.Content;
 
                if (responseContent != null)
                {
                    Task<String> stringContentsTask = responseContent.ReadAsStringAsync();
                    String stringContents = stringContentsTask.Result;                    
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
```

Db utilities

• PROBCKUP
• BULK LOAD
• DBANALYSIS
• DB ADMIN
• DATADIGGER
• SQL : https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmadm/sql-utilities.html

sqlschema -o atl.dfsql -Q % -t %.% -u "" -a "" progress:T:localhost:1024:atlp_17_01

make a function that returns the list of files modified since : branch creation

actually no, simply make a bash that do this and use an environment var containing the files? -> derp var limitation leght

cli option to set up the properties of the project (use reflection to browse all the properties and replace the matches)

Add autocompletion in bash and powershell

https://github.com/dotnet/command-line-api/wiki/dotnet-suggest

Improve current wildcard system

instead of just using * and ?, allow the usage of : **, * and ?

• ** matches any number of char including / and \
• • matches any number of char excluding / and \
• ? matches 1 char excluding \ and /

Task prolint that allows to output an xml with problems

todo

• After the source build tasks, check each previous files, those which were recompiled, check the targets differences, and remove the targets needed using sourceRemover task
• we also need to do that for unchanged files; use the task executor in test mode to simply get all the files built then do the same comparison with the previous built
• for Compile tasks, use a boolean that indicates wether or not files received in ExecuteForFiles should be compiled or they they already are

replace InitIds by reflection

Webclient : Provide an option to cabify the prowcapp into a prowcapc

Remove xsi:nil from OePRoject serialization

https://stackoverflow.com/a/47536301

Show alternative command name in help

use canczellation token of the compilation

Add child configuration that inherits from their parents

Documentation

Use :

• https://docs.readthedocs.io/en/latest/getting_started.html
• https://github.com/rtfd/template/tree/master/docs
• https://jcaillon-demo.readthedocs.io/en/latest/
• https://www.gitbook.com/?t=1
• https://helpbuilder.west-wind.com/

Improve OeExportReaderTest to read stream from file instead of reading all in one go

Add .oe/local to .gitignore on project init

Append $DLC/gui, $DLC/tty and $DLC/src to the propath

OeTaskCompile should handle compiling files when receiving something different than *.r

run all tests on linux

Create a new type that implements IList and that is made to handle list of IOeFile which has a FilePath property

this is to improve search in file list

Create an updater lib (github update) + update command

default for prolib version

filter what to delete in removal tasks

Set up environment variables before start Exec task

Add an option to UoeExecutionCompile : stop on compilation error

cli option to pass new OeVariables

Implement custom tasks

Could be interesting and useful to have something along these lines:

  <!-- defines the Zip task -->
  <UsingTask TaskName="Zip" TaskFactory="CodeTaskFactory" AssemblyFile="$(MSBuildToolsPath)\Microsoft.Build.Tasks.v4.0.dll">
    <ParameterGroup>
      <InputFileNames ParameterType="Microsoft.Build.Framework.ITaskItem[]" Required="true" />
      <OutputFileName ParameterType="System.String" Required="true" />
      <OverwriteExistingFile ParameterType="System.Boolean" Required="false" />
    </ParameterGroup>
    <Task>
      <Reference Include="System.IO.Compression" />
      <Using Namespace="System.IO.Compression" />
      <Code Type="Fragment" Language="cs">
        <![CDATA[        
        const int BufferSize = 64 * 1024;
 
        var buffer = new byte[BufferSize];
        var fileMode = OverwriteExistingFile ? FileMode.Create : FileMode.CreateNew;
 
        using (var outputFileStream = new FileStream(OutputFileName, fileMode))
        {
          using (var archive = new ZipArchive(outputFileStream, ZipArchiveMode.Create))
          {
            foreach (var inputFileName in InputFileNames.Select(f => f.ItemSpec))
            {
              var archiveEntry = archive.CreateEntry(Path.GetFileName(inputFileName));
 
              using (var fs = new FileStream(inputFileName, FileMode.Open))
              {
                using (var zipStream = archiveEntry.Open())
                {
                  int bytesRead = -1;
                  while ((bytesRead = fs.Read(buffer, 0, BufferSize)) > 0)
                  {
                    zipStream.Write(buffer, 0, bytesRead);
                  }
                }
              }
            }
          }
        }        
      ]]>
      </Code>
    </Task>
  </UsingTask>

à la msbuild