diaper | inventory system for diaper banks | Application Framework library

I'm new to postgres-node. Coming from a mySQL background, I'm unlearning old habits and now learning new things. I want to prevent SQL injections when inserting data. I read about parameterized query. Is this applicable to JSON type? I'm doing CRUD operations on a table in postgres that only have 2 columns. I'm manipulating JSON data (SELECT, INSERT and UPDATE). How do you prevent SQL injections when inserting JSON data in a table?

table

My app was rejected for TestFlight Beta as follows:

"Guideline 2.5.4 - Performance - Software Requirements

Your app declares support for external-accessory in the UIBackgroundModes key in your Info.plist file but does not declare any external accessory protocols supported by your app. The external accessory background mode is intended for apps that communicate with hardware accessories through the External Accessory framework.

If your app is meant to work with external hardware, supported protocols must be included in the UISupportedExternalAccessoryProtocols key in your app's Info.plist file - and the hardware's PPID # should be provided in the Review Notes field of your app in App Store Connect.

Additionally, your app must be authorized by MFi to use the desired hardware. If you are not yet in the MFi Program, you can enroll at MFi program."

I read similar questions, but none answer or solve my problem.

In Xcode project settings I have checked "Uses Bluetooth LE accessories" under Background Modes.

In info.plist I have NSBluetoothPeriperalUsageDescription="Uses Bluetooth for switches and adaptive toys".

If I uncheck "Uses Bluetooth LE accessories" under Background modes I think my app will be approved, but it leaves out the following important set of users of the app as follows:

The app is for capability switch users in the Accessibility realm, which is already a small set of users. The feature requiring background communication between the app (central) and switches (peripheral) is for a specific subset of switch users that have a visual impairment and significant cognitive delays. This is an even smaller set of users, probably < 100 in the world, but it is an extremely important use case for these users. It is not practical to have the app always in the foreground when they use the app to use audio to say 1 or 2 words, typically "Yes"/"No", or "I need help!”, needed even when there is no WiFi or cell signal. For example, my test user (downloaded to her app directly from my Xcode dev env) with Fox G1 syndrome uses this mode exclusively and has seen great improvements in having some minimal control of things in her life (e.g., saying “I need help” when she feels a seizure coming on or requires diapering).

Current capability switches on the market use the Bluetooth HID profile, which does not allow for background use or 2-way communication between central (my app) and accessory (switch box), to do important feedback like adjusting delay time for switch activations for users with movement disorders and tremors, also the case of my test user.

Has anyone successfully received app approval for background communication with an accessory as a peripheral that is not MFi or HomeKit approved? When I read the MFi FAQ, this peripheral accessory does not appear to fall into the MFi umbrella, and with HomeKit I already came across the limitation that it does not work when the device is sleeping (this latter case is another bone I have to pick, since non-touch users cannot turn on lights, open auto-doors, turn up heaters... unless the device is open which they cannot physically do, and Siri is not an option since they are non-verbal!).

Additional technical background regarding the app: I use only CoreBluetooth (UART), where the app is the central. My API is so simple I am slightly embarrassed to list it, but here goes:

// BLE UART API

let receiveSwitch1On: NSString = "SWITCH1_ON"

let receiveSwitch1Off: NSString = "SWITCH1_OFF"

let receiveSwitch2On: NSString = "SWITCH2_ON"

let receiveSwitch2Off: NSString = "SWITCH2_OFF"

let sendSwitchboxOn: NSString = "ON"

let sendSwitchboxOff: NSString = "OFF"

let updateDebouncePrefix: NSString = "DEBOUNCE="

let updateGraceOffPrefix: NSString = "GRACE_OFF=“

Does anyone have a suggestion on what I could change technically, or advice for navigating the app approval process on what my lowest cost option would be to keep this use case of background comm between app and peripheral? Already I've spent significant time and money to create this capability. I am not in this to make money, but to provide some benefit to a small set of users that are largely left out of technology. I am willing to spend more time and money to reach the finish line, but I really can't afford a lot of ongoing program costs as I expect MFi or HomeKit might be.

Thanks for reading!

I need to write a code that would remove specific words from a text. After some research I found out that it's best to replace all the words with " ", but replace() is not a good option as it removes characters from other words too. I found this re.sub() function and want to define a piece of code that would replace words from the given text (words are defined in a separate list). In most tutorials creating a dictionary for replacements was needed. I don't have one, so I wanted to define something that would check the list of stopwords and whenever found one in the text replace it with " ".

That is my code:

I have the following df:

What I want to do is to count the frequency of combination of elements. For example:

• umbrella appears 8 times in the whole df
• detergent appears 5 times
• (beer, diaper) appear 2 times
• (beer, milk) appear 2 times
• (umbrella, milk, beer) appear 2 times

and so on, in other words, I need to generate something like this:

Count all the frequencies of single and combined items and only keep those both single and combined items with frequency >= n, where n is any positive integer. For this example let's say n -> {1, 2, 3, 4}.

I've been trying to use the following code:

I have seen other posts on stackoverflow, which unfortunately don't solve my issue.

I have the below dataset, which I am trying to encode:

In the end, I just want 7 columns (bread, wine, eggs, meat, cheese....), with a 1 or 0 in it, depending on whether that item was purchased.

I have tried pd.get_dummies, but it creates columns item1_bread; item2_bread... and so I cannot complete my analysis. I want to be able to have simply a 1 or 0 value in the column to say whether bread was purchased in that transaction

Can anyone help me please?

I am working on a big data of customer survey in a dataframe. I need to find the number of times 2 words "customer" & "consumer" are coming together in a sentence and count the ccurance. The problem is the data is a running text as given below

I am wondering why e.offsetX and e.offsetY are different for clicking in the same place. For the first click in a button e.offsetX and e.offsetY are correct but if you click a button before old ripple effect diapers than received event has incorrect e.offsetX and e.offsetY (always around 0). Because of this behavior my ripple effect has incorrect position if I click a button quickly many times.

• Why this event has such e.offsetX and e.offsetY ?
• How can I fix the position of my ripple effect without using e.target ?

I am having 2 tables product_categories and product_sub_categories and these table columns are as follows:
product_categories:
category_id category_name created_by created_date updated_by updated_date product_sub_categories:
sub_category_id category_id sub_category_name created_by created_date updated_by updated_date

I am able to fetch product categories and sub_categories like:

I'm trying to make an obligatory Todo app to help with my React learning . The behavior I'm going for is multiple Todo lists, where you select a todo name and the list of todo items for that show. Select a different name list and it's list todo items show, etc (like wunderlist/msft todo). It's using static json where each item has a child array.

I'm realizing I have no idea how to update the text in the nested array and I can't seem to find any relevant examples of this. Will someone show me how this is done or point me in the right direction?

In my POC on codesandbox each todo has a button where all I'd like to do (for now) is change the text to 'changed' when clicking on the button. Basically I'd like to do this: