Blog

GBAXG

Welcome to the GBA Cross-Game Pokemon Map Randomiser. This emulator mod loads and modifies Fire Red, Emerald and Crystal Dust ROMS so you can simultaneously play across Kanto, Johto and Hoenn. Memory is dynamically altered so you can keep your team, items, money and trainer data when moving between games/reigons.

A major new release is now (August 2023) available with a complete change of the emulation core to use skyemu. Go To The Emulator .

The older version can still be played here but will no longer be updated.

Rules

If you’ve not played a map randomiser before the goal is to find and beat the Gyms, E4, Champion (and final boss). In this you start in Pallet Town where none of the loading zones have been randomised but that will change as soon as you get to Viridian.

The randomisation logic should make it so that it’s possible to beat the Gyms, E4 and Champion in order. The logic only guarantees order within each region. This means you should always be able to beat Kanto Gym 1 before Gym 2(/3/4/5 e.t.c) however you might need to beat Johto gyms 1,2 and 3 before you can get to Kanto Gym 1.

If you are only randomising up to certain gyms you will never have to play beyond that point.

In a full randomisation there are 24 Gyms, 12 E4, 3 Champions and 1 final boss (Steven). Red is not present in Crystal Dust V2.

Setup

Legally backup a copy Fire Red 1.1 (U) [^1] and Emerald (U) [^2]
Download Crystal Dust V2 patch from here here. Make sure to use V2 and not V3
Use a rom patcher to apply the Crystal Dust V2 patch to a copy of your Emerald (U). You should now have 3 roms.
Open the emulator in Chrome (Edge is not supported) [^4]
Load each rom into the correct slot. Crystal and Emerald will need to run some initialisation code when they are loaded
When all 3 roms are loaded press ‘start’ and it should boot into a new game of Fire Red

ESC (or long swipe down) will bring up the emulation menu where you can change things like the seed.

[^1] (md5sum 51901a6e40661b3914aa333c802e24e8)
[^2] (md5sum 605b89b67018abcea91e693a4dd25be3)
[^3] (md5sum ef47f6528875dc3de037e75bba6a0ecb)
[^4] Firefox may work but is prone to lagging (especially during speedup)

Tracker

A version of Sekii’s tracker that supports all three game at once is now available at https://sekii.gitlab.io/pokemon-tracker/

How Does It Work?

Data extraction can be broken into 3 main parts.

Current Warp | (Length 0x3 bytes) | FR (0x2031dbc) / E (0x20322e4)
Current Party | (Length 0x258 bytes) | FR (0x02024284) / E (0x020244EC)
Save Data (it’s complicated).

From the save data we need to extract things like: Badges, Cross Game Flags (e.g running shoes/starter choice), Repel Steps, Play Time, Game Settings, Trainer Name/Gender/ID, Money, Bag Data, Boxed Pokemon e.t.c

Gen 3 save data structure is well documented, however 2 main issues. Some data (e.g money and item counts) is obsfucated with an XOR key that gets frequently updated and will be different between games. We need to be careful that when going from Game 1 to Game 2 we XOR this data with Game 1’s key then XOR it again with game two’s key before we inject that data. This key can be fround inside save block 1.

In general Block 1 contains game flags and bag data, Block 2 contains trainer data and settings and Block 3 contains boxes pokemon and items.

The second, and larger problem, is that save data is split into 3 blocks that get randomly moved around in the EWRAM each time a warp is triggered or menu opened. This means we cannot hard code offsets in order to look up data. To resolve this we have to look up the pointers to those addresses in the IWRAM (which do have a constant offsets) to get the start of each block. Then we use the offset from the start of the block to find the save data we want. Pointers are 3 32-bit values starting at FR (0x03005008) / E (0x03005D8C).

Current Cross-Game limitations

Currently only PC box 1 is shared between games
Whiteout (and teleport e.t.c) will go the the last heal point in which ever region/game you are currently in.
Some items (mostly from Crystal Dust e.g rage candy bar) only work in the game they were designed for. TMs may be different in Crystal.
When randomizing abilities and base stats with UPR these will change between regions. When randomising TMs/HMs these will not stay the same between games.

Progress & Development

You can now see the latest fixes and tracked issues over on the trello development page

You can find older releases here

F.A.Q

I found a bug. What should I do?

If you find any issue please report them in the issues setion of the github here. Preferably include as much details as possible and screenshots.

Can I choose which reigon I start in?

Not at the moment. This may be added in future.

Will Sevii Islands/Mt. Silver/Tin Tower/Battle Frontier e.t.c be included later?

I want to focus on making the experience as polished as possible for the first release so I’m not currently adding any more areas. Not every area is possible to add, however Sevii islands and the outside of the battle frontier may be added in a later release.

Can I randomise the pokemon?

Randomised roms have not had much testing and may produce bugs. However you can use this randomiser to randomise the roms. You will need to modify each rom separately before loading them. The Randomiser is a copy of Universal Pokemon Randomizer – ZX that has been modified so that it hopfully won’t crash when used on Crystal Dust V2. Compatibility with Crystal Dust V2 will probably not be 100% as I only made changes to help prevent crashing, I’ve not specifically added offsets e.t.c for things like static encounters.

Will this work with X Rom hack?

Simple binary hacks may be compatible. Decomp hacks will probably not work without making changes to some of the hard coded ROM and RAM addresses in the following files: WarpFixes, EmulationCoreHacks, SpriteOffsetData

Can I play on mobile/tablet

Maybe. The mod has been designed for and tested on desktop and requires a reasonable processor. However it may be able to run within some mobile browsers. A long swipe down can be used to open/close the main menu. On-screen keys can be activated from the controls screen. Some additional performance may be gained by activating ‘LOW SPEC PC’ mode from the hacks screen. This will disable audio and may cause frames to be missed.

It gets stuck saying ‘Initialising’ for Emerald/Crystal

The first time Emerald/Crystal are loaded (after erasing data) save data needs to be loaded in the background. This isn’t the case for Fire Red as you manually create a new game. Initialising the roms should generally not take more than 30 seconds the first time they are loaded and should be instant after. If the initilisation is taking a long time/appears to be stuck you should refresh the page and try again. Less powerful devices (such as tablets) may run out of resources during initilisation and fail. As a work-around you can start the game on a more powerful device, save the game and export the save file (‘EXPORT LAST’). You can then import this on your less powerful device BEFORE loading the roms and initilisation will be skipped.

Credits

Coding – `KittyPBoxx`

Testers – `Sabata`

*Crystal Dust V2 was created by Sierraffinity (domoreaweso.me)*
*IodineGBA (the core emulator) was created by Grant Galitz (taisel)*
*Universal Pokemon Randomizer ZX was created by Ajarmar*
*SkyEmu was created by skylersaleh*

The Source Code for the project can be found at https://github.com/KittyPBoxx/GBAXG

Licence

MIT License (MIT)

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Search

As various terms such as pokemon combo map randomizer, combo warp randomizer, crossover map randomizer e.t.c are used interchangeably some people have had issues finding the repository. For this reason I’ve started added in alternate terms such as map randomiser, multigame map randomizer and Fire Red + Emerald map randomizer to help people find this when using different search terms.

vinnie


Continuous Integration:
Code Coverage:
Maven Central:
Chat Room:
License:

vinnie is a lightweight Java library that reads and writes “vobject” data (vCard and iCalendar). It is used by the ez-vcard and biweekly projects.

Downloads | Javadocs | Maven/Gradle | Documentation

Examples

Parsing

Code

String str =
"BEGIN:VCARD\r\n" +
"VERSION:2.1\r\n" +
"FN:John Doe\r\n" +
"NOTE;QUOTED-PRINTABLE;CHARSET=UTF-8:=C2=A1Hola, mundo!\r\n" +
"END:VCARD\r\n";

Reader reader = new StringReader(str);
SyntaxRules rules = SyntaxRules.vcard();
VObjectReader vobjectReader = new VObjectReader(reader, rules);
vobjectReader.parse(new VObjectDataAdapter() {
	private boolean inVCard = false;

	public void onComponentBegin(String name, Context context) {
		if (context.getParentComponents().isEmpty() && "VCARD".equals(name)){
			inVCard = true;
		}
	}

	public void onComponentEnd(String name, Context context) {
		if (context.getParentComponents().isEmpty()) {
			//end of vCard, stop parsing
			context.stop();
		}
	}

	public void onProperty(VObjectProperty property, Context context) {
		if (inVCard) {
			System.out.println(property.getName() + " = " + property.getValue());
		}
	}
});
vobjectReader.close();

Output

FN = John Doe
NOTE = ¡Hola, mundo!

Writing

Code

Writer writer = new OutputStreamWriter(System.out);
VObjectWriter vobjectWriter = new VObjectWriter(writer, SyntaxStyle.OLD);

vobjectWriter.writeBeginComponent("VCARD");
vobjectWriter.writeVersion("2.1");
vobjectWriter.writeProperty("FN", "John Doe");

VObjectProperty note = new VObjectProperty("NOTE", "¡Hola, mundo!");
note.getParameters().put(null, "QUOTED-PRINTABLE");
vobjectWriter.writeProperty(note);

vobjectWriter.writeEndComponent("VCARD");
vobjectWriter.close();

Output

BEGIN:VCARD
VERSION:2.1
FN:John Doe
NOTE;QUOTED-PRINTABLE;CHARSET=UTF-8:=C2=A1Hola, mundo!
END:VCARD

Features

Full ABNF compliance with vCard (versions 2.1, 3.0, and 4.0) and iCalendar (versions 1.0 and 2.0) specifications.
Automatic decoding/encoding of quoted-printable data.
Streaming API.
Extensive unit test coverage.
Low Java version requirement (1.5 or above).
No dependencies on external libraries.

Maven/Gradle

Maven

<dependency>
   <groupId>com.github.mangstadt</groupId>
   <artifactId>vinnie</artifactId>
   <version>2.0.2</version>
</dependency>

Gradle

compile 'com.github.mangstadt:vinnie:2.0.2'

Build Instructions

vinnie uses Maven as its build tool, and adheres to its conventions.

To build the project: mvn compile
To run the unit tests: mvn test
To build a JAR: mvn package

Questions / Feedback

You have some options:

Post an issue
Gitter chat room
Email me directly: mike.angstadt@gmail.com

Crazy Sonos

Want to make someone go crazy with their Sonos player? This repo will help you to make it look possessed!
A project that started when I was testing the SoCo python library.

Things you can do

set_random_volume_for_random_time()

Set the volume of the Sonos speaker to a random value for a random amount of time

set_BOOM_volume_for_random_time()

Set the volume of the Sonos speaker to the max volume you choose for a shorter random amount of time

There are also check_playing_status that checks if the speaker is reproducing something (if not it restarts the reproduction), check_time_to_run that allows you to set the maximum script execution time, check_initial_status that checks if there is reproducing something as soon as the code is run (if not it puts a radio on), and take_snapshot that is useful to restore a previous backup reproducing session (if someone stops the reproduction while the script is running, see check_playing_status that uses this).

To run

Clone this repository
Install the requirements: pip3 install -r requirements.txt
Modify settings.py file adding the sonos_ip_address (optionally you can configure the other parameters)
Run script.py: python3 crazy_sonos.py. Right now the script is set to sleep first for 5 minutes then it will start to put a radio if something is not playing and then change the sonos speaker volume randomly according to the settings.
???
Profit!

ASYNCMONGO

Asynchronous MongoDB Made Easy

Overview

asyncmongo is a Python library for working with MongoDB asynchronously. I’m building this project to learn more about how database drivers work and to explore what goes into creating one. It’s a mix of learning and coding, so things might evolve as I figure things out!

Getting Started

Documentation

For detailed documentation, visit the asyncmongo documentation.

Prerequisites

Before getting started with asyncmongo, ensure your runtime environment meets the following requirements:

Programming Language: Python
Package Manager: Poetry

Installation

Install asyncmongo using one of the following methods:

Build from source:

Clone the asyncmongo repository:

git clone https://github.com/Roshan-R/asyncmongo

Navigate to the project directory:

cd asyncmongo

Install the project dependencies:

Using poetry

poetry install

Testing

Run the test suite using the following command: Using poetry

poetry run pytest

Project Roadmap

Currently Supported Operations

find
find_one
insert_one
Basic Connection: ~~Set up a basic connection to a MongoDB instance.~~
Authentication:
- Added support for SCRAM-SHA-256 authentication scheme.
- Add support for additional authentication mechanisms (e.g LDAP).
Connection Pooling: Develop connection pooling for better performance and scalability.
Testing and Benchmarks: Write unit tests and benchmarks.
- Write unit tests for connection handling and CRUD operations.
- Create benchmarks to measure and optimize performance.
Cython: Rewrite core components in Cython to improve performance, inspired by asyncpg’s implementation.

anilistgo wrapper

Most of the functionality is good to go for querying media from Anilist and Mutation such as adding media to the list or removing it. However there are still some left such as Threads, Reviews.

Anilist is an online manga/anime database and social networking service More information on Anilist can be found here : anilist

INSTALLATION

go get github.com/kaiserbh/anilistgo

Examples

Query

Character Query

import "github.com/kaiserbh/anilistgo"
c := anilistgo.NewCharacterQuery()

ok, err := c.FilterCharacterByName("Nezuko")
if err != nil{
	panic(err)
}

// ok is optional basically a boolean for further use cases.
if ok{ 
	fmt.Printf("%+v\n", c)
}
	
// can do this as well without ok variable.
import "github.com/kaiserbh/anilistgo"
c := anilistgo.NewCharacterQuery()

_, err := c.FilterCharacterByName("Nezuko-channnnnn")
if err != nil{
	panic(err)
}

fmt.Printf("%+v\n", c)

User Query

import "github.com/kaiserbh/anilistgo"
u := anilistgo.NewUserQuery()

ok, err : = u.FilterUserByID(197690)
if err != nil{
	panic(err)
}

// ok is optional basically a boolean for further use cases.
if ok{
fmt.Printf("%+v\n", u)
}

// can do this as well without ok variable.
import "github.com/kaiserbh/anilistgo"
u := NewUserQuery

_, err : = u.FilterUserByID(197690)
if err != nil{
	panic(err)
}

fmt.Printf("%+v\n", u)

Media Query

import "github.com/kaiserbh/anilistgo"
m := NewMediaQuery()

ok, err := m.FilterByID(1)
if err != nil{
	panic(err)
}

// ok is optional basically a boolean for further use cases.
if ok{
fmt.Printf("%+v\n", m)
}

// can do this as well without ok variable.
import "github.com/kaiserbh/anilistgo"
m := NewMediaQuery()

_, err := m.FilterByID(1)
if err != nil{
	panic(err)
}

fmt.Printf("%+v\n", u)

Page Query

import "github.com/kaiserbh/anilistgo"
p := NewPageQuery()

ok, err := p.PaginationByTitle("Attack on Titan", 1, 10) // takes title, page number, and per page amount
if err != nil{
	panic(err)
}

// ok is optional basically a boolean for further use cases.
if ok{
fmt.Printf("%+v\n", p)
}

Mediatrend

import "github.com/kaiserbh/anilistgo"
mt := NewMediaTrendQuery()
ok,err := mt.SearchByMediaID(1)
if err != nil{
	panic(err)
}
if ok{
    fmt.Printf("%+v\n", mt)
}

Staff query

import "github.com/kaiserbh/anilistgo"
s := NewStaffQuery()

ok, err := s.FilterStaffByName("Hideaki Sorachi")
if err  != nil {
	panic(err)
}

if ok{
	fmt.Printf("%+v\n", s)
}

Mutation

UserMediaList requires Auth/Token

import  "github.com/kaiserbh/anilistgo"
authKey := "long ass string"
ok, err := anilistgo.SaveMediaListEntry(1, "CURRENT", 0, authKey)
if err != nil{
	panic(err)
}
if ok{
	log.Info("succesfully updated uwu")
}

updateUser requires Auth/Token

import "github.com/kaiserbh/anilistgo"
authKey := "long ass string"

ok, err := anilist.UpdateUserAbout("uwu I love anime", authKey)
if err != nil{
    panic(err)
}
if ok{
    log.Info("succesfully updated uwu")
}

Notes

You will need auth token for some of the methods to work to get your own token feel free to use https://anilist.co/api/v2/oauth/authorize?client_id=4684&response_type=token

Docs

Documentation

    Piojo is a small C (C99) library of common containers and other useful
    structures.

    Documentation: http://eliangidoni.github.io/piojo


                                  Dependencies

1) CMake 2.6 (or any later version).
2) (optional) Doxygen for docs generation.
3) (optional) gcov/lcov for code coverage.


                                     Build

$ cd build
$ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local -DCMAKE_BUILD_TYPE=Release ..
$ make

To generate docs:
$ make doc


                                     Usage

See directory doc/ or test/ for code samples.


                                  Development

1) Debug

$ cd build
$ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local -DCMAKE_BUILD_TYPE=Debug ..
$ make

2) Testing (outputs Coverage)

$ cd build
$ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local -DCMAKE_BUILD_TYPE=Testing ..
$ cmake --build .
$ ctest --output-on-failure

Run valgrind image:

$ docker buildx build -t valgrind .
$ docker run -it -v $PWD:/user -w /user valgrind
$ mkdir -p build && cd build
$ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local -DCMAKE_BUILD_TYPE=Release ..
$ make clean && make
$ valgrind --leak-check=full ./test/piojo_array_test

3) Code Style

- Avoid lines with more than 80 characters.
- Avoid more than 3 levels of indentation.
- Avoid functions longer than 50 lines.
- Avoid functions with more than 5 arguments.
- Predicate (boolean) functions end with '_p'.
- Interface type names end with '_if'.
- Function/Callback type names end with '_cb'.
- Any other type names end with '_t'.
- Don't use typedef to hide pointer types. (exception: functions/callbacks)

Requirements

conda install pytorch==1.9.1 torchvision==0.10.1 torchaudio==0.9.1 cudatoolkit=11.3 -c pytorch -c conda-forge
pip install wandb==0.12.9
pip install Shapely==1.8.0

train.sh

CUDA_VISIBLE_DEVICES=$CUDA python train.py --yaml=main

test.sh

read -p "Exp: " dir
rm -rf ./exp/$dir
cd utils/cpp_bindings
sh compile.sh
cd ../..

CUDA_VISIBLE_DEVICES=$CUDA python test.py --yaml=org --dir=$dir
cp ./config/main.yaml ./exp/$dir/

Referecne: gmuffiness/CRAFT-train

CRAFT-train

On the official CRAFT github, there are many people who want to train CRAFT models.

However, the training code is not published in the official CRAFT repository.

There are other reproduced codes, but there is a gap between their performance and performance reported in the original paper. (https://arxiv.org/pdf/1904.01941.pdf)

The trained model with this code recorded a level of performance similar to that of the original paper.

├── config
│   ├── syn_train.yaml
│   ├── ic15_train.yaml
├── data
│   ├── pseudo_label
│   │   ├── make_charbox.py
│   │   └── watershed.py
│   ├── boxEnlarge.py
│   ├── dataset.py
│   ├── gaussian.py
│   ├── imgaug.py
│   ├── imgproc.py
├── loss
│   └── mseloss.py
├── metrics
│   └── eval_det_iou.py
├── model
│   ├── craft.py
│   └── vgg16_bn.py
├── utils
│   ├── craft_utils.py
│   ├── inference_boxes.py
│   └── utils.py
├── trainSynth.py
├── trainIC15.py
└── eval.py

Training

Write configuration in yaml format
Put the yaml file in the config folder
Run train code (trainSynth.py or trainIC15.py)
Then, experiment results will be saved to ./exp/[yaml] by default.

CUDA_VISIBLE_DEVICES=0,1 python3 trainSynth.py --yaml=syn_train   # run supervision code
CUDA_VISIBLE_DEVICES=0,1 python3 trainIC15.py --yaml=ic15_train   # run weak-supervision code

Arguments

--yaml : configuration file name

Evaluation

In the official repository issues, the author mentioned that the first row setting F1-score is around 0.75.
In the official paper, it is stated that the result F1-score of the second row setting is 0.87.
- If you adjust post-process parameter ‘text_threshold’ from 0.85 to 0.75, then F1-score reaches to 0.856.

Training Dataset	Evaluation Dataset	Precision	Recall	F1-score	pretrained model
SynthText	ICDAR2013	0.801	0.748	0.773	download link
SynthText + ICDAR2015	ICDAR2015	0.909	0.794	0.848	download link

ProductsApp

About

This demo project was bootstrapped with create-react-app, spring-boot-v2 and also jhipster.

Try deployed instance with Heroku productsapp

Goals

The main goal is to integrate various technologies and principles in a single full-stack application.

Dependencies

Backend

Frontend

Overview

Clone project with

    git clone github.com/gzheyts/productsapp <project_root>

Running application

mvn -f <project_root>/pom.xml spring-boot:run

Then navigate to localhost:8080

Running API

mvn -f <project_root>/pom.xml spring-boot:run -Dskip.yarn

This will run api on localhost:8080/api

Running Frontend dev server

cd <project_root>/src/main/webapp
yarn start

Will run frontend dev server at localhost:3000

Running server-side tests

To launch application’s tests, run:

mvn -f <project_root>/pom.xml test -Dskip.yarn

API usage examples httpie

Register user request

http POST :8080/users/register username="user" password="password"

response

HTTP/1.1 200 
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Content-Length: 0
Expires: 0
Pragma: no-cache
X-Content-Type-Options: nosniff
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block

Obtain JWT auth token for registered user

http POST :8080/login username="user" password="password"

response

HTTP/1.1 200 
Authorization: Bearer eyJhbGciOiJIUzUxMiJ9.eyJpYXQiOjE1MzMxOTgxNTYsInN1YiI6InVzZXIifQ.zvw99k1_Nh1UTNI6ZCBHL3v6-boXvuiyBNEcFM2LVhW0Rc6pAN7lEEJpXcSsOrJy0_9ifzgcJvCJTE9C1hW-ig
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Content-Length: 0
Expires: 0
Pragma: no-cache
X-Content-Type-Options: nosniff
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block

Access protected resources

http :8080/api/categories Authorization:"Bearer eyJhbGciOiJIUzUxMiJ9.eyJpYXQiOjE1MzMxOTgxNTYsInN1YiI6InVzZXIifQ.zvw99k1_Nh1UTNI6ZCBHL3v6-boXvuiyBNEcFM2LVhW0Rc6pAN7lEEJpXcSsOrJy0_9ifzgcJvCJTE9C1hW-ig"

response


HTTP/1.1 200 
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Content-Type: application/json;charset=UTF-8
Expires: 0
Pragma: no-cache
Transfer-Encoding: chunked
X-Content-Type-Options: nosniff
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block

{
    "content": [... ],
    "page": 0,
    "pageSize": 20,
    "total": 5
}

Logout

http :8080/logout Authorization:"Bearer eyJhbGciOiJIUzUxMiJ9.eyJpYXQiOjE1MzMxOTgxNTYsInN1YiI6InVzZXIifQ.zvw99k1_Nh1UTNI6ZCBHL3v6-boXvuiyBNEcFM2LVhW0Rc6pAN7lEEJpXcSsOrJy0_9ifzgcJvCJTE9C1hW-ig"

ASP.NET C# Demo Projects for Active Query Builder ASP.NET Edition

Also, check the VB.NET Demo projects repository for the same.

Demo projects for ASP.NET Core reside in a separate repository: ASP.NET Core Demo projects repository.

What is Active Query Builder?

Active Query Builder is a Visual SQL Query Builder and SQL parser component suite for ASP.NET (WebForms, MVC and Core 2.0).

Details:

How do I get Active Query Builder?

Download the trial version from the product web site
Get it by installing the Active Query Builder ASP.NET Edition NuGet package for WebForms or MVC.

What’s in this repository?

The demo projects in this repository illustrate various aspects of the component’s functionality from basic usage scenarios to advanced features. They are also included the trial and full versions of Active Query Builder.
A brief description of each project can be found below.

Prerequisites:

Visual Studio 2012 or higher,
.NET Framework 4.0 or higher for WebForms,
.NET Framework 4.6.2 or higher for MVC.

Dependencies:

Active Query Builder Core,
Newtonsoft.Json assembly 6.0.4 or higher.

How to get these demo projects up and running?

Clone this repository to your PC.
Open the “Samples.sln” solution to review the WebForms and MVC demo projects
Run the project.

The necessary packages will be installed automatically. In case of any problems with the packages, open the “Tools” – “NuGet Package Manager” – “Package Manager Console” menu item and install them by running the following command:
Install-Package ActiveQueryBuilder.Web.MVC
or
Install-Package ActiveQueryBuilder.Web.WebForms

Have a question or want to leave feedback?

Welcome to the Active Query Builder Help Center!
There you will find:

End-user’s Guide,
Getting Started guides,
Knowledge Base,
Community Forum.

The Offline project which doesn’t establish a connection to the database, but reads metadata from the pre-generated XML file (usually from the Northwind database).
It is ideal for quick acquaintance with the component.
The OLE DB project which must be configured to connect to a database.
It lets quickly test the component with your database.
The Query Results project gives an idea how Active Query Builder can be integrated into the data browsing facility. It also illustrates the usage of the CriteriaBuilder control along with a result data grid.
The Edit Sub-Query Text project explains how to Edit the Sub-query text and preview sub-query results as if it was a standalone query.

Designing a user-friendly query building environment

Defining friendly names for database objects and fields, adding meaningful objects, customizing database schema tree.

Alternate Names

Active Query Builder lets substitute unreadable names for user-friendly aliases.
The Alternate Names feature allows for substitution of unintelligible names of database objects and fields for friendly aliases. End-users see the friendly names in the visual query building interface as well as in the query text when editing it manually. The component gets the query with real names back only when you need to execute the query against a database server.
Read more about this feature in the Knowledge Base: Defining friendly names for database objects and fields.

Virtual Objects And Fields

Add objects which act like views and calculated or lookup fields to your database schema.
This demo illustrates the ability to add queries as new objects to the Database Schema Tree that act like ordinary database views. Users see virtual objects as ordinary database objects and can use them in their queries without the need to understand their complexity. The same is true for virtual fields: you can add new fields and put complex SQL expressions or correlated sub-queries as their expressions. The users will see them as ordinary fields even in the SQL query text. They will be expanded to corresponding SQL expressions only when you need to execute the query against a database server.
Read more about this feature in the Knowledge Base: Adding virtual objects and calculated fields to the database schema.

Custom Metadata Structure

Customize your Database Schema View the way you like: group objects by subject area, define folders with favourite objects, etc.
This demo gives an idea how to build a custom structure of nodes in the Database Schema Tree: Creation of folders for particular objects (Favorites), folders which contain objects according to a mask, etc.
Read more about this feature: Customizing the Database Schema Tree structure.

Toggling Usage of Alternate Names

Users can see and edit SQL text with both alternate and real object names.
Advanced SQL writers may wish to turn displaying of friendly aliases off to see the real names in the visual query building interface. This demo project gives the sample for this operation.

User-defined Queries and Fields

Reusable (User-defined) Queries

Users can save their queries and use them as data sources in subsequent queries.
The ability to work save queries to the special repository and then use them in subsequent queries the same way as ordinary views is provided by default. The programmer just has to take care of saving and restoring them between work sessions.

User-defined Fields

Let advanced users create own calculated fields.
This demo introduces the possibility to define calculated fields by end-users.

User Interface Customizations

Custom Expression Editor

Define own editor to deal with complex SQL expressions.
This demo adds a button to the in-place editor of Expression and Criteria cells of the Query Columns List and gives the sample of creating a custom editor to edit the cell content in a popup window.

SQL Syntax Highlighting

Highlight SQL syntax using a third-party SQL text editor.
This demo provides the sample of integration of a third-party SQL text editor to enable SQL syntax highlighting.

jQueryUI Theming

Apply any jQueryUI skin to Active Query Builder UI.
This demo illustrates run-time switching and appliance of jQueryUI themes.

Work without the Design Pane

Build queries without the design pane by dragging fields right to the Query Columns List.
This demo implements a visual query building interface without the Design Area. Users build queries by dragging fields from the Database Schema Tree to the Query Columns List and define query column properties, such as grouping, ordering, etc. The appropriate database objects are automatically added to the query, get linked with each other and removed when they aren’t needed.

Metadata Loading

Load Metadata Demo

Four ways to fill the Metadata Container programmatically.
This demo illustrates various ways of loading metadata information to Active Query Builder.
Metadata handling is described here: Metadata handling and filtration.

Switch Database Connections

Switch between different database connections at runtime.
This demo gives an idea how to get connected to different databases and reload the Database Schema Tree on switching between connections.

SQL Query Analysis and Modification

Query Analysis

Explore the internal query object model, get summary information about the query.
This demo contains the code example of a pass through the entire internal query object model.

Query Modification

Modify SQL queries programmatically.
This demo explains how one can analyze and modify user queries to correct user errors or to limit the data returned by them.

Query Creation

Create SQL queries programmatically from scratch.
This demo provides code samples of the programmatic creation of various SQL queries.

Advanced Programming Tasks

Redefining the server-side objects storage

Get rid of the ASP.NET session storage mechanism to maintain the user work sessions.
The default behaviour of saving the component state within the ASP.NET session can be changed by redefining the storage provider with a few simple steps. Enables the component usage in web farms.
Read more about this feature in the Knowledge Base: Configuring session state server to use Active Query Builder in a web farm.

Handle Query Building Events

Performing specific actions in the process of building a SQL query.
This demo gives an idea how to perform custom actions in response to some user actions. The full list of available JavaScript events can be found in this article: Active Query Builder JavaScript API.

Handle The Reusable Queries Events

Performing specific actions in the process of working with Reusable (user-defined) Queries.
This demo illustrates how to handle addition, renaming and deletion of Reusable Queries, deny or correct user actions.

License

The source code of the demo projects in this repository is covered by the MIT license.

Blog

GBAXG

Rules

Setup

Tracker

How Does It Work?

Current Cross-Game limitations

Progress & Development

F.A.Q

Credits

Coding – KittyPBoxx

Testers – Sabata

Licence

Search

vinnie

Examples

Parsing

Writing

Features

Maven/Gradle

Build Instructions

Questions / Feedback

Crazy Sonos

Things you can do

set_random_volume_for_random_time()

set_BOOM_volume_for_random_time()

To run

ASYNCMONGO

Overview

Getting Started

Documentation

Prerequisites

Installation

Testing

Project Roadmap

Currently Supported Operations

anilistgo wrapper

INSTALLATION

Examples

Query

Character Query

User Query

Media Query

Page Query

Mediatrend

Staff query

Mutation

UserMediaList requires Auth/Token

updateUser requires Auth/Token

Notes

Docs

CRAFT-train

Training

Arguments

Evaluation

ProductsApp

About

Goals

Dependencies

Backend

Frontend

Overview

Running application

Running API

Running Frontend dev server

Running server-side tests

API usage examples httpie

Register user request

Obtain JWT auth token for registered user

Access protected resources

Logout

ASP.NET C# Demo Projects for Active Query Builder ASP.NET Edition

Also, check the VB.NET Demo projects repository for the same.

Demo projects for ASP.NET Core reside in a separate repository: ASP.NET Core Demo projects repository.

What is Active Query Builder?

Details:

How do I get Active Query Builder?

What’s in this repository?

Prerequisites:

Dependencies:

Coding – `KittyPBoxx`

Testers – `Sabata`